When asking questions, shouldn't we encourage new (indeed all) posters to give DDL and DML rather than table descriptions and rows of data?
I'll use a trivial example from MySQL.
mysql> create table fred(billy int, joe int, PRIMARY KEY (billy));
mysql> insert into fred values(1,1);
mysql> insert into fred values(2, 1);
mysql> insert into fred values(3, 1);
Now, we should encourage posters NOT to post the following as their table defintion:
mysql> desc fred;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| billy | int(11) | NO | PRI | 0 | |
| joe | int(11) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
But rather:
mysql> show create table fred; <some stuff deleted...>
CREATE TABLE `fred` (
`billy` int(11) NOT NULL DEFAULT '0',
`joe` int(11) DEFAULT NULL,
PRIMARY KEY (`billy`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
And likewise, data should NOT be given as:
mysql> select * from fred;
+-------+------+
| billy | joe |
+-------+------+
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
+-------+------+
But rather:
insert into fred values(1,1);
insert into fred values(2, 1);
insert into fred values(3, 1);
An example occurred today here and bluefeet's answer was excellent, however he wouldn't have had to write out INSERTs &c. had the OP done it for him. I know that this was a relatively trivial example, but it could save contributors here considerable time and trouble as well as increasing the value of dba.stackexchange as a site. Any takers?
