/SQL/How to assign date field for table in mysql

How to assign date field for table in mysql

Mysql format date

DATE_FORMAT(date, format)
-- E.g.
SELECT DATE_FORMAT(dateField, '%m/%d/%Y') FROM TableName;
-- See https://www.mysqltutorial.org/mysql-date_format/ for available formats

Source: mysqltutorial.org

How to assign date field for table in mysql

        
            
        
     CREATE TABLE people (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
    birth_date DATE NOT NULL
);

Source: mysqltutorial.org

Similar codes

0 vote201 views1 answer
Print hello world in plsql
SQL
0 vote149 views1 answer
Mysql, how to query the table comments?
SQL
0 vote141 views1 answer
Composit key in sql
SQL
-1 vote222 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote252 views1 answer
Mysql edit trigger
SQL
1 vote151 views1 answer
Oracle sql first day of year
SQL
0 vote155 views1 answer
Oracle allow space to user
SQL
0 vote203 views1 answer
TSQL Find csv file in folder
SQL
4 votes162 views1 answer
List tables sqlite
SQL
0 vote160 views1 answer
Sql query use select name inside where clause
SQL