আমি কি প্রশ্ন করতে পারি যে MySQL-এ নির্দিষ্ট সারি বা কলাম কতটা ডিস্কে স্থান নিচ্ছে?

হ্যাঁ, নিচের সিনট্যাক্স −

select * from information_schema.tables where table_name=yourTableName;

আসুন প্রথমে একটি টেবিল তৈরি করি -

mysql> create table DemoTable1600
   -> (
   -> StudentId int,
   -> StudentFirstName varchar(20)
   -> );
Query OK, 0 rows affected (0.51 sec)

সন্নিবেশ কমান্ড -

mysql> insert into DemoTable1600 values(100,'Bob');
Query OK, 1 row affected (0.14 sec)
mysql> insert into DemoTable1600 values(101,'David');
Query OK, 1 row affected (0.17 sec)
mysql> insert into DemoTable1600 values(102,'Carol');
Query OK, 1 row affected (0.19 sec)

সিলেক্ট স্টেটমেন্ট -

mysql> select * from DemoTable1600;

এটি নিম্নলিখিত আউটপুট −

+-----------+------------------+
| StudentId | StudentFirstName |
+-----------+------------------+
|       100 | Bob              |
|       101 | David            |
|       102 | Carol            |
+-----------+------------------+
3 rows in set (0.00 sec)

নির্দিষ্ট সারি বা কলাম −

mysql> select * from information_schema.tables where table_name='DemoTable1600';

এটি নিম্নলিখিত আউটপুট তৈরি করবে

+---------------+--------------+---------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME    | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME         | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT |
+---------------+--------------+---------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------------+
| def           | web          | demotable1600 | BASE TABLE | InnoDB |      10 | Dynamic    | 0          | 0               | 16384       |              0 |           0 |         0 |         NULL    | 2019-10-19 14:34:46 | NULL       | NULL          | utf8_unicode_ci | NULL    |                |                |
+---------------+--------------+---------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------------+
1 row in set (0.00 sec)