MySQL5.5.21学习教程之一(二)
G
*************************** 1. row ***************************
CURDATE(): 2015-01-14
NOW(): 2015-01-14 19:39:56
NOW(): 2015-01-14 19:39:56
time(NOW()): 19:39:56
year(NOW()): 2015
1 row in set (0.00 sec)
insert into date_test values (CURDATE(),NOW(),NOW(),time(NOW()),year(NOW()));
select * from date_test \G
*************************** 1. row ***************************
f_date: 2015-01-14
f_datetime: 2015-01-14 19:41:07
f_timestamp: 2015-01-14 19:41:07
f_time: 19:41:07
f_year: 2015
1 row in set (0.00 sec)
create TABLE user(id INTEGER,name VARCHAR(20));
insert into user values (1,'bob'),(2,'petter');
select * from user;
+------+--------+
| id | name |
+------+--------+
| 1 | bob |
| 2 | petter |
+------+--------+
show tables;
+----------------+
| Tables_in_test |
+----------------+
| bit_test |
| date_test |
| f_test |
| int_table |
| int_test |
| user |
+----------------+