/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 vote189 views1 answer
Sqlite commands
SQL
1 vote150 views1 answer
Unique vs distinct sql
SQL
3 votes249 views1 answer
Mysql group_concat distinct
SQL
1 vote143 views1 answer
Oracle character set
SQL
1 vote199 views1 answer
Mysql dump specific tables
SQL
0 vote152 views1 answer
Mysql timeout 30 seconds
SQL
0 vote187 views1 answer
On update current_timestamp jpa
SQL
0 vote179 views1 answer
Sqlite update only if greater
SQL
0 vote189 views2 answers
Zsh: command not found: mysq
SQL
0 vote205 views1 answer
Product of a column in mysql
SQL