In chapter 11 under Manipulating Data in a Database there is a INSERT command example. I have done all of the required steps to get to the database and everything and I type in what it says but I am getting a:

ERROR 1136: Column count doesn't match value count in row 1

Can anyone tell me why?

Hmm..
On my comp works correctly...

...but the Soon is eclipsed by the Moon

I appreciate your question was posted more than 2 years ago, so the sethtrain may have already left the station, but if you're referring to the INSERT INTO DVDs2, where values are copied from another database, I had the same problem and solved it by including 'DVDID' as one of the fields in the SELECT. It would appear that this error can be generated when there are fewer columns specified in the destination table than in the source.

101boxdevice

Further to my last post, I now realise I mis-named the field 'DVID', when it should have been 'DVDName' - so this is one way at least that the error can occur ... ;-(

101boxdevice

I had the same problem but found that it was the tomestamp and date that was added to the db in the command line client, easily fixed by adding tha approtriate info for example:-

mysql> INSERT INTO users VALUES(
     ->NULL,
     ->'Pads',
     ->password('password'),
     ->'Brian Reid',
     ->'Winger',
     ->'[email protected]',
     ->'A top class ball handler.'),
     ->'yyyy-mm-dd',
     ->'yyyymmddhhmmss');

Note the extra date and time tables in the db, either drop the tables or populate them. You might have others tho so check and see first.

you can do that by opening your command line client and typing in your password, then type:-

mysql> SHOW DATABASES;

and you should get something that looks like this:-

 --------------------
| Database |
 --------------------
| Test |
| Sample_db |
 --------------------

Then type:-

mysql> USE sample_db;

Then type:-

mysql> SHOW TABLES;

and you'll get something like this...

 -----------------------
| Tables in sample_db |
 -----------------------
| access_log |
| user |
 -----------------------

then you type...

mysql> DESC user;

and you should get a list of all the field titles which you need to fill when you enter the information into the database through your command line client.

I understand this post is way late but maybe it can help someone else...





Dislexics have more fnu