সমস্ত টেবিল প্রদর্শন করতে information_schema.tables ব্যবহার করুন। এর সাথে, ডাটাবেসের নামও দেখুন, যাতে আপনি শুধুমাত্র একটি নির্দিষ্ট ডাটাবেস থেকে টেবিল প্রদর্শন করতে পারেন।
এখন ডাটাবেস “ওয়েব” -
-এর সমস্ত টেবিল প্রদর্শন করা যাকmysql> information_schema.tables থেকে group_concat(table_name) নির্বাচন করুন যেখানে table_schema='web';
এটি নিম্নলিখিত আউটপুট −
তৈরি করবে <পূর্ব>+------------------------------------------------------------ -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ------------------------------------------------ --------------------------------+| group_concat(টেবিল_নাম) |+--------------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------------- -------------------------------------------------- ---+| demo_table725, demotabe619, demotabe620, demotable211, demotable212, demotable213, demotable214, demotable215, demotable216, demotable217, demotable218, demotable219, demotable220, demotable221, demotable222, demotable223, demotable224, demotable225, demotable226, demotable227, demotable228, demotable229, demotable230, demotable231, demotable232, demotable233, demotable234, demotable235, demotable236, demotable237, demotable238, demotable239, demotable240, demotable241, demotable244, demotable245, demotable246, demotable247, demotable248, demotable249, demotable250, demotable251, demotable252, demotable253, demotable254, demotable255, demotable256, demotable257, demotable258, demotable259, demotable260, demotable261, demotable262, demotable263, demotable264, demotable265, demotable266, demotable267, demotable268, demotable269, demotable270, demotable271, demotable272, demotable273, demotable274, demotable275, demotable276, demotable277, demotable278, demotable279, demotable280, demotable281, demotable282, demotable283, demotable284, demotable285, demotable286, demotable287,demotable28 |+--------------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ----------------------------------------- -------------------------------------------------- ---+1 সারি সেটে, 1 সতর্কতা (0.01 সেকেন্ড)