/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 vote258 views1 answer
Mysql is odd
SQL
-1 vote265 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote259 views1 answer
Sqlalchemy query join many to many
SQL
16 votes261 views4 answers
Find duplicates mysql
SQL
1 vote263 views1 answer
Declare table variable
SQL
0 vote243 views1 answer
Drop all data from tables
SQL
3 votes250 views1 answer
Ms sql skip take
SQL
0 vote239 views1 answer
Backup a table in sql
SQL
0 vote246 views1 answer
Rabbitmq service not starting
SQL
11 votes265 views1 answer
Oracle insert into where
SQL