SQL Database

[Equinox1354]

Can anyone help me connect my SQL database to www.freeSql.com:3306

Where do I put it into the database?

/*
wat
wat
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for achievements
-- ----------------------------
DROP TABLE IF EXISTS `achievements`;
CREATE TABLE `achievements` (
  `ID` text NOT NULL,
  `GMod Racer: Record Breaker` int(11) NOT NULL,
  `GMod Racer: Speed Demon` int(11) NOT NULL,
  `GMod Racer: Road Rage` int(11) NOT NULL,
  `GMod Racer: Destruction Derby` int(11) NOT NULL,
  `GMod Racer: Rolling the Rick` int(11) NOT NULL,
  `GMod Racer: Bomber` int(11) NOT NULL,
  `GMod Racer: Black Worshiper` int(11) NOT NULL,
  `Murder: Cold Blood` int(11) NOT NULL,
  `Murder: Framed` int(11) NOT NULL,
  `Murder: No Rest for the Wicked` int(11) NOT NULL,
  `Murder: Short Round` int(11) NOT NULL,
  `Murder: Wanna Be Cop` int(11) NOT NULL,
  `Murder: Ninja` int(11) NOT NULL,
  `Murder: Sharp Shooter` int(11) NOT NULL,
  `Murder: Last Stand` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for admin_times
-- ----------------------------
DROP TABLE IF EXISTS `admin_times`;
CREATE TABLE `admin_times` (
  `STEAMID` text NOT NULL,
  `NAME` text NOT NULL,
  `SERVER` text NOT NULL,
  `TIME` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for bans
-- ----------------------------
DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans` (
  `ID` text NOT NULL,
  `NAME` text NOT NULL,
  `UNBAN` int(11) NOT NULL default '0',
  `BANNER` text,
  `REASON` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for global_chat
-- ----------------------------
DROP TABLE IF EXISTS `global_chat`;
CREATE TABLE `global_chat` (
  `server_id` text,
  `user_name` text,
  `message` text,
  `num` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for gmp_coins
-- ----------------------------
DROP TABLE IF EXISTS `gmp_coins`;
CREATE TABLE `gmp_coins` (
  `STEAMID` text NOT NULL,
  `NAME` text NOT NULL,
  `COINS` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for gmp_minigames
-- ----------------------------
DROP TABLE IF EXISTS `gmp_minigames`;
CREATE TABLE `gmp_minigames` (
  `NAME` text NOT NULL,
  `NUMBER` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for gorpg_items
-- ----------------------------
DROP TABLE IF EXISTS `gorpg_items`;
CREATE TABLE `gorpg_items` (
  `user` text,
  `item_id` text,
  `quantity` int(11) default '1',
  `x` int(11) default '0',
  `y` int(11) default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for gorpg_map_vars
-- ----------------------------
DROP TABLE IF EXISTS `gorpg_map_vars`;
CREATE TABLE `gorpg_map_vars` (
  `var_name` text,
  `var_value` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for gorpg_vars
-- ----------------------------
DROP TABLE IF EXISTS `gorpg_vars`;
CREATE TABLE `gorpg_vars` (
  `user` text,
  `var_name` text,
  `var_value` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for gorpg_vars_quest
-- ----------------------------
DROP TABLE IF EXISTS `gorpg_vars_quest`;
CREATE TABLE `gorpg_vars_quest` (
  `user` text,
  `var_name` text,
  `var_value` int(11) default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for rp_items
-- ----------------------------
DROP TABLE IF EXISTS `rp_items`;
CREATE TABLE `rp_items` (
  `steamid` text NOT NULL,
  `item_id` text NOT NULL,
  `item_quantity` int(10) unsigned zerofill NOT NULL default '0000000000'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for rp_org
-- ----------------------------
DROP TABLE IF EXISTS `rp_org`;
CREATE TABLE `rp_org` (
  `id` int(10) unsigned zerofill NOT NULL auto_increment,
  `name` text NOT NULL,
  `owner_steamid` text NOT NULL,
  `motd` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for rp_users
-- ----------------------------
DROP TABLE IF EXISTS `rp_users`;
CREATE TABLE `rp_users` (
  `steamid` text NOT NULL,
  `name` text NOT NULL,
  `money` int(10) unsigned zerofill NOT NULL default '0000001000',
  `free_points` int(10) unsigned zerofill NOT NULL default '0000000006',
  `time_played` int(10) unsigned zerofill NOT NULL default '0000000000',
  `blacklist` text NOT NULL,
  `vehicles` text NOT NULL,
  `vehicle_skins` text NOT NULL,
  `org` int(10) unsigned zerofill NOT NULL default '0000000000',
  `model` text NOT NULL,
  `skill_dexterity` int(10) unsigned zerofill NOT NULL default '0000000000',
  `skill_stamina` int(10) unsigned zerofill NOT NULL default '0000000000',
  `skill_intelligence` int(10) unsigned zerofill NOT NULL default '0000000000',
  `skill_strength` int(10) unsigned zerofill NOT NULL default '0000000000',
  `skill_craftiness` int(10) unsigned zerofill NOT NULL default '0000000000',
  `ammo_pistol` int(10) unsigned zerofill NOT NULL default '0000000000',
  `ammo_rifle` int(10) unsigned zerofill NOT NULL default '0000000000',
  `ammo_shotgun` int(10) unsigned zerofill NOT NULL default '0000000000'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `ID` text NOT NULL,
  `NAME` text NOT NULL,
  `RANK` int(11) NOT NULL default '5'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for ve_donations
-- ----------------------------
DROP TABLE IF EXISTS `ve_donations`;
CREATE TABLE `ve_donations` (
  `ID` text NOT NULL,
  `Ammount` int(11) NOT NULL,
  `Claimed` int(11) NOT NULL default '0',
  `Name` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for ve_profiles
-- ----------------------------
DROP TABLE IF EXISTS `ve_profiles`;
CREATE TABLE `ve_profiles` (
  `SkillLevel_1` int(11) NOT NULL,
  `SkillLevel_2` int(11) NOT NULL,
  `SkillLevel_3` int(11) NOT NULL,
  `SkillLevel_4` int(11) NOT NULL,
  `SkillLevel_5` int(11) NOT NULL,
  `SkillLevel_6` int(11) NOT NULL,
  `SkillLevel_7` int(11) NOT NULL,
  `SkillLevel_8` int(11) NOT NULL,
  `SkillLevel_9` int(11) NOT NULL,
  `OwnsWeapon_1` int(11) NOT NULL,
  `OwnsWeapon_2` int(11) NOT NULL,
  `OwnsWeapon_3` int(11) NOT NULL,
  `OwnsWeapon_4` int(11) NOT NULL,
  `OwnsWeapon_5` int(11) NOT NULL,
  `OwnsWeapon_6` int(11) NOT NULL,
  `OwnsWeapon_7` int(11) NOT NULL,
  `OwnsWeapon_8` int(11) NOT NULL,
  `OwnsWeapon_9` int(11) NOT NULL,
  `OwnsWeapon_10` int(11) NOT NULL,
  `OwnsWeapon_11` int(11) NOT NULL,
  `OwnsWeapon_12` int(11) NOT NULL,
  `OwnsWeapon_13` int(11) NOT NULL,
  `OwnsWeapon_14` int(11) NOT NULL,
  `SteamID` text NOT NULL,
  `Name` text NOT NULL,
  `EquipedWep` int(11) NOT NULL,
  `EquipedWep_Side` int(11) NOT NULL,
  `Cash` int(11) NOT NULL,
  `Kills` int(11) NOT NULL,
  `Deaths` int(11) NOT NULL,
  `Headshots` int(11) NOT NULL,
  `TimeSpent` int(11) NOT NULL,
  `TimesPlayed` int(11) NOT NULL,
  `TimesWon` int(11) NOT NULL,
  `Points` int(11) NOT NULL,
  `OwnsIronsights` int(11) NOT NULL,
  `OwnsFrag` int(11) NOT NULL,
  `OwnsSmoke` int(11) NOT NULL,
  `Rank` int(11) NOT NULL,
  `CustTitle` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for zh_donations
-- ----------------------------
DROP TABLE IF EXISTS `zh_donations`;
CREATE TABLE `zh_donations` (
  `ID` text NOT NULL,
  `AMMOUNT` int(11) NOT NULL default '0',
  `CLAIMED` int(11) NOT NULL default '0',
  `NAME` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for zh_players
-- ----------------------------
DROP TABLE IF EXISTS `zh_players`;
CREATE TABLE `zh_players` (
  `STEAMID` text NOT NULL,
  `KILLS` int(11) NOT NULL,
  `NAME` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------

[j03]

Hey. That is an SQL query which you would run on a database. You can't specify which server to run it on through actual SQL code. You need to use an SQL client of some sort - be it command line tool, phpmyadmin or an automatic installer. Does freesql provide you with any kind of admin panel?

[root]

you need to write

use database name;

at the start

[j03]

Also, I believe that it's FreeSQL.org, not .com.

[berry120]

Having a look on the site it does have a link to phpmyadmin, but it doesn't work at present (may be something to do with the message explaining the server crash on the homepage!)

[adelf]

sql database is one type of the programming language.
Sql Database language is use to store a data in the database.to use Sql query of the store data in the database.
How to Insert Data in the Database:
INSERT INTO table1(no,name,address) VALUES('1','maulik','address');