Problem with this MYSQL code

[Rollo_Tamasi]

Trying to create this table thru phpmyadmin but i'm getting errors which i don't quite understand because i'm new to MYSQL

Here is the code, if someone can figure it out then please let me know what's up. Cheers

CREATE TABLE users (
  userid int(25) NOT NULL auto_increment,
  first_name varchar(25) NOT NULL default '',
  last_name varchar(25) NOT NULL default '',
  email_address varchar(25) NOT NULL default '',
  phone number(25) Not NULL default '',
  username varchar(25) NOT NULL default '',
  password varchar(255) NOT NULL default '',
  ccname varchar(25) Not NULL default '',
  cctype varchar(25) Not NULL default '',
  ccnum number(12) Not NULL default '',
  ccsec number(3) Not NULL default '',
  month varchar(8) Not NULL default '',
  year varchar(8) Not NULL default '',
  street varchar(25) Not NULL default '',
  street2 varchar(25) Not NULL default '',
  city varchar(25) Not NULL default '',
  country varchar(25) Not NULL default '',
  info text NOT NULL,
  user_level enum('0','1','2','3') NOT NULL default '0',
  signup_date datetime NOT NULL default '0000-00-00 00:00:00',
  last_login datetime NOT NULL default '0000-00-00 00:00:00',
  activated enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (userid)
) TYPE=MyISAM COMMENT='Membership Information';

[herve]

What are those error messages 🙂 ?

I'm not 100 % sure but having " not null " and " default '' " together on a column may be a problem ?

[Rollo_Tamasi]

Sorry this is the error
MySQL said:

You have an error in your SQL syntax near 'number(25) Not NULL default '', username varchar(25) NOT NULL default '',

[herve]

ok, it's because there's no "number" column type in MySQL.

Look here : http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

you will find all the numericals columns types. Choosing one depend of the maximum
size of the number you intend to store inside the column.

Things like phone number are usually store in CHAR/VARCHAR columns because
you aren't trying to do mathematical things with them (not adding phone numbers together
for instance)

Credit card numbers too.