All pastes #97249 Raw Edit

Someone

public text v1 · immutable
#97249 ·published 2006-07-23 14:14 UTC
rendered paste body
mysql> explain jobs;
+-----------+-------------+------+-----+---------+----------------+
| Field     | Type        | Null | Key | Default | Extra          |
+-----------+-------------+------+-----+---------+----------------+
| jobid     | int(11)     |      | PRI | NULL    | auto_increment |
| owner     | varchar(16) | YES  |     | NULL    |                |
| jobpri    | int(11)     | YES  |     | NULL    |                |
| prn       | varchar(64) | YES  |     | NULL    |                |
| filmroll  | varchar(30) | YES  |     | NULL    |                |
| minpage   | int(11)     | YES  |     | NULL    |                |
| maxpage   | int(11)     | YES  |     | NULL    |                |
| jobstate  | tinyint(4)  | YES  |     | NULL    |                |
| startdate | date        | YES  |     | NULL    |                |
| enddate   | date        | YES  |     | NULL    |                |
+-----------+-------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

mysql> select * from jobs;
Empty set (0.00 sec)

mysql> INSERT VALUES INTO jobs (filmroll, minpage, maxpage, prn, jobpri) VALUES ("dafa",5,3,"",3);
ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'VALUES INTO jobs (filmroll, minpage, maxpage, prn, jobpri) VALU
mysql>