Command for MySQL of DBMS-I

I am now giving the commands which was shown by Tahrima madam in the class.

1. show databases: It will show you the existing databases.

2. use : This will active your desired database.

3. create database : It will create a new database.

4. create database if not exists : it will create a database if the database doesn't exist.

5. drop database if exists : Delete a database if it is existing.

6. create table if not exists ( column_name1 data type,column_name2 data type,column3_name data type,...); : It will create a table in database with your desired fields.

7. show tables:shows the existing tables.

8. explain :It will show you the table with their fields and data type, type modifier etc.

9. alter table add column : Add a column in your table.

10.alter table change : You can change a column with new one.

11. alter table drop column : you can delete a column using this command.

Please give ;(semi colon) after every command (like C's statement )

To run LAMPP and MySQL in UBUNTU commands are-

Code:

LAMPP: sudo /opt/lampp/lampp start

MySQL: sudo /opt/lampp/bin/mysql


To run MySQL in windows :

Code:

net start mysql

Here I have given all the commands from today's class. If there is any command I missed, then please reply me.

erm... there is a space after sudo and please give them using the code tag.

And can you also mention the windows xampp mysql command thingy?

Sorry :S I wasn't sure about the command of UBUNTU. Ok, I am making it correct and am giving the command to make mySQL run in windows.

aaaaaaand rep++!!

Thank u thank u :and; :and; :and;

[You must be registered and logged in to see this image.] uff...cant give a symbol due to quote symbol problem

try again

I guess aro besh kisu command o silo
not sure
PRAN collects those

2. use : This will active your desired database.

I am an idiot and I do not understand these two commands
when I type use; and press enter it says USE must be followed by a database name.

But as you instructed, I didn't do anything wrong.
Can you please tell me what is wrong?

I see! It was the problem which was occurred in forum for some times, that u have fixed. I typed all the things currently because still I have the file from which I paste it here (because of the log out problem, I typed it and then copy it to a text file)

I typed the there, but don't know where it has gone? you found some other mistakes in the same post, it was not my fault, it was the error occurred by forum.

BIT0129-tabassum wrote:I see! It was the problem which was occurred in forum for some times, that u have fixed. I typed all the things currently because still I have the file from which I paste it here (because of the log out problem, I typed it and then copy it to a text file)

I typed the there, but don't know where it has gone? you found some other mistakes in the same post, it was not my fault, it was the error occurred by forum.

can you be kind enough to type the proper commands now or what?

And by the way, they are codes right?

and I thought there was something called code tag which should be used when you are posting a code.


the code tags are for handling those errors by default.
Even at the occurrence of such errors, using code tag prevents them from affecting the post where they are used.

Or is it that you thought mysql commands are not codes at all?

Begging pardon for my stupid post. Hoping next time I will give smart posts

BIT0129-tabassum wrote:Begging pardon for my stupid post. Hoping next time I will give smart posts

you are not going to edit the title post, are you?

:\ I assume you have a blind ear :/

I apologize. Dont know why I am forgetting every thing these days!!!ufff.. :'(