Change Column in MySQL

最新推荐文章于 2023-04-03 08:30:00 发布

lazying_bird

最新推荐文章于 2023-04-03 08:30:00 发布

阅读量555

点赞数

分类专栏： SQL 文章标签： mysql

本文链接：https://blog.csdn.net/a_flying_bird/article/details/51491216

版权

SQL 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

Main SQL Statements

Includes:
- DESCRIBE ttt;
- ALTER TABLE ttt CHANGE the_date the_datetime;
- ALTER TABLE ttt CHANGE the_date the_datetime DATETIME;
- DESCRIBE ttt;
- ALTER TABLE ttt CHANGE the_datetime the_datetime2 DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;
- DESCRIBE ttt;

Detail Process

Detail SQL Statements and Result:

MariaDB [testdate]> DESCRIBE ttt;
+----------+-------------+------+-----+-------------------+-------+
| Field    | Type        | Null | Key | Default           | Extra |
+----------+-------------+------+-----+-------------------+-------+
| others   | varchar(20) | YES  |     | NULL              |       |
| the_date | datetime    | NO   |     | CURRENT_TIMESTAMP |       |
+----------+-------------+------+-----+-------------------+-------+
2 rows in set (0.00 sec)

MariaDB [testdate]> ALTER TABLE ttt CHANGE the_date the_datetime;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at
line 1
MariaDB [testdate]> ALTER TABLE ttt CHANGE the_date the_datetime DATETIME;
Query OK, 0 rows affected (0.45 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [testdate]> DESCRIBE ttt;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| others       | varchar(20) | YES  |     | NULL    |       |
| the_datetime | datetime    | YES  |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

MariaDB [testdate]> ALTER TABLE ttt CHANGE the_datetime the_datetime2 DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;
Query OK, 5 rows affected (0.62 sec)
Records: 5  Duplicates: 0  Warnings: 0

MariaDB [testdate]> DESCRIBE ttt;
+---------------+-------------+------+-----+-------------------+-------+
| Field         | Type        | Null | Key | Default           | Extra |
+---------------+-------------+------+-----+-------------------+-------+
| others        | varchar(20) | YES  |     | NULL              |       |
| the_datetime2 | datetime    | NO   |     | CURRENT_TIMESTAMP |       |
+---------------+-------------+------+-----+-------------------+-------+
2 rows in set (0.00 sec)

MariaDB [testdate]>