Posted by: Lucio Menci
Date: March 12, 2015 05:58AM

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)";

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

Options: ReplyQuote

Written By
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.