connection with sql command

Anonymous User 3022 09 Jul 2013

Hi Expert!

How do I execute a command as and when a new mysql connection is established from php?

$con=mysqli_connect("localhost","root","","gts");

In the above example, I need to pass set sql command :

sql_log_bin = 0

This will make sure that the commands executed by this connection will not be written to binary log. I have another "normal" connection that will work as usual and write all the commands to binary log.

In other words I need 2 connections to mysql one with disabled binary logging. I should be able to decide which one to use. How is it done in PHP?

Thanks in advance.

Ask by Anonymous User

Updated 09 Jul 2013

1 Answers

AVADHESH PATEL 09 Jul 2013

Hi,

First create two connections.

$con1=mysqli_connect("localhost","root","","gts");

$con2=mysqli_connect("localhost","root","","gts");

Then on one of them disable your binlog

mysqli_query($con1, "SET sql_log_bin = 0");

I Hope it helpful for you.

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

connection with sql command

Can you answer this question?

1 Answers