01. september 2005 - 11:11
Der er
13 kommentarer
Fejl i denne SQL?
Hey alle... Kan ikke få lov til at importere dette ind? CREATE DATABASE `meetme` CREATE TABLE `tblusers` ( `UserID` int(10) unsigned NOT NULL auto_increment, `UserEMail` varchar(45) NOT NULL default '', `UserNickName` varchar(45) NOT NULL default '', `UserName` varchar(45) NOT NULL default '', `UserArticleID` int(10) unsigned NOT NULL default '0', `UserTypeID` int(10) unsigned NOT NULL default '0', `UserStatusID` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`UserID`), UNIQUE KEY `idxUserNickName` USING HASH (`UserNickName`) CREATE TABLE `tbluserstatus` ( `StatusID` int(10) unsigned NOT NULL default '0', `StatusName` varchar(45) NOT NULL default '', PRIMARY KEY (`StatusID`) CREATE TABLE `tblusertypes` ( `UserTypeID` int(10) unsigned NOT NULL default '0', `UserTypeName` varchar(45) NOT NULL default '', PRIMARY KEY (`UserTypeID`) CREATE TABLE `tblmailbox` ( `MailID` int(10) unsigned NOT NULL auto_increment, `MailToUserID` int(10) unsigned NOT NULL default '0', `MailFromUserID` int(10) unsigned NOT NULL default '0', `MailSentTime` datetime NOT NULL default '0000-00-00 00:00:00', `MailReadTime` datetime default NULL, `MailTitle` varchar(100) default NULL, `MailBody` text, PRIMARY KEY (`MailID`) CREATE TABLE `tblforums` ( `ForumID` int(10) unsigned NOT NULL auto_increment, `ForumName` varchar(45) NOT NULL default '', `ForumSortIndex` int(10) unsigned NOT NULL default '0', `ForumVisibility` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`ForumID`), UNIQUE KEY `idxForumName` (`ForumName`) CREATE TABLE `tblforumthreads` ( `ThreadID` int(10) unsigned NOT NULL auto_increment, `ForumID` int(10) unsigned NOT NULL default '0', `ThreadParentID` int(10) unsigned default '0', `ThreadAuthorID` int(10) unsigned default '0', `ThreadTime` datetime default NULL, `ThreadTitle` varchar(100) default NULL, `ThreadBody` text, PRIMARY KEY (`ThreadID`), KEY `idxForumID` (`ForumID`), KEY `idxThreadParent` (`ThreadParentID`) CREATE TABLE `tblarticles` ( `ArticleID` int(10) unsigned NOT NULL auto_increment, `AuthorID` int(10) unsigned NOT NULL default '0', `ArticleStatusID` int(10) unsigned zerofill NOT NULL default '0000000001', `ArticleModificationTime` datetime default '0000-00-00 00:00:00', `ArticleActivationTime` datetime default '0000-00-00 00:00:00', `ArticleExpirationTime` datetime default '0000-00-00 00:00:00', `ArticleTemplateID` int(10) unsigned default '0', PRIMARY KEY (`ArticleID`) CREATE TABLE `tblarticleparts` ( `ArticleID` int(10) unsigned NOT NULL default '0', `PartID` varchar(45) NOT NULL default '', `PartContent` text, PRIMARY KEY (`ArticleID`,`PartID`) CREATE TABLE `tblarticlestatus` ( `StatusID` int(10) unsigned NOT NULL auto_increment, `StatusName` varchar(45) NOT NULL default '', PRIMARY KEY (`StatusID`) DATA mysql> select * from tbluserstatus; +----------+------------+ | StatusID | StatusName | +----------+------------+ | 0 | Aktiv | | 1 | Inaktiv | +----------+------------+ mysql> select * from tblusers; +--------+----------------------+--------------+-------------------+---------------+------------+--------------+ | UserID | UserEMail | UserNickName | UserName | UserArticleID | UserTypeID | UserStatusID | +--------+----------------------+--------------+-------------------+---------------+------------+--------------+ | 1 | nicky@framemakers.dk | Admin | Nicky Christensen | 0 | 2 | 0 | +--------+----------------------+--------------+-------------------+---------------+------------+--------------+ mysql> select * from tblusertypes; +------------+---------------+ | UserTypeID | UserTypeName | +------------+---------------+ | 0 | Bruger | | 1 | Moderator | | 2 | Administrator | +------------+---------------+ mysql> select * from tblarticlestatus; +----------+-----------------+ | StatusID | StatusName | +----------+-----------------+ | 1 | Ikke publiceret | | 2 | Publiceret | +----------+-----------------+
Annonceindlæg tema
01. september 2005 - 11:17
#1
Og det er ikke fordi din database allerede er oprettet? Så skal du slette øverste linie.
01. september 2005 - 11:21
#2
Nej, databasen er nemlig ikke oprettet :(
01. september 2005 - 11:22
#3
Jeg får denne fejl: MySQL returnerede: #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 'CREATE TABLE `tblusers` ( `UserID` int(10) unsigned NOT NULL auto_increment, `' at line 3
01. september 2005 - 11:52
#4
msngler der ikke ; efter sætningerne ?
01. september 2005 - 11:52
#5
mangler
01. september 2005 - 11:57
#6
Jo, gør der nu, har nu sat dem på, men virker stadig ikke Nu ser koden sådanne ud: CREATE DATABASE `meetme` CREATE TABLE `tblusers` ( `UserID` int(10) unsigned NOT NULL auto_increment, `UserEMail` varchar(45) NOT NULL default '', `UserNickName` varchar(45) NOT NULL default '', `UserName` varchar(45) NOT NULL default '', `UserArticleID` int(10) unsigned NOT NULL default '0', `UserTypeID` int(10) unsigned NOT NULL default '0', `UserStatusID` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`UserID`), UNIQUE KEY `idxUserNickName` USING HASH (`UserNickName`); CREATE TABLE `tbluserstatus` ( `StatusID` int(10) unsigned NOT NULL default '0', `StatusName` varchar(45) NOT NULL default '', PRIMARY KEY (`StatusID`); CREATE TABLE `tblusertypes` ( `UserTypeID` int(10) unsigned NOT NULL default '0', `UserTypeName` varchar(45) NOT NULL default '', PRIMARY KEY (`UserTypeID`); CREATE TABLE `tblmailbox` ( `MailID` int(10) unsigned NOT NULL auto_increment, `MailToUserID` int(10) unsigned NOT NULL default '0', `MailFromUserID` int(10) unsigned NOT NULL default '0', `MailSentTime` datetime NOT NULL default '0000-00-00 00:00:00', `MailReadTime` datetime default NULL, `MailTitle` varchar(100) default NULL, `MailBody` text, PRIMARY KEY (`MailID`); CREATE TABLE `tblforums` ( `ForumID` int(10) unsigned NOT NULL auto_increment, `ForumName` varchar(45) NOT NULL default '', `ForumSortIndex` int(10) unsigned NOT NULL default '0', `ForumVisibility` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`ForumID`), UNIQUE KEY `idxForumName` (`ForumName`); CREATE TABLE `tblforumthreads` ( `ThreadID` int(10) unsigned NOT NULL auto_increment, `ForumID` int(10) unsigned NOT NULL default '0', `ThreadParentID` int(10) unsigned default '0', `ThreadAuthorID` int(10) unsigned default '0', `ThreadTime` datetime default NULL, `ThreadTitle` varchar(100) default NULL, `ThreadBody` text, PRIMARY KEY (`ThreadID`), KEY `idxForumID` (`ForumID`), KEY `idxThreadParent` (`ThreadParentID`); CREATE TABLE `tblarticles` ( `ArticleID` int(10) unsigned NOT NULL auto_increment, `AuthorID` int(10) unsigned NOT NULL default '0', `ArticleStatusID` int(10) unsigned zerofill NOT NULL default '0000000001', `ArticleModificationTime` datetime default '0000-00-00 00:00:00', `ArticleActivationTime` datetime default '0000-00-00 00:00:00', `ArticleExpirationTime` datetime default '0000-00-00 00:00:00', `ArticleTemplateID` int(10) unsigned default '0', PRIMARY KEY (`ArticleID`); CREATE TABLE `tblarticleparts` ( `ArticleID` int(10) unsigned NOT NULL default '0', `PartID` varchar(45) NOT NULL default '', `PartContent` text, PRIMARY KEY (`ArticleID`,`PartID`); CREATE TABLE `tblarticlestatus` ( `StatusID` int(10) unsigned NOT NULL auto_increment, `StatusName` varchar(45) NOT NULL default '', PRIMARY KEY (`StatusID`);
01. september 2005 - 12:02
#7
der mangler stadig ; efter CREATE DATABASE `meetme`
01. september 2005 - 12:07
#8
Så opretter den databasen, men ingen tabeller, får så denne fejl når jeg prøver at oprette tabellerne : MySQL returnerede: #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 '' at line 10
01. september 2005 - 12:15
#9
du lukker ikke dine paranteser..... UNIQUE KEY `idxUserNickName` USING HASH (`UserNickName`); skal vaere: UNIQUE KEY `idxUserNickName` USING HASH (`UserNickName`)); tror det skal aendres for alle tabeller.
01. september 2005 - 12:26
#10
Det havde du sq ret i :) - kanon... ligger du et svar ? :)
01. september 2005 - 12:32
#11
Tror jeg skal dele med arne_v ;-)
02. september 2005 - 21:05
#12
if so
09. marts 2008 - 10:08
#13
lukketid ... ?
Computerworld tilbyder specialiserede kurser i database-management