Mysql Datebase need little help!

Mysql Datebase need little help! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql Datebase need little help! (/showthread.php?tid=435148)

Mysql Datebase need little help! - OpticKiller - 05.05.2013

Hi Guys i got the SQL tables here

but am not sure how to make it into a file datebase so i can upload it to phpmyadmin

Код:

CREATE TABLE IF NOT EXISTS `repairpoints` (
  `repairpointID` int(10) NOT NULL,
  `repairpointPosX` varchar(128) NOT NULL default '0.0',
  `repairpointPosY` varchar(128) NOT NULL default '0.0',
  `repairpointPosZ` varchar(128) NOT NULL default '0.0',
  `repairpointInterior` int(10) NOT NULL default '0',
  `repairpointVirtualWorld` int(10) NOT NULL default '0',
  `repairpointFee` int(10) NOT NULL default '5',
  PRIMARY KEY  (`repairpointID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

INSERT INTO `repairpoints` (`repairpointID`, `repairpointPosX`, `repairpointPosY`, `repairpointPosZ`, `repairpointInterior`, `repairpointVirtualWorld`, `repairpointFee`) VALUES
(1, '0.0', '0.0', '0.0', 0, 0, 5),
(2, '0.0', '0.0', '0.0', 0, 0, 5),
(3, '0.0', '0.0', '0.0', 0, 0, 5),
(4, '0.0', '0.0', '0.0', 0, 0, 5),
(5, '0.0', '0.0', '0.0', 0, 0, 5),
(6, '0.0', '0.0', '0.0', 0, 0, 5),
(7, '0.0', '0.0', '0.0', 0, 0, 5),
(8, '0.0', '0.0', '0.0', 0, 0, 5),
(9, '0.0', '0.0', '0.0', 0, 0, 5),
(10, '0.0', '0.0', '0.0', 0, 0, 5),
(11, '0.0', '0.0', '0.0', 0, 0, 5),
(12, '0.0', '0.0', '0.0', 0, 0, 5),
(13, '0.0', '0.0', '0.0', 0, 0, 5),
(14, '0.0', '0.0', '0.0', 0, 0, 5),
(15, '0.0', '0.0', '0.0', 0, 0, 5),
(16, '0.0', '0.0', '0.0', 0, 0, 5),
(17, '0.0', '0.0', '0.0', 0, 0, 5),
(18, '0.0', '0.0', '0.0', 0, 0, 5),
(19, '0.0', '0.0', '0.0', 0, 0, 5),
(20, '0.0', '0.0', '0.0', 0, 0, 5),
(21, '0.0', '0.0', '0.0', 0, 0, 5),
(22, '0.0', '0.0', '0.0', 0, 0, 5),
(23, '0.0', '0.0', '0.0', 0, 0, 5),
(24, '0.0', '0.0', '0.0', 0, 0, 5),
(25, '0.0', '0.0', '0.0', 0, 0, 5);

Re: Mysql Datebase need little help! - Vince - 05.05.2013

Open phpMyAdmin and click the button that reads 'Query window' in the left pane. Paste all of your queries there and hit execute.

Re: Mysql Datebase need little help! - OpticKiller - 05.05.2013

Thanks Vince

Re: Mysql Datebase need little help! - OpticKiller - 05.05.2013

hmm getting this error for some reason.

Код:

SQL query:

CREATE TABLE IF NOT EXISTS  `repairpoints` (

 `repairpointID` INT( 10 ) NOT NULL ,
 `repairpointPosX` VARCHAR( 128 ) NOT NULL DEFAULT  '0.0',
 `repairpointPosY` VARCHAR( 128 ) NOT NULL DEFAULT  '0.0',
 `repairpointPosZ` VARCHAR( 128 ) NOT NULL DEFAULT  '0.0',
 `repairpointInterior` INT( 10 ) NOT NULL DEFAULT  '0',
 `repairpointVirtualWorld` INT( 10 ) NOT NULL DEFAULT  '0',
 `repairpointFee` INT( 10 ) NOT NULL DEFAULT  '5',
PRIMARY KEY (  `repairpointID` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 ROW_FORMAT = DYNAMIC ;

MySQL said: