Databases
StackOverflow2013
Postsdbo
POCan't run sql script
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCan't run sql script
    primarykey
    data
    text
    <p>I can't run this SQL script.</p> <p>This errors occurs:</p> <blockquote> <p>Message 102, Level 15, State 1, Line 10<br> Incorrect syntax near the construction "=".<br> Message 102, Level 15, State 1, Line 28<br> Incorrect syntax near the construction of "<code>".<br> Message 102, Level 15, State 1, Line 56<br> Incorrect syntax near the construction of "</code> ".<br> Message 102, Level 15, State 1, Line 86<br> Incorrect syntax near the construction of "` ".</p> </blockquote> <p>What can I do?</p> <pre><code>-- phpMyAdmin SQL Dump -- version 3.3.1 -- http://www.phpmyadmin.net -- -- Хост: localhost -- Время создания: Дек 29 2011 г., 16:23 -- Версия сервера: 5.5.10 -- Версия PHP: 5.2.4 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- База данных: `test` -- -- -------------------------------------------------------- -- -- Структура таблицы `customers` -- CREATE TABLE IF NOT EXISTS `customers` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'идентификатор записи', `FIRST_NAME` varchar(30) COLLATE utf8_bin NOT NULL COMMENT 'Имя', `LAST_NAME` varchar(30) COLLATE utf8_bin NOT NULL COMMENT 'Фамилия', `PHONE` varchar(10) COLLATE utf8_bin NOT NULL COMMENT 'Телефон', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='заказчики' AUTO_INCREMENT=9 ; -- -- Дамп данных таблицы `customers` -- INSERT INTO `customers` (`ID`, `FIRST_NAME`, `LAST_NAME`, `PHONE`) VALUES (1, 'Борис', 'Петров', ''), (2, 'Иван', 'Сидоров', ''), (3, 'Сергей', 'Иванов', ''), (4, 'Александр', 'Бойко', ''), (5, 'Петр', 'Борисов', ''), (6, 'Семён', 'Александров', ''), (7, 'Александр', 'Лебедев', ''), (8, 'Алексей', 'Ильин', ''); -- -------------------------------------------------------- -- -- Структура таблицы `items` -- CREATE TABLE IF NOT EXISTS `items` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'идентификатор записи', `NAME` varchar(50) COLLATE utf8_bin NOT NULL COMMENT 'название товара', `AMOUNT` float NOT NULL DEFAULT '0' COMMENT 'цена товара', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=12 ; -- -- Дамп данных таблицы `items` -- INSERT INTO `items` (`ID`, `NAME`, `AMOUNT`) VALUES (1, 'Молоток', 0), (2, 'Бумага', 0), (3, 'Шоколадка Snickers', 0), (4, 'Отвёртка', 0), (5, 'Ручка', 0), (6, 'Шоколадка Kit-Kat', 0), (7, 'Гаечный ключ', 0), (8, 'Карандаш', 0), (9, 'Конфеты Helth Bar', 0), (10, 'Счётчик ленты', 0), (11, 'Переплётная машина', 0); -- -------------------------------------------------------- -- -- Структура таблицы `payments` -- CREATE TABLE IF NOT EXISTS `payments` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'идентификатор записи', `CUSTOMER_ID` int(11) NOT NULL COMMENT 'ИД заказчика. Связь с таблицей customers', `ITEM_ID` int(11) NOT NULL COMMENT 'ИД товара. Связь с таблицей items', `ITEM_COUNT` int(11) NOT NULL DEFAULT '0' COMMENT 'количество товара', `TRANS_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'время транзакции', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='продажи' AUTO_INCREMENT=21 ; -- -- Дамп данных таблицы `payments` -- INSERT INTO `payments` (`ID`, `CUSTOMER_ID`, `ITEM_ID`, `ITEM_COUNT`, `TRANS_TIME`) VALUES (1, 1, 6, 0, '2011-12-29 14:49:06'), (2, 1, 9, 0, '2011-12-29 14:49:06'), (3, 2, 2, 0, '2011-12-29 14:52:09'), (4, 2, 8, 0, '2011-12-29 14:52:09'), (5, 3, 4, 0, '2011-12-29 14:52:09'), (6, 3, 7, 0, '2011-12-29 14:52:09'), (7, 3, 10, 0, '2011-12-29 14:52:09'), (8, 4, 5, 0, '2011-12-29 14:52:09'), (9, 4, 8, 0, '2011-12-29 14:52:09'), (10, 4, 11, 0, '2011-12-29 14:52:09'), (11, 5, 1, 0, '2011-12-29 14:52:09'), (12, 5, 4, 0, '2011-12-29 14:52:09'), (13, 5, 10, 0, '2011-12-29 14:52:35'), (14, 6, 5, 0, '2011-12-29 14:52:35'), (15, 6, 11, 0, '2011-12-29 14:52:55'), (16, 7, 1, 0, '2011-12-29 14:52:55'), (17, 7, 4, 0, '2011-12-29 14:53:12'), (18, 8, 3, 0, '2011-12-29 14:53:12'), (19, 8, 9, 0, '2011-12-29 14:53:22'), (20, 2, 11, 0, '2011-12-29 16:03:55'); </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmarc_s
    1. USNate
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCan't run sql script
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POCan't run sql script
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POCan't run sql script
      1. This table or related slice is empty.
      1. VTDownMod
    1. COPost the SQL which generates these errors. You likely have syntax wrong somehwere.
      singulars
      1. POCan't run sql script
      1. USxQbert
    2. COAdding a whole zip file instead of properly phrasing your question is just lazy.
      singulars
      1. POCan't run sql script
      1. USErwin Brandstetter
    3. COPlease, download file and try to run it. Sql script is too long to post it here, it would take a lot of place.
      singulars
      1. POCan't run sql script
      1. USNate
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload