MySQL Statements

This is an alphabetical listing of our documentation of MySQL statements. This is provided as a quick way to get to the documentation page when you know on which SQL statement you need information. The more popular SQL statements are highlighted with blue text for the heading.

This MySQL statement may be used to change the contents of a db.opt file, which contains the default CHARACTER SET and COLLATE values.
page views: 4,974;
category: Istruzione Database e Tabella Struttura
Use this MySQL statement to delete a given database along with all its tables and data.
page views: 13,913;
category: Istruzione Database e Tabella Struttura
There is no summary of this document.
parent: SELECT;
related resources: 6;
page views: 5,193;
category: Manipolazione dei Dati
Use this MySQL statement to alter an existing scheduled MySQL event.
page views: 6,209;
category: Stored Routine
DROP EVENT
This MySQL statement deletes an event.
page views: 3,127;
category: Stored Routine
There is no summary of this document.
parent: SELECT;
page views: 3,630;
category: Manipolazione dei Dati
This MySQL statement changes the characteristics of an existing user-defined function.
page views: 11,732;
category: Stored Routine
DROP FUNCTION
Use this MySQL statement to delete a user-defined function.
page views: 3,018;
category: Stored Routine
This MySQL statement, the SELECT is used to retrieve and display data from tables within a MySQL database.
parent: SELECT;
page views: 7,335;
category: Manipolazione dei Dati
This MySQL statement changes the characteristics of an existing stored procedure.
page views: 22,048;
category: Stored Routine
DROP INDEX
This MySQL statement deletes a given index from a MySQL table.
page views: 2,890;
category: Istruzione Database e Tabella Struttura
This MySQL statement sets a system or user variable for global or session use.
page views: 4,203;
category: Manipolazione dei Dati
This MySQL statement may be used to change the contents of a db.opt file, which contains the default CHARACTER SET and COLLATE values.
page views: 4,098;
category: Istruzione Database e Tabella Struttura
This MySQL statement deletes a prepared statement.
page views: 3,682;
category: Stored Routine
This MySQL statement skips the given number of events from the master.
page views: 3,808;
category: Replicazione
ALTER SERVER
Use this MySQL statement with the FEDERATED storage engine to change the connection parameters of a server created with CREATE SERVER.
page views: 3,017;
category: Istruzione Database e Tabella Struttura
DROP PROCEDURE
This MySQL statement deletes a stored procedure.
page views: 3,021;
category: Stored Routine
SET PASSWORD
Utilizzare questa istruzione MySQL per modificare la password di un conto utente.
page views: 2,886;
category: Istruzione di Utente e Sicurezza
After you've created a table, use this MySQL statement to change the structure of a table.
sub-documents: 12;
related resources: 3;
page views: 8,513;
category: Istruzione Database e Tabella Struttura
DROP SERVER
This MySQL statement can be used with the FEDERATED storage engine to delete a given server that was created with CREATE SERVER.
page views: 3,101;
category: Istruzione Database e Tabella Struttura
This MySQL statement enables or disables binary logging of SQL statements for the current connection.
page views: 6,169;
category: Replicazione
The ADD FULLTEXT clause of the ALTER TABLE statement adds an index on a TEXT column within an existing MyISAM table in MySQL.
parent: ALTER TABLE;
related resources: 3;
page views: 36,921;
category: Istruzione Database e Tabella Struttura
Use this MySQL statement to delete a MySQL table from a database, including its data.
page views: 3,636;
category: Istruzione Database e Tabella Struttura
Use this MySQL statement to set an isolation level for the current transaction, for a transaction that's about to be started, or globally.
page views: 4,008;
category: Transazioni
This ADD clause of the MySQL statement ALTER TABLE is used to add a SPATIAL index to a MySQL table.
parent: ALTER TABLE;
related resources: 3;
page views: 5,719;
category: Istruzione Database e Tabella Struttura
This MySQL statement deletes a trigger.
page views: 5,276;
category: Stored Routine
SHOW BINARY LOGS
This MySQL statement displays a list of binary logs created by the master MySQL server in the filesystem directory.
page views: 2,980;
category: Replicazione
Use the ADD INDEX clause of the ALTER TABLE statement to add an index to a MySQL table.
parent: ALTER TABLE;
related resources: 3;
page views: 4,724;
category: Istruzione Database e Tabella Struttura
Se un utente non ha privilegi a tutti—significato, dopo aver revocare tutti i privilegi di un utente con il <tt>REVOKE</tt> di istruzione—è possibile utilizzare questa istruzione per rimuo
page views: 9,027;
category: Istruzione di Utente e Sicurezza
This MySQL statement displays the events in a binary log file.
page views: 7,968;
category: Replicazione
These clauses of the MySQL statement, ALTER TABLE add columns to a MySQL table.
parent: ALTER TABLE;
related resources: 3;
page views: 6,042;
category: Istruzione Database e Tabella Struttura
DROP VIEW
This MySQL statement deletes a view. Multiple views may be given in a comma-separated list.
page views: 2,945;
category: Istruzione Database e Tabella Struttura
This MySQL statement will show all of the character sets (e.g., latin1, utf8) installed on the server.
page views: 5,777;
category: Istruzione Database e Tabella Struttura
These ADD clauses of the MySQL statement ALTER TABLE add foreign keys and references to MySQL tables that use the storage engine, InnoDB in MySQL.
parent: ALTER TABLE;
related resources: 3;
page views: 20,109;
category: Istruzione Database e Tabella Struttura
EXECUTE
This MySQL statement executes a user-defined prepared statement.
page views: 2,925;
category: Stored Routine
Use this MySQL statement to list all of the collation character sets.
page views: 3,747;
category: Istruzione Database e Tabella Struttura
These clauses of the MySQL statement, ALTER TABLE are used to alter an existing column in a MySQL table.
parent: ALTER TABLE;
related resources: 3;
page views: 9,704;
category: Istruzione Database e Tabella Struttura
Use this MySQL statement to display information about the columns of a given table or the handling of a SELECT statement.
page views: 3,507;
category: Manipolazione dei Dati
With this MySQL statement you can display the columns for a table: their datatype, whether they're indexed, default value, etc..
page views: 6,218;
category: Istruzione Database e Tabella Struttura
The DROP clause of the MySQL statement, ALTER TABLE removes a given column from a MySQL table and delete the column's
parent: ALTER TABLE;
related resources: 3;
page views: 5,463;
category: Istruzione Database e Tabella Struttura
FETCH
A cursor is similar to a MySQL table or a view: it represents, within a procedure, a results set that is retrieved one row at a time using this MySQL statement.
page views: 3,018;
category: Stored Routine
This MySQL statement just displays the CREATE DATABASE statement for creating the MySQL database given—which isn't very useful for most developers.
page views: 5,075;
category: Istruzione Database e Tabella Struttura
These clauses of the MySQL statement, ALTER TABLE are used to delete indexes in a MySQL table.
parent: ALTER TABLE;
related resources: 3;
page views: 28,936;
category: Istruzione Database e Tabella Struttura
Use this MySQL statement to clear temporary caches in MySQL.
page views: 4,365;
category: Tavola e Server Istruzione Amministrazione
SHOW CREATE EVENT
This MySQL statement displays an SQL statement that can be used to create an event like the one given.
page views: 3,263;
category: Stored Routine
These clauses of the MySQL statement, ALTER TABLE can be used to change a variety of MySQL table properties.
parent: ALTER TABLE;
related resources: 3;
page views: 4,350;
category: Istruzione Database e Tabella Struttura
Questo è probabilmente l'istruzione più utilizzato SQL per la creazione di utenti e garantire loro privilegi in MySQL.
sub-documents: 3;
page views: 5,447;
category: Istruzione di Utente e Sicurezza
SHOW CREATE FUNCTION
This MySQL statement displays an SQL statement that can be used to create a function like the one given.
page views: 3,182;
category: Stored Routine
These clauses of the MySQL statement, ALTER TABLE are used to change the properties of MySQL tables that are partitioned.
parent: ALTER TABLE;
page views: 5,560;
category: Istruzione Database e Tabella Struttura
There is no summary of this document.
parent: GRANT;
page views: 6,570;
category: Istruzione di Utente e Sicurezza
This MySQL statement displays an SQL statement that can be used to create a stored procedure like the one given.
page views: 3,615;
category: Stored Routine
These table partition clauses for the MySQL statement, ALTER TABLE may be used to add or remove partitions in a MySQL table.
parent: ALTER TABLE;
page views: 30,577;
category: Istruzione Database e Tabella Struttura
Questa pagina contiene un elenco di privilegi utente che possono essere accordate o revocate.
parent: GRANT;
page views: 6,173;
category: Istruzione di Utente e Sicurezza
This MySQL statement displays an SQL statement that can be used to create a MySQL table like the one named. The results may be copied and used with another MySQL database.
page views: 3,663;
category: Istruzione Database e Tabella Struttura
This page lists all of the table options that can be set with the ALTER TABLE statement for altering a MySQL table.
parent: ALTER TABLE;
page views: 12,773;
category: Istruzione Database e Tabella Struttura
There is no summary of this document.
parent: GRANT;
page views: 6,298;
category: Istruzione di Utente e Sicurezza
SHOW CREATE VIEW
Use this MySQL statement to display an SQL statement that can be used to create a view like the one named.
page views: 2,993;
category: Istruzione Database e Tabella Struttura
There is not an ALTER TRIGGER statement in MySQL at this time.
page views: 14,636;
category: Stored Routine
A handle provides direct access to a table, as opposed to working from a results set.
page views: 6,725;
category: Manipolazione dei Dati
This MySQL statement displays the list of databases on the server. The keyword DATABASE has become synomymous with SCHEMA.
page views: 4,069;
category: Istruzione Database e Tabella Struttura
Use this MySQL statement to change a view, which are created with CREATE VIEW, of course.
page views: 10,551;
category: Istruzione Database e Tabella Struttura
HELP
This MySQL statement can be used to access built-in documentation.
page views: 2,819;
category: Altri Istruzioni
SHOW ENGINE
Use this MySQL statement to display details of the status of a given storage engine.
page views: 2,915;
category: Tavola e Server Istruzione Amministrazione
Use this MySQL statement to store information that can be useful later when the MySQL optimizer chooses the order for consulting indexes during a query.
page views: 4,732;
category: Tavola e Server Istruzione Amministrazione
This MySQL statement is used to add rows of data to a table. It has a few primary syntax with many options.
sub-documents: 4;
related resources: 5;
page views: 6,383;
category: Manipolazione dei Dati
SHOW ENGINES
Use this MySQL statement to list the storage engines (types of tables) available for the installation of MySQL you're using.
page views: 3,209;
category: Tavola e Server Istruzione Amministrazione
BACKUP TABLE
This MySQL statement makes a backup copy of a MyISAM table. However, it has been deprecated because it does not work reliably.
page views: 3,043;
category: Tavola e Server Istruzione Amministrazione
This syntax of the MySQL statement, INSERT is used to insert rows of data into a table based on the results of a
parent: INSERT;
related resources: 5;
page views: 5,073;
category: Manipolazione dei Dati
SHOW ERRORS
Use this MySQL statement to display error messages for the previous SQL statement.
page views: 2,988;
category: Manipolazione dei Dati
BEGIN
Use this MySQL statement to start a transaction.
page views: 3,268;
category: Transazioni
This format of the MySQL statement, INSERT allows one SQL statement to insert multiple rows into a MySQL table.
parent: INSERT;
related resources: 5;
page views: 68,373;
category: Manipolazione dei Dati
SHOW EVENTS
This MySQL statement displays a list of scheduled events on the server.
page views: 2,917;
category: Stored Routine
Use this combination of MySQL statements to start and end the steps that are part of a stored procedure or trigger.
page views: 4,088;
category: Stored Routine
Use this variant of the MySQL statement, INSERT to add only one row of data into a MySQL table per statement.
parent: INSERT;
related resources: 5;
page views: 4,413;
category: Manipolazione dei Dati
This MySQL statement displays the internal code of a function.
page views: 4,690;
category: Stored Routine
CACHE INDEX
This MySQL statement tells MySQL to cache the given indexes to a specific index cache, which can be created with the SET GLOBAL statement. This MySQL statement is used only on MyISAM tables.
page views: 3,085;
category: Tavola e Server Istruzione Amministrazione
KILL
Use this MySQL statement to terminate a client connection to MySQL. You can use the SHOW PROCESSLIST statement to obtain a connection thread identifier for use in this statement.
page views: 3,239;
category: Tavola e Server Istruzione Amministrazione
SHOW FUNCTION STATUS
This MySQL statement displays information on user-defined functions.
page views: 3,058;
category: Stored Routine
CALL
Use this MySQL statement to call a stored procedure.
page views: 3,137;
category: Stored Routine
This MySQL statement has been deprecated and will be removed from future releases of MySQL.
page views: 5,268;
category: Replicazione
SHOW GRANTS
Questa istruzione MySQL visualizza il <tt>GRANT</tt> istruzione per un dato utente.
page views: 3,069;
category: Istruzione di Utente e Sicurezza
This MySQL statement changes the settings on a slave server related to the master server and replication.
page views: 3,512;
category: Replicazione
This MySQL statement can be used to import organized data from a text file into a table in MySQL. The file can be either on the server or on the client.
page views: 16,737;
category: Manipolazione dei Dati
This MySQL statement displays information about the indexes for a MySQL table.
page views: 4,983;
category: Istruzione Database e Tabella Struttura
CHECK TABLE
Use this MySQL statement to check tables for errors; as of version 5.1.9 of MySQL, it works with the MyISAM, InnoDB, ARCHIVE, and CSV storage engines.
page views: 3,116;
category: Tavola e Server Istruzione Amministrazione
Use this MySQL statement to preload a table's index into a given key cache for a MyISAM table.
page views: 4,756;
category: Altri Istruzioni
SHOW MASTER LOGS
This MySQL statement displays a list of binary logs created by the master MySQL server in the filesystem directory.
page views: 3,216;
category: Replicazione
This MySQL statement returns a MyISAM table's live checksum value, a value that can be optionally maintained to improve a table's repairability.
page views: 4,186;
category: Tavola e Server Istruzione Amministrazione
LOAD TABLE...FROM MASTER
This MySQL statement has been deprecated and will be removed from future releases of MySQL since it has many problems.
page views: 2,834;
category: Replicazione
SHOW MASTER STATUS
This MySQL statement displays information on the status of the binary log file that is being used currently on the master MySQL server.
page views: 3,163;
category: Replicazione
CLOSE
This MySQL statement closes a cursor that has been declared within the current routine and has been opened using the OPEN statement.
page views: 2,870;
category: Stored Routine
Use this MySQL statement to lock the given tables for exclusive use by the current connection thread.
page views: 4,285;
category: Tavola e Server Istruzione Amministrazione
Use this MySQL statement to display a list of tables that are open; that is to say, in the table cache. The list does not include any temporary tables.
page views: 8,649;
category: Tavola e Server Istruzione Amministrazione
Use this MySQL statement to commit transactions, which are SQL statements that have changed data and that have been entered into MySQL but not yet saved.
page views: 3,794;
category: Transazioni
This function is useful to synchronize MySQL master and slave server logging.
page views: 3,521;
category: Replicazione
SHOW PLUGINS
Use this MySQL statement to display a list of plugins on the server.
page views: 3,147;
category: Tavola e Server Istruzione Amministrazione
This MySQL statement creates a new database with the name given. There's not much to it.
page views: 6,922;
category: Istruzione Database e Tabella Struttura
This page our MySQL documentation relates to MySQL Subqueries, in particular, subqueries which involve multiple fields or return multiple fields in the resu
page views: 15,748;
category: Sotto-Query
SHOW PRIVILEGES
Questa istruzione MySQL fornisce un elenco di privilegi disponibili, insieme con il contesto di ognuna (ad esempio, l'amministrazione del server) e una descrizione.
page views: 2,844;
category: Istruzione di Utente e Sicurezza
Use this MySQL statement to schedule the execution of an SQL statement at a specific time and date.
page views: 8,328;
category: Stored Routine
OPEN
This MySQL statement opens a cursor that has been declared within the current routine.
page views: 2,981;
category: Stored Routine
This MySQL statement displays the internal code of a stored procedure.
page views: 3,608;
category: Stored Routine
A user-defined function is in essence a set of MySQL statements that may be called as a unit, processing any data it's given in its parameters and returning a value to the caller of the function.
page views: 7,051;
category: Stored Routine
Use this MySQL statement to optimize the data contained in a table. Optimization is useful when many rows have been deleted from a table.
page views: 3,318;
category: Tavola e Server Istruzione Amministrazione
SHOW PROCEDURE STATUS
This MySQL statement displays information on stored procedures.
page views: 3,176;
category: Stored Routine
CREATE INDEX
Use this MySQL statement to add an index to a MySQL table after it has been created.
page views: 3,253;
category: Istruzione Database e Tabella Struttura
PREPARE
This MySQL statement creates a prepared statement.
page views: 3,096;
category: Stored Routine
SHOW PROCESSLIST
This statement displays a list of connection threads running on the MySQL server. You'll need this if one of them is locked and slowing down the system.
page views: 3,147;
category: Tavola e Server Istruzione Amministrazione
These clauses of the CREATE INDEX statement can be used to create FULLTEXT indexes in a MySQL table.
parent: CREATE TABLE;
page views: 4,009;
category: Istruzione Database e Tabella Struttura
This MySQL statement deletes the binary logs from a master server.
page views: 3,553;
category: Replicazione
SHOW SCHEMAS
This MySQL statement is synonymous with SHOW DATABASES. See the description of that statement for more information and examples.
page views: 2,776;
category: Tavola e Server Istruzione Amministrazione
There is no summary of this document.
parent: CREATE TABLE;
page views: 5,003;
category: Istruzione Database e Tabella Struttura
This MySQL statement instructs the server to release a savepoint named earlier with the SAVEPOINT statement for the current transaction.
page views: 3,329;
category: Transazioni
This MySQL statement displays a list of slave servers for the master server.
page views: 4,262;
category: Replicazione
These clauses of the CREATE INDEX statement can be used to create UNIQUE indexes in a MySQL table.
parent: CREATE TABLE;
page views: 4,940;
category: Istruzione Database e Tabella Struttura
This MySQL statement does what it says: it will rename a database to whatever name you give it, provided it doesn't already exist.
page views: 4,385;
category: Istruzione Database e Tabella Struttura
SHOW SLAVE STATUS
This MySQL statement displays information on the slave thread.
page views: 3,063;
category: Replicazione
A procedure, also known as a stored procedure, is set of MySQL statements stored on the MySQL server and called as a unit, processing any data it's given in its parameters.
page views: 7,281;
category: Stored Routine
If for some reason you want to rename an existing MySQL table, use this MySQL statement. It's the easiest way.
page views: 5,515;
category: Istruzione Database e Tabella Struttura
This MySQL statement displays status information and variables from the server.
page views: 3,403;
category: Tavola e Server Istruzione Amministrazione
This MySQL statement is synonymous with CREATE DATABASE.
page views: 45,430;
category: Istruzione Database e Tabella Struttura
Se un amministratore di MySQL vuole semplicemente cambiare il nome utente o l'host di un conto utente di MySQL, ma non i privilegi di un account utente, un amministratore può utilizzare questa is
page views: 6,205;
category: Istruzione di Utente e Sicurezza
This MySQL statement displays status information on a set of tables from a database.
page views: 23,573;
category: Tavola e Server Istruzione Amministrazione
You can use this MySQL statement with the FEDERATED storage engine to set the connection parameters.
page views: 4,184;
category: Istruzione Database e Tabella Struttura
Use this MySQL statement to repair corrupted MyISAM tables.
page views: 3,760;
category: Tavola e Server Istruzione Amministrazione
SHOW TABLE STATUS
This MySQL statement displays status information on a set of tables from a database.
page views: 3,088;
category: Tavola e Server Istruzione Amministrazione
This is one of the primary MySQL statements that a MySQL developer will use when first setting up a database. It's used to create MySQL tables, to which data will later be added.
sub-documents: 11;
page views: 5,447;
category: Istruzione Database e Tabella Struttura
This MySQL statement to insert new rows of data and to replace existing rows where the PRIMARY KEY or UNIQUE index key is the same as the new record being inserted.
page views: 4,169;
category: Manipolazione dei Dati
This MySQL statement displays a list of MySQL tables and views. To distinguish between MySQL tables and views, add the FULL keyword.
page views: 3,387;
category: Istruzione Database e Tabella Struttura
There is no summary of this document.
parent: CREATE TABLE;
page views: 25,336;
category: Istruzione Database e Tabella Struttura
Utilizzare questa istruzione MySQL per reimpostare alcune impostazioni del server e file di log.
page views: 3,575;
category: Istruzione di Utente e Sicurezza
This MySQL statement displays a list of triggers on the server.
page views: 8,413;
category: Stored Routine
There is no summary of this document.
parent: CREATE TABLE;
page views: 9,299;
category: Istruzione Database e Tabella Struttura
RESET
Utilizzare questa istruzione MySQL per reimpostare alcune impostazioni del server e file di log.
page views: 2,796;
category: Istruzione di Utente e Sicurezza
This MySQL statement displays the system variables for the MySQL server.
page views: 3,648;
category: Tavola e Server Istruzione Amministrazione
There is no summary of this document.
parent: CREATE TABLE;
page views: 51,155;
category: Istruzione Database e Tabella Struttura
RESET MASTER
This MySQL statement deletes all the binary log files on the master server.
page views: 3,056;
category: Replicazione
SHOW VIEWS
If you were looking for this MySQL statement and can't find it anywhere else, I'm not surprise. Click on this one and you'll see why.
page views: 3,207;
category: Istruzione Database e Tabella Struttura
There is no summary of this document.
parent: CREATE TABLE;
page views: 10,504;
category: Istruzione Database e Tabella Struttura
RESET SLAVE
Use this MySQL statement within or after the RESET MASTER statement that sets the binary logging index back to 1.
page views: 2,980;
category: Replicazione
Use this MySQL statement to display warning messages, error messages, and notes for previous SQL statements for the current session.
page views: 3,969;
category: Manipolazione dei Dati
There is no summary of this document.
parent: CREATE TABLE;
page views: 6,133;
category: Istruzione Database e Tabella Struttura
RESTORE TABLE
This MySQL statement restores a table that was saved to the filesystem by the BACKUP TABLE statement, which is deprecated.
page views: 2,768;
category: Tavola e Server Istruzione Amministrazione
This page our MySQL documentation relates to sub-queries which involve a single field or return a single field in the results of the inner query.
page views: 3,995;
category: Sotto-Query
There is no summary of this document.
parent: CREATE TABLE;
page views: 4,105;
category: Istruzione Database e Tabella Struttura
This page our MySQL documentation relates to MySQL Subqueries, in particular, subqueries which return a results set from the inner query.
page views: 4,567;
category: Sotto-Query
Use this MySQL statement to start a slave server.
page views: 4,830;
category: Replicazione
There is no summary of this document.
parent: CREATE TABLE;
page views: 9,526;
category: Istruzione Database e Tabella Struttura
Questa istruzione MySQL è usato per revocare facilmente privilegi specificati da un utente senza necessariamente revocare tutti i privilegi o debbano eliminare un utente e creare nuovamente l'utente c
page views: 4,649;
category: Istruzione di Utente e Sicurezza
Use this MySQL statement to start a transaction.
page views: 4,498;
category: Transazioni
These options are used to set the maximum and minimum rows of a MySQL table, respectively. Use the SHOW CREATE TABLE statement to see the results.
parent: CREATE TABLE;
page views: 5,446;
category: Istruzione Database e Tabella Struttura
Use this MySQL statement with transactional tables to reverse transactions that have not yet been committed.
page views: 3,516;
category: Transazioni
STOP SLAVE
This MySQL statement stops the slave server threads.
page views: 2,836;
category: Replicazione
Triggers are actions to be taken when a user requests a change to data in MySQL.
page views: 6,923;
category: Stored Routine
This MySQL statement instructs the server to reverse SQL statements for the current transaction back to a point marked in the transaction by the SAVEPOINT statement.
page views: 26,807;
category: Transazioni
TRUNCATE
Use this MySQL statement to delete the contents of a table rapidly.
page views: 3,023;
category: Manipolazione dei Dati
Questa istruzione MySQL è molto semplice: è usato per creare un utente, ma non permette privilegi da concedere con esso. Per questo, si può usare il <tt>GRANT</tt> istruzione.
page views: 3,508;
category: Istruzione di Utente e Sicurezza
Use this MySQL statement to identify a point in a transaction to which SQL statements may potentially be undone later.
page views: 3,595;
category: Transazioni
UNLOCK TABLES
Use this MySQL statement to unlock tables that were locked by the current connection thread with the LOCK TABLES statement.
page views: 3,213;
category: Tavola e Server Istruzione Amministrazione
Use this MySQL statement to create a view, which is a preset query, stored in a database. In certain situations a view can be useful for improved security.
page views: 7,984;
category: Istruzione Database e Tabella Struttura
To retrieve and display data from tables within a database, use this MySQL statement. It also has more than one syntax and many options—it also allows for sub-queries.
sub-documents: 7;
related resources: 6;
page views: 6,434;
category: Manipolazione dei Dati
If you want to change data in a table or just in some rows—even one row only—use this MySQL statement. Click on the heading here for more details.
sub-documents: 2;
page views: 5,969;
category: Manipolazione dei Dati
This MySQL statement declares local variables and other items related to routines.
page views: 4,837;
category: Stored Routine
There is no summary of this document.
parent: SELECT;
related resources: 6;
page views: 4,412;
category: Manipolazione dei Dati
This syntax of the MySQL statement, UPDATE, available as of version 4.0.4 of MySQL, allows for multiple MySQL tables to be updated or referenced in one MySQL statement.
parent: UPDATE;
page views: 6,821;
category: Manipolazione dei Dati
Use this MySQL statement to delete rows of data from a given table. Be careful with this one: there's basically no UNDO statement.
page views: 6,286;
category: Manipolazione dei Dati
There is no summary of this document.
parent: SELECT;
related resources: 6;
page views: 13,158;
category: Manipolazione dei Dati
This page of our MySQL documentation relates to the MySQL statement, UPDATE, in particular, updating a single table, as opposed to
parent: UPDATE;
page views: 5,218;
category: Manipolazione dei Dati
DELIMITER
This MySQL statement changes the delimiter (terminating character) of SQL statements from the default of a semi-colon to another character.
page views: 2,795;
category: Stored Routine
There is no summary of this document.
parent: SELECT;
related resources: 6;
page views: 3,665;
category: Manipolazione dei Dati
USE
This MySQL statement sets the default database MySQL is to use for the current session.
page views: 2,938;
category: Altri Istruzioni
This MySQL statement displays information about the columns of a given MySQL table.
page views: 5,691;
category: Istruzione Database e Tabella Struttura
There is no summary of this document.
parent: SELECT;
related resources: 6;
page views: 4,637;
category: Manipolazione dei Dati
This MySQL statement is used for XA distributed transactions.
page views: 4,650;
category: Altri Istruzioni
DO
This MySQL statement suppresses the display of an expression's results. I can't think of much point to this one. Please let me know you can.
page views: 3,050;
category: Manipolazione dei Dati