Предыдущая публикация
При попытке создать таблицу появляется сообщение:
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 'IF NOT EXISTS TABLE `region_89` ( `id_town` INT(2) AUTO_INCREMENT, `town_ru' at line 1.
В чём проблема?
Следующая публикация
Комментарии 6
синтаксис то
CREATE TABLE IF NOT EXISTS `user` (
id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
username CHAR(24),
summonername VARCHAR(16),
password VARCHAR(16),
region CHAR(3),
lvl INT(2) DEFAULT '0',
maxlvl INT(2),
status VARCHAR(20),
enabled INT(1...Ещёа запрос, ладн у вас распространенная проблема с метаданными, без самого запроса не разберешься - проблема в нем
синтаксис то
CREATE TABLE IF NOT EXISTS `user` (
id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
username CHAR(24),
summonername VARCHAR(16),
password VARCHAR(16),
region CHAR(3),
lvl INT(2) DEFAULT '0',
maxlvl INT(2),
status VARCHAR(20),
enabled INT(1) DEFAULT '1',
priority INT(1) DEFAULT '0',
)
взято с - http://stackoverflow.com/questions/25874046/mysql-create-new-table-syntax-errors
SELECT t.theme AS ttheme,
t.post AS tpost, t.date AS tdate, u.login AS uuser, t.like AS tlike,t.dislike AS tdislike, u.avatar AS uavatar, u.reputation AS ureputation, u._id_user AS u_id_user,
( SELECT SUM(d.s)
FROM (
SELECT u2._id_user AS _id, p2.like AS s
FROM post AS p2, user AS u2
WHERE (u2._id_user = p2.id_user)
UNION
SELECT u2._id_user, t2.like
FROM theme_post AS t2, user AS u2
WHERE (u2._id_user = t2.id_user)
) AS d
WHERE d._id = u._id_user
(SELECT COUNT
FROM theme_post AS tt
WHERE tt.id_user = u._id_user) AS nTopics,
(SELECT COUNT
FROM post AS np
<p...Ещёдля примера, один из моих запросов ))))SELECT t.theme AS ttheme,
t.post AS tpost, t.date AS tdate, u.login AS uuser, t.like AS tlike,t.dislike AS tdislike, u.avatar AS uavatar, u.reputation AS ureputation, u._id_user AS u_id_user,
( SELECT SUM(d.s)
FROM (
SELECT u2._id_user AS _id, p2.like AS s
FROM post AS p2, user AS u2
WHERE (u2._id_user = p2.id_user)
UNION
SELECT u2._id_user, t2.like
FROM theme_post AS t2, user AS u2
WHERE (u2._id_user = t2.id_user)
) AS d
WHERE d._id = u._id_user
(SELECT COUNT
FROM theme_post AS tt
WHERE tt.id_user = u._id_user) AS nTopics,
(SELECT COUNT
FROM post AS np
WHERE np.id_user = u._id_user) AS nPost
FROM theme_post AS t, user AS u
WHERE (t.id_user = u._id_user) AND
(t._id_theme_post =
UNION
SELECT '',
p.post, p.date, u.login, p.like, p.dislike, u.avatar, u.reputation, u._id_user,( SELECT SUM(d.s)
FROM (
SELECT u2._id_user AS _id, p2.like AS s
FROM post AS p2, user AS u2
WHERE (u2._id_user = p2.id_user)
UNION
SELECT u2._id_user, t2.like
FROM theme_post AS t2, user AS u2
WHERE (u2._id_user = t2.id_user)
) AS d
WHERE d._id = u._id_user
(SELECT COUNT
FROM theme_post AS tt
WHERE tt.id_user = u._id_user),
(SELECT COUNT
FROM post AS np
WHERE np.id_user = u._id_user)
FROM theme_post AS t, post AS p, user AS u
WHERE (t._id_theme_post = p.id_theme) AND
(p.id_user = u._id_user) AND
(t._id_theme_post =