Re: stupid insert error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



David Bear,您好!

	yes.of course.
    you should insert the record like this:
    insert into person3 (asuid, fname, lname, addedby, addedon,
    slopbucket) values ('123455', 'name', 'name', 'entered', '12/12/2004', '');

======= 2005-06-24 08:12:03 您在来信中写道:=======

>I guess I'm too stupid to see the error, but I don't understand why
>the following fails.
>
>
>insert into person3 (asuid, fname, lname, addedby, addedon,
>slopbucket) values ("123455", "name", "name", "entered", "12/12/2004", NULL);
>ERROR:  column "123455" does not exist
>
>is the double quote byting me?
>-- 
>David Bear
>phone: 	480-965-8257
>fax: 	480-965-9189
>College of Public Programs/ASU
>Wilson Hall 232
>Tempe, AZ 85287-0803
> "Beware the IP portfolio, everyone will be suspect of trespassing"
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>

= = = = = = = = = = = = = = = = = = = =
			

        致
礼!
 
				 
        李江华
        ljh1469@xxxxxxxxxxxxxxx
          2005-06-24


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux