Jump to content

Search the Community

Showing results for tags 'examples sql'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • W3Schools
    • General
    • Suggestions
    • Critiques
  • HTML Forums
    • HTML/XHTML
    • CSS
  • Browser Scripting
    • JavaScript
    • VBScript
  • Server Scripting
    • Web Servers
    • Version Control
    • SQL
    • ASP
    • PHP
    • .NET
    • ColdFusion
    • Java/JSP/J2EE
    • CGI
  • XML Forums
    • XML
    • XSLT/XSL-FO
    • Schema
    • Web Services
  • Multimedia
    • Multimedia
    • FLASH

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Languages

Found 1 result

  1. The tutorial for SQL is good, don't get me wrong. I just felt like I just came out of college and all of my knowledge didn't apply to the real world. It's one thing to know how to use Foreign IDs CREATE TABLE IF NOT EXISTS person(ID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),)ENGINE=InnoDB; CREATE TABLE IF NOT EXISTS file(ID INT NOT NULL AUTO_INCREMENT,OWNERID INT NOT NULL,PRIMARY KEY(ID),FOREIGN KEY (OWNERID) REFERENCES person(ID))ENGINE=InnoDB; CREATE TABLE IF NOT EXISTS picture(ID INT NOT NULL AUTO_INCREMENT,FILEID INT NOT NULL,PRIMARY KEY(ID),FOREIGN KEY (FILEID) REFERENCES file(ID))ENGINE=InnoDB; But it's another entirely to remove a picture if it belongs to a certain user. Also it's hard to get the person ID associated with a picture. I don't mean the row, I mean the actual text ID/name associated with a person.
×
×
  • Create New...