MySQL is dead but subsys locked Issue Description: When tried to connect to MySQL or run any command. It Displayed […]
Category: mysql
How to check table Engine in MySQL
How to check table Engine in MySQL With the help of below query, we can check the table engine in […]
MySQL Addtime() : Adding time to datetime
MySQL Addtime() : Adding time to datetime The ADDTIME() function adds a time interval to a time/datetime and then returns the […]
Data Manipulation Language in SQL (DML)
SQL language also includes syntax to update, insert, and delete records. These query and update commands together form the Data […]
Data Definition Language (DDL) in SQL
The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also define […]
Characteristics of SQL Commands
Here you can see that SQL commands follow a number of basic rules: • SQL keywords are not normally case […]
SQL Commands
There are three groups of commands in SQL: 1. Data Definition 2. Data Manipulation and 3. Transaction Control
What is SQL?
Structured Query Language, commonly abbreviated to SQL and pronounced as “sequel”, is not a conventional computer programming language in the […]
PHP MySQL connector
PHP MySQL connector Example: <html> <head> <title>Connecting MySQL Server</title> </head> <body> <?php $dbhost = ‘localhost:3306’; $dbuser = ‘guest’; $dbpass = […]
LOCATE() – MySQL Function
LOCATE() – MySQL Function The LOCATE() function returns the position of the first occurrence of a substring in a string. […]