answersLogoWhite

0

There is a specific DATE variable type for collumns (as well as DATETIME, and TIME variable types). By default, entering a date in the format of yyyy-mm-dd (y being a digit of a year, m being a digit of a month, and d being a digit of a day) will suffice when storing dates. Most server-side languages take returned DATE's and turn them into strings - but in MySQL, they are not just strings.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

How do you store and retrieve pictures in MySQL database?

The best thing to do is store them in a longblob field in your MySQL table.


What is an API Is MySQL an API?

MySQL is not an API MySQL is a database where you store data. An API is how you request information from another website.


What is the best way to store a timestamp in MySQL?

The best way to store a timestamp in MySQL is to either store it in a timestamp field or in an INT(10) field and insert using UNIX_TIMESTAMP(). Both ways are exactly the same and both use 4 bytes of data.


What is mysql latest version?

The current latest stable version of MySQL is 8.0. You can check your MySQL version with dbForge Studio for MySQL by following this few steps: in the Database Connection Properties window enter connection settings click Test Connection.


What is the latest version of MySQL?

The latest versions of MySQL are:Stable:MySQL 5: version 5.1.48 (2 June 2010)Preview Release:MySQL 5: version 5.5.4 (9 April 2010)


What is the latest MySQL version?

The latest versions of MySQL are:Stable:MySQL 5: version 5.1.48 (2 June 2010)Preview Release:MySQL 5: version 5.5.4 (9 April 2010)


What are 5 different types of databases?

sql db2 oracle mysql


Is MySQL open source?

Yes, MySQL is open source and is free to download and install. You can use the MySQL Installer to install and configure MySQL server on Windows operating system. It provides a simplified installation and configuration process for MySQL products running on Microsoft Windows. The list of MySQL products includes the following items: MySQL Server MySQL Workbench MySQL Router MySQL Shell MySQL for Visual Studio MySQL Reference Manuals PDF MySQL connectors (MySQL/Python connector, MySQL/NET connector, etc.) MySQL database examples. To get started with MySQL database easily, you can use the comprehensive solution provided by dbForge Studio for MySQL, which allows you to efficiently process data and automate the management of your database objects.


How can you overcome the problems of a flat-file database?

Store it in MySQL or use more then one flat-file DB...


How do you check if the MySQL is running?

To check if MySQL is running, you can use the command line. On Linux, you can execute systemctl status mysql or service mysql status to see the service status. On Windows, you can check the Task Manager for the MySQL service or use the command sc query MySQL. Additionally, you can try connecting to the MySQL server using the MySQL client with mysql -u username -p to see if it accepts connections.


Is MySQL a server?

MySQL is an open source relational database management system based on SQL queries. It was developed by the Swedish company MySQL AB and is now a subsidiary of Oracle Corporation. Your could use a MySQL Client, for example dbForge Studio for MySQL, to install and connect to MySQL Server as a first steps to get started with MySQL.


What is MySQL AB?

MySQL AB's population is 400.