/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 vote117 views1 answer
Mysql workbench search all tables
SQL
0 vote223 views1 answer
How to get number of months between 2 dates sql server
SQL
24 votes177 views6 answers
Replace mysql
SQL
0 vote170 views1 answer
PSQL qith variables
SQL
0 vote181 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote260 views4 answers
Stored procedure sql
SQL
5 votes160 views1 answer
Oracle get foreign keys on table
SQL
0 vote155 views1 answer
Denormalise SQL command
SQL
3 votes163 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
10 votes147 views5 answers
Mysql create user
SQL