<< < 1 2 3 4 5 6 7 8 9 > >>   ∑:377  Sort:Date

Entering Characters as HEX Numbers in MySQL
How To Enter Characters as HEX Numbers in MySQL? If you want to enter characters as HEX numbers, you can quote HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (0x). A HEX number string will be automatically converted into a character string, if the expression cont...
2018-03-31, 2919🔥, 0💬

Updating Existing Rows in MySQL
How To Update Existing Rows in a Table in MySQL? 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 include "mysql_connection.php"; $sql = "UPDATE fyi_links SET ...
2023-09-10, 2907🔥, 1💬

💬 2023-09-10 Pintu kumar: To update existing rows in a table in MySQL, you can use the UPDATE statement. Here's a general syntax for updating rows in MySQ...

Managing Tables and Running Queries with PHP for MySQL
Where to find answers to frequently asked questions on Managing Tables and Running Queries with PHP for MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Tables and Running Queries with PHP for MySQL. Clear explanations and tutorial ...
2017-10-08, 2907🔥, 0💬

Installing MySQL Server in MySQL
How To Install MySQL Server in MySQL? 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.mysql.com/downloads /mysql/5.0.html.Select th...
2018-06-12, 2901🔥, 0💬

Connecting to MySQL Server on a Specific Port in MySQL
How To Connect to MySQL Server on a Different Port in MySQL? If your MySQL server is listening on port number different than 3306, you need to specify "--port=portNumber" option to any client program that needs to connect to the server. The tutorial exercise shows you how to connect "mysql" to start...
2017-11-25, 2885🔥, 0💬

Returning Query Output in XML Format in MySQL
How To Return Query Output in XML Format in MySQL? By default, "mysql" returns query output in text table format. If you want to receive query output in XML format, you need to use the "-X" command option. Here is a good tutorial exercise: &gt;cd \mysql\bin &gt;mysql -u root -X test mysql&am...
2018-04-21, 2877🔥, 0💬

What Is "mysqladmin" Command in MySQL
What Is "mysqladmin" in MySQL? "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" - Checks if the server is alive or not. "mysqladmin ...
2018-06-01, 2875🔥, 0💬

User Privilege Tables in MySQL
Where Are User Privileges Stored on the Server in MySQL? MySQL server has a system database, which hosts a number of system tables to system related information like user privileges. Depending on the scope levels, granted user privileges are stored in different tables: "mysql.user" - Stores privileg...
2017-12-09, 2874🔥, 0💬

Difference between CHAR and NCHAR in MySQL
What Are the Differences between CHAR and NCHAR in MySQL? Both CHAR and NCHAR are fixed length string data types. But they have the following differences: CHAR's full name is CHARACTER. NCHAR's full name is NATIONAL CHARACTER. By default, CHAR uses ASCII character set. So 1 character is always store...
2018-01-19, 2871🔥, 0💬

Turn on and off Autocommit in MySQL
How To Switch between Autocommit-On and Autocommit-Off Modes in MySQL? By default, your connection session will be in Autocommit-On mode, where every server executable statement will start a new transaction, and end the transaction when the execution ends. Changes will be committed. So consider this...
2016-10-17, 2858🔥, 0💬

"mysql" - Command Line End User Interface in MySQL
What Is the Command Line End User Interface - mysql in MySQL? "mysql", official name is "MySQL monitor", is a command-line interface for end users to manage user data objects. "mysql" has the following main features: "mysql" is command line interface. It is not a Graphical User Interface (GUI). "mys...
2018-04-28, 2856🔥, 0💬

Ways to Start a New Transaction in MySQL
How To Start a New Transaction in MySQL? MySQL server offers two modes to manage transactions: Autocommit On - Default mode. Can be started with "SET AUTOCOMMIT = 1" command. In this mode, every single SQL statement is a new transaction. All changes will be committed at the end of the statement exec...
2016-10-17, 2851🔥, 0💬

Returning Query Output in HTML Format in MySQL
How To Return Query Output in HTML Format in 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: &gt;cd \mysql\bin &gt;mysql -u root -H test mysql&...
2018-02-08, 2848🔥, 0💬

Restore Tables by Copying MyISAM Files in MySQL
How To Restore Tables by Copying MyISAM Table Files in MySQL? 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 shut down MySQL server to do this, because the current table ...
2017-09-01, 2843🔥, 0💬

Backup Tables by Copying MyISAM Files in MySQL
How To Backup Tables by Copying MyISAM Table Files in MySQL? 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 following tutorial exercise shows you how to a...
2017-09-01, 2838🔥, 0💬

What Is "mysql" Command in MySQL
What Is "mysql" in MySQL? "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 and table rows: "CREATE TABLE links (name VARCHAR(80)...
2018-05-19, 2827🔥, 0💬

LAST_INSERT_ID() - Last Value of AUTO_INCREMENT Column
How to obtain the last inserted value of an AUTO_INCREMENT column using the LAST_INSERT_ID() function? LAST_INSERT_ID() is a MySQL built-in function that returns the last inserted value of an AUTO_INCREMENT column. For example: CREATE TABLE MyTable (id INTEGER AUTO_INCREMENT, comment CHAR(80), PRIMA...
2025-04-11, 2813🔥, 0💬

What Is a Result Set Object in MySQL
What Is a Result Set Object in MySQL? 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 the result set. Once you get a result set object, you can us...
2017-09-20, 2807🔥, 0💬

PS_CURRENT_THREAD_ID() - PS Thread ID of Current Connect
How to obtain the performance schema thread id of the current connection using the PS_CURRENT_THREAD_ID() function? PS_CURRENT_THREAD_ID() is a MySQL built-in function that returns the performance schema thread id of the current connection. For example: SELECT PS_CURRENT_THREAD_ID(); -- +-----------...
2025-02-16, 2799🔥, 0💬

Non-Standard SQL Commands in MySQL
What Are the Non-Standard SQL Commands Supported by "mysql" in 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 specified information name. "SHOW infoName" - Sho...
2018-02-08, 2797🔥, 0💬

Tools to Manage MySQL Server in MySQL
What Tools Available for Managing MySQL Server in MySQL? MySQL comes with the following programs as administration tools for you to manage your MySQL server: mysqld - MySQL server daemon. You can use "mysqld" to start your MySQL server. mysqladmin - A command-line interface for administrators to per...
2018-06-01, 2795🔥, 0💬

Tables Using CSV Storage Engine in MySQL
How To Create a New Table Using the CSV Storage Engine in MySQL? 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 end of the "CREATE TABLE" statement to create...
2017-08-13, 2794🔥, 0💬

Accessing MySQL Server through Firewalls in MySQL
How To Access MySQL Servers through Firewalls in MySQL? If your MySQL server is provided by an Internet service company, connecting to the server from your local machine will not be so easy, because there are firewalls between your local machine and your MySQL server as shown below: Firewalls to MyS...
2017-11-25, 2775🔥, 0💬

"mysql" Command Line Options in MySQL
What Are the "mysql" Command Line Options in MySQL? "mysql" offers a big list of command line options. Here are some commonly used options: "-?" - Displays a help message on how to use "mysql" and terminates the program. "-u userName" - Specifies a user name for the server to authenticate when conne...
2018-04-28, 2774🔥, 0💬

<< < 1 2 3 4 5 6 7 8 9 > >>   ∑:377  Sort:Date