/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 vote377 views1 answer
T-sql update table variale
SQL
-1 vote346 views1 answer
Add column alter table default value
SQL
1 vote303 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote340 views1 answer
Sql server select top 2 of each group
SQL
0 vote333 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote335 views1 answer
Char varchar nvarchar sql
SQL
0 vote359 views1 answer
Get db connection detail from sql developer profile
SQL
1 vote347 views1 answer
Sql convert month name to number
SQL
0 vote366 views1 answer
Update having mysql
SQL
0 vote360 views1 answer
Postgresql create query
SQL