Home / mySQL

mySQL

Find MySQL root password cPanel

Hi Guys, This is only a small tip for those use cPanel servers. If you are looking to find the MySQL root password for the server, it’s easy and can be done in a flah of a second. The password is saved in file named .my.cnf under the root directory …

Read More »

Backup and Restore a Single Table in MySQL Database

Hello, Taking the backup of a single table of a MySQL database and restoring it is possible via command line. You might have done this using phpmyadmin or via other applications, let’s check how this can be done using the command line tool. I am not writing too much, let’s …

Read More »

How to Solve #1045 Error in phpMyAdmin

We Successfully instal WAMP server in localhost for programing, but after installing WAMP server we tryping to access the phpMyAdmin you may encounter the error: #1045 Access Denied for user 'root'@'localhost' (using password: YES). This may happen if you provided a wrong password or if your root@localhost database user was …

Read More »

Convert The Amount to Word in PHP

Hi Guys, Convert the amount or current to words is very important in fees invoice or bank payment details in php. Here I describe how to convert amount to words in a simple method. [crayon-5efdcc9698e4b984811894/] OUTPUT one lakh nine thousand Rupees Shop Related Products

Read More »

How to Get Last Row From mysql

Hi Friends, How to find out the last row data from database. It’s very useful to developers. Suppose our table has different field and multiple row values exist. We find the last values from database for some purpose like find the last row values id or something like this. Syntax …

Read More »

How to calculate the time difference from current time using ajax in php

Hi Friends, Today we discuss one important topic related to ajax like calculate the time difference from current time using ajax in php. In the previous article How to get current Time using JavaScript In here there is little bit changes for solving this problem. Ajax method is helps to …

Read More »

Main differences between INNODB and MYISAM

Good Morning to all…. ๐Ÿ™‚ In MYSQL, the MyISAM and InnoDB are the most commonly used storage engine. Both these storage enginee have advantages and disadvantages depending on the specific application. The main and important difference between InnoDB and MYISAM is : the MyISAM does not support the advanced transaction …

Read More »

Insert Image Into Database and folder in AngularJS, PHP, MYSQL

Good Afternoon… I got a query from my blog viewer How to upload images in database by using PHP and angularjs. He tried a lot of time but he can’t upload. Based on this request I try to solve this problem I can find the solution. And here I explain …

Read More »

MYSQL Data Types

In here I explain the types of MYSQL data types. There are many possible types of datas are available in php with which the PHP variable may be initialized. Similarly MYSQL support several datatypes. The database table contains multiple columns with attributes or with data types such as string or …

Read More »
Translate ยป
Social Media Auto Publish Powered By : XYZScripts.com