/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 vote202 views1 answer
Round up and down sql
SQL
0 vote233 views1 answer
Sql today at midnight
SQL
0 vote222 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote155 views1 answer
Get all stored procedures in sql server
SQL
1 vote214 views1 answer
Mysql count all table rows
SQL
5 votes212 views4 answers
Change auto increment mysql
SQL
0 vote261 views1 answer
Download mysql database to excel in android studio
SQL
1 vote224 views1 answer
Postgres cast as currency format
SQL
0 vote205 views1 answer
How to use query in nosql
SQL
2 votes216 views1 answer
Grant revoke privileges to mysql username
SQL