Αποτελέσματα Αναζήτησης
3 Νοε 2014 · To insert table names into another table using a SELECT statement in MySQL, you can query the INFORMATION_SCHEMA.TABLES like this: INSERT INTO metadata(table_name) SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'your_database_name';
The SELECT statement is used to pull information from a table. The general form of the statement is: SELECT what_to_select FROM which_table WHERE conditions_to_satisfy; what_to_select indicates what you want to see.
26 Ιαν 2024 · To select a database to work with, use the USE command followed by the database name: USE database_name; Be sure to replace database_name with the actual name of the database you wish to work with.
The SELECT statement is used to select data from a database. The data returned is stored in a result table, called the result-set. SELECT Syntax. SELECT column1, column2, ... FROM table_name; Here, column1, column2, ... are the field names of the table you want to select data from.
Querying data from tables. Query all data from a table: SELECT * FROM table_name; Code language: SQL (Structured Query Language) (sql) Query data from one or more columns of a table: SELECT column1, column2, ... FROM table_name; Code language: SQL (Structured Query Language) (sql) Remove duplicate rows from the result of a query:
6 Ιουλ 2024 · Read data from the Table (Select) Once the data has been saved, it is time to read it. The statement is select. The basic syntax is as follows: > SELECT column1, column2, ... FROM table_name; If you want to read all the data in the table, use this one: > SELECT * FROM table_name;
mysql is a simple SQL shell with input line editing capabilities. It supports interactive and noninteractive use. When used interactively, query results are presented in an ASCII-table format. When used noninteractively (for example, as a filter), the result is presented in tab-separated format.
