SQL Basics--mysql 5 (9)

16 inserting INSERT into table values ()

Mysql> Insert  intoPw_priceValues(5, the,'Cai'); Query OK,1Row affected (0.03sec) MySQL> Select *  fromPw_price;+-----+-------+------------+|Uid|Price|First_Name|+-----+-------+------------+|   1 |    - |Wang||   2 |   + |Zhang||   3 |   - |Li||   4 |   the |Weizhi||   5 |   the |Cai|+-----+-------+------------+5Rowsinch Set(0.00Sec

Insert a partial field

Mysql> Insert  intoPw_price (Uid,first_name)Values(6,'Guo'); Query OK,1Row affected (0.03sec) MySQL> Select *  fromPw_price;+-----+-------+------------+|Uid|Price|First_Name|+-----+-------+------------+|   1 |    - |Wang||   2 |   + |Zhang||   3 |   - |Li||   4 |   the |Weizhi||   5 |   the |Cai||   6 |  NULL |Guo|+-----+-------+------------+6Rowsinch Set(0.00Sec

Insert Retrieve data

MySQL>  insertintoselect from Pw_price;

SQL Basics--mysql 5 (9)