/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 vote182 views1 answer
T-sql disable system versioning
SQL
0 vote187 views1 answer
Sql remove last 2 digit
SQL
4 votes204 views3 answers
Postgres drop all tables
SQL
2 votes184 views2 answers
Mysql search for column name in all tables
SQL
0 vote182 views1 answer
Sql server size of every table in a db
SQL
3 votes171 views1 answer
Oracle undo tablespace list by user
SQL
2 votes194 views1 answer
Postgresql create table as select
SQL
0 vote196 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote176 views1 answer
Myswql show full processlist
SQL
2 votes187 views4 answers
List databases in sql server
SQL