Online Database 1

[chris921]

I've never learnt MySQL so would it be possible for someone to tell me how to make a simple database that holds an address of a website and a sequence of numbers with it, which are given by a Perl CGI file?

The site address is input by a user.

Thanks,

Chris

 

[bastienk]

download phpmyadmin from

http://sourceforge.net.

It is a fantastic tool that will let you whip dbs in no time thru a gui environment. It (obviously) works on php so you need that installed.

standard format
CREATE DATABASE [IF NOT EXISTS] db_name
    [create_specification [, create_specification] ...]

create_specification:
    [DEFAULT] CHARACTER SET charset_name
  | [DEFAULT] COLLATE collation_name


Create DATABASE db_name

create table

CREATE TABLE `tester` (
  `my_id` int(10) NOT NULL auto_increment,
  `url` varchar(50) NOT NULL default '',
  `no_sequence` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`my_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;