Worked like a charm, thanks.

How do I avoid varchar if I the size of the text will vary with each entry?

It's going to be a pretty small database anyway so I'm not that worried, 
but how often do I optimize the table to avoid fragmentation?

-Lisi

At 10:29 AM 4/8/02 +0200, you wrote:
>I don't think you can use text(50),
>
>It should be one of the following tinytext, mediumtext or text
>Or you should use char(50).
>
>I would try to avoid using varchar() it fragments the database.
>
>Remco
>
>----- Original Message -----
>From: "Lisi" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, April 08, 2002 11:11 AM
>Subject: [PHP-DB] Error creating new table
>
>
> > I am trying to create the following table using PHPMyAdmin:
> >
> > CREATE TABLE IF NOT EXISTS ayny(
> >          organization varchar(50) NOT NULL,
> >          subtitle varchar(50) NOT NULL,
> >          img varchar(20) NOT NULL,
> >          width varchar(5),
> >          height varchar(5),
> >          link varchar(30) NOT NULL,
> >          maintext text(50) NOT NULL,
> >          boxtext text(50) NOT NULL,
> >          ID INT(9) NOT NULL AUTO_INCREMENT,
> >          PRIMARY KEY(ID)
> > );
> >
> > But I keep getting the following error:
> >
> > MySQL said: You have an error in your SQL syntax near '(50) NOT NULL,
> > boxtext text(50) NOT NULL, ID INT(9) NOT NULL AUTO_INCREMENT,' at line 8
> >
> > Any ideas what I'\m doing wrong?
> >
> > TIA,
> >
> > -Lisi
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to