/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 vote291 views1 answer
Change filed order in mysql
SQL
0 vote288 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote274 views1 answer
Groupby error in mysql
SQL
10 votes284 views6 answers
Mysql delete duplicates
SQL
1 vote265 views1 answer
T-SQL Alter the column data type
SQL
6 votes260 views3 answers
Mysql server is not starting xampp
SQL
6 votes265 views3 answers
Mysql first day of year
SQL
1 vote306 views1 answer
Primary key with prefix sql
SQL
0 vote313 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote280 views2 answers
Select columns from 2 tables with foreign key
SQL