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

How To Show Table Names with "mysqlshow"
How To Show Table Names with "mysqlshow"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to show table names with "mysqlshow", you need to specify a database name. The followings tutorial exercise shows you how to get all table names that match a pattern: If you want analyz...
2007-05-11, 4374👍, 0💬

How To Include Comments in SQL Statements
How To Include Comments in SQL Statements? - MySQL FAQs - Introduction to SQL Basics If you want to include comments in a SQL statement, you can first enter "--", then enter your comment until the end of the line. The tutorial exercise below shows you some good examples: SELECT 'Hello world!' FROM D...
2007-05-11, 4412👍, 0💬

How To Use "mysql" to Run SQL Statements
How To Use "mysql" to Run SQL Statements? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to run SQL statement to your server with "mysql", you need to start "mysql" and enter your SQL statement at the "mysql" prompt. Here is a good tutorial exercise that shows you how to ru...
2007-05-11, 4324👍, 0💬

How To Analyze Tables with "mysqlcheck"
How To Analyze Tables with "mysqlcheck"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want analyze tables with "mysqlcheck", you need to use the "--analyze" option. The following tutorial exercise shows you how to analyze all tables in "mysql" database: >cd \mysql\bin >mysqlch...
2007-05-11, 6092👍, 0💬

How Much Memory Does the Server Take
How Much Memory Does the Server Take? - MySQL FAQs - Server Daemon mysqld Administration If you are interested to know how much memory your MySQL server is taking, you can use Windows Task Manager to find out. Try to following this tutorial exercise: Start your MySQL server. Press Ctrl-Alt-Del and c...
2007-05-11, 4833👍, 0💬

How To Query Multiple Tables Jointly
How To Query Multiple Tables Jointly? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts 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: "use...
2007-05-11, 5227👍, 0💬

How To Delete Existing Rows in a Table
How To Delete Existing Rows in a Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row: &lt;?php include "mysql_con...
2007-05-11, 4785👍, 0💬

How To Start MySQL Server Daemon mysqld
How To Start MySQL Server Daemon mysqld? - MySQL FAQs - Server Daemon mysqld Administration There are a number of ways to start MySQL server daemon, mysqld: Double click on the file name, mysqld.exe, in a file explorer window. This is an easy way to start the server. But you will not be able to spec...
2007-05-11, 4531👍, 0💬

How To Perform Key Word Search in Tables
How To Perform Key Word Search in Tables? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts 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...
2007-05-11, 4999👍, 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, 4418👍, 0💬

How To Update Existing Rows in a Table
How To Update Existing Rows in a Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values: &lt;?php in...
2007-05-11, 4999👍, 0💬

How To Get the Last ID Assigned by MySQL
How To Get the Last ID Assigned by MySQL? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you use an ID column with AUTO_INCREMENT attribute, you can use the mysql_insert_id() function to get the last ID value assigned by the MySQL server, as shown in the sample script below: ...
2007-05-11, 6430👍, 0💬

What Are the "mysqld" Command Line Options
What Are the "mysqld" Command Line Options? - MySQL FAQs - Server Daemon mysqld Administration "mysqld" offers a big list of command line options. Here are some commonly used options: "--help" - Displays a short help message on how to use "mysqld". "--verbose --help" - Displays a long help messages ...
2007-05-11, 4447👍, 0💬

What Are Numeric Data Types
What Are Numeric Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL supports the following numeric data types: BIT(n) - An integer with n bits. BOOL same as BOOLEAN - Boolean values stored in 1 bit. TINYINT - A small integer stored in 1 byte. SMALLINT - A small integer stored in 2 bytes. ME...
2007-05-11, 4354👍, 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, 4346👍, 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, 4372👍, 0💬

What Is "mysqladmin"
What Is "mysqladmin"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqladmin" is a command-line interface for administrators to perform server administration tasks. It support a number of commonly used commands like: "mysqladmin shutdown" - Shuts down the server. "mysqladmin ping" ...
2007-05-11, 4567👍, 0💬

How To Turn on Error Logs
How To Turn on Error Logs? - MySQL FAQs - Server Daemon mysqld Administration If you want MySQL to write critical errors into a log file, you can use the "--log-error=fileName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option: >cd \m...
2007-05-11, 4576👍, 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, 4254👍, 0💬

How To Show All Tables with "mysql"
How To Show All Tables with "mysql"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to see all the tables in a database, you run the non-SQL command "SHOW TABLES" at the "mysql" prompt. See the following tutorial exercise for example: >cd \mysql\bin >mysql -u root test Welc...
2007-05-11, 4364👍, 0💬

How To Turn on Query Logs
How To Turn on Query Logs? - MySQL FAQs - Server Daemon mysqld Administration If you want MySQL to write query logs to a file, you can use the "--log=fileName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option and view the query log f...
2007-05-11, 4470👍, 0💬

What Is "mysqlimport"
What Is "mysqlimport"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqlimport" - A command-line interface for administrators or end users to load data files into tables program tool to load data into tables. Here is a sample commands supported by "mysqlimport": "mysqlimport databa...
2007-05-11, 4282👍, 0💬

What Is Binary Log File
What Is Binary Log File? - MySQL FAQs - Server Daemon mysqld Administration MySQL server binary log file plays an important role in restoring database changes to the server. Main features on binary log files are: Binary logs can be turned on by "--log-bin=fileBaseName" option on "mysqld". Binary log...
2007-05-11, 4776👍, 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, 4639👍, 0💬

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