.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

<< < … 122 123 124 125 126 127 128 129 130 131 132 … > >>   Sort: Rank

How To Divide Query Output into Groups
How To Divide Query Output into Groups? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY You can divide query output into multiple groups with the GROUP BY clause. It allows you specify a column as the grouping criteria, so that rows with the same value in that column will be considered as a... 2007-05-11, 8647👍, 0💬

How To Update Values on Multiple Rows
How To Update Values on Multiple Rows? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If the WHERE clause in an UPDATE matches multiple rows, the SET clause will be applied to all matched rows. This rule allows you to update values on multiple rows in a single UPDATE statement... 2007-05-11, 5245👍, 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, 7038👍, 0💬

How To Name Query Output Columns
How To Name Query Output Columns? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries Each column in the query output has a default name. If you don't like the default name, you can specify a new name for any column in the query output by using the AS clause. The following statement shows ... 2007-05-11, 5327👍, 0💬

What Is a SELECT Query Statement
What Is a SELECT Query Statement? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY The SELECT statement is also called the query statement. It is the most frequently used SQL statement in any database application. A SELECT statement allows you to retrieve data from one or more tables or view... 2007-05-11, 4896👍, 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, 7177👍, 0💬

How To Update Values in a Table
How To Update Values in a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you want to update some values in one row or multiple rows in a table, you can use the UPDATE statement. The tutorial script below shows a good example: mysql> UPDATE fyi_links SET counts = 999,... 2007-05-11, 5229👍, 0💬

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

What Is a Subquery
What Is a Subquery? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries A subquery is a SELECT statement used as part of the selection criteria of the main SELECT statement. The subquery specified in the WHERE clause will be evaluated repeated on each row of the selection base table. The o... 2007-05-11, 5484👍, 0💬

What Is a TR Tag/Element
What Is a TR Tag/Element? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells A "tr" element is a special element that can only be used as a sub-element of a "table" element. A "tr" element defines a row in a table. Here are basic rules about "tr" elements: "tr" elements are special element... 2007-05-11, 5086👍, 0💬

What Is a TABLE Tag/Element
What Is a TABLE Tag/Element? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells A "table" element is a block level element that you can use to present information in table of rows and columns. Here are basic rules about "table" elements: "table" elements are block elements. "table" element... 2007-05-11, 5226👍, 0💬

What Are Group Functions
What Are Group Functions? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY Group functions are functions applied to a group of rows. Examples of group functions are: COUNT(*) - Returns the number of rows in the group. MIN(exp) - Returns the minimum value of the expression evaluated on each r... 2007-05-11, 5132👍, 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, 5592👍, 0💬

How To Return Top 5 Rows
How To Return Top 5 Rows? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you want the query to return only the first 5 rows, you can use the LIMIT clause, which takes one parameter as the maximum number of rows to return. The following statement returns the first 5 rows from the fy... 2007-05-11, 7921👍, 0💬

How To Specify Default Values in INSERT Statement
How To Specify Default Values in INSERT Statement? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If a column is defined with a default value in a table, you can use the key word DEFAULT in the INSERT statement to take the default value for that column. The following tutorial ... 2007-05-11, 5217👍, 0💬

How To Insert a New Row into a Table
How To Insert a New Row into a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements To insert a new row into a table, you should use the INSERT INTO statement with values specified for all columns as shown in the following example: mysql> INSERT INTO fyi_links VALUES (101, 'd... 2007-05-11, 5164👍, 0💬

What Is a TD Tag/Element
What Is a TD Tag/Element? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells A "td" element is a special element that can only be used as a sub-element of a "tr" element. A "td" element defines a column in a row. Here are basic rules about "td" elements: "td" elements are special elements ... 2007-05-11, 8167👍, 0💬

What Are the Attributes of a TABLE Element
What Are the Attributes of a TABLE Element? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells A "table" element may have the following commonly used attributes: "summary" - Specifies a text string as the summary of the table. "width" - Specifies the width of the table. "border" - Specifie... 2007-05-11, 4860👍, 0💬

How To Convert Character Strings to Numeric Values
How To Convert Character Strings to Numeric Values? - MySQL FAQs - Introduction to SQL Basics You can convert character strings to numeric values by using the CAST(string AS DECIMAL) or CAST(string AS SIGNED INTEGER) function as shown in the following examples: SELECT CAST('4123.45700' AS DECIMAL) F... 2007-05-11, 5175👍, 0💬

How To Convert Numeric Values to Character Strings
How To Convert Numeric Values to Character Strings? - MySQL FAQs - Introduction to SQL Basics You can convert numeric values to character strings by using the CAST(value AS CHAR) function as shown in the following examples: SELECT CAST(4123.45700 AS CHAR) FROM DUAL; 4123.45700 -- How to get rid of t... 2007-05-11, 5732👍, 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, 5757👍, 0💬

What Happens If You No CREATE Privilege in a Database
What Happens If You No CREATE Privilege in a Database? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements In order to create tables in a database, your user account must have the CREATE privilege for that database. Otherwise you will get an error as shown in the following tutorial ex... 2007-05-11, 5161👍, 0💬

How To Get a List of Indexes of an Existing Table
How To Get a List of Indexes of an Existing Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you want to see the index you have just created for an existing table, you can use the "SHOW INDEX FROM tableName" command to get a list of all indexes in a given table. The tutor... 2007-05-11, 5087👍, 0💬

How To Include Character Strings in SQL statements
How To Include Character Strings in SQL statements? - MySQL FAQs - Introduction to SQL Basics If you want to include character strings in your SQL statements, you need to quote them in one of the following formats: Using single quotes. For example 'FYIcenter.com'. Using double quotes. For example "F... 2007-05-11, 5499👍, 0💬

<< < … 122 123 124 125 126 127 128 129 130 131 132 … > >>   Sort: Rank

.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