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
What are the function of DBA?

Explain the term High level DML? High level DML A high-level or non-procedural DML permit the user to specify what data is needed without specifying how it is to be acquired.

explain equi-join using illustration

Vertical Fragmentation- Vertical fragmentation groups together only those attributes in a relation that are used jointly by various important transactions. A vertical fragment is d

Describe the four main ways of optimising disk block access. Ans: a. Disk  b. Non-volatile writes buffers c. File organization (Clustering) d. Log-based file system

List any two significant differences between a file processing system and a DBMS. File Processing System vs. DBMS Data Independence - Data independence is the capacity t

Define outer union operation of the relational algebra. Compute the outer union for the relations R and S given below. Outer Join - If there are any values in one tabl

Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i

Which product produces the relation that has attributes of R1 and R2 ? Cartesian product produce the relation which has attributes of R1 and R2

I just purchased a document for you guys and wanted to confirm that it will be send within an hour or 2 to my email or where will document be sent to?