---

Hej NG.

Jeg prøver at få MySql til at lave en tabel efter følgende:

mysql> create table trans_210_type (project_ID varchar(50),
project_description text, costumer_contact varchar(50), unit_no varchar(50),
location_place varchar(100), only_one_activity enum('no', 'yes') default
'no', activity_ID varchar(50), activity_description text,
planned_activity_start_date date, planned_activity_end_date date,
planned_activity_duration varchar(50), legal_employees text,
legal_departments text, project_status enum('released', 'started',
'delayed', 'completed') default 'released', project_data text, hcstat_hcmess
enum('0', '1', '2', '3', '4', '5', '6', '7', '8'. '9') default '0',
free_text1 text, free_text2 text) type=MyISAM;

Men jeg får melding om fejl, jeg har fjernet alle not null osv. Men får
stadig en fejl, nogle forslag.

Mvh.Leif.

---

On Thu, 20 Nov 2003 21:10:10 +0100, "Leif" <?> wrote:

>enum('0', '1', '2', '3', '4', '5', '6', '7', '8'. '9') default '0',

Du har et punktum i stedet for et komma efter '8'

--
- Peter Brodersen

Ugens sprogtip: :) (og ikke *sxms*)

---

Hej. Tak. Jeg har rettet punktum til komma, men får stadig følgende fejl:

ERROR 1064 at line 1: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'mysql> create table trans_210_type (project_ID varchar(50), pro

Mvh. Leif.

"Peter Brodersen" <usenet@ter.dk> skrev i en meddelelse
news:bpj79q$oh2$1@dknews.tiscali.dk...
> On Thu, 20 Nov 2003 21:10:10 +0100, "Leif" <?> wrote:
>
> >enum('0', '1', '2', '3', '4', '5', '6', '7', '8'. '9') default '0',
>
> Du har et punktum i stedet for et komma efter '8'
>
> --
> - Peter Brodersen
>
> Ugens sprogtip: :) (og ikke *sxms*)

---

"Leif" <?> wrote in message
news:3fc0ecdf$0$137$edfadb0f@dread11.news.tele.dk...
> Hej. Tak. Jeg har rettet punktum til komma, men får stadig følgende fejl:
>
> ERROR 1064 at line 1: You have an error in your SQL syntax. Check the
> manual that corresponds to your MySQL server version for the right syntax
to
> use near 'mysql> create table trans_210_type (project_ID varchar(50), pro

Den her virker.!

CREATE TABLE trans_210_type( project_ID varchar( 50 ) ,
project_description text,
costumer_contact varchar( 50 ) ,
unit_no varchar( 50 ) ,
location_place varchar( 100 ) ,
only_one_activity enum( 'no', 'yes' ) default 'no',
activity_ID varchar( 50 ) ,
activity_description text,
planned_activity_start_date date,
planned_activity_end_date date,
planned_activity_duration varchar( 50 ) ,
legal_employees text,
legal_departments text,
project_status enum( 'released', 'started', 'delayed', 'completed' )
default 'released',
project_data text,
hcstat_hcmess enum( '0', '1', '2', '3', '4', '5', '6', '7', '8', '9' )
default '0',
free_text1 text,
free_text2 text ) TYPE = MYISAM


mvh Kim Isaksen

---

Hej. Tak for hjælpen.

Det eneste jeg kan se du har gjort anderledes, er flere mellemrum, og store
bogstaver, vidste ikke det betød så meget.

Mvh. leif.

"kim isaksen" <lysalf@hippie.dk.private.me> skrev i en meddelelse
news:6G7wb.44675$jf4.2295969@news000.worldonline.dk...
> "Leif" <?> wrote in message
> news:3fc0ecdf$0$137$edfadb0f@dread11.news.tele.dk...
> > Hej. Tak. Jeg har rettet punktum til komma, men får stadig følgende
fejl:
> >
> > ERROR 1064 at line 1: You have an error in your SQL syntax. Check the
> > manual that corresponds to your MySQL server version for the right
syntax
> to
> > use near 'mysql> create table trans_210_type (project_ID varchar(50),
pro
>
> Den her virker.!
>
> CREATE TABLE trans_210_type( project_ID varchar( 50 ) ,
> project_description text,
> costumer_contact varchar( 50 ) ,
> unit_no varchar( 50 ) ,
> location_place varchar( 100 ) ,
> only_one_activity enum( 'no', 'yes' ) default 'no',
> activity_ID varchar( 50 ) ,
> activity_description text,
> planned_activity_start_date date,
> planned_activity_end_date date,
> planned_activity_duration varchar( 50 ) ,
> legal_employees text,
> legal_departments text,
> project_status enum( 'released', 'started', 'delayed', 'completed' )
> default 'released',
> project_data text,
> hcstat_hcmess enum( '0', '1', '2', '3', '4', '5', '6', '7', '8', '9' )
> default '0',
> free_text1 text,
> free_text2 text ) TYPE = MYISAM
>
>
> mvh Kim Isaksen
>
>