<< < 1 2 3 4 5 6 7 8 9 > >>   Sort: Date

How To Delete Existing Rows in a Table
How To Delete Existing Rows in a Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row: &lt;?php include "mysql_con...
2007-05-11, 4786👍, 0💬

How To Use MySQL Command Line Interface
How To Use MySQL Command Line Interface? - PHP Script Tips - Working with MySQL Database MySQL server comes with a command line interface, which will allow you to operate with the server with SQL statements and other commands. To start the command line interface, you can run the \mysql\bin\mysql pro...
2007-04-18, 4781👍, 0💬

What Is ISAM
What Is ISAM? - MySQL FAQs - Database Basics and Terminologies ISAM (Indexed Sequential Access Method) was developed by IBM to store and retrieve data on secondary storage systems like tapes.
2007-05-10, 4777👍, 0💬

What Is Binary Log File
What Is Binary Log File? - MySQL FAQs - Server Daemon mysqld Administration MySQL server binary log file plays an important role in restoring database changes to the server. Main features on binary log files are: Binary logs can be turned on by "--log-bin=fileBaseName" option on "mysqld". Binary log...
2007-05-11, 4776👍, 0💬

How To Use UNION to Merge Outputs from Two Queries Together
How To Use UNION to Merge Outputs from Two Queries Together? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you have two queries that returns the same row fields, you can merge their outputs together with the UNION operator. The following tutorial exercise shows you how to return a...
2007-05-11, 4769👍, 0💬

How To Rollback the Current Transaction
How To Rollback the Current Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback If you have used some DML statements updated some data objects, you find a problem with those updates, and you don't want those updates to be permanently recorded in the database, you can use the ROLLB...
2007-05-11, 4754👍, 0💬

What Is MyISAM
What Is MyISAM? - MySQL FAQs - Database Basics and Terminologies MyISAM is a storage engine used as the default storage engine for MySQL database. MyISAM is based on the ISAM (Indexed Sequential Access Method) concept and offers fast data storage and retrieval. But it is not transaction safe.
2007-05-10, 4748👍, 0💬

How To Get the ID Column Auto-Incremented
How To Get the ID Column Auto-Incremented? - PHP Script Tips - Working with MySQL Database Many tables require an ID column to assign a unique ID number for each row in the table. For example, if you have a table to hold forum member profiles, you need an ID number to identify each member. To allow ...
2007-04-14, 4737👍, 0💬

Can Multiple Columns Be Used in GROUP BY
Can Multiple Columns Be Used in GROUP BY? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want to break your output into smaller groups, if you specify multiple column names or expressions in the GROUP BY clause. Output in each group must satisfy a specific combination of the express...
2007-05-11, 4733👍, 0💬

What Is View
What Is View? - MySQL FAQs - Database Basics and Terminologies A view is a logical table defined by a query statement.
2007-05-10, 4732👍, 0💬

How To Shut Down the Server with "mysqladmin"
How To Shut Down the Server with "mysqladmin"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to shut down the server with "mysqladmin", you can use the command "mysqladmin shutdown" as shown in the following tutorial example: >cd \mysql\bin >mysqladmin -u root shutdown If ...
2007-05-11, 4731👍, 0💬

How To End the Current Transaction
How To End the Current Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback There are several ways the current transaction can be ended implicitly or explicitly: In "Autocommit On" mode, a single-statement transaction will be ended implicitly when the execution of the statement end...
2007-05-11, 4705👍, 0💬

What Happens If the UPDATE Subquery Returns No Rows
What Happens If the UPDATE Subquery Returns No Rows? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you use a subquery to assign new values in the SET clause in an UPDATE statement, and the subquery returns no rows for an outer row, MySQL will provide a NULL value to the SE...
2007-05-11, 4679👍, 0💬

What Is "mysqlcheck"
What Is "mysqlcheck"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqlcheck" is a command-line interface for administrators to check and repair tables. Here are some sample commands supported by "mysqlcheck": "mysqlcheck databaseName tableName" - Checks the specified table in the ...
2007-05-11, 4679👍, 0💬

How To View and Change the Current Transaction Isolation Level
How To View and Change the Current Transaction Isolation Level? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to view or change the current transaction isolation level, you can use the following commands: SELECT @@TX_ISOLATION FROM DUAL; -- Viewing the current transaction iso...
2007-05-11, 4675👍, 0💬

How To Sort the Query Output
How To Sort the Query Output? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want the returning rows to be sorted, you can specify a sorting expression in the ORDER BY clause. The simplest sort expression is column name who's values will be sorted by. The following select statement ...
2007-05-11, 4675👍, 0💬

How To Switch between Autocommit-On and Autocommit-Off Modes
How To Switch between Autocommit-On and Autocommit-Off Modes? - MySQL FAQs - Transaction Management: Commit or Rollback By default, your connection session will be in Autocommit-On mode, where every server executable statement will start a new transaction, and end the transaction when the execution ...
2007-05-11, 4674👍, 0💬

How To Write an Inner Join with the WHERE Clause
How To Write an Inner Join with the WHERE Clause? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you don't want to use the INNER JOIN ... ON clause to write an inner join, you can put the join condition in the WHERE clause as shown in the following query example: mysql> SELECT l.id...
2007-05-11, 4674👍, 0💬

How To Get Some Basic Information Back from MySQL Servers
How To Get Some Basic Information Back from MySQL Servers? - MySQL FAQs - PHP Connections and Query Execution Once you got a MySQL server connection object successfully, you can use mysql_get_server() and mysql_get_host_info() to get some basic information from your MySQL server. The tutorial exerci...
2007-05-10, 4674👍, 0💬

How To Use SELECT Statement to Count the Number of Rows
How To Use SELECT Statement to Count the Number of Rows? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following tutorial exercise shows you some good example: mysql> SELECT COUNT(*) FROM ...
2007-05-11, 4666👍, 0💬

How To Start a New Transaction Explicitly
How To Start a New Transaction Explicitly? - MySQL FAQs - Transaction Management: Commit or Rollback If you are confused on the implicit new transaction rules, you can always start a new transaction with the "START TRANSACTION" command to start a new transaction explicitly. "START TRANSACTION" comma...
2007-05-11, 4663👍, 0💬

How To Experiment Dead Locks
How To Experiment Dead Locks? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to have some experience with dead locks, you can create two windows running two mysql transactions in two sessions at the REPEATABLE READ transaction isolation level. Then run some UPDATE statements a...
2007-05-09, 4658👍, 0💬

How To Start a New Transaction
How To Start a New Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback MySQL server offers two modes to manage transactions: Autocommit On - Default mode. Can be started with "SET AUTOCOMMIT = 1" command. In this mode, every single SQL statement is a new transaction. All changes w...
2007-05-11, 4656👍, 0💬

What Is Table
What Is Table? - MySQL FAQs - Database Basics and Terminologies A table is a data storage structure with rows and columns.
2007-05-10, 4650👍, 0💬

<< < 1 2 3 4 5 6 7 8 9 > >>   Sort: Date