Import data - Revision history

Connor at 15:15, 2 August 2012

2012-08-02T15:15:49Z

Connor at 14:04, 2 August 2012

2012-08-02T14:04:18Z

Marek at 15:32, 1 August 2012

2012-08-01T15:32:02Z

Marek at 15:29, 1 August 2012

2012-08-01T15:29:56Z

Connor at 09:01, 31 July 2012

2012-07-31T09:01:18Z

Connor at 09:00, 31 July 2012

2012-07-31T09:00:17Z

Connor at 08:47, 31 July 2012

2012-07-31T08:47:21Z

Connor: Created page with "Import someone else's data.

schema:scott
DROP TABLE employeeParking; DROP TABLE employeeCopy; <..."

2012-07-31T08:46:34Z

Created page with "Import someone else's data. <div class='ht'> <div class=params>schema:scott</div> <source lang=sql class='tidy'>DROP TABLE employeeParking; DROP TABLE employeeCopy;</source> <..."

New page

Import someone else's data.
<div class='ht'>
<div class=params>schema:scott</div>
<source lang=sql class='tidy'>DROP TABLE employeeParking;
DROP TABLE employeeCopy;</source>
<source lang=sql class='setup'> CREATE TABLE employeeParking(
id TEXT,
parkingSpace TEXT );
INSERT INTO employeeParking VALUES ('E01','F8');
INSERT INTO employeeParking VALUES ('E02','G22');
INSERT INTO employeeParking VALUES ('E03','F7');
CREATE TABLE employeeCopy (
id TEXT,
name VARCHAR(20),
phone INTEGER );
INSERT INTO employeeCopy VALUES ('E01','Harpo',2753);
INSERT INTO employeeCopy VALUES ('E02','Zeppo',2754);
INSERT INTO employeeCopy VALUES ('E03','Groucho',2755);
</source>
<div>
</div>

<source lang='sql' class='def'>CREATE VIEW mimic AS
SELECT employeeParking.id, COALESCE(name, employeeParking.id) AS name,
COALESCE(phone, 'Not Available') AS phone, parkingSpace
FROM employeeParking LEFT OUTER JOIN
employeeCopy ON (employeeParking.id = employeeCopy.id)</source>
<div class="ecomm e-mysql" style="display: none"></div>
</div>

{{Hacks Ref}}

@@ Line 53: / Line 53: @@
 </div>
-<source lang='sql' class='def'>CREATE VIEW mimic AS
+<source lang='sql' class='def'>
-SELECT employeeParking.id, COALESCE(name, employeeParking.id) AS name,
+CREATE VIEW mimic AS
-COALESCE(phone, 'Not Available') AS phone, parkingSpace
+     SELECT employeeParking.id, COALESCE(name, employeeParking.id) AS name,
-FROM employeeParking LEFT OUTER JOIN
+     COALESCE(phone, 'Not Available') AS phone, parkingSpace
 employeeCopy ON (employeeParking.id = employeeCopy.id);
-SELECT * FROM mimic;</source>
+       SELECT * FROM mimic;</source>
 <div class="ecomm e-mysql" style="display: none"></div>
 </div>
 {{Hacks Ref}}

@@ Line 1: / Line 1: @@
-Import someone else's data.
+<p>Import someone else's data.</p>
 <div class='ht'>
 <div class=params>schema:scott</div>

@@ Line 3: / Line 3: @@
 <div class=params>schema:scott</div>
 <source lang=sql class='tidy'>DROP TABLE employeeParking;
-DROP TABLE employeeCopy;</source>
+DROP TABLE employeeCopy;
 <source lang=sql class='setup'> CREATE TABLE employeeParking(
    id TEXT,