max_allowed_packed
I often use parameters in mysql commands (in .net programming) in this way:
myMysqlCommand.Parameters.Add("?code1", MySqlClient.MySqlDbType.VarChar).Value = code1;
myMysqlCommand.Parameters.Add("?descr1", MySqlClient.MySqlDbType.VarChar).Value = descr1;
myMysqlCommand.Parameters.Add("?code2", MySqlClient.MySqlDbType.VarChar).Value = code2;
myMysqlCommand.Parameters.Add("?descr2", MySqlClient.MySqlDbType.VarChar).Value = descr2;
myMysqlCommand.CommandText = "Insert Into Table (code, desc) Values (?code1, ?descr1), (?code2, ?descr2)";
myMysqlCommand.ExecuteNonQuery();
The max_allowed_packet variabile, refers to the CommandText length? Or it refers to the entire content (CommandText and all parameter names and contents)? Or the command is parsed before the send and the variabiles are replaced by its content, (then it refers to the length of the string: Insert Into Table (code, desc) Values ('', ''), ('', '') and the length of variables?
Thank you
Subject
Written By
Posted
max_allowed_packed
March 12, 2015 05:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.