My SQL Basic FAQ's

How to start mysql in windows ?
C:\mysql-5.0.16-win32\bin\mysqld.exe
C:\mysql-5.0.16-win32\bin\mysql -u root
How to log in to mysql ?
mysql -u root mysql

Then set a password (changing "NewPw", of course):
update user set Password=password('NewPw') where User='root';
flush privileges;

Creating a Database ?
create database database01;
All that really does is create a new subdirectory in your MYSQLHOME\data directory.

How to connect to DB?
use database01

How to create a new Table ?
create table table01 (field01 integer, field02 char(10));

How to see the existing tables ?
show tables;

How to see the table structure like desc in Oracle ?
show columns from table01;

How to insert data into a table ?
1)insert into table01 (field01, field02) values (1, 'first');
2)insert into table01 (field01,field02,field03,field04,field05) values
-> (2, 'second', 'another', '1999-10-23', '10:30:00');

Select commands in mysql ?
1) select * from table01;

Altering a table ?
1)alter table table01 add column field03 char(20);
2)alter table table01 add column field04 date, add column field05 time;

How to eneter a sql statement in multiple lines ?
create table table33
-> (field01
-> integer,
-> field02
-> char(30));

Updating a table data ?
update table01 set field04=19991022, field05=062218 where field01=1;

Deleting a record ?
delete from table01 where field01=3;

To come out of mysql prompt ?
quit


4 comments to "My SQL Basic FAQ's"

Post a Comment

Who ever writes Inappropriate/Vulgar comments to context, generally want to be anonymous …So I hope U r not the one like that?
For lazy logs u can at least use Name/URL option which don’t even require any sign-in, good thing is that it can accept your lovely nick name also and URL is not mandatory too.
Thanks for your patience
~Krishna(I love "Transparency")
వీలయితే నాల్గు పోస్టులు ...కుదురితే ఒక కామెంటూ ...

Translate

Enter your email address:

Buffs ...

Visitors


hits counter
View My StatsCheck Google Page Rank

Add to Google Reader or Homepage

Bookmark and Share

Tags


Powered by WidgetsForFree

Archives