/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 vote138 views1 answer
Denied
SQL
11 votes149 views2 answers
MySQL DISTINCT
SQL
0 vote148 views1 answer
Update and keep original value sql
SQL
3 votes139 views3 answers
Mysqldump: couldn
SQL
2 votes139 views1 answer
Oracle number to percentage
SQL
0 vote150 views1 answer
Oracle array
SQL
0 vote157 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote150 views1 answer
Yesql
SQL
3 votes161 views1 answer
Oracle cannot access v$session
SQL
1 vote176 views1 answer
Postgres power
SQL