Ik heb een fout in de mysql.
De error is als volgt:voor zover ik zie gaat het om dit stukje sql:// dit is line 30:
De error is als volgt:
Spoiler tonen
Fout
SQL-query:
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 30 Dec 2006 om 14:20
-- Server versie: 4.1.22
-- PHP Versie: 4.4.4
--
-- Database: `star_data`
--
-- --------------------------------------------------------
--
-- Tabel structuur voor tabel `[bloodtypes]`
--
CREATE TABLE `[bloodtypes]` (
`id` int( 255 ) NOT NULL AUTO_INCREMENT ,
`bloodaamm` int( 255 ) NOT NULL default 10000,
`bloodbamm` int( 255 ) NOT NULL default 10000,
`bloodabamm` int( 255 ) NOT NULL default 10000,
`bloodoamm` int( 255 ) NOT NULL default 10000,
`bloodapri` int( 255 ) NOT NULL default 2000,
`bloodbpri` int( 255 ) NOT NULL default 2000,
`bloodabpri` int( 255 ) NOT NULL default 2000,
`bloodopri` int( 255 ) NOT NULL default 2000,
PRIMARY KEY ( `id` )
) TYPE = MYISAM AUTO_INCREMENT =1;
MySQL retourneerde: Documentatie
#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 TYPE=MyISAM AUTO_INCREMENT=1 at line 30
SQL-query:
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 30 Dec 2006 om 14:20
-- Server versie: 4.1.22
-- PHP Versie: 4.4.4
--
-- Database: `star_data`
--
-- --------------------------------------------------------
--
-- Tabel structuur voor tabel `[bloodtypes]`
--
CREATE TABLE `[bloodtypes]` (
`id` int( 255 ) NOT NULL AUTO_INCREMENT ,
`bloodaamm` int( 255 ) NOT NULL default 10000,
`bloodbamm` int( 255 ) NOT NULL default 10000,
`bloodabamm` int( 255 ) NOT NULL default 10000,
`bloodoamm` int( 255 ) NOT NULL default 10000,
`bloodapri` int( 255 ) NOT NULL default 2000,
`bloodbpri` int( 255 ) NOT NULL default 2000,
`bloodabpri` int( 255 ) NOT NULL default 2000,
`bloodopri` int( 255 ) NOT NULL default 2000,
PRIMARY KEY ( `id` )
) TYPE = MYISAM AUTO_INCREMENT =1;
MySQL retourneerde: Documentatie
#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 TYPE=MyISAM AUTO_INCREMENT=1 at line 30
Spoiler tonen
CREATE TABLE `[bloodtypes]` (
`id` int(255) NOT NULL auto_increment,
`bloodaamm` int(255) NOT NULL default 10000,
`bloodbamm` int(255) NOT NULL default 10000,
`bloodabamm` int(255) NOT NULL default 10000,
`bloodoamm` int(255) NOT NULL default 10000,
`bloodapri` int(255) NOT NULL default 2000,
`bloodbpri` int(255) NOT NULL default 2000,
`bloodabpri` int(255) NOT NULL default 2000,
`bloodopri` int(255) NOT NULL default 2000,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
`id` int(255) NOT NULL auto_increment,
`bloodaamm` int(255) NOT NULL default 10000,
`bloodbamm` int(255) NOT NULL default 10000,
`bloodabamm` int(255) NOT NULL default 10000,
`bloodoamm` int(255) NOT NULL default 10000,
`bloodapri` int(255) NOT NULL default 2000,
`bloodbpri` int(255) NOT NULL default 2000,
`bloodabpri` int(255) NOT NULL default 2000,
`bloodopri` int(255) NOT NULL default 2000,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
) TYPE=MyISAM AUTO_INCREMENT=1 ; 