Log in

View Full Version : confused with query SQL?


surfhog
04-05-2004, 07:04 PM
I am confused with some hacks now saying thus:

Run this query SQL (don't forget to add a prfix to the table's name if you use it in your config.php)
Has my table prefix is vb3_ I am not sure how I need to enter this?
Here is an example:

CREATE TABLE `glossaire` (
`id` int(5) NOT NULL auto_increment,
`nom` varchar(25) NOT NULL default '',
`def` text NOT NULL,
`valide` int(1) NOT NULL default '0',
`lettre` char(1) NOT NULL default '',
KEY `lettre` (`lettre`,`id`)
);
:o :rolleyes: Thanks in advance.

AN-net
04-05-2004, 07:10 PM
you mean ur table prefix is vb3_ ?

filburt1
04-05-2004, 07:20 PM
Change

CREATE TABLE `glossaire`

to

CREATE TABLE `vb3_glossaire`

surfhog
04-05-2004, 08:11 PM
oic now and thanks very much filburt1