এর জন্য, আপনি INFORMATION_SCHEMA ব্যবহার করতে পারেন৷ নিম্নলিখিত সিনট্যাক্স −
information_schema থেকে my_schema.SCHEMA_NAME, group_concat(tbl.TABLE_NAME) নির্বাচন করুন। SCHEMATA my_schemaleft join information_schema.TABLES tbl on my_schema.SCHEMA_NAME=tbl.TABLE_SCHEMAগ্রুপ my_schema.SCHEMA_NAME;
MySQL-এ এবং প্রতিটি ডাটাবেসের জন্য সমস্ত ডাটাবেস দেখানোর জন্য আমাদের উপরোক্ত সিনট্যাক্স বাস্তবায়ন করা যাক -
mysql> information_schema থেকে my_schema.SCHEMA_NAME, group_concat(tbl.TABLE_NAME) নির্বাচন করুন। SCHEMATA my_schema বাম যোগান information_schema.TABLES tbl on my_schema.SCHEMA_NAME=tbl.TABLE_SCHEMAগ্রুপ my_schema.SCHEMA;SCHEMA;এটি নিম্নলিখিত আউটপুট −
তৈরি করবে <প্রে>+---------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ------------------------------------------------ -------------------------------------------------- ----------+| SCHEMA_NAME | group_concat(tbl.TABLE_NAME) |+-------------------------------+------------ -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ------------------------------------------------------------------ -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ----------------+| উভয়িনোদবন্ধমিইসাম | কর্মচারী,গ্রেডডেমো,ছাত্র,ছাত্র_তথ্য || ব্যবসা | addconstraintdemo, addonedaydemo, autoincrementtozero, booleandemo, কলেজ, columnvaluenulldemo, countcolumns, datatoolongdemo, deletedemo, demoemptyandnull, distinctdemo1, employeetable, findandreplacedemo, foreigntabledemo, groupdemo1, indemo, intandbigint20demo, javadatetimedemo, likedemo, modifycolumndemo, multiplerecordwithvalues, nestedtransactiondemo, nulldemo, orderbydemo, primarytable1, randomintegerdemo, retrievefirst40characters, saveintotextfile, selectinwithbetweendemo, sortingdemo, studentrecordwithmyisam, tabledemo3, tblifdemo, textintonumberdemo, trailingandleadingdemo, tttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt, uniqueconstrainttable, updatewithlimit, variableastablename, adddatetimewithother, agecalculationfromdatetime, autostoredate, chardemo, colortable, commaseperatedemo, countrycitydemo, datatypedemo, deleterecord, demoindex, dropindex,enumdemo,finddemo,functionindexdemo,groupt_concatdemo,indexingdemo,intandtinyint,keydemo,limitoffsetdemo,modifycolumnnamedemo,mul tiplerowsinsert,newstudent,nulldemo1,orderdemo,prim || কমান্ডলাইন | caseinsensitivedistinctdemo,insertmaxplus1demo,instructor,negativevaluetozerodemo || গ্রাহক-ট্র্যাকার | NULL || গ্রাহক_ট্র্যাকার_ডাটাবেস | NULL || গ্রাহক ট্র্যাকার | NULL || ডাটাবেস1 | NULL || ডেটাবেস নমুনা | NULL || ডেমো | mytable || শিক্ষা | ছাত্র, বিশ্ববিদ্যালয় || hb_student_tracker | demotable194, demotable202, demotable210, demortable218, demotable203, demotable21, demotable219, demotable228, demotable212, demotable220, demotable229, demotable197, demotable205, demotable213, demotable201, demotable2330, demotable230, demotable21, demotable198, demotable206, demotable214, demotable214, demotable223, demotable231, demotable199, demotable224, demotable232, demotable224, demotable200, demotable208, demotable233, demotable225, demotable233, demotable193, demotable201, demotable209, demotable217, demotable226, insertcurrentdate || হ্যালো | NULL || তথ্য_স্কিমা | কলাম, INNODB_CMP, INNODB_FIELDS, INNODB_FT_INDEX_TABLE, INNODB_TRX, PROCESSLIST, ST_SPATIAL_REFERENCE_SYSTEMS, মতামত, ইঞ্জিন, INNODB_CMP_PER_INDEX, INNODB_FOREIGN, INNODB_INDEXES, INNODB_VIRTUAL, প্রোফাইলিং, পরিসংখ্যান, ঘটনা, INNODB_CMP_PER_INDEX_RESET, INNODB_FOREIGN_COLS, INNODB_METRICS, KEY_COLUMN_USAGE, REFERENTIAL_CONSTRAINTS, TABLE_CONSTRAINTS, CHARACTER_SETS, ফাইল, INNODB_CMP_RESET, INNODB_FT_BEING_DELETED, INNODB_TABLES, কীওয়ার্ড, RESOURCE_GROUPS, TABLE_PRIVILEGES, COLLATION_CHARACTER_SET_APPLICABILITY, INNODB_BUFFER_PAGE, INNODB_CMPMEM, INNODB_FT_CONFIG, INNODB_TABLESPACES, OPTIMIZER_TRACE, রুটিন, টেবিল, COLLATIONS, INNODB_BUFFER_PAGE_LRU, INNODB_CMPMEM_RESET, INNODB_FT_DEFAULT_STOPWORD, INNODB_TABLESPACES_BRIEF, প্যারামিটার, SCHEMA_PRIVILEGES, TABLESPACES, COLUMN_PRIVILEGES, INNODB_BUFFER_POOL_STATS, INNODB_COLUMNS, INNODB_FT_DELETED, INNODB_TABLESTATS,PARTITIONS,SCHEMATA,TRIGGERS,COLUMN_STATISTICS,INNODB_CACHED_INDEXES,INNODB_DATAFILES,INNODB_FT_INDEX_CACHE,INNODB_TEMP_TABLE_INFOM, INNODB_TEMP_TABLE_INFOM,USER_INSO,PPR IVILEGES || instant_app | NULL || javadatabase2 | NULL || javasampledatabase | NULL || লগইন | NULL || আমার ব্যবসা | NULL || mydatabase | NULL || mysql | ডিবি, help_category, mytable, selectdistinct_countdemo, slave_worker_info, time_zone_transition, default_roles, help_keyword, PASSWORD_HISTORY, selectnonnumericvalue, slow_log, time_zone_transition_type, employee_information, help_relation, প্লাগইন, selectrowdemo, টেবিল, ব্যবহারকারী, bugdemo, engine_cost, help_topic, prioritydemo, সার্ভার, tables_priv, changevaluefrom1toy, func, innodb_index_stats, procs_priv, server_cost, tempvariableassignment, columns_priv, general_log, innodb_table_stats, proxies_priv, সার্ভার, TIME_ZONE, কম্পোনেন্ট, global_grants, limitdemo, removenumericcharaters, slave_master_info, time_zone_leap_second, countoccurrencesdemo, gtid_executed, md5demo, role_edges, slave_relay_log_info, time_zone_name || একঅন্যতম সম্পর্ক | NULL || অনলাইন বইয়ের দোকান | NULL || কর্মক্ষমতা_স্কিমা | events_errors_summary_by_user_by_error, events_stages_summary_by_user_by_event_name, events_statements_summary_by_digest, events_transactions_history_long, events_waits_history_long, file_summary_by_event_name, memory_summary_by_host_by_event_name, persisted_variables, replication_connection_configuration, session_variables, socket_summary_by_instance, table_lock_waits_summary_by_table, অ্যাকাউন্ট, events_errors_summary_global_by_error, events_stages_summary_global_by_event_name, events_statements_summary_by_host_by_event_name, events_transactions_summary_by_account_by_event_name, events_waits_summary_by_account_by_event_name, file_summary_by_instance, memory_summary_by_thread_by_event_name, prepared_statements_instances, replication_connection_status, setup_actors, status_by_account, থ্রেড, cond_instances,events_stages_current,events_statements_current,events_statements_summary_by_program,events_transactions_summary_by_host_by_event_name,events_waits_summary_by_host_by_event_name,global_status,memory_summary by_user_by_event_name,re || rdb | ছেলে, মেয়ে || নমুনা | accumulateddemo, addtotaltimedemo, autoincrementdemo, backtick_symboldemo, calculateaveragedemo, changecolumnname, columndoesnotexists, contains_capital_letterdemo, countbooleanfielddemo, crc32demo, decimal_demo, deletefrombasetabledemo, demotable10, demotable108, demotable115, demotable122, demotable13, demotable139, demotable146, demotable153, demotable160, demotable168, demotable175, demotable183, demotable190, demotable23, demotable240, demotable248, demotable255, demotable263, demotable28, demotable35, demotable43, demotable50, demotable58, demotable65, demotable72, demotable8, demotable87, demotable94, displayonlydistinctvalue, employeeinformation, excludecertaincolumnsdemo, findinsetdemo, firstweekofmonth, getfileextensiondemo, groupbydemo, idcolumnadd1demo, insert_prevent, javadatedemo, limitwithstoredprocedure,mergingselectdemo,new_viewdemo,old_tabledemo2,orderbyfield,pipeinsertdemo,primarykeydemo,recieved from fromtable,removeuniqueness constraint,returndemo,rowusinglimit,secondtable,select distinctdemo,resumssemo inlastrowdemo,stoproundi || নমুনা ডেটাবেস | NULL || স্কিমস্যাম্পল | NULL || slotgame | NULL || sys | host_summary_by_file_io, io_by_thread_by_latency, memory_by_user_by_current_bytes, schema_object_overview, session_ssl_status, user_summary, wait_classes_global_by_latency, এক্স $ host_summary_by_statement_latency, $ io_global_by_wait_by_bytes x, x $ processlist, এক্স $ schema_table_statistics_with_buffer, $ statements_with_temp_tables x, x $ wait_classes_global_by_latency, host_summary_by_file_io_type, io_global_by_file_by_bytes, memory_global_by_current_bytes, schema_redundant_indexes, statement_analysis, user_summary_by_file_io, waits_by_host_by_latency, এক্স $ host_summary_by_statement_type, এক্স $ io_global_by_wait_by_latency, এক্স $ ps_digest_95th_percentile_by_avg_us, এক্স $ schema_tables_with_full_table_scans, এক্স $ user_summary, এক্স $ waits_by_host_by_latency, host_summary_by_stages, io_global_by_file_by_latency, memory_global_total, schema_table_lock_waits, statements_with_errors_or_warnings, user_summary_by_file_io_type, waits_by_user_by_latency, এক্স $ innodb_buffer_stats_by_schema, $ latest_file_io x, x এর $ ps_digest_avg_latency_distribution,x$session,x$user_summ ary_by_file_io,x$waits_b || পরীক্ষা | absolutedifference, addcolumntocountasserialnumber, addingvaluetoexisting, allnamesstartwithaorborc, appenddatademo, autoincrementtabledemo, bigintdemo, boolorbooleanortinyintdemo, changecurrentautoincrementvalue, collatedemo, comparisononintfield, concatvalues, convertdatedemo, countingdemo, csvformatoutputs, গ্রাহক, dateformatdemo, datetimedemo, decimaldemo, defaultdate, demoofvertical, differentrows, duplicaterecords, employeemaxandsecondmaxsalary, equivalentofidentityinmysql, findlowercasevalue, firsttablemaxvalue, getdatefromtimestamp, gettotalhoursdemo, ifnotnulldemo, incrementingdemo1, insertnullvalue, integerdemo, javainsertdemo, likebinarydemo, lowercasedemo, morethan2columnconcat, newstable, notnullatcreationoftable, occurrencesofcharacter, orderbycharacterlength, orderbynullfirstdemo, orlikedemo, populatetabledemo, productdemo, removenullrecordsdemo, renameviewdemo, rowendswithspecificstring, searchtextdemo, select_distincttwocolumns, Selectindemo,selecttop2fromeachgroup,sessionvariabledemo,sortcolumnzeroatlastdemo,strin গ্রেপ্লেসডেমো, স্টুডেন্টইনফো || test3 | groupwithtopndemo, productdemo, studentinformation, bestdateformatdemo, lastrecordbeforelastone, radiansdemo, updatestringdemo, bitdemo, mostrecentdatedemo, returnresultofmd5demo, countdemo, mysqlandconditiondemo, select_timestampdemo, deletedemo, nullcasedemo, selectt extafterlastslashdemo, differentdatetime, আদেশ, siglequotesdemo, expandedoutputdemo, orderbydatethentimedemo, singleautoincrementcolumndemo, fieldlessthan5chars, পোস্ট, storeddemo || ট্র্যাকার | প্রতিরোধমূলক সংখ্যা || বিশ্ববিদ্যালয়ের ডাটাবেস | NULL || ওয়েব | demotable492, demotable500, demotable525, demotable516, demotable, demotable, demotable, demotable, demotable, demotable, demotable, demotable605, demotable613, demotable217, demotable225, demotable233, demotable231, demotable241, demotable251, demotable251, demotable251, demotable251, demotable251, demotable267, demotable275, demotable283, demotable291, demotable299, demotable307, demotable315, demotable323, demotable331, demotable339, demotable347, demotable355, demotable363, demotable371, demotable379, demotable388, demotable396, demotable404, demotable412, demotable420, demotable428, demotable436, demotable444, demotable452, demotable460, demotable468, demotable476, demotable493, demotable511, demotable526, demotable534, demotable, demotable, demotable, demotable, demotable, demotable, demotable, demotable606, demotable614, view_demotable388, demotable485, demotabe620, demotable218, demotable226, demotable234, demotable244, demotable252,demotable260,demotable268,demotable276, || web_tracker | NULL || ওয়েবট্র্যাকার | NULL |+----------------------------+------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ---------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------- সেটে 36টি সারি, 6টি সতর্কতা (0.18 সেকেন্ড)
