<< < 3 4 5 6 7 8 9 10 11 12 13 > >>   Sort: Rank

What Is "mysqlcheck"
What Is "mysqlcheck"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqlcheck" is a command-line interface for administrators to check and repair tables. Here are some sample commands supported by "mysqlcheck": "mysqlcheck databaseName tableName" - Checks the specified table in the ...
2007-05-11, 4676👍, 0💬

What Is "mysqlshow"
What Is "mysqlshow"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqlshow" is a command-line interface for end users to see information on tables and columns. Here are some sample commands supported by "mysqlshow": "mysqlshow" - Shows all the databases. "mysqlshow databaseName" - ...
2007-05-11, 4476👍, 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, 4531👍, 0💬

What Is "mysql"
What Is "mysql"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysql" is a command-line interface for end users to manage user data objects. You can use "mysql" to run any standard SQL statements against the server. For example, you use the following SQL statements to manage tables a...
2007-05-11, 4265👍, 0💬

What Is SQL
What Is SQL? - MySQL FAQs - Introduction to SQL Basics SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation.
2007-05-11, 4242👍, 0💬

What Is "mysqld"
What Is "mysqld"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqld" is MySQL server daemon program which runs quietly in background on your computer system. Invoking "mysqld" will start the MySQL server on your system. Terminating "mysqld" will shutdown the MySQL server. Here is ...
2007-05-11, 4421👍, 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, 4925👍, 0💬

How To Break Output into Pages
How To Break Output into Pages? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you have a query that returns hundreds of rows, and you don't want to present all of them to your users on a single page. You can break output into multiple pages, and only present 10 rows per page...
2007-05-10, 5099👍, 0💬

How To Get the Number of Rows Selected or Affected by a SQL Statement
How To Get the Number of Rows Selected or Affected by a SQL Statement? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts There are two functions you can use the get the number of rows selected or affected by a SQL statement: mysql_num_rows($res) - Returns the number of rows selecte...
2007-05-10, 4543👍, 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, 4451👍, 0💬

How To Create a New Table Using the InnoDB Storage Engine
How To Create a New Table Using the InnoDB Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB InnoDB storage engine was developed by Innobase Oy, which is an Oracle company now. InnoDB is transaction safe, and has been used by a number of large Websites, like Slashdot.org. InnoDB...
2007-05-10, 4491👍, 0💬

How To Insert Multiple Rows with a SELECT Statement
How To Insert Multiple Rows with a SELECT Statement? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If want to insert rows into a table based on data rows from other tables, you can use a sub-query inside the INSERT statement as shown in the following script example: &lt;?ph...
2007-05-10, 5707👍, 0💬

Where Table Data Is Stored by the BDB Storage Engine
Where Table Data Is Stored by the BDB Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, the BDB storage engine will create one file for each table to store ...
2007-05-10, 4245👍, 0💬

How To Create a New Table Using the CSV Storage Engine
How To Create a New Table Using the CSV Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB CSV (Comma-Separated Values) storage engine stores table data in text files in comma-separated value format. CSV is not the default storage engine. You need to specify "ENGINE = CSV" at the...
2007-05-10, 4200👍, 0💬

How To Create a New Table Using the BDB Storage Engine
How To Create a New Table Using the BDB Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB BDB (BerkeleyDB) storage engine was originally developed at U.C. Berkeley. It is now maintained by Sleepycat Software, Inc., which is an Oracle company now. BDB is transaction safe, and has...
2007-05-10, 4217👍, 0💬

How To See Which Storage Engines Are Supported in Your MySQL Server
How To See Which Storage Engines Are Supported in Your MySQL Server? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB If you want to know exactly which storage engines are supported in your MySQL server, you can run the "SHOW ENGINES" command as shown in the tutorial example below: mysql> SHOW...
2007-05-10, 4205👍, 0💬

How To Restore Tables by Copying MyISAM Table Files
How To Restore Tables by Copying MyISAM Table Files? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB If you have old copies of MyISAM table files, you can restore them easily by copying them back to the data directory to replace the current table files. However you may need to shutdown MySQL ...
2007-05-10, 4391👍, 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, 4598👍, 0💬

How To Start mysqld to Support the BDB Storage Engine
How To Start mysqld to Support the BDB Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB The default "mysqld" program does not support the BDB storage engine. If you want to use the BDB storage engine, you can start MySQL server with the "mysqld-max" program. The tutorial exerci...
2007-05-10, 4200👍, 0💬

How To Get Some Basic Information Back from MySQL Servers
How To Get Some Basic Information Back from MySQL Servers? - MySQL FAQs - PHP Connections and Query Execution Once you got a MySQL server connection object successfully, you can use mysql_get_server() and mysql_get_host_info() to get some basic information from your MySQL server. The tutorial exerci...
2007-05-10, 4672👍, 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 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, 4488👍, 0💬

How To Backup Tables by Copying MyISAM Table Files
How To Backup Tables by Copying MyISAM Table Files? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB To easiest way to backup MyISAM tables is to copy the data files to a backup directory. But this is not the recommended way to do backups. Read the backup FAQ collections for more details. The ...
2007-05-10, 4346👍, 0💬

Where Table Data Is Stored by the InnoDB Storage Engine
Where Table Data Is Stored by the InnoDB Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, InnoDB storage engine will create 3 files to store and manage all...
2007-05-10, 4352👍, 0💬

<< < 3 4 5 6 7 8 9 10 11 12 13 > >>   Sort: Rank