/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

-1 vote124 views1 answer
Mysql how to set update or create
SQL
2 votes178 views2 answers
Checking data type in sql server
SQL
12 votes176 views6 answers
Between in sql
SQL
0 vote210 views1 answer
Count column of tables psql
SQL
1 vote200 views1 answer
Oracle schema size
SQL
2 votes179 views2 answers
Mysql count rows returned
SQL
1 vote167 views1 answer
Mysql query where in select
SQL
0 vote183 views1 answer
Postgresql linux password
SQL
1 vote162 views1 answer
Pv mysql import
SQL
25 votes194 views3 answers
Mysql command show tables
SQL