/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 vote323 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote354 views1 answer
Mysql min value row
SQL
3 votes338 views2 answers
Sql random integer
SQL
0 vote391 views1 answer
Insert query return id mysql
SQL
15 votes341 views4 answers
T-sql drop function if exists
SQL
0 vote374 views2 answers
Generate sql trigger through ef migration
SQL
48 votes402 views3 answers
Psql create database
SQL
0 vote346 views1 answer
Java check if something is in mysql table
SQL
0 vote365 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
1 vote350 views1 answer
Mysql backup skip table
SQL