INSERT INOT users SET username='aaa',password='123456';
2015-07-19
INSERT tb1 VALUES('tom',25,25121);
INSERT tb1(username,age) VALUES('jon',25);
INSERT tb1(username,age) VALUES('jon',25);
2015-07-19
mysql> CREATE TABLE tb1(
-> username VARCHAR(20),
-> age TINYINT UNSIGNED,
-> salary FLOAT(8,2) UNSIGNED
-> );
Query OK, 0 rows affected (0.25 sec)
-> username VARCHAR(20),
-> age TINYINT UNSIGNED,
-> salary FLOAT(8,2) UNSIGNED
-> );
Query OK, 0 rows affected (0.25 sec)
2015-07-19