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 numbers or numberic. MYSQL provides… Read More »
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 solutions. The MySQL architecture is… Read More »
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 implement. A confirmation message for… Read More »
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 is a Database Management System… Read More »
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 MySQLi extension added in PHP… Read More »
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, … expn, aggregate_function (aggregate_exp) FROM… Read More »
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 simple step in same page.… Read More »
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. CREATE DATABASE `prittytimes` ; In… Read More »
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. DELETE is a Data Manipulation… Read More »