StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>not a solution for huge tables of course, and auto increments that are different. you could automate this with a cron job with a certain occurrence or if you say plop a value in a certain table that the cron job sees, clears, and begins it.</p> <pre><code>CREATE TABLE charlie1 ( billybob INT NOT NULL, birthdate DATETIME NOT NULL, funny_num FLOAT NOT NULL )ENGINE=INNODB; INSERT INTO charlie1 (billybob,birthdate,funny_num) VALUES (1,'2006-01-02',28832.123); INSERT INTO charlie1 (billybob,birthdate,funny_num) VALUES (2,'2004-09-02',18832.888); INSERT INTO charlie1 (billybob,birthdate,funny_num) VALUES (3,'2006-07-03',28332.123); INSERT INTO charlie1 (billybob,birthdate,funny_num) VALUES (4,'2006-01-02',28852.777); SELECT billybob,birthdate,funny_num FROM charlie1 ORDER BY billybob INTO OUTFILE '/tmp/charlie1.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' CREATE TABLE charlie2 ( billybob INT NOT NULL, birthdate DATETIME NOT NULL, funny_num FLOAT NOT NULL )ENGINE=MYISAM; INSERT INTO charlie2 (billybob,birthdate,funny_num) VALUES (1,'2006-01-02',28832.123); INSERT INTO charlie2 (billybob,birthdate,funny_num) VALUES (2,'2004-09-02',18832.888); INSERT INTO charlie2 (billybob,birthdate,funny_num) VALUES (3,'2006-07-03',28332.123); INSERT INTO charlie2 (billybob,birthdate,funny_num) VALUES (4,'2006-01-02',28852.777); SELECT billybob,birthdate,funny_num FROM charlie2 ORDER BY billybob INTO OUTFILE '/tmp/charlie2.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' i changed data in the file to show diff picks it up: root@hp:/tmp# diff /tmp/charlie1.csv /tmp/charlie2.csv 2c2 < "2","2004-09-02 00:00:00","18832.9" --- > "2","2004-09-02 00:00:00","18832.8" </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload