Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > mysql给字段添加default_MySQL

mysql给字段添加default_MySQL

WBOY
Release： 2016-06-01 13:28:24
Original
1111 people have browsed it

bitsCN.com


mysql给字段添加default

 

Sql代码  alter table  t_incoming_records modify  incomingtime datetime  default C  URRENT_TIMESTAMP;
Copy after login

 

 

注意：修改字段用关键字modify.

 

modify后的column可以省略。

 

bitsCN.com
Related labels：
mysql Keywords
source：php.cn
Previous article：MySQL备份与恢复之冷备_MySQL Next article：mysql表之间数据转移_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
What are the best practices for displaying version information in web applications? I'm developing a web application. What are the best practices for displaying version infor...
From 2024-04-06 19:13:16
0
2
476
Set relation "OR" for meta_query ORtax_query I'm trying to use WP_Query to create a query containing a meta_query element and a tax_que...
From 2024-04-04 20:01:43
0
1
1346
Steps to remove a foreign key entry I have two tables Employee and Address. Employee is my main table and Address is a subtabl...
From 2024-04-04 14:15:44
0
1
352
Illuminate\Database\QueryException: SQLSTATE: General error: 1364 Why can't I enter data? In the appointment table you don't want to enter the userid attrib...
From 2024-04-03 22:39:00
0
1
363
Problem: MySQL regular expression (limiter not working) Mod Note: Do Not Remove/Do Not Close I asked this question before and the admins closed it...
From 2024-04-02 23:35:21
0
1
263
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template