List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 28 2003 5:06pm
Subject:Re: Converting a MDB database into a mySQl Database
View as plain text  
At 10:52 -0500 4/28/03, Jeremy Bush wrote:
>hmm, I tried this, and it says there is an error in the syntax.

And indeed there is. Your description and keywords values aren't quoted.

If mydate is a DATE type, you'll also have problems with dates that aren't
in year-month-day order.

>   here is a
>sample line:
>INSERT INTO all_pages(id,title,description,keywords,url,mydate) VALUES
>(25,"MX285 Tractor",Downloadable Images,mx285 tractorDownloadable
>Images,"http://www.imagemanagement.ws/downloads/caseih/mx285.asp","3/20/2003
>");
>
>the table is created with all the row titles as described in the sql
>statement.


-- 
Paul DuBois
http://www.kitebird.com/
sql, query
Thread
Converting a MDB database into a mySQl DatabaseJeremy Bush25 Apr
  • Re: Converting a MDB database into a mySQl DatabaseC. Nicely25 Apr
    • Re: Converting a MDB database into a mySQl DatabaseJeremy Bush28 Apr
      • Re: Converting a MDB database into a mySQl DatabasePaul DuBois28 Apr
    • Re: Converting a MDB database into a mySQl DatabaseJeremy Bush28 Apr
    • Re: Converting a MDB database into a mySQl Databasegerald_clark28 Apr
    • Re: Converting a MDB database into a mySQl DatabaseJeremy Bush28 Apr
  • Re: Converting a MDB database into a mySQl DatabaseKaram Chand26 Apr
RE: Converting a MDB database into a mySQl DatabaseMike Hillyer25 Apr
RE: Converting a MDB database into a mySQl DatabaseDave Christensen25 Apr