/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

5 votes312 views6 answers
Sql foreign key
SQL
1 vote283 views1 answer
Sql week commencing date
SQL
1 vote476 views3 answers
Create table from existing table in sql
SQL
2 votes327 views3 answers
Sql function
SQL
8 votes346 views6 answers
Sql insert
SQL
0 vote333 views1 answer
Show specific events on mysql
SQL
0 vote315 views1 answer
Mysql exception output
SQL
1 vote300 views4 answers
Postgres extract date from timestamp
SQL
0 vote320 views1 answer
Check if a column is a primary key in sql server
SQL
13 votes306 views6 answers
Restart postgresql
SQL