OT: Insert brackets ( [ , ] ) into mysql table
Jeff Vian
jvian10 at charter.net
Sun Nov 5 15:08:29 UTC 2006
On Sun, 2006-11-05 at 09:26 -0500, Dylan Semler wrote:
> On 11/5/06, Cameron Simpson <cs at zip.com.au> wrote:
> > 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?
>
> mysql> describe objects;
> +---------------+---------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +---------------+---------+------+-----+---------+-------+
> | object | char(1) | YES | | NULL | |
> | ID | char(1) | YES | | NULL | |
> | Spec. | char(1) | YES | | NULL | |
The 3 fields you are trying to put a 5 character string into is only one
character in length.
I note that all the other fields in this table are the same length as
well.
> | B | char(1) | YES | | NULL | |
> | V | char(1) | YES | | NULL | |
> | J | char(1) | YES | | NULL | |
> | $\sigma$J | char(1) | YES | | NULL | |
> | H | char(1) | YES | | NULL | |
> | $\sigma$H | char(1) | YES | | NULL | |
> | K | char(1) | YES | | NULL | |
> | $\sigma$K | char(1) | YES | | NULL | |
> | [3.6] | char(1) | YES | | NULL | |
> | $\sigma$[3.6] | char(1) | YES | | NULL | |
> | [4.5] | char(1) | YES | | NULL | |
> | $\sigma$[4.5] | char(1) | YES | | NULL | |
> | [5.8] | char(1) | YES | | NULL | |
> | $\sigma$[5.8] | char(1) | YES | | NULL | |
> | [8.0] | char(1) | YES | | NULL | |
> | $\sigma$[8.0] | char(1) | YES | | NULL | |
> +---------------+---------+------+-----+---------+-------+
> 19 rows in set (0.00 sec)
>
>
>
>
> --
> Type faster. Use Dvorak:
> http://dvzine.org
> --
> fedora-list mailing list
> fedora-list at redhat.com
> To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
More information about the users
mailing list