View Single Post
  #6  
Old 15th November 2010, 08:34
lafouine022 lafouine022 is offline
Senior Member
 
Join Date: Feb 2010
P2P
Posts: 120
Default sql table user fix
Quote:
Originally Posted by Omenke View Post
Hello!

This is a problem with mysql when you want to put more than

Code:
   
-- Structure de la table `users`
-- 
 CREATE  TABLE  `users` ( `droits_film` decimal( 10, 0  )  NOT  NULL default  '10',
 PRIMARY  KEY (  `id`  ) ,

) ENGINE  =  MYISAM  DEFAULT CHARSET  = UTF8 AUTO_INCREMENT  =11325;

     
MySQL ERROR:
  #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 ') ENGINE=MyISAM  DEFAULT CHARSET=UTF8 AUTO_INCREMENT=11325' at   line 8

ok run whis in phpmyadmin

PHP Code:
ALTER TABLE `usersADD `droits_filmdecimal(10,0NOT NULL default '10'
Reply With Quote
The Following User Says Thank You to lafouine022 For This Useful Post:
Tory (15th November 2010)