MySQL table join JOIN clause is used to combine rows from two or more tables, based on a related column […]
Category: php-mysql
PHP mysql select average program example
PHP mysql select average program example PHP MySQL code to to calculate average. <!doctype html> <html lang=”en”> <head> <meta […]
Install LAMP Server (Apache, MySQL, PHP) On RHEL, CentOS
LAMP is a combination of operating system and open-source software stack. The acronym LAMP is derived from first letters of […]
PHP – MySQL : Create Database
[root@mysqlDB]# mysqladmin -u root -p create eduguru Enter password:****** This will create a MySQL database eduguru. This is a simple example […]
PHP MySQL Database Connection
PHP 5 and later can work with a MySQL database using: MySQLi extension (the “i” stands for improved) PDO (PHP […]
inserting data from one mysql table into another mysql table
insert into destinationtablename select * from srctablename
#1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
Login to mysql and run the below command: set global net_buffer_length=1000000; set global max_allowed_packet=1000000000;
Backup and Restore Mysql database table
Dump and restore from .sql Dump mysqldump db_name table_name > table_name.sql Restore mysql -u <user_name> -p db_name mysql> source <full_path>/table_name.sql […]
No route to host (113)
In host machine iptables is running and is blocking the port 5901. Kill all the vncserver desktop in the host machine […]
saving data into custom cdr field – add new filed in cdr
I created custom field “rec_name” id table “cdr”, database “asteriskcdrdb”. In this field I want to store recording name. I […]