Creating tables in SQL

Question

Does anyone know how to do this in SQL?

Step 1: Make a table in MySQL called users with 3 fields atleast.

Step 2: id is the first make it the primary and also auto_increment. username is the second. password is the third one.

If anyone does please give me the code or explain what I need to do, I would like to learn how to do it

-Thank in advance

Thank you for the link but I want to learn how you would make the tables by the interface first then i'd understand the code if you get me :) — Jack-T
– Jack-T, Commented Apr 27, 2012 at 1:19

eggyal · Accepted Answer · 2012-04-27 01:23:21Z

2

I think, if you would like to learn how to do it, you would be best off reading some tutorials on the subject. A quick Google for MySQL create table has plenty of suggestions.

I suspect just looking at the code will be far less instructive than working through a tutorial or reading the manual, but since you asked:

CREATE TABLE users (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50),
    password VARCHAR(50)
);

answered Apr 27, 2012 at 1:23

eggyal

127k18 gold badges220 silver badges244 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Leniel Maccaferri · Accepted Answer · 2012-04-27 01:25:27Z

1

You can try creating a table in MySQL with SQL Fiddle. It's an online tool that helps with rapid prototyping...

Take a look at this fiddle: http://sqlfiddle.com/#!2/a7da8/1

answered Apr 27, 2012 at 1:25

Leniel Maccaferri

103k48 gold badges380 silver badges495 bronze badges

Collectives™ on Stack Overflow

Creating tables in SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related