Re: FN-FORUM another simple mysql problem

date posted 27th April 2001 18:26

On Fri, Apr 27, 2001 at 12:10:40PM -0400, [EMAIL REMOVED] wrote:
> does anyone know why this .sql file won't import into a mysql database? It seems to come up with errors concerning the date, date right from the start.
>



>
> date date,
> day char(15),

day and date are mysql reserved words.

use:

entry_day
entry_date

or something similar.

Is there any reason why you are using char(x) rather than varchar(x)? If you don't
need fixed width fields, varchar() is *much* more space-efficient - and mysql will
use char() if it can save space that way.


Also, how are you generating your primary keys? mysql has a brilliant auto_increment
function which means that the keys are always unique, even when the db is hammered
by lots of processes at the same time...