PBPHPSOLUTIONS
Tag

MySQL

#mysql

More content

Read more stories on Hashnode

Articles with this tag

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

May 3, 20232 min read

Hi friends, in this tutorial, you will learn how to resolve SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max...

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

How to export database in PHPMyAdmin

Apr 5, 20232 min read

Hi friends, in this tutorial, you will learn how to export databases in phpmyadmin. This is very simple and I am going to discuss it in a step-by-step...

How to export database in PHPMyAdmin

Select First 10 Rows from MySQL using PHP

Mar 18, 20233 min read

Hi friends, in this tutorial, you will learn how to select first 10 rows from MySQL using PHP. This kind of query is required very often when you need...

Select First 10 Rows from MySQL using PHP

Calculate Balance From Credit and Debit Using PHP MySQL

Mar 18, 20232 min read

Hi friends, in this tutorial you will learn how to calculate balance from credit and debit using PHP MySQL and also get the direct code that you can...

Calculate Balance From Credit and Debit Using PHP MySQL

Export Data From MySQL to Excel Using PHP

Mar 18, 20233 min read

Hi friends, in this tutorial, you will learn how to export data from MySQL to excel using PHP. It is often required in the case of web development or...

Export Data From MySQL to Excel Using PHP

Delete a row in MySQL

Feb 4, 20232 min read

Hi friends, in this tutorial you will learn how to delete a row in MySQL. Actually, there are two ways by which you can perform the delete operations...

Delete a row in MySQL