Scribd
Upload
7 views1 page

MySQL Database and Table Management Guide

The document outlines the steps to set a password for MySQL, create and drop databases, create a table within a database, insert values into the table fields, and select the inserted values.

Uploaded by

satyam sharma
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
7 views1 page

MySQL Database and Table Management Guide

The document outlines the steps to set a password for MySQL, create and drop databases, create a table within a database, insert values into the table fields, and select the inserted values.

Uploaded by

satyam sharma
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

1.

to set password

# mysql -u root -p ( then press enter)


output: Enter password (press enter)

[Link] database
maria DB[(none)]>create database satyam; (press enter)

[Link] databases
maria DB[(none)]>show databases;(press enter)

[Link] databases
maria DB[(none)]>drop database satyam;(press enter)

[Link] in database
maria DB[(none)]>use satyam; (press enter) (note:satyam is used as database)

[Link] table in database


maria DB[satyam]>create table kamal(id int,Name varchar(50),contact int(12),Gmail
varchar(25),Age int(2)); (press enter))
(note: kamal is used as table)

[Link] see the table details


maria DB[satyam]>desc kamal; (press enter)

[Link] value in table fields


maria DB[satyam]>insert into
kamal(id,name,contact,gmail,age)value(101,"Rajbeer",7007926800,"satyamsharma204@gma
[Link]",22);

[Link] input values in table fields


maria DB[satyam]>select * from kamal;(press enter)

You might also like