/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

1 vote333 views1 answer
Mysql event last execution
SQL
3 votes332 views3 answers
List columns in table postgres
SQL
3 votes332 views3 answers
Sql last week
SQL
0 vote324 views1 answer
Database get 10 user aleatory
SQL
32 votes344 views6 answers
How to change column name in sql
SQL
6 votes335 views3 answers
Update with inner join postgres
SQL
0 vote348 views2 answers
While mysql
SQL
2 votes348 views1 answer
Use cases condition in sql query laravel
SQL
2 votes377 views3 answers
How to replace null values in sql
SQL
0 vote365 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL