/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

37 votes288 views3 answers
Postgresql insert column
SQL
0 vote279 views1 answer
Replace \n sql
SQL
4 votes320 views1 answer
W3schools create table
SQL
0 vote323 views1 answer
SQL Cut part string
SQL
9 votes293 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote290 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote283 views1 answer
Call function sql oracle
SQL
1 vote297 views1 answer
Select not matching data with join table
SQL
0 vote337 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote325 views1 answer
Table structure in sql
SQL