I have two MySQL tables. One is a large list of entries which is basically the main table. The second is a table of pending entries, that will ultimately get added to the large list of entries if they're approved…
I want to add or insert thousands commas in between digits of a number as long as I input digits like some calculators (see the image). For example, when I begin inputting the digits 793, the code inserts automatically a…
I am creating a "log" system and for this, trigger would be the best way to go I think. The thing is I have a header table (table1) and a line item table (table2). I created 2 new tables (table1log)…
I work with XYZ PHP Code WordPress plugin. Why this code dont't work? Table structure: id (int, AI), name (varchar), mail (varchar), message(varchar), date (datetime) if(isset($_POST['add']) && $_POST['name'] && $_POST['mail'] && $_POST['message']) { global $wpdb; $name= $_POST['name']; $mail= $_POST['mail']; $message=…
I have data in a table called "assignedwork_tb". I want to delete the entry from "assignedwork_tb" table which is equal to the current session's "Request_ID" (Request_ID is the primary key of "assignedwork_tb" table). In the same time, I want to…
I know there are a lot related questions with many answers, but I have a bit of a more nuanced question. I have been doing reading on different insert techniques for mass records, but are there limits on how big…
i want to insert values in a table by using procedure i have 2 tables sales and products in a product table i have id , product_name,product_price, product_quantity and in sales table i have p_id and p_qty by using procedure…
I am partially new to Flutter. I am trying to achieve a Dialog which carries an expandable grid of images (images to be added by the user), and every time the user adds an image (using the add/plus button) the…
Basicly I have a table for persons data- tb_person (name,date&time,person_id etc) and other table for meals- tb_meals(meal_id,meal type etc) , I want to insert a value in meal in tb_meals where person_id(from tb_person)= 1 the problem is that it is…
I'm trying to connect to mongodb, and then insert a document called data, I can see on my cluster that I connect, but no data gets inserted. I don't get any errors either. Here's my code: const {MongoClient, ServerApiVersion} =…