DE
CREATE TABLE IF NOT EXISTS "trade_marks" (
"id" SERIAL PRIMARY KEY,
"name" VARCHAR(255) NOT NULL,
"created_at" TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
Size: a a a
2021 August 15
DE
Ой сорян, это пгшный
DE
Ща
DE
CREATE TABLE `social_statuses` (
`id` INT PRIMARY KEY AUTO_INCREMENT,
`name` VARCHAR,
`image_url` VARCHAR,
`sort_order` INT
);
KP
mysql> CREATE TABLE
->
->
->
->
-> );
ERROR 1064 (42000): 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 ',
)' at line 3
social_statuses (->
id INT PRIMARY KEY AUTO_INCREMENT,->
name VARCHAR,->
image_url VARCHAR,->
sort_order INT-> );
ERROR 1064 (42000): 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 ',
image_url VARCHAR,sort_order INT)' at line 3
DE
Длину укажи
KP
mysql> mysql> create table [table name] (personid INT(50) NOT NULL AUTO_INCREMENT PRIMARY KEY, firstname VARCHAR(35), middlename VARCHAR(50), lastname VARCHAR(50) default 'bato');
ERROR 1064 (42000): 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 'mysql> create table [table name] (personid INT(50) NOT NULL AUTO_INCREMENT PRIMA' at line 1
ERROR 1064 (42000): 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 'mysql> create table [table name] (personid INT(50) NOT NULL AUTO_INCREMENT PRIMA' at line 1
DE
sql
-- chess.users definition
CREATE TABLE `users` (
`id` bigint(20) unsigned NOT NULL,
`is_bot` tinyint(1) DEFAULT NULL,
`first_name` varchar(255) DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`language_code` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `users_language_code_IDX` (`language_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
DE
sql
-- chess.games definition
CREATE TABLE `games` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`whites_id` bigint(20) unsigned NOT NULL,
`blacks_id` bigint(20) unsigned NOT NULL,
`inline_id` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`config` text,
PRIMARY KEY (`id`),
UNIQUE KEY `games_inline_id_unique` (`inline_id`),
KEY `games_whites_id_index` (`whites_id`),
KEY `games_blacks_id_index` (`blacks_id`),
KEY `games_inline_id_index` (`inline_id`),
CONSTRAINT `games_blacks_id_foreign` FOREIGN KEY (`blacks_id`) REFERENCES `users` (`id`),
CONSTRAINT `games_whites_id_foreign` FOREIGN KEY (`whites_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30413 DEFAULT CHARSET=utf8mb4;
KP
создалась, а в чем была ошибка?
DE
Я откуда знаю. Ты же запрос не показываешь
V
Стоит ли брать другой поисковый движок ? у меня в некоторых запросах очень медленно работает, это может улучшить ситуацию ?
MA
IZ
Сначала надо разобраться с тем, почему этот не работает
DE
Забыл про аванс )
2021 August 16
MI
Всем привет 🖐️