Home / mySQL


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 »

Securing MySQL Server

Good Morning to all, The MySQL server is widely used in the open source world, whether it’s for the financial data of SMBs or mission-critical ERP system.. This is due to its great performance and compatibility. However, it is also plagued with security challenges, just like any open source database …

Read More »

Removing Database and User – MYSQL

In this post, we will discuss detailed information based on how to delete MySQL usernames and MySQL databases from your hosting account. Removing Privileged User from a database If you would like to remove a privileged user. We remove user privileged from a database. This you can easy develope and …

Read More »

What is a database? What is SQL?

What is a Database? A database is a collection of data or information. Databases make data management easy. Databases support manipulation and storage of data. The database can easily be managed, accessed and updated. The databases can be classified based on types of content: full-text, bibliographic, numeric, and images. What …

Read More »

Difference Between MySQL vs MySQLi in PHP

Hi all, There are too many differences between these MYSQL and MYSQLi PHP database extensions. These differences are based upon some factors like features, performance, benefits, library functions and others. The “i” in mysqli stands for “improved”. The “mysqli” extension is an improvement over the old “mysql” extension. MYSQLi MYSQL …

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