Been struggling with this one. Long story short I have a problem where we need to read a file at different times throughout the month provided by the client. The file can be a few hundred lines, or over a…
I need to update each row in a table with a value returned by a function. This function uses a separate columns value of the same row. I understand how to select a columns value from a row and how…
I generate UUIDs by using UUID_TO_BIN(UUID(), true) and storing them as BINARY(16). However, when fetching the values: var uuid = dataReader.GetGuid(name); Console.WriteLine(uuid.ToString()); I do get an uuid string printed, but it is not the same string as when running SELECT…
How to add the same record in MySQL, like the same Lastname only. create table Person (Lastname varchar(15) primary key, Firstname varchar(15), Address varchar(30), Province varchar(30)); insert into Persons values ('Soriano', 'MamaMo', 'Sa tabi-tabi', 'Pangasinan'); ERROR 1062 (23000): Duplicate entry…
I Am builing a small application. where I Need to create MySQL Stored procedure via python using mysql Connector. I have tried following code. But getting an following error that "Commands out of sync; you can't run this command now."…
I already tried to install wheel -- didn't work well. Tried to install build tools -- didn't work Tried to install mysql connector/C and put it in the environment variables -- didn't work tried upgrading pip -- didn't work So…
I refer to mysql_stmt_bind_named_param() I don't understand the example in the documentation. It uses some traceparent which is never used. I come from PHP where bind variables are using the :bindName syntax. I think I am completely misunderstanding how it…
All my deployments are operated on virtual machines on linux.My MySQL container maps port 3306 to port 3307 of the host, and my Java project maps port 8080 to port 8080 of the host, and both work successfully. However, when…
@pname is the parameter set in C# code by: using (MySqlCommand dynamicQueryCommand = new MySqlCommand(dynamicQueryWithParameter, conn)) { dynamicQueryCommand.Parameters.Add("@pName", MySqlDbType.String); dynamicQueryCommand.Parameters["@pName"].Value = "John"; using (MySqlDataReader dynamicQueryReader = dynamicQueryCommand.ExecuteReader()) { string output = ""; object[] values = new object[dynamicQueryReader.FieldCount]; while (dynamicQueryReader.Read()) {…
I am using mysql-connector-c++-8.0.33 and C++ code to connect to database. Here is the code, try { sql::Driver *driver; sql::Connection *con; sql::Statement *stmt; sql::ResultSet *res; sql::ConnectOptionsMap connection_properties; driver = get_driver_instance(); connection_properties["hostName"] = "localhost"; connection_properties["userName"] = "correctusername"; connection_properties["password"] = "correctpassword"; connection_properties["schema"]…