.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 Access MySQL Servers through Firewalls
How To Access MySQL Servers through Firewalls? - MySQL FAQs - PHP Connections and Query Execution If your MySQL server is provided by an Internet service company, connecting to the server from your local machine will not be so easy, because there are firewalls between your local machine and your MyS... 2007-05-10, 5458👍, 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, 5451👍, 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, 5450👍, 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, 5449👍, 0💬

How To Turn on Error Logs
How To Turn on Error Logs? - MySQL FAQs - Server Daemon mysqld Administration If you want MySQL to write critical errors into a log file, you can use the "--log-error=fileName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option: >cd \m... 2007-05-11, 5448👍, 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, 5443👍, 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, 5436👍, 0💬

How To Properly Shutdown MySQL Server Daemon mysqld
How To Properly Shutdown MySQL Server Daemon mysqld? - MySQL FAQs - Server Daemon mysqld Administration The proper way to shutdown your MySQL server is to the use "mysqladmin shutdown" command. Other ways to shutdown your server include: Enter "mysqladmin -u root -ppassowrd shutdown" command with op... 2007-05-11, 5434👍, 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, 5429👍, 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, 5413👍, 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, 5412👍, 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, 5407👍, 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, 5406👍, 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, 5404👍, 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, 5403👍, 0💬

What Are the Differences between BINARY and VARBINARY
What Are the Differences between BINARY and VARBINARY? - MySQL FAQs - Introduction to SQL Basics Both BINARY and VARBINARY are both binary byte data types. But they have the following major differences: BINARY stores values in fixed lengths. Values are padded with 0x00. VARBINARY stores values in va... 2007-05-11, 5401👍, 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, 5398👍, 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, 5396👍, 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, 5394👍, 0💬

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

What Happens to the Current Transaction If the Session Is Ended
What Happens to the Current Transaction If the Session Is Ended? - MySQL FAQs - Transaction Management: Commit or Rollback If a session is ended, the current transaction in that session will be rolled back and ended. All the database changes made in the current transaction will be removed. This is c... 2007-05-11, 5385👍, 0💬

How To Drop an Existing Index
How To Drop an Existing Index? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you don't need an existing index any more, you should delete it with the "DROP INDEX indexName ON tableName" statement. Here is an example SQL script: mysql> DROP INDEX tip_subject ON tip; Query OK, ... 2007-05-11, 5369👍, 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, 5368👍, 0💬

What Are Date and Time Data Types
What Are Date and Time Data Types? - MySQL FAQs - Introduction to SQL Date and Time Handling MySQL supports the following date and time data types: DATE - A date in the range of '1000-01-01' and '9999-12-31'. Default DATE format is "YYYY-MM-DD". DATETIME - A date with the time of day in the range of... 2007-05-11, 5364👍, 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