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

What Is a Result Set Object
What Is a Result Set Object? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts A result set object is a logical representation of data rows returned by mysql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in t...
2007-05-10, 4450👍, 0💬

How To Run a SQL Statement
How To Run a SQL Statement? - MySQL FAQs - PHP Connections and Query Execution You can run any types of SQL statements through the mysql_query() function. It takes the SQL statement as a string and returns different types of data depending on the SQL statement type and execution status: Returning FA...
2007-05-10, 4322👍, 0💬

What Are User Privileges
What Are User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges MySQL offers many user privileges to control user accesses to different funtions and data objects. Here are some commonly used privileges: ALL - All privileges. CREATE - Allows the user to use CREATE TABLE commands...
2007-05-10, 4347👍, 0💬

How To Create a New Table
How To Create a New Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script: &lt;?php include "mysql_connection.php"; $sql = "CREATE TABLE fyi_links (" . " id INTEGER ...
2007-05-10, 4308👍, 0💬

How To Check and Repair MyISAM Tables
How To Check and Repair MyISAM Tables? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB If you have a corrupted MyISAM table, like the one resulted from the previous tutorial exercise, you can use the "CHECK TABLE" and "REPAIR TABLE" commands to try to repair it. The following tutorial exercis...
2007-05-10, 4284👍, 0💬

How To Check Your PHP Installation
How To Check Your PHP Installation? - MySQL FAQs - PHP Connections and Query Execution PHP provides two execution interfaces: Command Line Interface (CLI) and Common Gateway Interface (CGI). If PHP is installed in the \php directory on your system, you can try this to check your installation: Run "\...
2007-05-10, 4322👍, 0💬

How To Select an Exiting Database
How To Select an Exiting Database? - MySQL FAQs - PHP Connections and Query Execution The first thing after you have created a connection object to the MySQL server is to select the database where your tables are located, by using the mysql_select_db() function. If your MySQL server is offered by yo...
2007-05-10, 4356👍, 0💬

How To Create a Test Table in Your MySQL Server
How To Create a Test Table in Your MySQL Server? - MySQL FAQs - Downloading and Installing MySQL on Windows If you want to create a test table in your MySQL server, you can use the "mysql" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysql -u root Welcome to the My...
2007-05-10, 4187👍, 0💬

How Do You Know the Version of Your MySQL Server
How Do You Know the Version of Your MySQL Server? - MySQL FAQs - Downloading and Installing MySQL on Windows If you want to know the version number of your MySQL server, you can use the "mysqladmin" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysqladmin -u root ve...
2007-05-10, 4274👍, 0💬

How To Change the Password for Your Own User Account
How To Change the Password for Your Own User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to change the password of your own user account, you should use your user account connect to the server "mysql" first. You should then use the "SET PASSWORD ..." command to c...
2007-05-10, 4446👍, 0💬

What Are the Non-Standard SQL Commands Supported by "mysql"
What Are the Non-Standard SQL Commands Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql There are many non-standard SQL commands that are supported by "mysql". Here is short list of some commonly used commands: "SHOW infoName" - Shows basic information of based on the speci...
2007-05-10, 4438👍, 0💬

How To Change the Password of Another User Account
How To Change the Password of Another User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to change the password of someone else's user account, you can connect to the server as "root" and use the "SET PASSWORD FOR userName ..." command to change the password of ano...
2007-05-10, 6474👍, 0💬

How Do You Know If Your MySQL Server Is Alive
How Do You Know If Your MySQL Server Is Alive? - MySQL FAQs - Downloading and Installing MySQL on Windows If you want to know whether your MySQL server is alive, you can use the "mysqladmin" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysqladmin -u root ping mysql...
2007-05-10, 4170👍, 0💬

How To Test a New User Account and Password
How To Test a New User Account and Password? - MySQL FAQs - Managing User Accounts and Access Privileges If you have new user created with a password, you test it using "mysql" program with the "-u" and "-p" options. The following tutorial exercise shows you some interesting use cases of connecting ...
2007-05-10, 4378👍, 0💬

How To Install MySQL
How To Install 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. You can download a copy and install it on your local computer very easily. Here is how you can do this: Go to http://dev.my...
2007-05-10, 4281👍, 0💬

What Is InnoDB
What Is InnoDB? - MySQL FAQs - Database Basics and Terminologies InnoDB is a transaction safe storage engine developed by Innobase Oy (an Oracle company now).
2007-05-10, 5015👍, 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, 4841👍, 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, 4499👍, 0💬

How To Start MySQL Server
How To Start MySQL Server? - MySQL FAQs - Downloading and Installing MySQL on Windows If you want to start the MySQL server, you can run the "mysqld" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysqld "mysqld" will run quietly without printing any message in you c...
2007-05-10, 4236👍, 0💬

What Is BDB (BerkeleyDB)
What Is BDB (BerkeleyDB)? - MySQL FAQs - Database Basics and Terminologies BDB (BerkeleyDB) is transaction safe storage engine originally developed at U.C. Berkeley. It is now developed by Sleepycat Software, Inc. (an Oracle company now).
2007-05-10, 5244👍, 0💬

What Is a User Account
What Is a User Account? - MySQL FAQs - Managing User Accounts and Access Privileges A user account is identified by a user name and defines the user's attributes, including the following: Password for connection authentication. User privileges, for examples: Shutdown_priv, Create_priv, Drop_priv, In...
2007-05-10, 4205👍, 0💬

What Is Foreign Key
What Is Foreign Key? - MySQL FAQs - Database Basics and Terminologies A foreign key is a single column or multiple columns defined to have values that can be mapped to a primary key in another table.
2007-05-10, 5211👍, 0💬

What Is Transaction
What Is Transaction? - MySQL FAQs - Database Basics and Terminologies A transaction is a logical unit of work requested by a user to be applied to the database objects. MySQL server introduces the transaction concept to allow users to group one or more SQL statements into a single transaction, so th...
2007-05-10, 5192👍, 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, 4578👍, 0💬

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