Search results
11 wrz 2012 · The following query gives the list of all the primary keys in the given database. SELECT DISTINCT TABLE_NAME ,column_name FROM INFORMATION_SCHEMA.key_column_usage WHERE TABLE_SCHEMA IN ('*your_db_name*');
22 maj 2009 · To get the whole database structure as a set of CREATE TABLE statements, use mysqldump: mysqldump database_name --compact --no-data.
10 mar 2024 · In this tutorial, we learned about using the MySQL command line. We learned about different ways we can connect to the MySQL shell and how we can connect to a particular database directly, how we can execute SQL script files and export the output to CSV files.
10 paź 2019 · To get a list of the tables in a MySQL database, use the mysql client tool to connect to the MySQL server and run the SHOW TABLES command. Access the MySQL server: mysql -u user -p. From within the MySQL shell, switch to the database using the USE statement: USE database_name;
6 lip 2024 · To check which port is used by MySQL on Linux, you can use one of these two commands: $ lsof -n | grep 'mysql.*TCP' Or, you can use this one too: $ netstat -tlpn | grep mysql
25 sty 2024 · CREATE TABLE users ( id INT AUTO_INCREMENT, username VARCHAR(50) NOT NULL, PRIMARY KEY (id) ); This command creates a ‘users’ table with an auto-incrementing ‘id’ and a ‘username’ column. Showing tables: SHOW TABLES; This lists all tables in the current database. Working with Data
You can execute SQL statements in a script file (batch file) like this: mysql db_name < script.sql > output.tab. On Unix, the mysql client logs statements executed interactively to a history file. See Section 6.5.1.3, “mysql Client Logging”.
