OT: Insert brackets ( [ , ] ) into mysql table

[Cameron Simpson]

On 05Nov2006 02:23, Dylan Semler <dylan.semler at gmail.com> wrote:
| I've been searching a bit for this but nothing seems to work.  I have a mysql
| database setup and want to insert the value [mag] into a table.  How does one
| do that?  I've tried many variations on:
| 
|  insert into objects (object, ID, `Spec.`) VALUES ('[mag]', '[mag]', '[mag]
| ');
| 
| with backslashes and backticks around the brackets.  Usually mysql juts
| updates the table with a [, rather than [mag].  Anyone know how this should
| be done?

Please show us "describe objects". Maybe your column types are
restrictive?
-- 
Cameron Simpson <cs at zip.com.au> DoD#743
http://www.cskk.ezoshosting.com/cs/

deltaV = g * Isp * ln(Mr) ... it's not just a good idea, it's the Law
        - george william herbert <wh at crl.com>