/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

8 votes143 views1 answer
Oracle add datafile to tablespace
SQL
0 vote140 views1 answer
How to convert external table to managed table in hive
SQL
2 votes149 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote149 views1 answer
Postgresql inline table
SQL
0 vote124 views1 answer
Error code 1241 mysql
SQL
0 vote134 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote132 views1 answer
Pip install mysqlclient error
SQL
9 votes138 views2 answers
Convert data type in sql
SQL
2 votes184 views2 answers
Mysql date range
SQL
1 vote125 views1 answer
Mysql drop key
SQL