/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 vote340 views1 answer
Allow external access to mysql
SQL
2 votes327 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote362 views1 answer
Sql injection payload list github
SQL
1 vote329 views2 answers
Sql select only first occurrence
SQL
0 vote324 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
1 vote369 views1 answer
Alter constraint in sql
SQL
65 votes557 views6 answers
Sql add column to table
SQL
0 vote356 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote328 views1 answer
Casterar postgres
SQL
0 vote318 views1 answer
Deny select insert update delete sql
SQL