943,547 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Marked Solved
  • Views: 1111
  • MySQL RSS
Jan 18th, 2009
0

Help!!!

Expand Post »
Can someone help me with this database, code bellow

MySQL Syntax (Toggle Plain Text)
  1. --
  2. -- Table structure for table `bapps`
  3. --
  4.  
  5. CREATE TABLE `bapps` (
  6. `bappID` INT(11) NOT NULL AUTO_INCREMENT,
  7. `bappFROM` INT(11) NOT NULL DEFAULT '0',
  8. `bappBUSINESS` INT(11) NOT NULL DEFAULT '0',
  9. `bappTEXT` VARCHAR(255) NOT NULL DEFAULT '',
  10. PRIMARY KEY (`bappID`)
  11. ) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;
  12.  
  13. --
  14. -- Dumping data for table `bapps`
  15. --
  16.  
  17.  
  18.  
  19. -- --------------------------------------------------------
  20.  
  21. --
  22. -- Table structure for table `be`
  23. --
  24.  
  25. CREATE TABLE `be` (
  26. `beFROM` INT(11) NOT NULL DEFAULT '0',
  27. `beTO` INT(11) NOT NULL DEFAULT '0',
  28. PRIMARY KEY (`beFROM`)
  29. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  30.  
  31. --
  32. -- Dumping data for table `be`
  33. --
  34.  
  35.  
  36. -- --------------------------------------------------------
  37.  
  38. --
  39. -- Table structure for table `bf`
  40. --
  41.  
  42. CREATE TABLE `bf` (
  43. `bfFROM` INT(11) NOT NULL DEFAULT '0',
  44. `bfTO` INT(11) NOT NULL DEFAULT '0',
  45. PRIMARY KEY (`bfFROM`)
  46. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  47.  
  48. --
  49. -- Dumping data for table `bf`
  50. --
  51.  
  52.  
  53. -- --------------------------------------------------------
  54.  
  55. --
  56. -- Table structure for table `busevents`
  57. --
  58.  
  59. CREATE TABLE `busevents` (
  60. `bevID` INT(11) NOT NULL AUTO_INCREMENT,
  61. `bevGANG` INT(11) NOT NULL DEFAULT '0',
  62. `bevTIME` INT(11) NOT NULL DEFAULT '0',
  63. `bevTEXT` TEXT NOT NULL,
  64. PRIMARY KEY (`bevID`)
  65. ) ENGINE=MyISAM AUTO_INCREMENT=99 DEFAULT CHARSET=latin1 AUTO_INCREMENT=99 ;
  66.  
  67. --
  68. -- Dumping data for table `busevents`
  69. --
  70.  
  71.  
  72. -- --------------------------------------------------------
  73.  
  74. --
  75. -- Table structure for table `businesses`
  76. --
  77.  
  78. CREATE TABLE `businesses` (
  79. `bID` INT(11) NOT NULL AUTO_INCREMENT,
  80. `bNAME` VARCHAR(255) NOT NULL DEFAULT '',
  81. `bOWNER` INT(11) NOT NULL DEFAULT '0',
  82. `bPROFIT` BIGINT(30) NOT NULL DEFAULT '0',
  83. `bPOPULATION` BIGINT(30) NOT NULL DEFAULT '0',
  84. `bDAYSOLD` INT(11) NOT NULL DEFAULT '0',
  85. `bBANKMONEY` INT(11) NOT NULL DEFAULT '0',
  86. `bBANKCRYSTALS` INT(11) NOT NULL DEFAULT '0',
  87. `bLOGO` VARCHAR(255) NOT NULL DEFAULT '0',
  88. `bDESCRIPTION` VARCHAR(255) NOT NULL DEFAULT '0',
  89. `bPDAY` BLOB NOT NULL,
  90. `bMESSAGES` TEXT NOT NULL,
  91. PRIMARY KEY (`bID`)
  92. ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
  93.  
  94. --
  95. -- Dumping data for table `businesses`
  96. --
  97.  
  98. ALTER TABLE `users` ADD `business` INT(11) NOT NULL DEFAULT '0',
  99. ALTER TABLE `users` ADD `dib` INT(11) NOT NULL DEFAULT '0',

Error message is

Quote ...
#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 'TABLE `users` ADD `dib` int(11) NOT NULL default '0',' at line 2
Can someone please help me?
Reputation Points: 10
Solved Threads: 0
Light Poster
maddogsprofiles is offline Offline
29 posts
since Apr 2008
Jan 19th, 2009
1

Re: Help!!!

You have comma at the end of the statement, statement should end with a semicolon not comma.
Reputation Points: 29
Solved Threads: 47
Posting Whiz
mwasif is offline Offline
312 posts
since Dec 2007
Jan 19th, 2009
0

Re: Help!!!

Oh wow..... I can't believe I didn't catch that, thank you!
Reputation Points: 10
Solved Threads: 0
Light Poster
maddogsprofiles is offline Offline
29 posts
since Apr 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: Need way to group by two times
Next Thread in MySQL Forum Timeline: Update +1 For each page view (php to mysql)





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC