টেবিল তৈরি করা
mysql> create table DemoTable
-> (
-> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> Name varchar(100),
-> Score int
-> );
Query OK, 0 rows affected (0.78 sec)
রেকর্ড ইনসার্ট করা
mysql> insert into DemoTable(Name,Score) values('John',68);
Query OK, 1 row affected (0.23 sec)
mysql> insert into DemoTable(Name,Score) values('Carol',98);
Query OK, 1 row affected (0.27 sec)
mysql> insert into DemoTable(Name,Score) values('David',89);
Query OK, 1 row affected (0.16 sec)
mysql> insert into DemoTable(Name,Score) values('Robert',67);
Query OK, 1 row affected (0.14 sec)
সকল রেকর্ড প্রদর্শন
mysql> select *from DemoTable;
আউটপুট
+----+--------+-------+
| Id | Name | Score |
+----+--------+-------+
| 1 | John | 68 |
| 2 | Carol | 98 |
| 3 | David | 89 |
| 4 | Robert | 67 |
+----+--------+-------+
4 rows in set (0.00 sec)
নির্দিষ্ট কলামের মান ১ বাড়ানোর কোয়েরি
mysql> update DemoTable set Score=Score+1 where Id=3;
Query OK, 1 row affected (0.22 sec) Rows matched: 1 Changed: 1 Warnings: 0
আবার টেবিল রেকর্ড চেক করা
mysql> select *from DemoTable;
আউটপুট
+----+--------+-------+
| Id | Name | Score |
+----+--------+-------+
| 1 | John | 68 |
| 2 | Carol | 98 |
| 3 | David | 90 |
| 4 | Robert | 67 |
+----+--------+-------+
4 rows in set (0.00 sec)
