[MySQL] How do I set up a database?

[MySQL] How do I set up a database? - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: [MySQL] How do I set up a database? (/showthread.php?tid=140436)

[MySQL] How do I set up a database? - Lejo - 09.04.2010

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.

Re: [MySQL] How do I set up a database? - Grim_ - 09.04.2010

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;

Re: [MySQL] How do I set up a database? - Calgon - 09.04.2010

Clearly, you haven't searched at all.

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