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

How To Write Date and Time Literals
How To Write Date and Time Literals? - MySQL FAQs - Introduction to SQL Date and Time Handling MySQL offers a number of formats for you to use to enter date and time literals: ANSI standard format: "YYYY-MM-DD HH:MM:SS". Non-standard limiters. Like: "YYYY/MM/DD HH^MM^SS" or "YYYY.MM.DD HH-MM-SS". No...
2007-05-11, 4842👍, 0💬

How To Fix the INSERT Command Denied Error
How To Fix the INSERT Command Denied Error? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts The reason for getting the "1142: INSERT command denied" error is that your user accound does not have the INSERT privilege on the table or database. To resolve this error, you need to ask...
2007-05-10, 4841👍, 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, 4839👍, 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, 4838👍, 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, 4836👍, 0💬

How To Connect to a MySQL Sever with Default Port Number
How To Connect to a MySQL Sever with Default Port Number? - MySQL FAQs - PHP Connections and Query Execution If you want to connect a MySQL server with default port number, you can use the "mysql_connect($server)" function, where $server is the host name or IP address where the MySQL server is runni...
2007-05-10, 4831👍, 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, 4827👍, 0💬

What Is MySQL
What Is MySQL? - MySQL FAQs - Downloading and Installing MySQL on Windows MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. MySQL has the following main features: Works on many different platforms. APIs for C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, ...
2007-05-10, 4821👍, 0💬

How To Connect to MySQL Severs with User Accounts
How To Connect to MySQL Severs with User Accounts? - MySQL FAQs - PHP Connections and Query Execution If you want to connect a MySQL server with user account name and password, you need to call mysql_connect() with more parameters like this: $con = mysql_connect($server, $username, $password); If yo...
2007-05-10, 4820👍, 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, 4814👍, 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, 4809👍, 0💬

What Are Numeric Data Types
What Are Numeric Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL supports the following numeric data types: BIT(n) - An integer with n bits. BOOL same as BOOLEAN - Boolean values stored in 1 bit. TINYINT - A small integer stored in 1 byte. SMALLINT - A small integer stored in 2 bytes. ME...
2007-05-11, 4808👍, 0💬

What Happens If You Do Not Have Privileges to Create Database
What Happens If You Do Not Have Privileges to Create Database? - MySQL FAQs - PHP Connections and Query Execution If your MySQL server is provided by your Internet service company, your user account will most likely have no privilege to create new databases on the server. In that case, your CREATE D...
2007-05-10, 4806👍, 0💬

What Happens If NULL Values Are Involved in Expressions
What Happens If NULL Values Are Involved in Expressions? - MySQL FAQs - Introduction to SQL Basics If NULL values are used in expressions, the resulting values will be NULL values. In other words: Arithmetic expressions with NULL values result NULL values. Comparison expressions with NULL values res...
2007-05-11, 4794👍, 0💬

How To Turn on Query Logs
How To Turn on Query Logs? - MySQL FAQs - Server Daemon mysqld Administration If you want MySQL to write query logs to a file, you can use the "--log=fileName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option and view the query log f...
2007-05-11, 4794👍, 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, 4788👍, 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, 4786👍, 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, 4785👍, 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, 4782👍, 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, 4769👍, 0💬

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, 4769👍, 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, 4768👍, 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, 4767👍, 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, 4766👍, 0💬

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