Mysql help

This is a discussion on Mysql help within the Tech Board forums, part of the Community Boards category; So i'm not mysql savy, that's a give away....

  1. #1
    POeT GuY Matus's Avatar
    Join Date
    Feb 2008
    Location
    Bz
    Posts
    235

    Mysql help

    So i'm not mysql savy, that's a give away.
    Last edited by Matus; 03-15-2011 at 02:55 PM.
    PoEms R InsPiRatiOns of LIfE ExpErienCes!!


  2. #2
    Crazy Fool Perspective's Avatar
    Join Date
    Jan 2003
    Location
    Canada
    Posts
    2,640
    You seem to be using the ` character for you column names, this could be the source of your error, you shouldn't need any quotes around column names.

    Also, strings in SQL are generally delimited using the single quote character ' not the double quote "

    Check: MySQL :: MySQL 5.5 Reference Manual :: 12.2.5.1 INSERT ... SELECT Syntax

  3. #3
    Registered User linuxlover's Avatar
    Join Date
    Nov 2010
    Location
    INDIA
    Posts
    52
    Your syntax is wrong...See this

    SQL INSERT INTO Statement

  4. #4
    POeT GuY Matus's Avatar
    Join Date
    Feb 2008
    Location
    Bz
    Posts
    235
    thnx for the tips, ill be checkin on what u guys said, let u know if im succesful
    PoEms R InsPiRatiOns of LIfE ExpErienCes!!


  5. #5
    &TH of undefined behavior Fordy's Avatar
    Join Date
    Aug 2001
    Posts
    5,789
    @Matus

    Can you please not wipe out the original question you posted. It makes threads like this worthless to those who might have the same error and are also looking for help.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. TCP Server cannot save buffer data to mysql !
    By syedmuhd in forum C Programming
    Replies: 5
    Last Post: 09-18-2010, 09:54 PM
  2. MySQL query oddity between 2 OS's
    By xwielder in forum C Programming
    Replies: 8
    Last Post: 06-01-2010, 02:12 PM
  3. MySQL libraries
    By csonx_p in forum C++ Programming
    Replies: 6
    Last Post: 10-02-2008, 03:23 AM
  4. About C++ and MySQL or oether free database
    By xxxrugby in forum C++ Programming
    Replies: 18
    Last Post: 12-30-2005, 06:28 AM
  5. Get data from mysql and use in a system.
    By smaakage in forum Tech Board
    Replies: 3
    Last Post: 10-04-2005, 01:03 PM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21