demo.phpmyadmin.net / phpMyAdmin demo - MySQL / sys | phpMyAdmin 6.0.0-dev+20241219.8e721911f0

Sharlaý tarmaǵy kórinisin teńsheý.

Sharlaý taqtasy

Derekqorlardy sharlaýyn tarmaq retinde kórsetý Sharlaý taqtasynda derekqor tarmaǵyn tańdaýshymen aýystyrady
Negizgi taqtamen baılanystyrý Aǵymdyq derekqordy nemese kesteni bólekteý arqyly basty taqtamen baılanystyrý.
Logotıpty beıneleý Sharlaý taqtasynda logotıp kórsetý.
Logotıp siltemesiniń URL-y Sharlaý taqtasyndaǵyi logotıp meńzeıtin URL.
Logotıp siltemesiniń maqsaty Open the linked page in the main window (`main`) or in a new one (`new`).
Bólekteýdi qosý Tintýir kórsetkisi astynda serverdi bólekteý.
Birinshi deńgeıdegi eń kóp elementter Sharlaý tarmaǵynyń birinshi deńgeıindegi árbir bette beınelenetin element sany.
Súzgi uıasynda beınelenetin elementtiń eń az sany Súzgi uıasynda beınelenetin elementtiń (keste, kórinis, rásim jáne oqıǵa) eń az sanyn anyqtaıdy.
Jýyqtaǵy paıdalanylǵan kesteler Jaqynda paıdalanylǵan kestelerdiń eń kóp sany; óshirý úshin 0 ornatyńyz.
Tańdaýly kesteler Tańdaýly kestelerdiń eń kóp sany; óshirý úshin 0 ornatyńyz.
Sharlaý taqtasynyń eni Sharlaý taqtasyn tasalaý úshin 0 mánine ornatý.

Sharlaý tarmaǵyn teńsheý.

Sharlaý tarmaǵy

Tarmaqtaǵy elementtiń eń kóp sany Sharlaý tarmaǵynyń árbir bette beınelenetin element sany.
Tarmaqtaǵy elementterdi toptastyrý Sharlaý tarmaǵyndaǵy elementterdi toptastyrý (derekqor men kesteler qoıyndylarynda kórsetilgen bólgishpen anyqtalady).
Sharlaý tarmaǵyn keńeıtýdi qosý Sharlaý taqtasynda tarmaq keńeıtý yqtımaldyǵy usynylsyn ba.
Tarmaqtaǵy kestelerdi kórsetý Sharlaý tarmaǵy ishindegi derekqordyń astynda kesteler kórsetilsin be
Tarmaqtaǵy kórinisterdi kórsetý Sharlaý tarmaǵy ishindegi derekqor astynda kórinister kórsetilsin be
Tarmaqtaǵy funksıalardy kórsetý Sharlaý tarmaǵy ishindegi derekqor astynda fýnksıalar kórsetilsin be
Tarmaqtaǵy rásimderdi kórsetý Sharlaý tarmaǵy ishindegi derekqor astynda rásimder kórsetilsin be
Tarmaqtaǵy oqıǵalardy kórsetý Sharlaý tarmaǵy ishindegi derekqor astynda oqıǵalar kórsetilsin be
Jalǵyz derekqordy keńeıtý Sharlaý tarmaǵy ishindegi jalǵyz derekqor avtomatty keńeıtilsin be.

Serverlerdi beıneleý opsıalary.

Serverler

Serverler bólekteýdi beıneleý Sharlaý taqtasynyń joǵarǵy jaǵynda server tańdaýyn beıneleý.
Serverlerdi tizim retinde beıneleý Server tizbesin ashylmaly tizimniń ornyna tizim retinde kórsetý.

Derekqorlardy beıneleý opsıalary.

Derekqorlar

Derekqordyń súzgi uıasynda beınelenetin derekqordyń eń az sany
Derekqor tarmaǵynyń bólgishi Derekqorlardy ártúrli tarmaq deńgeılerine bóletin jol.

Kestelerdi beıneleý opsıalary.

Kesteler

Jyldam qatynaý beligishesi úshin maqsat
Ekinshi jyldam qatynaý beligishesi úshin maqsat
Keste tarmaǵynyń bólgishi Kestelerdi ártúrli tarmaq deńgeılerine bóletin jol.
Keste tarmǵynyń eń kóp terendigi

Faıldardy osynda aparyńyz

SQL júktep salý ( 0 ) x -

Bettiń joǵarǵy jaǵyna jyljý úshin jolaqty basyńyz

Saýaldy oryndaý úshin Ctrl+Enter basyńyz

Jıý Jaıý Qadaǵalaýdy kórsetý Qadaǵalaýdy jasyrý Alynǵan ýaqyt:

Árqashan saýal habarlaryn keńeıtý

Saýal tarıhyn basynda kórsetý

Aǵymdyq sholýdaǵy saýaldy kórsetý

Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.

Kúńgirt taqyrypqa aýystyrý

Jıý Jaıý Jańǵyrtý Óńdeý Explain áreketi Profaıldaý Saýal sátsiz aıaqtaldy Derekqor: Saýaldyq ýaqyt:

Kestelerdi«sys» derekqorynan eksporttaý

Ádepki eksport opsıalaryn teńsheý.

Ádepkilerdi eksporttaý

Jyldam
Eksport ádisi
Serverde saqtaý
Qoldanysta bar faıl(dar)dy qaıta jazý
Teńsheýli
Pishim
Qysý
Faıldyń tańbalar jıyny
Use `LOCK TABLES` statement
Jeke faıldar retinde eksporttaý
Faıl retinde saqtaý
Serverde saqtaý
Qoldanysta bar faıl(dar)dy qaıta jazý
Keste atynyń úlgisi
Derekqor atynyń úlgisi
Server atynyń úlgisi

Ádepki opsıalardy teńsheý.

SQL

Qurylym
Túsiniktemeler
Jasaý/jańartý/tekserý kúnderi
Qatynastyqtar
Media type
Eksportty tranzaksıaǵa qorshaý
Syrtqy kilt tekserýlerin óshirý
Kórinisterdi kesteler retinde eksporttaý
phpMyAdmin konfıgýrasıa saqtaýyshynan qatysty metaderekterdi eksporttaý
SQL úılesimdilik rejimi
Kesteni damptaý
DROP DATABASE ústeý
CREATE DATABASE / USE ústeý
DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER ústeý
CREATE TABLE ústeý
IF IF NOT EXISTS qosý (az tıimdi, sebebi ındekster keste jasaý kezinde jasalyp shyǵarylady )
AUTO_INCREMENT mánin ústeý
CREATE VIEW ústeý
Export/sql_view_current_user
OR REPLACE kórinis
CREATE PROCEDURE / FUNCTION / EVENT ústeý
CREATE TRIGGER ústeý
Keste men baǵan ataýlaryn doǵal ekpin tańbalarmen (`) qorshaý
Derekter
Kidiritilgen kiristirýlerdi paıdalaný
Elemeıtin kiristirýlerdi paıdalaný
Eksport túri
Derekterdi kiristirý kezinde paıdalanylatyn sıntaksıs
Jasalǵan saýaldyń eń kóp uzyndyǵy
BINARY jáne BLOB úshin onaltylyqty paıdalaný
Eksporttaýdyń UTC boıynsha ýaqyty

Ádepki opsıalardy teńsheý.

CodeGen

Pishim

Ádepki opsıalardy teńsheý.

CSV

CSV
Baǵandar mynaýmen aıaqtalǵan
Baǵandar mynaýmen qorshalǵan
Baǵandar mynaýmen ekrandalǵan
Syzyqtar mynaýmen aıaqtalǵan
NULL-dy mynaýmen aýystyrý
Baǵandar ishinen CRLF tańbalaryn alastaý
Baǵandardyń ataýlaryn birinshi jolǵa qoıý
MS Excel úshin CSV
NULL-dy mynaýmen aýystyrý
Baǵandar ishinen CRLF tańbalaryn alastaý
Baǵandardyń ataýlaryn birinshi jolǵa qoıý
Excel óńdemesi

Ádepki opsıalardy teńsheý.

LaTeX

Qurylym
Keste taqyrypshasyn qamtý
Kesteni damptaý
Keste taqyrypshasy
Jalǵasqan keste taqyrypshasy
Belgi kilti
Qatynastyqtar
Túsiniktemeler
Media type
Derekter
Baǵandardyń ataýlaryn birinshi jolǵa qoıý
Keste taqyrypshasy
Jalǵasqan keste taqyrypshasy
Belgi kilti
NULL-dy mynaýmen aýystyrý

Ádepki opsıalardy teńsheý.

Microsoft Office

Microsoft Word 2000
Kesteni damptaý
NULL-dy mynaýmen aýystyrý
Baǵandardyń ataýlaryn birinshi jolǵa qoıý

Ádepki opsıalardy teńsheý.

OpenDocument

OpenDocument elektrondyq kestesi
Baǵandardyń ataýlaryn birinshi jolǵa qoıý
NULL-dy mynaýmen aýystyrý
OpenDocument mátini
Kesteni damptaý
Qurylym
Qatynastyqtar
Túsiniktemeler
Media type
Derekter
Baǵandardyń ataýlaryn birinshi jolǵa qoıý
NULL-dy mynaýmen aýystyrý

Ádepki opsıalardy teńsheý

Texy! mátini

Derekter
Kesteni damptaý
NULL-dy mynaýmen aýystyrý
Baǵandardyń ataýlaryn birinshi jolǵa qoıý

Eksport ádisi:

Jyldam - eń az opsıalardy ǵana beıneleý

Teńsheýli - barlyq yqtımal opsıalardy beıneleý

Pishim:

Kesteler:

	Kesteler	Qurylym	Derekter
	Barlyǵyn bólekteý
	host_summary
	host_summary_by_file_io
	host_summary_by_file_io_type
	host_summary_by_stages
	host_summary_by_statement_latency
	host_summary_by_statement_type
	innodb_buffer_stats_by_schema
	innodb_buffer_stats_by_table
	innodb_lock_waits
	io_by_thread_by_latency
	io_global_by_file_by_bytes
	io_global_by_file_by_latency
	io_global_by_wait_by_bytes
	io_global_by_wait_by_latency
	latest_file_io
	memory_by_host_by_current_bytes
	memory_by_thread_by_current_bytes
	memory_by_user_by_current_bytes
	memory_global_by_current_bytes
	memory_global_total
	metrics
	processlist
	ps_check_lost_instrumentation
	schema_auto_increment_columns
	schema_index_statistics
	schema_object_overview
	schema_redundant_indexes
	schema_tables_with_full_table_scans
	schema_table_lock_waits
	schema_table_statistics
	schema_table_statistics_with_buffer
	schema_unused_indexes
	session
	session_ssl_status
	statements_with_errors_or_warnings
	statements_with_full_table_scans
	statements_with_runtimes_in_95th_percentile
	statements_with_sorting
	statements_with_temp_tables
	statement_analysis
	sys_config
	user_summary
	user_summary_by_file_io
	user_summary_by_file_io_type
	user_summary_by_stages
	user_summary_by_statement_latency
	user_summary_by_statement_type
	version
	waits_by_host_by_latency
	waits_by_user_by_latency
	waits_global_by_latency
	wait_classes_global_by_avg_latency
	wait_classes_global_by_latency
	x$host_summary
	x$host_summary_by_file_io
	x$host_summary_by_file_io_type
	x$host_summary_by_stages
	x$host_summary_by_statement_latency
	x$host_summary_by_statement_type
	x$innodb_buffer_stats_by_schema
	x$innodb_buffer_stats_by_table
	x$innodb_lock_waits
	x$io_by_thread_by_latency
	x$io_global_by_file_by_bytes
	x$io_global_by_file_by_latency
	x$io_global_by_wait_by_bytes
	x$io_global_by_wait_by_latency
	x$latest_file_io
	x$memory_by_host_by_current_bytes
	x$memory_by_thread_by_current_bytes
	x$memory_by_user_by_current_bytes
	x$memory_global_by_current_bytes
	x$memory_global_total
	x$processlist
	x$ps_digest_95th_percentile_by_avg_us
	x$ps_digest_avg_latency_distribution
	x$ps_schema_table_statistics_io
	x$schema_flattened_keys
	x$schema_index_statistics
	x$schema_tables_with_full_table_scans
	x$schema_table_lock_waits
	x$schema_table_statistics
	x$schema_table_statistics_with_buffer
	x$session
	x$statements_with_errors_or_warnings
	x$statements_with_full_table_scans
	x$statements_with_runtimes_in_95th_percentile
	x$statements_with_sorting
	x$statements_with_temp_tables
	x$statement_analysis
	x$user_summary
	x$user_summary_by_file_io
	x$user_summary_by_file_io_type
	x$user_summary_by_stages
	x$user_summary_by_statement_latency
	x$user_summary_by_statement_type
	x$waits_by_host_by_latency
	x$waits_by_user_by_latency
	x$waits_global_by_latency
	x$wait_classes_global_by_avg_latency
	x$wait_classes_global_by_latency

Anyqtalǵan búrkenshik attar

Jańa búrkenshik ataýlardy anyqtaý
Derekqordy bólekteý:
Kesteni bólekteý:
Baǵandy bólekteý:

Shyǵarý:

Eksporttalǵan derekqorlardy/kestelerdi/baǵandardy qaıta ataý
LOCK TABLES nusqaýyn paıdalaný
Shyǵarýdy mátin retinde kórý

Shyǵarýdy faılǵa saqtaý
- Faıl atynyń úlgisi: This value is interpreted using the 'strftime' function, so you can use time formatting strings. Additionally the following transformations will happen: @SERVER@ will become the server name and @DATABASE@ will become the database name. Other text will be kept as is. See the FAQ 6.27 for details.
  
  Use this for future exports
- Faıldyń tańbalar jıyny:
- Qysý:
- Kestelerdi bólek faıldar retinde eksporttaý
Skip tables larger than:
The size is measured in MiB.

phpMyAdmin demo-serveri: Aǵymda master tarmaǵynan RELEASE_5_2_1-5377-g8e721911f0 Git túzetýi iske qosylǵan.

Sharlaý taqtasy

Sharlaý tarmaǵy kórinisin teńsheý.

Sharlaý tarmaǵy

Sharlaý tarmaǵyn teńsheý.

Serverler

Serverlerdi beıneleý opsıalary.

Derekqorlar

Derekqorlardy beıneleý opsıalary.

Kesteler

Kestelerdi beıneleý opsıalary.

SQL júktep salý ( 0 ) x -

Kestelerdi«sys» derekqorynan eksporttaý

Ádepkilerdi eksporttaý

Ádepki eksport opsıalaryn teńsheý.

SQL

Ádepki opsıalardy teńsheý.

CodeGen

Ádepki opsıalardy teńsheý.

CSV

Ádepki opsıalardy teńsheý.

LaTeX

Ádepki opsıalardy teńsheý.

Microsoft Office

Ádepki opsıalardy teńsheý.

OpenDocument

Ádepki opsıalardy teńsheý.

Texy! mátini

Ádepki opsıalardy teńsheý

CodeGen

CSV

CSV for MS Excel

JSON

LaTeX

Kesteni damptaý

Nysan jasaý opsıalary

Derekter dampynyń opsıalary

MediaWiki Table

Kesteni damptaý

Microsoft Word 2000

Kesteni damptaý

Derekter dampynyń opsıalary

OpenDocument Spreadsheet

OpenDocument Text

Kesteni damptaý

Nysan jasaý opsıalary

Derekter dampynyń opsıalary

PDF

Kesteni damptaý

PHP array

SQL

Nysan jasaý opsıalary

Derekter jasaý opsıalary

Texy! text

Kesteni damptaý

Derekter dampynyń opsıalary

XML

Nysan jasaý opsıalary (barlyǵy usynylady)

Derekter dampynyń opsıalary

YAML