Difference between revisions of "Template:DATE and TIME ref"

From SQLZOO
Jump to navigation Jump to search
(Created page with "TODO: <div class='tutlist'><div class='fc'>CREATE and DROP Operations</div> <div>CREATE a new table</div> <div>DROP a table</div> <div>Composite primary key</...")
 
 
(5 intermediate revisions by one other user not shown)
Line 1: Line 1:
TODO:
+
<div class='tutlist'><div class='fc'>[[DATE and TIME Reference|DATE and TIME Operations]]</div>
 
+
<div>[[Date and time types]]</div>
<div class='tutlist'><div class='fc'>[[CREATE and DROP Operations]]</div>
+
<div>[[Format a date and time]]</div>
<div>[[CREATE a new table]]</div>
+
<div>[[Specify a date]]</div>
<div>[[DROP a table]]</div>
+
<div>[[Match a range of dates]]</div>
<div>[[Composite primary key]]</div>
+
<div>[[Subtract dates]]</div>
<div>[[CREATE a foreign key]]</div>
+
<div>[[INTERVAL of time]]</div>
<div>[[CREATE a VIEW]]</div>
+
<div>[[Components of date]]</div>
<div>[[Autonumber fields]]</div>
+
<div>[[Date functions]]</div>
<div>[[ALTER TABLE ... ADD COLUMN]]</div>
+
<div>[[Date arithmetics]]</div>
<div>[[ALTER TABLE ... DROP COLUMN]]</div>
+
<div>[[Select the oldest person]]</div>
<div>[[ALTER TABLE ... ADD constraint]]</div>
+
<div>[[Select a record with the latest date]]</div>
<div>[[CREATE TABLE problems: Invalid column name.]]</div>
+
<div>[[YYYYMMDD date format]]</div>
<div>[[CREATE TABLE problems: Insufficient privileges.]]</div>
+
<div>[[Getting the latest record]]</div>
<div>[[CREATE TABLE problems: Table already exists.]]</div>
 
<div>[[DROP TABLE problems: Foreign key references.]]</div>
 
<div>[[CREATE TABLE problems: Foreign key references.]]</div>
 
<div>[[Rename column]]</div>
 
 
</div>
 
</div>

Latest revision as of 22:07, 22 September 2012