Timestamp type, Database Management System

Do NOT use the timestamp type.  Use separate date and time data types only.  Figure out how to define an SQL insert statement that uses built-in SQL (or MySQL) functions to define the date and the time on an insert.  Do not set the MySQL data or time using PHP functions: use only (SQL) MySQL functions embedded in your SQL commands submitted by your script.

Posted Date: 3/29/2013 5:51:17 AM | Location : United States







Related Discussions:- Timestamp type, Assignment Help, Ask Question on Timestamp type, Get Answer, Expert's Help, Timestamp type Discussions

Write discussion on Timestamp type
Your posts are moderated
Related Questions
using the invoice table shown below,write the relational schema,draw a dependencies,inclunding all partial and transitive dependencies.assume that the table does not contain repeat

Update or Modify operation alters the existing values. If these operations alter the value that is the foreign key also, the only check need is the similar as that of the Insert op

What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is

What are the drawbacks of shadow-paging technique? The drawbacks of shadow paging is:- a) Commit Overhead b) Data fragmentation c)  Garbage collection

waht is a repeating group?

A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of Ame

What is persistency? Persistency ensures which data is stored and that after the object is no longer available (program stops running) the data will be available to other users

construct an er diagram for a hospital with a set of patients and a set of medical doctors. associate with each patient a log of various test and examination conducted.convert er d

Making Common Behaviour Abstract Let us define abstraction "Abstraction means to focus on the necessary, inherent aspects of an entity and ignoring its accidental features". O

What is the difference among a database schema and a database state? The collection of information stored in database at particular moment in time is known as database state a