.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

<< < … 2 3 4 5 6 7 8 9 10 11 12 … > >>   Sort: Date

How To Perform Key Word Search in Tables
How To Perform Key Word Search in Tables? - PHP Script Tips - Working with MySQL Database 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 specified as '%keyw... 2007-04-19, 5274👍, 0💬

How To Grant User Privileges at the Database Level
How To Grant User Privileges at the Database Level? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to grant a user privilege at the database level, you can use the "GRANT privilegeName ON databaseName.* TO userName" command. The argument "databasename.*" in the command stand... 2007-05-10, 5265👍, 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, 5263👍, 0💬

How To Write a Query with a Full Outer Join
How To Write a Query with a Full Outer Join? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries There is no way to do full outer join in MySQL. It does not support this feature at the current MySQL release. 2007-05-11, 5261👍, 0💬

How To Create a New View
How To Create a New View? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements You can create a new view based on one or more existing tables by using the "CREATE VIEW viewName AS selectStatement" statement as shown in the following script: mysql> CREATE TABLE comment (faqID INTEGER, m... 2007-05-11, 5261👍, 0💬

What Is a Data Lock
What Is a Data Lock? - MySQL FAQs - Transaction Management: Commit or Rollback MySQL uses two types of data locks at two levels to provide you the transaction isolation level you need: Share Lock at Row Level (S) - A data row is locked by a transaction for reading. Exclusive Lock at Row Level (X) - ... 2007-05-09, 5261👍, 0💬

How To Run MySQL Server on a Different Port
How To Run MySQL Server on a Different Port? - MySQL FAQs - Server Daemon mysqld Administration By default, MySQL will listen at port number 3306 for any client connections. But you can change this by starting the server with "--port=portNumber" option. The tutorial exercise shows you how to start t... 2007-05-11, 5258👍, 0💬

How To Use Existing Values in UPDATE Statements
How To Use Existing Values in UPDATE Statements? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If a row matches the WHERE clause in a UPDATE statement, existing values in this row can be used in expressions to provide new values in the SET clause. Existing values are represen... 2007-05-11, 5253👍, 0💬

What Are Date and Time Intervals
What Are Date and Time Intervals? - MySQL FAQs - Introduction to SQL Date and Time Handling A date and time interval is special value to be used to increment or decrement a date or a time at a given date or time unit. A data and time interval should be expression in the format of "INTERVAL expressio... 2007-05-11, 5250👍, 0💬

What Are the Predefined User Accounts
What Are the Predefined User Accounts? - MySQL FAQs - Managing User Accounts and Access Privileges There is only one predefined user account called "root": "root" was created during the installation process. "root" has no password initially. You need to assign a new password as soon as you finishes ... 2007-05-10, 5250👍, 0💬

Can Group Functions Be Used in the ORDER BY Clause
Can Group Functions Be Used in the ORDER BY Clause? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If the query output is aggregated as groups, you can sort the groups by using group functions in the ORDER BY clause. The following statement returns how many links were created in each year ... 2007-05-11, 5248👍, 0💬

What Are Date and Time Functions
What Are Date and Time Functions? - MySQL FAQs - Introduction to SQL Date and Time Handling MySQL offers a number of functions for date and time values: ADDDATE(date, INTERVAL expr unit) - Adding days to a date. Same as DATE_ADD(). ADDTIME(time1, time2) - Adding two time values together. CURDATE() -... 2007-05-11, 5234👍, 0💬

What Are the Differences between CHAR and VARCHAR
What Are the Differences between CHAR and VARCHAR? - MySQL FAQs - Introduction to SQL Basics CHAR and VARCHAR are both ASCII character data types by default. But they have the following major differences: CHAR stores values in fixed lengths. Values are padded with space characters to match the speci... 2007-05-11, 5233👍, 0💬

What Is "mysqldump"
What Is "mysqldump"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqldump" - A command-line interface for administrators or end users to export data from the server to files. Here are some sample commands supported by "mysqldump": "mysqldump databaseName tableName" - Dumps the spe... 2007-05-11, 5233👍, 0💬

How To Write a Query with a Right Outer Join
How To Write a Query with a Right Outer Join? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you want to query from two tables with a right outer join, you can use the RIGHT OUTER JOIN ... ON clause in the FROM clause. The following query returns output with a right outer join from... 2007-05-11, 5226👍, 0💬

How To Check Server Status with "mysqladmin"
How To Check Server Status with "mysqladmin"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to check the server status by with "mysqladmin", you can following this tutorial example: >cd \mysql\bin >mysqladmin -u root status Uptime: 223 Threads: 1 Questions: 1 Slow queries:... 2007-05-11, 5226👍, 0💬

How To Use Regular Expression in Pattern Match Conditions
How To Use Regular Expression in Pattern Match Conditions? - MySQL FAQs - Introduction to SQL Basics If you have a pattern that is too complex for LIKE to handle, you can use the regular expression pattern condition: REGEXP. The following tutorial exercise provides you some good examples: SELECT 'FY... 2007-05-11, 5222👍, 0💬

What Tools Available for Managing MySQL Server
What Tools Available for Managing MySQL Server? - MySQL FAQs - Administrator Tools for Managing MySQL Server MySQL comes with the following programs as administration tools for you to manage your MySQL server: mysqld - MySQL server daemon. You can use "mysqld" to start your MySQL server. mysqladmin ... 2007-05-11, 5220👍, 0💬

How To Query Multiple Tables Jointly
How To Query Multiple Tables Jointly? - PHP Script Tips - Working with MySQL Database 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: "users" for user profile... 2007-04-19, 5215👍, 0💬

Can the Query Output Be Sorted by Multiple Columns
Can the Query Output Be Sorted by Multiple Columns? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns employees' salaries sorted by department and salary value: mysql> SELECT ... 2007-05-11, 5211👍, 0💬

What Is mSQL
What Is mSQL? - MySQL FAQs - Database Basics and Terminologies Mini SQL (mSQL) is a light weight relational database management system capable of providing rapid access to your data with very little overhead. mSQL is developed by Hughes Technologies Pty Ltd. MySQL was started from mSQL and shared th... 2007-05-10, 5209👍, 0💬

How To Add More Data to the Testing Table
How To Add More Data to the Testing Table? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want to continue with other tutorial exercises in this FAQ collection, you need to add more data to the testing table. Follow the script below to add a new column and : mysql> ALTER TABLE fyi_l... 2007-05-11, 5208👍, 0💬

Is the Order of Columns in the SET Clause Important
Is the Order of Columns in the SET Clause Important? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements Yes. The order of columns in the SET clause of the UPDATE statement is important. There is a BIG DIFFERENCE between MySQL and Oracle on update columns with previous values: Orac... 2007-05-11, 5207👍, 0💬

How To Define and Use Table Alias Names
How To Define and Use Table Alias Names? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names as shown in the following select statement: mysql> SELECT l.id, l.url, r.... 2007-05-11, 5200👍, 0💬

<< < … 2 3 4 5 6 7 8 9 10 11 12 … > >>   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