/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

4 votes181 views2 answers
Sql select except null
SQL
0 vote187 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
3 votes193 views3 answers
Restart mysql mac
SQL
0 vote196 views1 answer
Many rows to 1 string mysql
SQL
1 vote178 views1 answer
Mysqli connect
SQL
0 vote183 views1 answer
Create function syntax sql server
SQL
1 vote184 views1 answer
Loading local data is disabled mysql
SQL
0 vote199 views1 answer
How to close external sql connection in laravel
SQL
1 vote193 views1 answer
Oracle select first result
SQL
0 vote210 views1 answer
Check command
SQL