/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 vote343 views1 answer
Show specific events on mysql
SQL
0 vote339 views1 answer
Check if string is a number sql
SQL
0 vote333 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote293 views1 answer
Show function mysql
SQL
1 vote303 views1 answer
Oracle stop job
SQL
0 vote389 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote305 views3 answers
Between keyword sql
SQL
0 vote306 views1 answer
Mysql set boolean default value
SQL
0 vote356 views1 answer
Delete from table where length sql
SQL
2 votes317 views1 answer
Mysql create user with mysql_native_password
SQL