Hello World....



On my second week in the programming class, I learned about SQL syntax. in SQL syntax I use XAMPP to create database the way is as follows:
1. Open the XAMPP app

2.Start MySQL Database, ProFTPD, and Apache Web Server

3. Open Terminal

4.Write / Applications / XAMPP / xamppfiles / bin / mysql -u root -p

5.Press Enter
6.Write create database (database name); for example: create database db_IDN;

7.write use (database name) for example: use db_IDN;
and now I want give you how to make a table, Actually the table has many types, but I will explain one only, to create table the way is as follows:
1. write create table (table name) for example: create table tb_IDN
2. press enter and make like this


and how to insert the name and class to table? lets follow me:
1.write like this for example: insert into tb_IDN(nis,students_name,class) values(1,'Fatah','RPL 1');

2.to show the tables write select * from tb_IDN
Ok only that's all for this week,sorry for unpleasing words and if I make some mistake, wassalamualaikum WR,WB.





ViewGrip: #1 Free Youtube Views, Likes & Subscribers

Tidak ada komentar:

Posting Komentar