/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

4 votes233 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote221 views1 answer
Rename view mysql
SQL
0 vote200 views1 answer
Postgresql import data from csv
SQL
0 vote211 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote268 views1 answer
Sql select without column name
SQL
0 vote217 views1 answer
Insert into select with group by
SQL
23 votes229 views2 answers
Query to delete a database in mysql
SQL
18 votes225 views6 answers
Creating table in MySQL
SQL
1 vote212 views2 answers
Sql select only first occurrence
SQL
2 votes243 views3 answers
How do I add a user to a postgres database? cli
SQL