| Mailing List | | Home | | MySQL General - General MySQL discussion | | MaxDB - Everything about MaxDB, formerly known as SAP DB | | MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP | | Java Help - Mostly related to the MySQL Connector/J driver | | ODBC - ODBC with the MySQL Connector/ODBC driver | | Perl - Perl support for MySQL with DBI and DBD::mysql | | MySQL++ - Programming with the C++ API to MySQL |
|
|
  | |  | Going from 3.23 to 4 - sql statement errors | Going from 3.23 to 4 - sql statement errors 2004-03-20 - By Victoria Reznichenko
Back "Mike R " <spycobalt@(protected) > wrote:
>
> Thanks for responding! :)
>
> "UPDATE sites SET start_date = '$MySQLDate ', domain = '$host_edit ',
> host_plan = '$host_plan_edit ', ssl = '$ssl_edit ', fp_ext = '$fp_ext_edit ',
> username = '$username_edit ', password = '$password_edit ', fp_password =
> '$fp_password_edit ', cust_comments = '$cust_comments_edit ', customer_id =
> '$customer_id_edit ', shared = '$shared_edit ', ip_address =
> '$ip_address_edit ', server_name = '$server_name_edit ', site_id =
> '$site_id_edit ', host_price = '$host_price_edit ' WHERE domain =
> '$domainhosted ' "
>
SSL is a reserved word. Use backticks (`) to quote column name:
http://www.mysql.com/doc/en/Reserved_words.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@(protected)
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives:
http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=mysql
@(protected)
|
|
 |