\_(K_I)_/
Новичок
Помогите пожалуйста
SQL-запрос:
[...]
Ответ 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 'CREATE TABLE IF NOT EXISTS `bonus_day` (
`bonus_id` int(11) NOT NULL,
`bonus' at line 45
....
Как в файле
--
-- Структура таблицы `bonus_day`
--
CREATE TABLE IF NOT EXISTS `bonus_day` (
`bonus_id` int(11) NOT NULL,
`bonus_id_account` int(11) NOT NULL DEFAULT '0',
`bonus_day_1_time` int(11) NOT NULL DEFAULT '-1',
`bonus_day_2_time` int(11) NOT NULL DEFAULT '-1',
`bonus_day_3_time` int(11) NOT NULL DEFAULT '-1',
`bonus_day_4_time` int(11) NOT NULL DEFAULT '-1',
`bonus_day_5_time` int(11) NOT NULL DEFAULT '-1',
`bonus_day_6_time` int(11) NOT NULL DEFAULT '-1',
`bonus_day_7_time` int(11) NOT NULL DEFAULT '-1'
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=cp1251;
--
-- Дамп данных таблицы `bonus_day`
--
INSERT INTO `bonus_day` (`bonus_id`, `bonus_id_account`, `bonus_day_1_time`, `bonus_day_2_time`, `bonus_day_3_time`, `bonus_day_4_time`, `bonus_day_5_time`, `bonus_day_6_time`, `bonus_day_7_time`) VALUES
(1, 1, 1501398576, -1, -1, -1, -1, -1, -1),
(2, 3, 1501678790, -1, -1, -1, -1, -1, -1),
(3, 5, 1502031144, -1, -1, -1, -1, -1, -1),
(4, 6, 1502040149, -1, -1, -1, -1, -1, -1);
-- --------------------------------------------------------
SQL-запрос:
[...]
Ответ 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 'CREATE TABLE IF NOT EXISTS `bonus_day` (
`bonus_id` int(11) NOT NULL,
`bonus' at line 45
....
Как в файле
--
-- Структура таблицы `bonus_day`
--
CREATE TABLE IF NOT EXISTS `bonus_day` (
`bonus_id` int(11) NOT NULL,
`bonus_id_account` int(11) NOT NULL DEFAULT '0',
`bonus_day_1_time` int(11) NOT NULL DEFAULT '-1',
`bonus_day_2_time` int(11) NOT NULL DEFAULT '-1',
`bonus_day_3_time` int(11) NOT NULL DEFAULT '-1',
`bonus_day_4_time` int(11) NOT NULL DEFAULT '-1',
`bonus_day_5_time` int(11) NOT NULL DEFAULT '-1',
`bonus_day_6_time` int(11) NOT NULL DEFAULT '-1',
`bonus_day_7_time` int(11) NOT NULL DEFAULT '-1'
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=cp1251;
--
-- Дамп данных таблицы `bonus_day`
--
INSERT INTO `bonus_day` (`bonus_id`, `bonus_id_account`, `bonus_day_1_time`, `bonus_day_2_time`, `bonus_day_3_time`, `bonus_day_4_time`, `bonus_day_5_time`, `bonus_day_6_time`, `bonus_day_7_time`) VALUES
(1, 1, 1501398576, -1, -1, -1, -1, -1, -1),
(2, 3, 1501678790, -1, -1, -1, -1, -1, -1),
(3, 5, 1502031144, -1, -1, -1, -1, -1, -1),
(4, 6, 1502040149, -1, -1, -1, -1, -1, -1);
-- --------------------------------------------------------
Последнее редактирование: