[HELP] How to create table for house (MySQL)
#4

Quote:
Originally Posted by xganyx
Посмотреть сообщение
I just learn about mysql yesterday but i think i can help

pawn Код:
mysql_query("CREATE TABLE IF NOT EXISTS `houses` (\
  `hId` int(11) NOT NULL AUTO_INCREMENT,\
  `hPosX` varchar(128) NOT NULL,\
  `hPosY` varchar(128) NOT NULL,\
  `hPosZ` varchar(128) NOT NULL,\
  `hPosRotX` varchar(128) NOT NULL,\
  `hPosRotY` varchar(128) NOT NULL,\
  `hPosRotZ` varchar(128) NOT NULL,\
  PRIMARY KEY (`hId`)\
  ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1"
);
Yes something like that but you don't need to use varchar(12 for float data type. Maybe is better to you to create
table with phpmyadmin or adminer and then look on SQL command to figure out how thing works. This is the best advice if you want to learn something.
Reply


Messages In This Thread
[HELP] How to create table for house (MySQL) - by MartiQ - 17.10.2013, 11:30
Re: [HELP] How to create table for house (MySQL) - by MartiQ - 17.10.2013, 13:21
Re: [HELP] How to create table for house (MySQL) - by xganyx - 17.10.2013, 13:28
Re: [HELP] How to create table for house (MySQL) - by TryCatch - 17.10.2013, 14:07

Forum Jump:


Users browsing this thread: 1 Guest(s)