.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

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

How To Query Tables and Loop through the Returning Rows
How To Query Tables and Loop through the Returning Rows? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts The best way to query tables and loop through the returning rows is to run the SELECT statement with the mysql_query() function, catch the returning object as a result set, an... 2007-05-11, 6306👍, 0💬

What Is InnoDB
What Is InnoDB? - MySQL FAQs - Database Basics and Terminologies InnoDB is a transaction safe storage engine developed by Innobase Oy (an Oracle company now). 2007-05-10, 6303👍, 0💬

What Is Primary Key
What Is Primary Key? - MySQL FAQs - Database Basics and Terminologies A primary key is a single column or multiple columns defined to have unique values that can be used as row identifications. 2007-05-10, 6302👍, 0💬

How To Perform Key Word Search in Tables
How To Perform Key Word Search in Tables? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts The simplest way to perform key word search is to use the SELECT statement with a LIKE operator in the WHERE clause. The LIKE operator allows you to match a text field with a keyword pattern... 2007-05-11, 6290👍, 0💬

How To Include Numeric Values in SQL statements
How To Include Numeric Values in SQL statements? - MySQL FAQs - Introduction to SQL Basics If you want to include a numeric value in your SQL statement, you can enter it directly as shown in the following examples: SELECT 255 FROM DUAL; -- An integer 255 SELECT -6.34 FROM DUAL; -- A regular number -... 2007-05-11, 6224👍, 0💬

What Is Commit
What Is Commit? - MySQL FAQs - Database Basics and Terminologies Commit is a way to terminate a transaction with all database changes to be saved permanently to the database server. 2007-05-10, 6211👍, 0💬

How To Add a New User Account
How To Add a New User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to add a new user account, you can connect to the server as "root" and use the "CREATE USER ..." command. The command syntax for create a new user account with a specified user name and password is... 2007-05-10, 6185👍, 0💬

How To Get a List of Databases from MySQL Servers
How To Get a List of Databases from MySQL Servers? - MySQL FAQs - PHP Connections and Query Execution Once you got a MySQL server connection object successfully, you need to know what databases are available on the server and which database you should use to manage your tables and data. To get a lis... 2007-05-10, 6178👍, 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, 6157👍, 0💬

How To Omit Columns with Default Values in INSERT Statement
How To Omit Columns with Default Values in INSERT Statement? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you c... 2007-05-11, 6153👍, 0💬

How Long a Transaction Will Wait for a Data Lock
How Long a Transaction Will Wait for a Data Lock? - MySQL FAQs - Transaction Management: Commit or Rollback If you issue a UPDATE or DELETE statement on a row that has an exclusive lock owned by another session, your statement will be blocked to wait for the other session to release the lock. But th... 2007-05-11, 6147👍, 0💬

How Does MySQL Handle Read Consistency
How Does MySQL Handle Read Consistency? - MySQL FAQs - Transaction Management: Commit or Rollback Read consistency is a concept that describes how consistent the output will be on two subsequent read operations. A read operation is usually a stand alone SELECT statement or a SELECT subquery in a par... 2007-05-11, 6142👍, 0💬

What Are the "mysql" Command Line Arguments
What Are the "mysql" Command Line Arguments? - MySQL FAQs - Command-Line End User Interface mysql "mysql" supports only one optional command line argument, "database". But "mysql" allows the operating system to redirect input and output streams at the command line level. Here are some good examples:... 2007-05-10, 6142👍, 0💬

How To Create a Table for Transaction Testing
How To Create a Table for Transaction Testing? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to learn transaction management, you should create a table with the InnoDB storage engine. The default storage engine MyISAM does not support the transaction concept. The tutorial exe... 2007-05-11, 6130👍, 0💬

How To Count Groups Returned with the GROUP BY Clause
How To Count Groups Returned with the GROUP BY Clause? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you use the COUNT(*) function on groups returned with the GROUP BY clause, it will count the number of rows within each group, not the number of groups. If you want to count the nu... 2007-05-11, 6098👍, 0💬

How To Quote Text Values in SQL Statements
How To Quote Text Values in SQL Statements? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes (''). In... 2007-05-11, 6083👍, 0💬

How To Convert Dates to Character Strings
How To Convert Dates to Character Strings? - MySQL FAQs - Introduction to SQL Date and Time Handling You can convert dates to character strings using the DATE_FORMAT(date, format) function. MySQL supports the following basic formatting codes: %a Abbreviated weekday name (Sun..Sat) %b Abbreviated mon... 2007-05-11, 6074👍, 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, 6073👍, 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, 6067👍, 0💬

What Is a Dead Lock
What Is a Dead Lock? - MySQL FAQs - Transaction Management: Commit or Rollback A dead lock is phenomenon happens between two transactions with each of them holding a lock that blocks the other transaction as shown in the following diagram: (transaction 1) (transaction 2) update row X to create lock ... 2007-05-09, 6067👍, 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, 6020👍, 0💬

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

How To Sort Output in Descending Order
How To Sort Output in Descending Order? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want to sort a column in descending order, you can specify the DESC keyword in the ORDER BY clause. The following SELECT statement first sorts the "tag" in descending order, then sorts the "counts... 2007-05-11, 5966👍, 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, 5960👍, 0💬

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

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML