MySQL, SQL, DDL ו DML

rdice:# mysql test 

Welcome to the MySQL monitor. Commands end with ; or \g. 

Your MySQL connection id is 4 to server version: 3.21.28-gamma-log 


Type 'help' for help. 

mysql> create table albums ( 	here I'm using DDL 

   -> title varchar(100), 		to set up a table where 

   -> artist varchar(100), 		I'll store some 

   -> released date); 			musical info 

Query OK, 0 rows affected (0.07 sec) 

mysql> insert into albums(title,artist,released) 

-> values('Selling England By The Pound','Genesis','1973-01-01'); 

Query OK, 1 row affected (0.08 sec) 

mysql> select * from albums; 
+---------------------------------------+----------+-------------+ 

| title         | artist      | released      | 

+------------------------------+-------+-------------------------+

 | Selling England By The Pound | Genesis | 1973-01-01 | 

+------------------------------+-------+-------------------------+ 

1 row in set (0.06 sec)

create table TABLENAME ( 

   COLUMN1 column1datatype, 

   COLUMN2 column2datatype,

    ... 

   COLUMN_x column_xdatatype 

)

insert into TABLE(column1,column2,...,column_x) 

values(value1,value2,...,value_x)

select title, released
from albums
where artist ='Genesis'
order by released

והרי הדרך להשתמש בפקודות האלו:

mysql> update albums
 -> set released = '1973-02-01'
 -> where title = 'Selling England by the Pound'
 -> and artist = 'Genesis'; 
Query OK, 1 row affected (0.03 sec) 

mysql> select * from albums; 
 +------------------------------------+----------+---------------+ 
| title                                           | artist      | 
released       | 
+------------------------------------+----------+---------------+
| Selling England by the Pound | Genesis | 1973-02-01  | 
| Wind & Wuthering                  | Genesis | 1976-01-01  |
| We Can't Dance                       | Genesis | 1991-01-01  |
+------------------------------------+----------+---------------+ 
3 rows in set (0.00 sec) 

mysql> delete from albums where artist = 'Genesis'; 
Query OK, 3 rows affected (0.00 sec) 

mysql> select * from albums; 
Empty set (0.00 sec)

rdice:# mysqlshow test

     Database: test

     +--------+

     | Tables |

     +--------+

     | albums |

     +--------+

     rdice:# mysqlshow test albums

     Database: test  Table: albums  Rows: 0

     +----------+--------------+------+-----+---------+-------+

     | Field    | Type         | Null | Key | Default | Extra |

     +----------+--------------+------+-----+---------+-------+

     | title    | varchar(100) | YES  |     |         |       |

     | artist   | varchar(100) | YES  |     |         |       |

     | released | date         | YES  |     |         |       |

     +----------+--------------+------+-----+---------+-------+