I had created a table and started populating it, but did not get to certain fields until later.


When I tried to do an insert it would not go. It was not reconizing 2 fields. I read and re-read the statement etc. Tried it from phpMyAdmin, command line and my php script.


Anyways, I removed one field and put it back in and it worked... But now I really wanted to figure out why.


After another few minutes of invetigation I realized that I had a trailing space in the name.

It was due to copy and pasting the names into phpMyAdmin. You would think someone would haver put a trim in there.

Well... Just thought I would pass on this experience.

Cheers,
Mike





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to