Есть база даных в MySQL:
SQL |
CREATE TABLE dle_zakaz( id_article INT NOT NULL AUTO_INCREMENT, name TINYTEXT NOT NULL, description TINYTEXT NOT NULL, autors TINYTEXT NOT NULL, years TINYTEXT NOT NULL, rozdil TINYTEXT NOT NULL, id_page MEDIUMINT NOT NULL, PRIMARY KEY (id_article), KEY id_page (id_page)) ENGINE=MyISAM; |
Цитата (Nazz @ 28.03.2009 - 14:17) | ||
Есть база даных в MySQL:
Но выдает ошыбку: #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 'AM' at line 1 Подскажите что делать, плиз... Заранее благодарен!!! |
SQL |
CREATE TABLE `dle_zakaz` ( `id_article` int(11) NOT NULL auto_increment, `name` tinytext NOT NULL, `description` tinytext NOT NULL, `autors` tinytext NOT NULL, `years` tinytext NOT NULL, `rozdil` tinytext NOT NULL, `id_page` mediumint(9) NOT NULL, PRIMARY KEY (`id_article`), KEY `id_page` (`id_page`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; |
AUTO_INCREMENT=1 CHARACTER SET 'cp1251' COLLATE 'cp1251_general_ci';А вот ошибка
ALTER TABLE dle_usergroups ADD `admin_table` TINYINT( 1 ) NOT NULL DEFAULT '0';
ОшибкаУстанавливаю стол заказов модуль на сайт.
SQL-запрос:
ALTER TABLE dle_usergroups ADD `admin_table` TINYINT( 1 ) NOT NULL DEFAULT '0';
Ответ MySQL:
#1146 - Table 'novchat_zakaz.dle_usergroups' doesn't exist
CREATE TABLE `dle_table` (Вот весь запрос
`id` INTEGER(6) NOT NULL AUTO_INCREMENT,
`date` VARCHAR(15) COLLATE cp1251_general_ci NOT NULL DEFAULT '',
`name` VARCHAR(40) COLLATE cp1251_general_ci NOT NULL DEFAULT '',
`runame` VARCHAR(40) COLLATE cp1251_general_ci NOT NULL DEFAULT '',
`enname` VARCHAR(40) COLLATE cp1251_general_ci NOT NULL DEFAULT '',
`fileyear` YEAR(4) NOT NULL DEFAULT '0000',
`category` VARCHAR(10) COLLATE cp1251_general_ci NOT NULL DEFAULT '',
`link` TEXT COLLATE cp1251_general_ci NOT NULL,
`answer` TEXT COLLATE cp1251_general_ci NOT NULL,
`status` TINYINT(1) NOT NULL DEFAULT '0',
`editor` VARCHAR(30) COLLATE cp1251_general_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `id` (`id`)
)ENGINE=MyISAM
AUTO_INCREMENT=1 CHARACTER SET 'cp1251' COLLATE 'cp1251_general_ci';
ALTER TABLE dle_usergroups ADD `admin_table` TINYINT( 1 ) NOT NULL DEFAULT '0';