Błąd 1064 „near ') USING BTREE'” w MySQL 5.6 podczas tworzenia tabeli itemshop_items

Opublikowano 10 Listopada 202510 Lis

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 ') USING BTREE, INDEX item_vnum_indexvnum) USING BTREE) ENGINE = MyISAM AU' at line 57

Potrzebuje pomocy chce wgrać owe tabelki:

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for itemshop_editors
-- ----------------------------

DROP TABLE IF EXISTS itemshop_editors;

CREATE TABLE itemshop_editors (
    name varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for itemshop_items
-- ----------------------------

DROP TABLE IF EXISTS itemshop_items;

CREATE TABLE itemshop_items (
    id int(11) NOT NULL AUTO_INCREMENT,
    category smallint(5) UNSIGNED NOT NULL DEFAULT 0,
    vnum int(11) NOT NULL,
    price int(10) UNSIGNED NOT NULL DEFAULT 0,
    count smallint(3) NOT NULL,
    socket0 int(10) UNSIGNED NOT NULL DEFAULT 0,
    socket1 int(10) UNSIGNED NOT NULL DEFAULT 0,
    socket2 int(10) UNSIGNED NOT NULL DEFAULT 0,
    socket3 int(10) UNSIGNED NOT NULL DEFAULT 0,
    socket4 int(10) UNSIGNED NOT NULL DEFAULT 0,
    socket5 int(10) UNSIGNED NOT NULL DEFAULT 0,
    attrtype0 tinyint(4) NOT NULL DEFAULT 0,
    attrvalue0 smallint(6) NOT NULL DEFAULT 0,
    attrtype1 tinyint(4) NOT NULL DEFAULT 0,
    attrvalue1 smallint(6) NOT NULL DEFAULT 0,
    attrtype2 tinyint(4) NOT NULL DEFAULT 0,
    attrvalue2 smallint(6) NOT NULL DEFAULT 0,
    attrtype3 tinyint(4) NOT NULL DEFAULT 0,
    attrvalue3 smallint(6) NOT NULL DEFAULT 0,
    attrtype4 tinyint(4) NOT NULL DEFAULT 0,
    attrvalue4 smallint(6) NOT NULL DEFAULT 0,
    attrtype5 tinyint(4) NOT NULL DEFAULT 0,
    attrvalue5 smallint(6) NOT NULL DEFAULT 0,
    attrtype6 tinyint(4) NOT NULL DEFAULT 0,
    attrvalue6 smallint(6) NOT NULL DEFAULT 0,
    fixed_count tinyint(1) NOT NULL DEFAULT 1,
    add_time datetime(0) NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY id) USING BTREE,
    INDEX item_vnum_indexvnum) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

SET FOREIGN_KEY_CHECKS = 1;

Opublikowano 10 Listopada 202510 Lis

Jaka wersja silnika bazy danych?

Opublikowano 10 Listopada 202510 Lis

Autor

2 minuty temu, Sevence napisał(a):
Jaka wersja silnika bazy danych?

5.6

Opublikowano 10 Listopada 202510 Lis

Masz błąd w składni, spróbuj tego zapytania:

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for itemshop_editors
-- ----------------------------
DROP TABLE IF EXISTS itemshop_editors;
CREATE TABLE itemshop_editors (
  name varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for itemshop_items
-- ----------------------------
DROP TABLE IF EXISTS itemshop_items;
CREATE TABLE itemshop_items (
  id int(11) NOT NULL AUTO_INCREMENT,
  category smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  vnum int(11) NOT NULL,
  price int(10) UNSIGNED NOT NULL DEFAULT 0,
  count smallint(3) NOT NULL,
  socket0 int(10) UNSIGNED NOT NULL DEFAULT 0,
  socket1 int(10) UNSIGNED NOT NULL DEFAULT 0,
  socket2 int(10) UNSIGNED NOT NULL DEFAULT 0,
  socket3 int(10) UNSIGNED NOT NULL DEFAULT 0,
  socket4 int(10) UNSIGNED NOT NULL DEFAULT 0,
  socket5 int(10) UNSIGNED NOT NULL DEFAULT 0,
  attrtype0 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue0 smallint(6) NOT NULL DEFAULT 0,
  attrtype1 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue1 smallint(6) NOT NULL DEFAULT 0,
  attrtype2 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue2 smallint(6) NOT NULL DEFAULT 0,
  attrtype3 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue3 smallint(6) NOT NULL DEFAULT 0,
  attrtype4 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue4 smallint(6) NOT NULL DEFAULT 0,
  attrtype5 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue5 smallint(6) NOT NULL DEFAULT 0,
  attrtype6 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue6 smallint(6) NOT NULL DEFAULT 0,
  fixed_count tinyint(1) NOT NULL DEFAULT 1,
  add_time datetime(0) NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `item_vnum_indexvnum` (`vnum`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

SET FOREIGN_KEY_CHECKS = 1;

Opublikowano 10 Listopada 202510 Lis

Autor
Rozwiązanie

7 minut temu, Sevence napisał(a):

Masz błąd w składni, spróbuj tego zapytania:

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ------------------------------ Table structure for itemshop_editors-- ----------------------------DROP TABLE IF EXISTS itemshop_editors;
CREATE TABLE itemshop_editors (
  name varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ------------------------------ Table structure for itemshop_items-- ----------------------------DROP TABLE IF EXISTS itemshop_items;
CREATE TABLE itemshop_items (
  id int(11) NOT NULL AUTO_INCREMENT,
  category smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  vnum int(11) NOT NULL,
  price int(10) UNSIGNED NOT NULL DEFAULT 0,
  count smallint(3) NOT NULL,
  socket0 int(10) UNSIGNED NOT NULL DEFAULT 0,
  socket1 int(10) UNSIGNED NOT NULL DEFAULT 0,
  socket2 int(10) UNSIGNED NOT NULL DEFAULT 0,
  socket3 int(10) UNSIGNED NOT NULL DEFAULT 0,
  socket4 int(10) UNSIGNED NOT NULL DEFAULT 0,
  socket5 int(10) UNSIGNED NOT NULL DEFAULT 0,
  attrtype0 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue0 smallint(6) NOT NULL DEFAULT 0,
  attrtype1 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue1 smallint(6) NOT NULL DEFAULT 0,
  attrtype2 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue2 smallint(6) NOT NULL DEFAULT 0,
  attrtype3 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue3 smallint(6) NOT NULL DEFAULT 0,
  attrtype4 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue4 smallint(6) NOT NULL DEFAULT 0,
  attrtype5 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue5 smallint(6) NOT NULL DEFAULT 0,
  attrtype6 tinyint(4) NOT NULL DEFAULT 0,
  attrvalue6 smallint(6) NOT NULL DEFAULT 0,
  fixed_count tinyint(1) NOT NULL DEFAULT 1,
  add_time datetime(0) NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `item_vnum_indexvnum` (`vnum`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

SET FOREIGN_KEY_CHECKS = 1;

Pomogło dziękuje.

Błąd 1064 „near ') USING BTREE'” w MySQL 5.6 podczas tworzenia tabeli itemshop_items

Featured Replies

Rozwiązane przez adekkk0298

Konto

Nawigacja

Skonfiguruj powiadomienia push w przeglądarce.

Chrome (Android)

Chrome (Desktop)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (Desktop)

Firefox (Android)

Firefox (Desktop)