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

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, 5092👍, 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, 5077👍, 0💬

How To Write a Query with an Inner Join
How To Write a Query with an Inner Join? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you want to query from two tables with an inner join, you can use the INNER JOIN ... ON clause in the FROM clause. The tutorial exercise below creates another testing table and returns output wi...
2007-05-11, 5064👍, 0💬

What Happens to the Current Transaction If a START TRANSACTION Is Executed
What Happens to the Current Transaction If a START TRANSACTION Is Executed? - MySQL FAQs - Transaction Management: Commit or Rollback If you are in a middle of a current transaction, and a START TRANSACTION command is executed, the current transaction will be committed and ended. All the database ch...
2007-05-11, 5045👍, 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, 5039👍, 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, 5035👍, 0💬

How To Calculate the Difference between Two Dates
How To Calculate the Difference between Two Dates? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have two dates, and you want to know how many days between them, you can use the DATEDIFF(date1, date2) function as shown below: SELECT DATEDIFF(DATE('1997-02-28'), DATE('1997-03-01'))...
2007-05-11, 5026👍, 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, 5024👍, 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, 5013👍, 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, 5005👍, 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, 5004👍, 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, 5003👍, 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, 4995👍, 0💬

What Is Join
What Is Join? - MySQL FAQs - Database Basics and Terminologies Join is data retrieval operation that combines rows from multiple tables under certain matching conditions to form a single row.
2007-05-10, 4987👍, 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, 4985👍, 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, 4985👍, 0💬

How To Experiment Data Locks
How To Experiment Data Locks? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to have some experience with data locks, you can create two windows running two mysql transactions in two sessions. In session 1, you can run a UPDATE statement with REPEATABLE READ transaction isolat...
2007-05-11, 4982👍, 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, 4982👍, 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, 4979👍, 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, 4977👍, 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, 4973👍, 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, 4961👍, 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, 4961👍, 0💬

What Is Union
What Is Union? - MySQL FAQs - Database Basics and Terminologies Join is data retrieval operation that combines multiple query outputs of the same structure into a single output.
2007-05-10, 4955👍, 0💬

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