Need Some SQL help

Question

I need to pass the following SQL statement:

UPDATE table_products 
SET shipping = "a:5:{s:16:"min_items_in_box"; i:0;s:16:"max_items_in_box"; i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}";

I'm getting a syntax error from phpMyAdmin panel, asking to check the syntax. Could you please let me know what is wrong with the syntax?

What RDBMS is this for ??? – RolandoMySQLDBA Feb 19 '13 at 20:03 — RolandoMySQLDBA, Feb 19 '13 at 20:03
Says phpmyadmin @RolandoMySQLDBA. I'd say RolandoSQL :) – Philᵀᴹ Feb 19 '13 at 22:40 — Philᵀᴹ, Feb 19 '13 at 22:40

score 3 · Answer 1 · answered Feb 19 '13 at 20:07

3

Pass strings to the dbms within single quotes, not within double quotes.

UPDATE table_products 
SET shipping = 'a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}';

answered Feb 19 '13 at 20:07

Mike Sherrill 'Cat Recall'

10,766
1
36
43

Need Some SQL help

1 Answers1