.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

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, 5197👍, 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, 5186👍, 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, 5184👍, 0💬

How To Return Query Output in HTML Format
How To Return Query Output in HTML Format? - MySQL FAQs - Command-Line End User Interface mysql By default, "mysql" returns query output in text table format. If you want to receive query output in HTML format, you need to use the "-H" command option. Here is a good tutorial exercise: >cd \mysql\bin... 2007-05-10, 5184👍, 0💬

How To Quote Text Values in SQL Statements
How To Quote Text Values in SQL Statements? - PHP Script Tips - Working with MySQL Database 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 SQL language syntax... 2007-04-19, 5183👍, 0💬

What Are Group Functions
What Are Group Functions? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY Group functions are functions applied to a group of rows. Examples of group functions are: COUNT(*) - Returns the number of rows in the group. MIN(exp) - Returns the minimum value of the expression evaluated on each r... 2007-05-11, 5182👍, 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, 5179👍, 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, 5171👍, 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, 5165👍, 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, 5157👍, 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, 5156👍, 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, 5152👍, 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, 5151👍, 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, 5151👍, 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, 5149👍, 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, 5148👍, 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, 5148👍, 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, 5147👍, 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, 5144👍, 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, 5136👍, 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, 5135👍, 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, 5133👍, 0💬

How Many Groups of Data Types
How Many Groups of Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL support 3 groups of data types as listed below: String Data Types - CHAR, NCHAR, VARCHAR, NVARCHAR, BINARY, VARBINARY, TINYBLOB, TINYTEXT, BLOB, TEXT, MEDIUMBLOB, MEDIUMTEXT, LONGBLOB, LONGTEXT, ENUM, SET Numeric Data Typ... 2007-05-11, 5129👍, 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, 5118👍, 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