Home / mySQL (page 3)

mySQL

Multiple WordPress Installation Using a Single Database

Hi all, Here I explain how to install multiple wordpress in a single database. If you want multiple sites, multiple theme in one database. You must install WordPress manually in order for this to work. Most one click programs like Fantastic would not let you choose the prefix. Multiple Blogs …

Read More »

An Introduction to SQL Data Types – PostgreSQL

Hi Friends, Everybody know that SQL is a structured Query Language is a computer language. It is used for storing, manipulating and retrieving data stored in relational databases. This article give you a basic idea about data types in PostgreSQL. SQL support standard language for relational database system. The all …

Read More »

How to copy one table data into another table using Mysql Query?

Hi friends, Today I’m going to tell you “how to copy table values from one database table values to another database table using MYSQL.” We can easly copy the one table values to another table in same database. This is easy and this purpose is used in allproject. But in …

Read More »

SQL Query Interview Questions with Answers

Hi all, Today I share one important topic related to SQL. SQL query is very important. This article mainly focus sql query related to interview questions and answer. In this article, I am giving some examples of SQL queries with answer which is frequently asked when you go for a …

Read More »

mysql_close() function:PHP

To close an open MySQl connection in php, the mysql_close()helps to perform this function. The mysql_close() function is not the necessary part in our program. In non-persistent open links are automatically closed at the end of the script’s execution. Syntax mysql_close(connection) Example [crayon-5a37b722a4bd7602056158/] Output : connected successfully at:26/07/10 : 09:31:14 …

Read More »

Fetch MYSQL table data – PHP

Welcome to all, Here we discuss one useful topic related to MYSQL,fetch the data from data base in MySQL using PHP. From the MYSQL database the data can be fetched by executing SQL SELECT statement through PHP function mysql_query. The mysqli_fetch_array() or mysql_fetch_array() function is most frequently option. This function …

Read More »

mysql_connect() and mysql_pconnect()

Hi all, Nobody knows what are the main differnce between MYSQL_CONNECT() and MYSQL_PCONNECT(). MYSQL_CONNECT() and MYSQL_PCONNECT() are working for database connection. But these two have some little diffrence. In mysql_pconnect(), ā€˜pā€™ stands for persistance connection. The mysqli_connect() function opens a new connection to the MySQL server. Every time it is …

Read More »

SQL LIKE Operator

Good morning to all, Welcome to SQL commnands, queries, operators etc. Now we are discuss the SQL LIKE operator. The LIKE operators used to fetch the data from database foor specific pattern. The LIKE operator is used to search for a specified pattern in a column used in WHERE clause. …

Read More »

Reset Auto-Increment – MySQL

Good morning to all, Here I going to demonstrate how to reset auto-increment value in MySql. Assign to auto-increment attributes to a column of a table, to generate unique identity for the new row. If new row is inserted it incrementsthe value one. Whenever you insert a new row into …

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