[MySQL] How do I set up a database?
#1

The title says it all. I'm confused on how I set up a database, or what programs to use. Yes, I've searched ****** and all of that. So yeah, if someone could assist me with this, it would be wonderful.
Reply
#2

You have to use custom code depending on what your database contains (such as which tables, table names, row names).

Here's an example:

Код:
CREATE TABLE IF NOT EXISTS `adminlog` (
 `id` mediumint(7) NOT NULL auto_increment,
 `command` varchar(14) NOT NULL,
 `admin` varchar(21) NOT NULL,
 `adminid` mediumint(7) NOT NULL,
 `player` varchar(21) NOT NULL default '*',
 `playerid` mediumint(7) NOT NULL default '-1',
 `str` varchar(128) NOT NULL default '*',
 `time` int(11) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `adminid` (`adminid`),
 KEY `playerid` (`playerid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Reply
#3

Clearly, you haven't searched at all.

http://developedtraffic.com/resource...l-database.php
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)