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

How To Delete All Rows a Table
How To Delete All Rows a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you want to delete all rows from a table, you have two options: Use the DELETE statement with no WHERE clause. Use the TRUNCATE TABLE statement. The TRUNCATE statement is more efficient the DELET...
2007-05-11, 6004👍, 0💬

How To Return the Second 5 Rows
How To Return the Second 5 Rows? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you want to display query output in multiple pages with 5 rows per page, and the visitor wants to see the output for the second page, you need to display query output from row 6 to row 10. You can use t...
2007-05-11, 5972👍, 0💬

How To Test Transaction Isolation Levels
How To Test Transaction Isolation Levels? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to test transaction isolation levels, you need to make sure that: The tables are created with transaction-safe storage engines, like InnoDB. Multiple-statement transactions are started wit...
2007-05-09, 5886👍, 0💬

How To Select Some Rows from a Table
How To Select Some Rows from a Table? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you don't want select all rows from a table, you can specify a WHERE clause to tell the query to return only the rows that meets the condition defined in the WHERE clause. The WHERE clause condition is ...
2007-05-11, 5885👍, 0💬

How To Select All Columns of All Rows from a Table
How To Select All Columns of All Rows from a Table? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY The simplest query statement is the one that selects all columns of all rows from a single table: "SELECT * FROM tableName;". The (*) in the SELECT clause tells the query to return all column...
2007-05-11, 5766👍, 0💬

How To Insert Multiple Rows with a SELECT Statement
How To Insert Multiple Rows with a SELECT Statement? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If want to insert rows into a table based on data rows from other tables, you can use a sub-query inside the INSERT statement as shown in the following script example: &lt;?ph...
2007-05-10, 5709👍, 0💬

How To Apply Filtering Criteria at Group Level
How To Apply Filtering Criteria at Group Level? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want to return only specific groups from the query, you can apply filtering criteria at the group level by using the HAVING clause inside the GROUP BY clause. Note group functions can also...
2007-05-11, 5697👍, 0💬

Can one execute dynamic SQL from Forms?
Can one execute dynamic SQL from Forms? Yes, use the FORMS_DDL built-in or call the DBMS_SQL database package from Forms. Eg: FORMS_DDL('INSERT INTO X VALUES (' || col_list || ')'); Just note that FORMS_DDL will force an implicit COMMIT and may de-synchronize the Oracle Forms COMMIT mechanism.
2011-04-12, 5422👍, 0💬

What Happens to Your Transactions When ERROR 1205 Occurred
What Happens to Your Transactions When ERROR 1205 Occurred? - MySQL FAQs - Transaction Management: Commit or Rollback If your transaction receives the "Lock wait timeout exceeded" - ERROR 1205, MySQL server automatically terminates your transaction and rolls back your data changes of the entire tran...
2007-05-11, 5351👍, 0💬

What Happens to the Current Transaction If a DDL Statement Is Executed
What Happens to the Current Transaction If a DDL Statement Is Executed? - MySQL FAQs - Transaction Management: Commit or Rollback If a DDL statement is executed, the current transaction will be committed and ended. All the database changes made in the current transaction will become permanent. This ...
2007-05-11, 5245👍, 0💬

What Is BDB (BerkeleyDB)
What Is BDB (BerkeleyDB)? - MySQL FAQs - Database Basics and Terminologies BDB (BerkeleyDB) is transaction safe storage engine originally developed at U.C. Berkeley. It is now developed by Sleepycat Software, Inc. (an Oracle company now).
2007-05-10, 5245👍, 0💬

How To Query Multiple Tables Jointly
How To Query Multiple Tables Jointly? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join. Assuming that you have 3 tables in a forum system: "use...
2007-05-11, 5227👍, 0💬

What Is Foreign Key
What Is Foreign Key? - MySQL FAQs - Database Basics and Terminologies A foreign key is a single column or multiple columns defined to have values that can be mapped to a primary key in another table.
2007-05-10, 5212👍, 0💬

How To Convert Character Strings to Dates
How To Convert Character Strings to Dates? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a character string that represents a date, and you want to convert it into a date value, you can use the STR_TO_DATE(string, format) function. STR_TO_DATE() shares the same formatting cod...
2007-05-11, 5199👍, 0💬

What Is Transaction
What Is Transaction? - MySQL FAQs - Database Basics and Terminologies A transaction is a logical unit of work requested by a user to be applied to the database objects. MySQL server introduces the transaction concept to allow users to group one or more SQL statements into a single transaction, so th...
2007-05-10, 5193👍, 0💬

How To Use Subqueries with the EXISTS Operator
How To Use Subqueries with the EXISTS Operator? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries A subquery can be used with the EXISTS operator as "EXISTS (subquery)", which returns true if the subquery returns one or more rows. The following statement is a good example of "EXISTS (sub...
2007-05-11, 5185👍, 0💬

What Is Rollback
What Is Rollback? - MySQL FAQs - Database Basics and Terminologies Rollback is a way to terminate a transaction with all database changes not saving to the database server.
2007-05-10, 5180👍, 0💬

SQL Joins
What is the difference between Inner Join and Outer Join? 1. You use INNER JOIN to return all rows from both tables where there is a match. ie. in the resulting table all the rows and colums will have values. In OUTER JOIN the relulting table may have empty colums. Outer join may be either LEFT or R...
2008-09-25, 5170👍, 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, 5127👍, 0💬

How To Break Output into Pages
How To Break Output into Pages? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you have a query that returns hundreds of rows, and you don't want to present all of them to your users on a single page. You can break output into multiple pages, and only present 10 rows per page...
2007-05-10, 5100👍, 0💬

How To Get the ID Column Auto-Incremented
How To Get the ID Column Auto-Incremented? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts 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 ea...
2007-05-11, 5028👍, 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, 5017👍, 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, 5016👍, 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, 5006👍, 0💬

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