Skip to content
La2Base
Home
DownloadsWikiForumFAQ
ruen
Sign up Login
HomeFilesWikiLogin
  • Home
  • Downloads
  • Wiki
  • FAQ
  • Contact Us
  • About
  • Rules
  • Privacy
  • Terms of Service

© 2026 la2base.com · All rights reserved

ruen
Forum/Web обвязка/ошибка в запросе Sql
Search

ошибка в запросе Sql

1 replies57 viewsCurrently viewing: 1
hancel
hancel

User

Участник

Posts: 33

На форуме с: 09/02/2008

Репутация: +16

Рейтинг: 0

· 01/08/2009, 11:33 AM

Запрос
CREATE TABLE `l2top` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`nick` varchar(30) NOT NULL,
`ip` varchar(20) NOT NULL,
`time` varchar(20) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

Ошибка
[Err] 1050 - Table 'l2top' already exists
[Err] CREATE TABLE `l2top` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`nick` varchar(30) NOT NULL,
`ip` varchar(20) NOT NULL,
`time` varchar(20) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Запрос
ALTER TABLE `donate` CHANGE `state` `state` ENUM( '0', 'I', 'E', 'P', 'S' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0' ;
ALTER TABLE `donate` ADD `payer_wm` VARCHAR( 12 ) NOT NULL AFTER `price` ;
ALTER TABLE `donate` ADD `payer_purse` VARCHAR( 13 ) NOT NULL AFTER `payer_wm` ;
ALTER TABLE `donate` ADD `invs_no` VARCHAR( 11 ) NOT NULL AFTER `payer_purse` ;
ALTER TABLE `donate` ADD `trans_no` VARCHAR( 11 ) NOT NULL AFTER `invs_no` ;
ALTER TABLE `donate` ADD `trans_date` VARCHAR( 17 ) NOT NULL AFTER `trans_no` ;

Ошибка
[Err] 1060 - Duplicate column name 'payer_wm'
[Err] ALTER TABLE `donate` ADD `payer_wm` VARCHAR( 12 ) NOT NULL AFTER `price` ;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Ошибка
[Err] 1060 - Duplicate column name 'email'
[Err] ALTER TABLE `accounts` ADD `email` VARCHAR( 50 ) NULL ;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Запрос
ALTER TABLE `characters` ADD `lastteleport` DECIMAL( 20, 0 ) NULL DEFAULT NULL;

Ошибка
[Err] 1060 - Duplicate column name 'lastteleport'
[Err] ALTER TABLE `characters` ADD `lastteleport` DECIMAL( 20, 0 ) NULL DEFAULT NULL;
[Msg] Finished - Unsuccessfully
--------------------------------------------------


Запрос
CREATE TABLE `l2top` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`nick` varchar(30) NOT NULL,
`ip` varchar(20) NOT NULL,
`time` varchar(20) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

Ошибка
[Err] 1050 - Table 'l2top' already exists
[Err] CREATE TABLE `l2top` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`nick` varchar(30) NOT NULL,
`ip` varchar(20) NOT NULL,
`time` varchar(20) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Запрос

ALTER TABLE `donate` CHANGE `state` `state` ENUM( '0', 'I', 'E', 'P', 'S' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0' ;
ALTER TABLE `donate` ADD `payer_wm` VARCHAR( 12 ) NOT NULL AFTER `price` ;
ALTER TABLE `donate` ADD `payer_purse` VARCHAR( 13 ) NOT NULL AFTER `payer_wm` ;
ALTER TABLE `donate` ADD `invs_no` VARCHAR( 11 ) NOT NULL AFTER `payer_purse` ;
ALTER TABLE `donate` ADD `trans_no` VARCHAR( 11 ) NOT NULL AFTER `invs_no` ;
ALTER TABLE `donate` ADD `trans_date` VARCHAR( 17 ) NOT NULL AFTER `trans_no` ;

Ошибка
[Err] 1060 - Duplicate column name 'payer_wm'
[Err] ALTER TABLE `donate` ADD `payer_wm` VARCHAR( 12 ) NOT NULL AFTER `price` ;
[Msg] Finished - Unsuccessfully
--------------------------------------------------


Сори Сори, затупил, это ошибка дубликации, что уже такое существует....модераторы удалите тему(уже 2 сутки не сплю, и туплю)

0
Topic is closed for replies