RE: [sqlite] Conversion mysql -> sqlite

2005-03-16 Thread Reid Thompson
Peter Jay Salzman wrote: > Hi all, > > I know very little about mysql and sqlite - I've only played > around a little bit with databases, so I'm a newbie in this area. > > There's a blogger called Wheatblog that I've been trying to > convert from mysql to sqlite so I don't have to run a full >

Re: [sqlite] Conversion mysql -> sqlite

2005-03-16 Thread Jeremy Hinegardner
On Tue, Mar 15, 2005 at 03:26:26PM -0500, Peter Jay Salzman wrote: > Hi all, > > I know very little about mysql and sqlite - I've only played around a little > bit with databases, so I'm a newbie in this area. > > There's a blogger called Wheatblog that I've been trying to convert from > mysql

Re: [sqlite] Conversion mysql -> sqlite

2005-03-16 Thread Clay Dowling
Darren Duncan said: > Having NOT NULL with a PRIMARY KEY is redundant, if not an outright > error. Defining something as a primary key is implicitly defining it > to be both not null and distinct. -- Darren Duncan You'll find NOT NULL and PRIMARY KEY to be perfectly compatible, at least in

Re: [sqlite] Conversion mysql -> sqlite

2005-03-15 Thread Darren Duncan
At 3:26 PM -0500 3/15/05, Peter Jay Salzman wrote: And here's how I've tried to implement it on sqlite using PHP. Note that DB_query() is a wrapper for sqlite_query(). I've changed the "auto_increment" to "INTEGER PRIMARY KEY", as the FAQ said. I'm very new to SQL, but I guess "INTEGER PRIMARY

Re: [sqlite] Conversion mysql -> sqlite

2005-03-15 Thread Peter Jay Salzman
On Tue 15 Mar 05, 9:36 PM, Rob Laveaux <[EMAIL PROTECTED]> said: > > On 15-mrt-05, at 21:26, Peter Jay Salzman wrote: > > >It appears that the error is a "syntax error" near where my arrow > >(<--) > >is. Can someone throw some charity my way? Is there anything > >obviously > >wrong

RE: [sqlite] Conversion mysql -> sqlite

2005-03-15 Thread Reid Thompson
Peter Jay Salzman wrote: > Hi all, > > I know very little about mysql and sqlite - I've only played > around a little bit with databases, so I'm a newbie in this area. > > There's a blogger called Wheatblog that I've been trying to > convert from mysql to sqlite so I don't have to run a full >

Re: [sqlite] Conversion mysql -> sqlite

2005-03-15 Thread Rob Laveaux
On 15-mrt-05, at 21:26, Peter Jay Salzman wrote: It appears that the error is a "syntax error" near where my arrow (<--) is. Can someone throw some charity my way? Is there anything obviously wrong here? Yes, remove the "TYPE=MyISAM" part. This is a MySQL specific extension. HTH, - Rob