Error bij tabel toevoegen.
Bernd
07/08/2008 16:41:00Hey,
Ik ben vrij nieuw op gebied van SQL. Ik was aan het proberen deze tabel toe te voegen:
Ik ben vrij nieuw op gebied van SQL. Ik was aan het proberen deze tabel toe te voegen:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
CREATE TABLE IF NOT EXISTS `gebruikers` (
`id` int(5) NOT NULL auto_increment,
`naam` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
`wachtwoord` varchar(40) character set latin1 collate latin1_general_ci NOT NULL,
`email` varchar(100) character set latin1 collate latin1_general_ci NOT NULL default '',
`ip` varchar(15) character set latin1 collate latin1_general_ci NOT NULL default '',
`rang` varchar(100) character set latin1 collate latin1_general_ci NOT NULL default 'member',
`active` varchar(3) NOT NULL default yes',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
[/Code]
Maar toen kreeg ik een error:
MySQL said:
#1064 - 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 'yes',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 8
Iemand enig idee?
Alvast bedankt!
`id` int(5) NOT NULL auto_increment,
`naam` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
`wachtwoord` varchar(40) character set latin1 collate latin1_general_ci NOT NULL,
`email` varchar(100) character set latin1 collate latin1_general_ci NOT NULL default '',
`ip` varchar(15) character set latin1 collate latin1_general_ci NOT NULL default '',
`rang` varchar(100) character set latin1 collate latin1_general_ci NOT NULL default 'member',
`active` varchar(3) NOT NULL default yes',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
[/Code]
Maar toen kreeg ik een error:
MySQL said:
#1064 - 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 'yes',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 8
Iemand enig idee?
Alvast bedankt!
Gewijzigd op 01/01/1970 01:00:00 door Bernd
PHP hulp
29/03/2024 13:55:10Jacco Engel
07/08/2008 16:42:00Zoek de verschillen,
Hint : Kleurtjes