/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 vote203 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote264 views1 answer
Liquibase update row
SQL
0 vote179 views1 answer
Count the table indatabase
SQL
1 vote193 views3 answers
Execute sp in sql server
SQL
0 vote187 views1 answer
Update set with inner join oracle
SQL
1 vote216 views4 answers
Get week day from date in sql
SQL
15 votes191 views4 answers
Mysql where value is null
SQL
1 vote192 views3 answers
String to int mysql
SQL
1 vote196 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote230 views3 answers
Find below average salary in sql
SQL