টেবিল তৈরি করা
mysql> create table DemoTable
-> (
-> FirstName varchar(20),
-> LastName varchar(20)
-> );
Query OK, 0 rows affected (1.44 sec)
রেকর্ড ইনসার্ট করা
mysql> insert into DemoTable values('John','Smith');
Query OK, 1 row affected (0.35 sec)
mysql> insert into DemoTable values('Chris','Brown');
Query OK, 1 row affected (0.37 sec)
mysql> insert into DemoTable values('Carol','Taylor');
Query OK, 1 row affected (0.15 sec)
mysql> insert into DemoTable values('David','Miller');
Query OK, 1 row affected (0.24 sec)
সকল রেকর্ড প্রদর্শন
mysql> select *from DemoTable;
আউটপুট
+-----------+----------+
| FirstName | LastName |
+-----------+----------+
| John | Smith |
| Chris | Brown |
| Carol | Taylor |
| David | Miller |
+-----------+----------+
4 rows in set (0.00 sec)
MySQL-এ একাধিক কলাম দ্বারা সার্ট করার কোয়েরি
mysql> select *from DemoTable order by FirstName,LastName
আউটপুট
+-----------+----------+
| FirstName | LastName |
+-----------+----------+
| Carol | Taylor |
| Chris | Brown |
| David | Miller |
| John | Smith |
+-----------+----------+
4 rows in set (0.24 sec)
