How to create a new table with sql?

I'm not familiar with the SQL syntax in whm manager. I want to execute something like this >>

CREATE TABLE `visitor_map` (
`id` INTEGER auto_increment,
`ip` VARCHAR(15) NOT NULL,
`location` VARCHAR(32) NOT NULL,
`longitude` FLOAT NOT NULL,
`latitude` FLOAT NOT NULL,
PRIMARY KEY (`id`)
);

for creating a database, naming it something like 'visitormap', and assign it a user. I will have five fields; id, ip, location, longitude and latitude.

Purpose for this is to create a 'Geo visitor Map' on the site.

 

BR

 

Quote · 7 Jan 2011
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.