Re: Converting a MDB database into a mySQl Database

[Paul DuBois]

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