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

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

How To Quote Date and Time Values in SQL Statements
How To Quote Date and Time Values in SQL Statements? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to provide date and time values in a SQL statement, you should write them in the format of "yyyy-mm-dd hh:mm:ss", and quoted with single quotes ('). The tutorial exerc...
2007-05-11, 5334👍, 0💬

What Is Commit
What Is Commit? - MySQL FAQs - Database Basics and Terminologies Commit is a way to terminate a transaction with all database changes to be saved permanently to the database server.
2007-05-10, 5333👍, 0💬

How Does MySQL Handle Read Consistency
How Does MySQL Handle Read Consistency? - MySQL FAQs - Transaction Management: Commit or Rollback Read consistency is a concept that describes how consistent the output will be on two subsequent read operations. A read operation is usually a stand alone SELECT statement or a SELECT subquery in a par...
2007-05-11, 5302👍, 0💬

How To Include Numeric Values in SQL statements
How To Include Numeric Values in SQL statements? - MySQL FAQs - Introduction to SQL Basics If you want to include a numeric value in your SQL statement, you can enter it directly as shown in the following examples: SELECT 255 FROM DUAL; -- An integer 255 SELECT -6.34 FROM DUAL; -- A regular number -...
2007-05-11, 5290👍, 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, 5279👍, 0💬

How Long a Transaction Will Wait for a Data Lock
How Long a Transaction Will Wait for a Data Lock? - MySQL FAQs - Transaction Management: Commit or Rollback If you issue a UPDATE or DELETE statement on a row that has an exclusive lock owned by another session, your statement will be blocked to wait for the other session to release the lock. But th...
2007-05-11, 5269👍, 0💬

Can Group Functions Be Mixed with Non-group Selection Fields
Can Group Functions Be Mixed with Non-group Selection Fields? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If a group function is used in the SELECT clause, all other selection fields must be group level fields. Non-group fields can not be mixed with group fields in the SELECT clause. Th...
2007-05-11, 5250👍, 0💬

How To Convert Dates to Character Strings
How To Convert Dates to Character Strings? - MySQL FAQs - Introduction to SQL Date and Time Handling You can convert dates to character strings using the DATE_FORMAT(date, format) function. MySQL supports the following basic formatting codes: %a Abbreviated weekday name (Sun..Sat) %b Abbreviated mon...
2007-05-11, 5250👍, 0💬

How To Query Tables and Loop through the Returning Rows
How To Query Tables and Loop through the Returning Rows? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts The best way to query tables and loop through the returning rows is to run the SELECT statement with the mysql_query() function, catch the returning object as a result set, an...
2007-05-11, 5246👍, 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, 5244👍, 0💬

What Is a Dead Lock
What Is a Dead Lock? - MySQL FAQs - Transaction Management: Commit or Rollback A dead lock is phenomenon happens between two transactions with each of them holding a lock that blocks the other transaction as shown in the following diagram: (transaction 1) (transaction 2) update row X to create lock ...
2007-05-09, 5233👍, 0💬

What Is ISAM
What Is ISAM? - MySQL FAQs - Database Basics and Terminologies ISAM (Indexed Sequential Access Method) was developed by IBM to store and retrieve data on secondary storage systems like tapes.
2007-05-10, 5225👍, 0💬

How To Quote Text Values in SQL Statements
How To Quote Text Values in SQL Statements? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes (''). In...
2007-05-11, 5221👍, 0💬

What Is CSV
What Is CSV? - MySQL FAQs - Database Basics and Terminologies CSV (Comma Separated Values) is a file format used to store database table contents, where one table row is stored as one line in the file, and each data field is separated with comma.
2007-05-10, 5192👍, 0💬

How To Create a Table for Transaction Testing
How To Create a Table for Transaction Testing? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to learn transaction management, you should create a table with the InnoDB storage engine. The default storage engine MyISAM does not support the transaction concept. The tutorial exe...
2007-05-11, 5176👍, 0💬

How To Get the Last ID Assigned by MySQL
How To Get the Last ID Assigned by MySQL? - PHP Script Tips - Working with MySQL Database If you use an ID column with AUTO_INCREMENT attribute, you can use the mysql_insert_id() function to get the last ID value assigned by the MySQL server, as shown in the sample script below: &lt;?php include...
2007-04-18, 5163👍, 0💬

How To Add a New User Account
How To Add a New User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to add a new user account, you can connect to the server as "root" and use the "CREATE USER ..." command. The command syntax for create a new user account with a specified user name and password is...
2007-05-10, 5149👍, 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, 5143👍, 0💬

How To Revoke User Privileges
How To Revoke User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges If your want remove some granted user privileges, you can use the "REVOKE privilegeName ..." command. You can only revoke privileges in the same way as they were granted. For example, you can not revoke a priv...
2007-05-08, 5143👍, 0💬

How Much Memory Does the Server Take
How Much Memory Does the Server Take? - MySQL FAQs - Server Daemon mysqld Administration If you are interested to know how much memory your MySQL server is taking, you can use Windows Task Manager to find out. Try to following this tutorial exercise: Start your MySQL server. Press Ctrl-Alt-Del and c...
2007-05-11, 5140👍, 0💬

Where Are User Privileges Stored on the Server
Where Are User Privileges Stored on the Server? - MySQL FAQs - Managing User Accounts and Access Privileges MySQL server has a system database, which hosts a number of system tables to system related information like user privileges. Depending on the scope levels, granted user privileges are stored ...
2007-05-08, 5134👍, 0💬

How To Omit Columns with Default Values in INSERT Statement
How To Omit Columns with Default Values in INSERT Statement? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you c...
2007-05-11, 5126👍, 0💬

How To Rollback the Current Transaction
How To Rollback the Current Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback If you have used some DML statements updated some data objects, you find a problem with those updates, and you don't want those updates to be permanently recorded in the database, you can use the ROLLB...
2007-05-11, 5112👍, 0💬

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