help in mysql

[Awah Mohamed]

hello guys . i am new to mysql and i really dont know anything about it so i need your help in creating a database that contains two places one is the username the the 2nd one is the password .So please tell me how to do it

[griswolf]

Do a tutorial on (My)SQL. By the end of 20 minutes, you will have this and more. You may search online, or look at one or more of these:

• http://www.w3schools.com/sql/default.asp
• http://www.mysqltutorial.org/
• http://dev.mysql.com/tech-resources/articles/mysql_intro.html

[Awah Mohamed]

ok but i need quick code that can create for me 3 tables username,password,email how can i do it reading and understanding the 25 page of w3schools takes long time and i dont have enough time for that

[Awah Mohamed]

please !!!!! i want the code of creating my tables !!!!!!!

[griswolf]

"I want" is not a sufficient amount of work. "I tried this and need some more help because (what exactly went wrong) is sufficient. "I have not enough time" is never sufficient: You are responsible for your own time management.

We ought to consider that he is a Prince

[swi2]

hi

here i write how to create datbase

create database "databasename"

and how to create table syntax is given below

create table "tablename"("fieldname",datatype, size);

[sandeepji1]

Hi,MySql act as Database System Software which is an open source in nature means freely available.& we need " Structured Query Language " For Accessing it,

Now, According to your Query, I First Create data base

"CREATE DATABASE Name_of_Database";
Later you create a table

CREATE TABLE IF NOT EXISTS Table_Name
( username VARCHAR(25) NOT NULL,
Password VARCHAR(25) NOT NULL
);
and you are New Then I think you need

How we Insert data in Table ?

Now we Insert one data at one time:
INSERT INTO Table_Name VALUES("Pradeep","123458");

Take Enjoy With that Knowledge, and still you have any little bit doubt then just, mention here.

[griswolf]

Better yet, actually read and do the tutorial work mentioned above. There is good documentation, maybe even in your native language, here: http://dev.mysql.com/doc/

[Awah Mohamed]

thanks to all of you
The reason that i have no enough time is because i am at the school there days and our exams are close to us and also we need to create a database and login forms to our class website and i am the only one in my class that can create a website but i can create it in html and i am learning php so that is why i have no time but if i have hot enough time then i will read even 1000 page to learn because i really like programming

http://www.phpeasystep.com/phptu/6.html