[SOLVED] Help Creating New .SQL Table (Beginner)

Aaron1988 · #1 (**permalink**) Oct 31st, 2007, 16:27

Hi, i have loginscript but need help creating the sql table for it the information i need to create the .sql file is as follows

firstname
lastname
email
address1
address2
city
state
zip
country
level

so does any one know how to create sql table please, the table will be called members.

Thanks
Aaron

karinne · #2 (**permalink**) Oct 31st, 2007, 16:28

Hmmm ... you could have found this in the documentation on the MySQL site

http://dev.mysql.com/doc/refman/5.0/...ate-table.html

Marc · #3 (**permalink**) Oct 31st, 2007, 16:29

Try this: http://www.w3schools.com/sql/sql_create.asp.

Hope that helps!

Aaron1988 · #4 (**permalink**) Oct 31st, 2007, 16:41

cheers Both of you will check them out now cause i am a total beginner at creating a sql table lol.

so i am trying so hard lol

Monie · #5 (**permalink**) Nov 1st, 2007, 01:42

Or you could use MySQL GUI Tools to create your database visually..

Aaron1988 · #6 (**permalink**) Nov 3rd, 2007, 09:42

Hey i downloaded the 5.0 GUI Tool but how do i get it to connect please thanks
do i need to download MYSQL Enterprise

dab42pat · #7 (**permalink**) Nov 3rd, 2007, 10:12

Have you tried xampp.
you could create your db's and tables through phpmyadmin.

Aaron1988 · #8 (**permalink**) Nov 3rd, 2007, 13:55

Well i am a total beginner so know have never sued xampp and also i know how to create tables in phpmyadmin but dont know what values or what to give them and the what to give the primary key

Aaron1988 · #9 (**permalink**) Nov 4th, 2007, 16:48

hi everyone i have this sql table and i get errors when importing it can anyone help me fix these errors

Code: Select all

CREATE TABLE 'user'(
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'username' varchar(20) NOT NULL default '',
'password' varchar(50) NOT NULL default '',
'email' varchar(40) NOT NULL default '',
'ip' varchar( 20) NOT NULL default '',
PRIMARY KEY ('id')
) ENGINE = MYISAM AUTO_INCREMENT =1 DEFAULT CHARSET = latin1 AUTO_INCREMENT=1 ;

Marc · #10 (**permalink**) Nov 4th, 2007, 16:50

What error(s) do you get Aaron?

Aaron1988 · #11 (**permalink**) Nov 4th, 2007, 16:52

these are errors and as i am a total beginner i wouldnt know what it meant lol i no it means line 1 but still bit dont know what is wrong with it

Code: Select all

Error
 
SQL query: 
 
CREATE TABLE 'user'( 'id'int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
'username'varchar( 20 ) NOT NULL default '',
'password'varchar( 50 ) NOT NULL default '',
'email'varchar( 40 ) NOT NULL default '',
'ip'varchar( 20 ) NOT NULL default '',
PRIMARY KEY ( 'id' ) 
) ENGINE = MYISAM AUTO_INCREMENT = 1DEFAULT CHARSET = latin1 AUTO_INCREMENT =1 
MySQL said:  
#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 ''user'(
 
'id'int(10) unsigned NOT NULL AUTO_INCREMENT ,
'username'varchar(20)' at line 1

Marc · #12 (**permalink**) Nov 4th, 2007, 16:54

you have to use " ` " instead of " ' "....

Aaron1988 · #13 (**permalink**) Nov 4th, 2007, 16:58

ok, i will try now and if doesnt work i give you the error i get

Marc · #14 (**permalink**) Nov 4th, 2007, 17:02

I think it should be

Code: Select all

CREATE TABLE `user`( `id`int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`username`varchar( 20 ) NOT NULL default ``,
`password`varchar( 50 ) NOT NULL default ``,
`email`varchar( 40 ) NOT NULL default ``,
`ip`varchar( 20 ) NOT NULL default ``,
PRIMARY KEY ( `id` ) 
) ENGINE = MYISAM AUTO_INCREMENT = 1DEFAULT CHARSET = latin1 AUTO_INCREMENT =1

But i am no expert at MySQL

Aaron1988 · #15 (**permalink**) Nov 4th, 2007, 17:08

hey you where nearly there lol, what you had to do instead of having " ` " at the end of default you put the normal " ' " and it worked so you where nearly there lol

P.S thanks for the help mate most appreciated.

Thanks
Aaron

Marc · #16 (**permalink**) Nov 4th, 2007, 17:13

lol, i just did a little search and replace in Notepad and forgot about that LOL.. Sorry!

Glad you got it sorted and if you are finished, go into Thread Tools then Mark Thread as Solved.

Cheers,

Aaron1988 · #17 (**permalink**) Nov 4th, 2007, 17:17

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[SOLVED] Please help with creating a Mailing list form.	Oak	Starting Out	3	Dec 26th, 2007 18:54
[SOLVED] Beginner that needs helps	defy	Starting Out	7	Nov 16th, 2007 11:20
[SOLVED] Creating users/members?	vistar	PHP Forum	7	Oct 25th, 2007 00:04
Creating a scroll bar within a table	Diablo	Web Page Design	5	Mar 12th, 2007 16:10
Creating Table with Random Number	spinal007	Classic ASP	1	Jun 1st, 2006 06:57

		Webforumz.com > Main Forums > Program Your Website > Databases
[SOLVED] Help Creating New .SQL Table (Beginner)