/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

3 votes306 views3 answers
Mysql declare variable
SQL
0 vote280 views1 answer
EnvironmentError: mysql_config not found
SQL
-1 vote303 views1 answer
Select first rows postgresql
SQL
0 vote291 views1 answer
Sql server alter table column nullable
SQL
3 votes290 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote292 views1 answer
Mysql check if lowercase
SQL
0 vote278 views3 answers
Between keyword sql
SQL
0 vote302 views1 answer
Php mysqli install
SQL
5 votes318 views1 answer
Get column name sql server
SQL
5 votes312 views2 answers
Mysqldump password
SQL