dėl duomenu bazes

[irmantasjr]

sveiki, turiu toki senoka gm, ir keliant ji i ismeta taip:

kodas:

--
-- Sukurta duomenų struktūra lentelei `zaidejai`
--
CREATE TABLE `zaidejai` (
  `Id` int(11) NOT NULL,
  `vardas` varchar(24) NOT NULL,
  `pass` varchar(24) NOT NULL,
  `patirtis` int(11) NOT NULL,
  `pinigai` int(11) NOT NULL,
  `banke` int(11) NOT NULL,
  `namuose` int(11) NOT NULL,
  `lytis` int(1) NOT NULL,
  `pos_X` float NOT NULL,
  `pos_Y` float NOT NULL,
  `pos_Z` float NOT NULL,
  `alga` int(11) NOT NULL,
  `direktorius` int(3) NOT NULL,
  `pavaduotojas` int(3) NOT NULL,
  `darbas` int(3) NOT NULL,
  `JobRank` int(2) NOT NULL,
  `drabuziai` int(3) NOT NULL,
  `world` int(3) NOT NULL,
  `star` int(3) NOT NULL,
  `teorijost` int(3) NOT NULL,
  `pinkodas` varchar(24) NOT NULL,
  `mute` int(11) NOT NULL,
  `interior` int(3) NOT NULL,
  `kreditai` int(11) NOT NULL,
  `Kreditai2` int(2) NOT NULL,
  `Admin` int(1) NOT NULL,
  `AdminLaikas` int(11) NOT NULL,
  `vip` int(1) NOT NULL,
  `Viplaikas` int(11) NOT NULL,
  `bsaskaita` int(11) NOT NULL,
  `pakviestas` int(11) NOT NULL,
  `glicenzija` int(1) NOT NULL,
  `glicteorija` int(2) NOT NULL,
  `aikstele` int(1) NOT NULL,
  `fteises` int(1) NOT NULL,
  `mteises` int(1) NOT NULL,
  `teorija` int(1) NOT NULL,
  `uniform` int(1) NOT NULL,
  `uniforma` int(3) NOT NULL,
  `kokainas` int(11) NOT NULL,
  `zole` int(11) NOT NULL,
  `Prazaide` int(11) NOT NULL,
  `DarboIspejimai` int(1) NOT NULL,
  `AdminIspejimai` int(1) NOT NULL,
  `VipIspejimai` int(1) NOT NULL,
  `masalas` int(11) NOT NULL,
  `zuvis` int(11) NOT NULL,
  `Kalejime` int(11) NOT NULL,
  `Investicija` int(1) NOT NULL,
  `meskere` int(1) NOT NULL,
  `surakintas` int(1) NOT NULL,
  `KiekTuriRepTasku` int(6) NOT NULL,
  `bakelis` int(1) NOT NULL,
  `Telefonas` int(1) NOT NULL,
  `Kortele` int(1) NOT NULL,
  `cteises` int(1) NOT NULL,
  `TelefonoStat` int(1) NOT NULL,
  `Emigruotas` int(1) NOT NULL,
  `aPriziuretojas` int(1) NOT NULL,
  `vPriziuretojas` int(1) NOT NULL,
  `ePriziuretojas` int(1) NOT NULL,
  `dPriziuretojas` int(1) NOT NULL,
  `bPriziuretojas` int(1) NOT NULL,
  `MasinuIeskojimas1` int(1) NOT NULL,
  `MasinuIeskojimas2` int(1) NOT NULL,
  `MasinuIeskojimas3` int(1) NOT NULL,
  `MasinuIeskojimas4` int(1) NOT NULL,
  `MasinuIeskojimas5` int(1) NOT NULL,
  `PriimtiIskvietimai` int(2) NOT NULL,
  `PolicijosStazas` int(11) NOT NULL,
  `MedikuStazas` int(11) NOT NULL,
  `TaksistuStazas` int(11) NOT NULL,
  `MechanikuStazas` int(11) NOT NULL,
  `DyleriuStazas` int(11) NOT NULL,
  `FuristuStazas` int(11) NOT NULL,
  `SWATStazas` int(11) NOT NULL,
  `BallasStazas` int(11) NOT NULL,
  `GrooveStazas` int(11) NOT NULL,
  `ArmijosStazas` int(6) NOT NULL,
  `AlgosGavimas` int(1) NOT NULL,
  `AlgosLaikas` int(11) NOT NULL,
  `Uzbanintas` int(1) NOT NULL,
  `BanLaikas` int(3) NOT NULL,
  `Saskaita` int(11) NOT NULL,
  `Navigacija` int(1) NOT NULL,
  `NickBanai` int(1) NOT NULL,
  `Suristas` int(1) NOT NULL,
  `Ginklas0` int(4) NOT NULL,
  `Ginklas1` int(4) NOT NULL,
  `Ginklas2` int(4) NOT NULL,
  `Ginklas3` int(4) NOT NULL,
  `Ginklas4` int(4) NOT NULL,
  `Ginklas5` int(4) NOT NULL,
  `Ginklas6` int(4) NOT NULL,
  `Ginklas7` int(4) NOT NULL,
  `Ginklas8` int(4) NOT NULL,
  `Ginklas9` int(4) NOT NULL,
  `Ginklas10` int(4) NOT NULL,
  `Ginklas11` int(4) NOT NULL,
  `Ammo0` int(4) NOT NULL,
  `Ammo1` int(4) NOT NULL,
  `Ammo2` int(4) NOT NULL,
  `Ammo3` int(4) NOT NULL,
  `Ammo4` int(4) NOT NULL,
  `Ammo5` int(4) NOT NULL,
  `Ammo6` int(4) NOT NULL,
  `Ammo7` int(4) NOT NULL,
  `Ammo8` int(4) NOT NULL,
  `Ammo9` int(4) NOT NULL,
  `Ammo10` int(4) NOT NULL,
  `Ammo11` int(4) NOT NULL,
  `CARID` int(11) NOT NULL,
  `gaujosID` int(11) NOT NULL,
  `KelintaNMisija` int(3) NOT NULL,
  `LeidimasH` int(2) NOT NULL,
  `LeidimasHUNT` int(2) NOT NULL,
  `LeidimasT` int(2) NOT NULL,
  `Alkis` int(4) NOT NULL,
  `tVerslas` int(6) NOT NULL,
  `tVerslasPelnas` int(10) NOT NULL,
  `menke` int(6) NOT NULL,
  `lasisa` int(6) NOT NULL,
  `pleksne` int(6) NOT NULL,
  `eserys` int(6) NOT NULL,
  `lydeka` int(6) NOT NULL,
  `valas` int(2) NOT NULL,
  `cuffed` int(1) NOT NULL,
  `DuotaBaudu` int(5) NOT NULL,
  `NuveztaKroviniu` int(5) NOT NULL,
  `Mires` int(11) NOT NULL,
  `DrkIspejimai` int(3) NOT NULL,
  `UzbanintasLaikui` int(2) NOT NULL,
  `KiekLaikoBan` int(15) NOT NULL,
  `PriklausBalai` int(3) NOT NULL,
  `Priklausomybe` int(2) NOT NULL,
  `KiekIsprende` int(6) NOT NULL,
  `LaimejoVar` int(2) NOT NULL,
  `prazaideALL` int(11) NOT NULL,
  `valiuta` int(11) NOT NULL,
  `Valiuta2` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Erorras:

 

SQL query: 
CREATE DEFINER=`root`@`localhost` PROCEDURE `test_multi_sets` ()  begin
        select user() as first_col;
        select user() as first_col, now() as second_col;
        select user() as first_col, now() as second_col, now() as third_col;
        end
MySQL atsakymas: 
#1304 - PROCEDURE test_multi_sets already exists

 

[1dev]

o kas neaišku? Rašo atsakymą tau.

[TomyG]

MySQL atsakymas: 
#1304 - PROCEDURE test_multi_sets already exists

[irmantasjr]

nu bet ten nera tokio dalyko kaip , tiesiog neikelia zaidėju bazes kur turi krautis zaideju informacija.

test_multi_sets

Redaguota Kovo 20, 2017, nario ledifusionN