answersLogoWhite

0

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.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the best way to store searchable information?

The best way to store searchable information is by using a database management system like MySQL, PostgreSQL, or MongoDB. These systems allow you to structure your data efficiently and perform fast searches using query languages like SQL or MongoDB query language. Using indexes and optimizing queries can further enhance search performance.


Where can one get a tutorial for Mysql select?

A good place to start for learning mysql is with the dev mysql site. This gives tutorials and a well indexed menu for finding your way around. It is easy to understand which is a bonus.


What is the best way to store flax seed?

The best way to store flax seed is in the refrigerator or in the freezer. Make sure the bag you store it in is airtight as flax seed can get rancid.


What is the best way to store insulin?

in the refrigerator


What is the best way to store cooked food?

The best way is in a sealed container in the refrigerator, or freezer.


What is the best way to store ornaments after Christmas to keep them from breaking?

The best way to store ornaments after Christmas is to wrap them with tissue paper and store them in a box with compartments or use shoe boxes to pack them.


What is the best way to store water?

The best way would probably store water in a nice cold place so it can cold so, later on you can have a nice cold drink. Or you can store water in a pantry.


Best way to store photos?

In Chronological order.


What is the best way to store vegetable?

under refrigeration


What is the best way to store airsoft guns?

in a case


How do you get the day of the week with php?

Following code will give you current day of the week (monday, Tuesday and so on):$day = date ('l', time());If you want more information on this topic, you can search php.net for function "date()" which formats timestamp in a way you want and "time()" which returns current timestamp.


How do i get to best buy store from here?

The best way to get to the Best Buy store from where you are is to use a navigation app. If I knew where you were I would be happy to provide directions.