I am creating a REST API using nodejs , express , MySql server , sequelize I want to save the following object to my database. let dataToSave = { "config": { "id": "1697141843496" "user_id": 27856, "imageurl": "my url", "name": "Ikea",…
I have a Stored Procedure which takes as input a JSON List String in the following format: [{"NOME":"Teste Produto, produo3 AAAAAAAAAAAAA","SKU":"ITAPE000011","IMG":"https://image.com","DESCRICAO":"Produto com total garantia","NCM":"90069190"},{"NOME":"NOV PRODUto dadsad","SKU":"ITAPE006666","IMG":"https://image.com","DESCRICAO":"Produto cadastrado novo","NCM":"85181090"},{"NOME":"Virgula,Produto, produo3 BBBBBBBBBBBBBBB","SKU":"ITAPE445566","IMG":"https://image3.com","DESCRICAO":"Produto Novo","NCM":"12345690000"}] And inside this proc, I'm trying to use two…
I have a list of products, and a list of related products. I know I can retrieve the list of products, then retrieve the list of related products, using two SQL queries. But I need to return the list of…
@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 have a MySQL table that records item with item, make, model & serial number as follows : item table item_name make model serial_no qty Computer HP Pro 300D 123ert34c10 1 Computer HP Pro 400D 123xgt34c110 1 Printer Canon ir1210…
I'm sorry if this is duplicate question, but I could'nt find anything helpful here. So, what I'm trying to do, is to sort the results of my mySQL statement by the position of a query string inside the title field.…
Here is a simple question I got but I want to know if there is anyone could tell me the mechanism behind the distinct and group by in window function. I've read several posts but didn't get any related to…
I have a simple MySQL table which consists of a primary key ID field, a timestamp (integer) field, and a foreign key ID field (device_id). There are indexes on each of these columns: mysql> show indexes from device_heartbeats; +-------------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ |…
I want replace in a column a string of characters with UTF8 characters, using REGEXP_REPLACE and/or REPLACE. $search = mysqli_real_escape_string($id_mysql, $_POST['search']); $new = mysqli_real_escape_string($id_mysql, $_POST['new']); mysqli_query ($id_mysql, "UPDATE table_name SET column_name = REGEXP_REPLACE(column_name, '$search', '$new') WHERE column_name REGEXP '$search'" )…
This is probably really simple, but I've been trying to figure this out for a while, maybe a fresh pair of eyes will/could help. http://sqlfiddle.com/#!9/557e5a/1 I have this table wherein I need to prioritize selecting Accounts that are Chequing first,…