HelloI have a websitea bit old,you needa databasebut thedbbe givingerror in thecurrentmanagers,
if someonepodessefixI would be verygrateful
Erro: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_query("CREATE DATABASE `site_alan`")' at line 1
mysql_query("CREATE DATABASE `site_alan`");
mysql_query("CREATE TABLE `site_alan`.`fama` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`foto` VARCHAR( 100 ) NOT NULL ,
`nome` VARCHAR( 100 ) NOT NULL ,
`nick` VARCHAR( 100 ) NOT NULL ,
`classe` VARCHAR( 100 ) NOT NULL ,
`cla` VARCHAR( 100 ) NOT NULL ,
`idade` VARCHAR( 100 ) NOT NULL ,
`mora` VARCHAR( 100 ) NOT NULL
) ENGINE = MYISAM");
mysql_query("CREATE TABLE `site_alan`.`regras` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`regra` TEXT NOT NULL
) ENGINE = MYISAM");
mysql_query("CREATE TABLE `site_alan`.`download` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`versao_pat` VARCHAR( 50 ) NOT NULL ,
`tamanho_pat` VARCHAR( 50 ) NOT NULL ,
`link_pat` TEXT NOT NULL ,
`episodio_bro` VARCHAR( 50 ) NOT NULL ,
`tamanho_bro` VARCHAR( 50 ) NOT NULL ,
`link_bro` TEXT NOT NULL
) ENGINE = MYISAM");
mysql_query("CREATE TABLE `site_alan`.`equipe` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`cargo` VARCHAR( 50 ) NOT NULL ,
`nome` VARCHAR( 50 ) NOT NULL ,
`especi` TEXT NOT NULL
) ENGINE = MYISAM");
mysql_query("CREATE TABLE `site_alan`.`noticias` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`titulo` TEXT NOT NULL ,
`noticia` TEXT NOT NULL ,
`data` VARCHAR( 20 ) NOT NULL ,
`por` VARCHAR( 50 ) NOT NULL
) ENGINE = MYISAM");
mysql_query("CREATE TABLE `site_alan`.`eventos` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`titulo` TEXT NOT NULL ,
`evento` TEXT NOT NULL ,
`data` VARCHAR( 20 ) NOT NULL
) ENGINE = MYISAM");
mysql_query("CREATE TABLE `site_alan`.`admin` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`usuario` VARCHAR( 50 ) NOT NULL ,
`senha` VARCHAR( 50 ) NOT NULL ,
`privilegio` VARCHAR( 2 ) NOT NULL
) ENGINE = MYISAM");
Question
Scofield
Hello I have a website a bit old, you need a database but the db be giving error in the current managers,
if someone podesse fix I would be very grateful
Erro: #1064 - You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'mysql_query("CREATE DATABASE `site_alan`")' at line 1
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.