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

What Is Join
What Is Join? - MySQL FAQs - Database Basics and Terminologies Join is data retrieval operation that combines rows from multiple tables under certain matching conditions to form a single row.
2007-05-10, 4649👍, 0💬

What Happens If Unique Value Constraints Are Violated
What Happens If Unique Value Constraints Are Violated? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you are inserting a new record that has values violating a unique constraint, you will get an error. Note that primary key column has a unique value constraint by default. ...
2007-05-11, 4646👍, 0💬

How To Calculate the Difference between Two Time Values
How To Calculate the Difference between Two Time Values? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have two time values, and you want to know the time difference between them, you can use the TIMEDIFF(time1, time2) function as shown below: SELECT TIMEDIFF(TIME('19:26:50'), TIM...
2007-05-11, 4646👍, 0💬

How To Turn on Binary Logs
How To Turn on Binary Logs? - MySQL FAQs - Server Daemon mysqld Administration If you want MySQL to write binary logs to a file, you can use the "--log-bin=fileBaseName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option: >cd \mysql\bi...
2007-05-11, 4643👍, 0💬

What Is Union
What Is Union? - MySQL FAQs - Database Basics and Terminologies Join is data retrieval operation that combines multiple query outputs of the same structure into a single output.
2007-05-10, 4643👍, 0💬

How To Find Out the Current Transaction Mode
How To Find Out the Current Transaction Mode? - MySQL FAQs - Transaction Management: Commit or Rollback If you are not sure about your current transaction mode, you can use the "SELECT @@AUTOCOMMIT FROM DUAL" statement to find out as shown in the following tutorial exercise: >\mysql\bin\mysql -u dev...
2007-05-11, 4642👍, 0💬

What Happens to the Current Transaction If the Session Is Killed
What Happens to the Current Transaction If the Session Is Killed? - MySQL FAQs - Transaction Management: Commit or Rollback If a session is killed by the DBA, the current transaction in that session will be rolled back and ended. All the database changes made in the current transaction will be remov...
2007-05-11, 4637👍, 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, 4629👍, 0💬

What Is Row
What Is Row? - MySQL FAQs - Database Basics and Terminologies A row is a unit of data with related data items stored as one item in one column in a table.
2007-05-10, 4629👍, 0💬

What Are Transaction Isolation Levels
What Are Transaction Isolation Levels? - MySQL FAQs - Transaction Management: Commit or Rollback There are 4 transaction isolation levels defined by SQL-1992 standard: READ UNCOMMITTED - The SELECT statements in one transaction will read uncommitted data changes from transactions of all connected se...
2007-05-09, 4624👍, 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, 4621👍, 0💬

What Happens If the UPDATE Subquery Returns Multiple Rows
What Happens If the UPDATE Subquery Returns Multiple Rows? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If a subquery is used in a UPDATE statement, it must return exactly one row for each row in the update table that matches the WHERE clause. If it returns multiple rows, My...
2007-05-11, 4620👍, 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, 4618👍, 0💬

What Are the Impacts on Applications from Locks, Timeouts, and DeadLocks
What Are the Impacts on Applications from Locks, Timeouts, and DeadLocks? - MySQL FAQs - Transaction Management: Commit or Rollback If you are using transactions with REPEATABLE READ isolation level and transaction safe storage engines in your applications, data locks, lock timeouts, and dead lock d...
2007-05-08, 4613👍, 0💬

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

How To Experiment Data Locks
How To Experiment Data Locks? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to have some experience with data locks, you can create two windows running two mysql transactions in two sessions. In session 1, you can run a UPDATE statement with REPEATABLE READ transaction isolat...
2007-05-11, 4599👍, 0💬

How To Connect to a MySQL Sever with a Port Number
How To Connect to a MySQL Sever with a Port Number? - MySQL FAQs - PHP Connections and Query Execution If you want to connect a MySQL server with a non-default port number, you need to use the "mysql_connect($server)" function with $server in the format of "hostName:portNubmber". The tutorial exerci...
2007-05-10, 4599👍, 0💬

How To Delete a User Account
How To Delete a User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to delete a user account, you can connect to the server as "root" and use the "DROP USER ..." command to delete a user account. The tutorial exercise below shows you a good example: >cd \mysql\bin >...
2007-05-10, 4594👍, 0💬

What Is Index
What Is Index? - MySQL FAQs - Database Basics and Terminologies An index is a single column or multiple columns defined to have values pre-sorted to speed up data retrieval speed.
2007-05-10, 4591👍, 0💬

How To Count Duplicated Values in a Column
How To Count Duplicated Values in a Column? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you have a column with duplicated values, and you want to know what are those duplicated values are and how many duplicates are there for each of those values, you can use the GROUP BY ... HAVING ...
2007-05-11, 4586👍, 0💬

How To Get a List of Databases from MySQL Servers
How To Get a List of Databases from MySQL Servers? - MySQL FAQs - PHP Connections and Query Execution Once you got a MySQL server connection object successfully, you need to know what databases are available on the server and which database you should use to manage your tables and data. To get a lis...
2007-05-10, 4583👍, 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, 4580👍, 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, 4579👍, 0💬

What Is Column
What Is Column? - MySQL FAQs - Database Basics and Terminologies A column defines one piece of data stored in all rows of the table.
2007-05-10, 4579👍, 0💬

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