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
>
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
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
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
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
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
>
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
7 matches
Mail list logo