This shows you the differences between two versions of the page.
— | faq:mysql03 [2011/04/30 17:37] (current) – created clemens | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | < | ||
+ | [03] IS THERE AN SQL PRIMER I CAN USE? | ||
+ | MySQL conforms pretty much to SQL92. | ||
+ | | ||
+ | its beyond the scope of the SDF FAQ to cover this. | ||
+ | |||
+ | | ||
+ | The best way to learn SQL is by using it. | ||
+ | |||
+ | (SQL commands are in UPPER CASE, objects are in lowercase) | ||
+ | |||
+ | | ||
+ | | ||
+ | |||
+ | | ||
+ | name VARCHAR (15), | ||
+ | email VARCHAR (25), | ||
+ | phone INT, | ||
+ | ID INT NOT NULL AUTO_INCREMENT, | ||
+ | | ||
+ | |||
+ | | ||
+ | | ||
+ | |||
+ | DESC test; | ||
+ | |||
+ | | ||
+ | | Field | Type | Null | Key | Default | Extra | | ||
+ | | ||
+ | | name | varchar(15) | YES | | NULL | | | ||
+ | | email | varchar(25) | YES | | NULL | | | ||
+ | | phone | int(11) | ||
+ | | ID | int(11) | ||
+ | | ||
+ | |||
+ | | ||
+ | | ||
+ | |||
+ | | ||
+ | | ||
+ | |||
+ | | ||
+ | | ||
+ | |||
+ | | ||
+ | |||
+ | | ||
+ | | name | email | phone | ID | | ||
+ | | ||
+ | | Ted Uhlemann | iczer@sdf.lonestar.org | 5551212 | 1 | | ||
+ | | ||
+ | |||
+ | | ||
+ | | ||
+ | |||
+ | | ||
+ | |||
+ | ALTER A TABLE | ||
+ | | ||
+ | | ||
+ | ALTER TABLE test RENAME friends; | ||
+ | |||
+ | ALTER TABLE friends ADD birthday DATE; | ||
+ | |||
+ | ALTER TABLE friends CHANGE name fullname VARCHAR (25); | ||
+ | |||
+ | ALTER TABLE friends DROP name; | ||
+ | |||
+ | | ||
+ | | ||
+ | |||
+ | | ||
+ | |||
+ | | ||
+ | |||
+ | | ||
+ | | ||
+ | |||
+ | DROP TABLE friends; | ||
+ | |||
+ | COPY DATA BETWEEN TABLES | ||
+ | | ||
+ | |||
+ | | ||
+ | </ | ||
+ | |||
+ | [[mysql|back]] |