/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

2 votes213 views1 answer
Orcale index size
SQL
0 vote218 views2 answers
Dbms interview questions
SQL
1 vote195 views1 answer
SQL server query column yes or no
SQL
7 votes212 views2 answers
Execute mysql file
SQL
4 votes204 views1 answer
SQL find text in SP
SQL
0 vote185 views1 answer
Sql examples from your work
SQL
3 votes216 views2 answers
How to delete git repo locally
SQL
0 vote207 views1 answer
Implizite joins sql
SQL
0 vote264 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote211 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL