Insert a record
mysql 4.1.16-nt-max> insert into
table01 (field01, field02) values (1, 'first');
Query OK, 1 row affected (0.00 sec)
Enclose entire list of field names between one pair of parentheses.
Enclose the values to be inserted between another pair of parentheses.
Commas are used between each field and between each value.
A space may be used after the comma between fields.
List all the records in a table
mysql 4.1.16-nt-max> select * from table01;
Excellent! |
