mysql创建时间为当前时间 mysql生成当前时间

1.查看当前时间：
 mysql> select now();
 ±--------------------+
 | now() |
 ±--------------------+
 | 2019-01-09 18:38:59 |
 ±--------------------+
 1 row in set (0.00 sec)2.创建表格：
 mysql> create table t_organization(
 -> code char(10),
 -> name varchar(32),
 -> createTime date);
 Query OK, 0 rows affected (0.02 sec)3.插入一行数值：
 mysql> insert into t_organization(code,name,createTime) values(‘111’,‘business’,now());
 Query OK, 1 row affected, 1 warning (0.00 sec)mysql> select * from t_organization;
 ±-----±---------±-----------+
 | code | name | createTime |
 ±-----±---------±-----------+
 | 111 | business | 2019-01-09 |
 ±-----±---------±-----------+
 1 row in set (0.00 sec)mysql> select now();
 ±--------------------+
 | now() |
 ±--------------------+
 | 2019-01-09 18:46:48 |
 ±--------------------+
 1 row in set (0.00 sec)4.复制表格：
 通用语句： sentence:create table tablename as select columnname, from tablename
 4.1 mysql> create table orga as select * from t_organization;
 Query OK, 1 row affected (0.02 sec)
 Records: 1 Duplicates: 0 Warnings: 0
 4.2 create table org as select code,name from orga;
 5.把查询结果插入到表格中：
 insert into emp2 select * from emp2 where sal=3000
 把emp2中的符合条件的结果附在本表的后面