View Single Post
  #3 (permalink)  
Old 09-07-2008, 03:54 AM
dink dink is offline
Newbie
 
Join Date: Sep 2008
Posts: 2
Credits: 0
Rep Power: 0
dink is on a distinguished road
Cool Re: MySQL Column count does not match value count at row 1

Thanks orjan!

I could not have done this with out your help. The textbook leaves out a lot of vital information for a newbie.
I finally got it to work by inserting field names and then the values for the fields that did not have default values.
INSERT INTO user
(Host,User,Password,ssl_cipher,x509_issuer,x509_su bject) VALUES('localhost','myuser','mypassword','null','n ull','null');

There is no way I could have found this information on my own. It only took me 30 minutes to figure out the code you posted needed a semicolon to work. haha

Again thanks and I really appreciate your help.
Who knows maybe some day I can help some one.
dink
Reply With Quote