no way to compare when less than two revisions

Differences

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:
 +<code>
 +[03] IS THERE AN SQL PRIMER I CAN USE?
  
 +     MySQL conforms pretty much to SQL92.  There are many 
 +     documents/tutorials/faqs available on the net .. besides that,
 +     its beyond the scope of the SDF FAQ to cover this. 
 +
 +     HOWEVER, here are a few quick commands to get your started!
 +     The best way to learn SQL is by using it.
 +
 +     (SQL commands are in UPPER CASE, objects are in lowercase)
 +
 +     CREATING A TABLE
 +     ----------------
 +
 +     CREATE TABLE test (
 +     name VARCHAR (15),
 +     email VARCHAR (25),
 +     phone INT,
 +     ID INT NOT NULL AUTO_INCREMENT,
 +     PRIMARY KEY (ID));
 +
 +     DESCRIBING A TABLE
 +     ------------------
 +
 +     DESC test;
 +
 +     +-------+-------------+------+-----+---------+----------------+
 +     | Field | Type        | Null | Key | Default | Extra          |
 +     +-------+-------------+------+-----+---------+----------------+
 +     | name  | varchar(15) | YES  |     | NULL    |                |
 +     | email | varchar(25) | YES  |     | NULL    |                |
 +     | phone | int(11)     | YES  |     | NULL    |                |
 +     | ID    | int(11)          | PRI | NULL    | auto_increment |
 +     +-------+-------------+------+-----+---------+----------------+
 +
 +     INSERTING A ROW INTO A TABLE
 +     ----------------------------
 +
 +     INSERT INTO test VALUES 
 +     ('Ted Uhlemann', 'iczer@sdf.lonestar.org', '5551212', NULL);
 +
 +     SELECTING RECORDS FROM A TABLE
 +     ------------------------------
 + 
 +     SELECT * FROM test;
 +
 +     +--------------+------------------------+---------+----+
 +     | name         | email                  | phone   | ID |
 +     +--------------+------------------------+---------+----+
 +     | Ted Uhlemann | iczer@sdf.lonestar.org | 5551212 |  1 |
 +     +--------------+------------------------+---------+----+
 +
 +     DELETING A ROW FROM A TABLE
 +     ---------------------------
 +
 +     DELETE FROM test;
 +
 +     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;
 +     
 +     UPDATING A ROW
 +     --------------
 +
 +     UPDATE test SET email = 'iczer@freeshell.org'; 
 +
 +     UPDATE friends SET birthday = '1978-06-16' WHERE id = '1';
 +
 +     DROPPING A TABLE
 +     ----------------
 +     
 +     DROP TABLE friends;
 +
 +     COPY DATA BETWEEN TABLES
 +     ------------------------
 +
 +     INSERT IGNORE INTO wp2_posts SELECT * FROM wp_posts;
 +</code>
 +
 +[[mysql|back]]