Home / mySQL (page 2)

mySQL

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 »

SQL HAVING Clause

Hi Guys, This SQL article explain how to use the SQL HAVING clause with example and syntax. Mainly the SQL HAVING clause is used in combination with the GROUP BY clause to restrict the groups of returned rows to only those whose the condition is TRUE. Syntax SELECT exp1, exp2, …

Read More »

How to Delete Data from MySQL with Confirmation in PHP

Good Moring to all, All are familure with how to delete data from databse using php page. But nobody try to develope delete data from mysql database with confirmation. In here, now we discuss how to delete data from mysql database with confirmation in PHP.. We solve this problem with …

Read More »

Data Insert Into MySQL Database – PHP

Hi all, In here, I will show you to how to insert data into mysql database from php page. Table Of Content Create Database Create Table HTML Form HTML Style Create Database In here, the database is create for performing insert operation. Create database and name it whatever you want. …

Read More »

Difference between DELETE, TRUNCATE and DROP commands

Good Morning to all, In here, I share the article related to delete, truncated and drop command. We cover basic concept of these three command, syntax, simple example in this post. DELETE If you want to remove the rows from a table the DELETE command helps to perform this operations. …

Read More »