/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 vote253 views1 answer
Create table if not exist with exceptions
SQL
0 vote293 views2 answers
Mysql missin expression near on
SQL
1 vote271 views2 answers
Copy database mysql
SQL
0 vote303 views1 answer
Generate sql from specific migration ef core
SQL
0 vote259 views1 answer
Mysql server not running
SQL
3 votes255 views1 answer
Oracle apex warning message
SQL
0 vote265 views1 answer
Contact mysql column field
SQL
0 vote253 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote332 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
2 votes255 views2 answers
Laravel query builder toSql
SQL