Differences

This shows you the differences between two versions of the page.

Link to this comparison view

faq:mysql03 [2011/04/30 17:37] (current)
clemens created
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]]