I am having a update problem, I have a table that has 28 columns they
are name 1-28. I am able to insert data into the table. When I try to
update info into the table it does not work. Any ideas?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
In the last episode (Jun 09), Blake Schroeder said:
I am having a update problem, I have a table that has 28 columns they
are name 1-28. I am able to insert data into the table. When I try to
update info into the table it does not work. Any ideas?
Not until you tell us the error message.
Sorry
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#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 '1 = '1' WHERE id = '1'' at line 1
-Blake
|
Dan Nelson wrote:
In the last episode (Jun 09),
I am having a update problem, I have a table that has 28 columns they
are name 1-28. I am able to insert data into the table. When I try to
update info into the table it does not work. Any ideas?
1) What are the QUERY you´re using to UPDATE datas?
2) What is the error message?
3) What are the
Blake,
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#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 '1 = '1' WHERE id = '1'' at line 1
Is the column 1 string type?
If it´s numec type. You
The type is a varchar.
-Blake
Ronan Lucio wrote:
Blake,
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#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 '1 = '1' WHERE id = '1'' at line 1
Is the
In the last episode (Jun 09), Blake Schroeder said:
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#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 '1 = '1' WHERE id = '1'' at line 1
Mysql is
Dan
Great suggestion also.
-Blake
Dan Nelson wrote:
In the last episode (Jun 09), Blake Schroeder said:
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#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