/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 vote134 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote161 views2 answers
Suse Linux restart MySQL
SQL
0 vote133 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote234 views1 answer
How to get all values in a table mysql in c#
SQL
1 vote135 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
1 vote127 views1 answer
ORA-01950
SQL
2 votes138 views1 answer
Mysql time ago difference
SQL
0 vote135 views1 answer
How to delete python anywhere mysql database
SQL
17 votes134 views6 answers
Change column name in sql
SQL
0 vote122 views1 answer
Check sql database table lock
SQL