.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

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

How To Create a Table Index
How To Create a Table Index? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you have a table with a lots of rows, and you know that one of the columns will be used often as a search criteria, you can add an index for that column to improve the search performance. To add an ind... 2007-05-11, 5290👍, 0💬

What Is a Transaction
What Is a Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback 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 transac... 2007-05-11, 5289👍, 0💬

What Are DML Statements
What Are DML Statements? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements DML (Data Manipulation Language) statements are statements to change data values in database tables. The are 3 primary DML statements: INSERT - Inserting new rows into database tables. UPDATE - Updating ex... 2007-05-11, 5281👍, 0💬

How To Create a New Table by Selecting Rows from Another Table
How To Create a New Table by Selecting Rows from Another Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements Let's say you have a table with many data rows, now you want to create a backup copy of this table of all rows or a subset of them, you can use the "CREATE TABLE ... SEL... 2007-05-11, 5279👍, 0💬

What Happens If You No CREATE Privilege in a Database
What Happens If You No CREATE Privilege in a Database? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements In order to create tables in a database, your user account must have the CREATE privilege for that database. Otherwise you will get an error as shown in the following tutorial ex... 2007-05-11, 5274👍, 0💬

How To See the CREATE TABLE Statement of an Existing Table
How To See the CREATE TABLE Statement of an Existing Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you want to know how an existing table was created, you can use the "SHOW CREATE TABLE" command to get a copy of the "CREATE TABLE" statement back on an existing table. T... 2007-05-11, 5272👍, 0💬

How To Get a List of Columns in an Existing Table
How To Get a List of Columns in an Existing Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you have an existing table, but you don't remember what are the columns used in the table, you can use the "SHOW COLUMNS FROM tableName" command to get a list of all columns of th... 2007-05-11, 5272👍, 0💬

How To Get a List of Indexes of an Existing Table
How To Get a List of Indexes of an Existing Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you want to see the index you have just created for an existing table, you can use the "SHOW INDEX FROM tableName" command to get a list of all indexes in a given table. The tutor... 2007-05-11, 5270👍, 0💬

How To Install MySQL
How To Install MySQL? - PHP Script Tips - Working with MySQL Database 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. Here is how you can do this: Go to http://dev.mysql.com/downloads /mysql... 2007-04-18, 5269👍, 0💬

What Do You Need to Connect PHP to MySQL
What Do You Need to Connect PHP to MySQL? - PHP Script Tips - Working with MySQL Database If you want to access MySQL database server in your PHP script, you need to make sure that MySQL module is installed and turned on in your PHP engine. Check the PHP configuration file, php.ini, to make sure the... 2007-04-18, 5254👍, 0💬

How To Create a New Database
How To Create a New Database? - MySQL FAQs - PHP Connections and Query Execution A database in a MySQL server is a logical container used to group tables and other data objects together as a unit. If you are a the administrator of the server, you can create a new databases using the CREATE DATABASE ... 2007-05-10, 5251👍, 0💬

What Are Date and Time Data Types
What Are Date and Time Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL supports the following date and time data types: DATE - A date in the range of '1000-01-01' and '9999-12-31'. Default DATE format is "YYYY-MM-DD". DATETIME - A date with the time of day in the range of '1000-01-01 00:... 2007-05-11, 5250👍, 0💬

Can SELECT Statements Be Used on Views
Can SELECT Statements Be Used on Views? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY Select (query) statements can be used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view: mysql> CREATE VIEW myLinks A... 2007-05-11, 5242👍, 0💬

What Is the MySQL Server Daemon - mysqld
What Is the MySQL Server Daemon - mysqld? - MySQL FAQs - Server Daemon mysqld Administration "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 se... 2007-05-11, 5241👍, 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, 5241👍, 0💬

How To Delete an Existing Row from a Table
How To Delete an Existing Row from a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements: mysql> INSERT INT... 2007-05-11, 5240👍, 0💬

How To Drop an Existing View
How To Drop an Existing View? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you have an existing view, and you don't want it anymore, you can delete it by using the "DROP VIEW viewName" statement as shown in the following script: mysql> DROP VIEW faqComment; Query OK, 0 rows ... 2007-05-11, 5238👍, 0💬

How To Drop an Existing Database
How To Drop an Existing Database? - MySQL FAQs - PHP Connections and Query Execution If want to drop an existing database from the MySQL server, you can use the DROP DATABASE statement. Here is a good example of dropping an existing database: $con = mysql_connect('localhost:8888' ,'dev', 'iyf'); $sq... 2007-05-10, 5238👍, 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, 5236👍, 0💬

How To Query Tables and Loop through the Returning Rows
How To Query Tables and Loop through the Returning Rows? - PHP Script Tips - Working with MySQL Database The best way to query tables and loop through the returning rows is to run the SELECT statement with the catch the mysql_query() function, catch the returning object as a result set, and loop thr... 2007-04-19, 5235👍, 0💬

What Are String Data Types
What Are String Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL supports the following string data types: CHAR(n) same as CHARACTER(n) - Fixed width and " " padded characters strings. Default character set is ASCII. NCHAR(n) same as NATIONAL CHARACTER(n) - Fixed width and " " padded char... 2007-05-11, 5230👍, 0💬

How Many SQL DDL Commands Are Supported by "mysql"
How Many SQL DDL Commands Are Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql There are 4 SQL Data Definition Language (DDL) commands that are supported by "mysql". They are listed below with short descriptions: "CREATE dataObjectType dataObjectName" - Creates new database... 2007-05-08, 5216👍, 0💬

How To Insert Multiple Rows with One INSERT Statement
How To Insert Multiple Rows with One INSERT Statement? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you want to insert multiple rows with a single INSERT statement, you can use a subquery instead of the VALUES clause. Rows returned from the subquery will be inserted the t... 2007-05-11, 5215👍, 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, 5215👍, 0💬

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

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML