I have two tables (see below) in a postgreSQL database. Table1 tracks all changes made to each ID (i.e. multiple rows per ID): create table table1(id,record,name,data1,data2,data3)as values (1,1,'Dave', 1.2,55,1) ,(1,2,'David', 1.2,55,1) ,(2,1,'Sam', .8,30,2) ,(3,1,'Jenn', .9,28,2) ,(4,1,'Arthur',1.1,77,1) ,(5,1,'Jim', .7,42,2) ,(5,2,'Jimmy', .7,42,2)…
I am trying to generate random serial numbers in PostgreSQL with some conditions. The numbers need to start with the same 3 letters, YAK. After YAK, there needs to be 8 random digits. I only need to do 10 iterations…
How can I find all rows in a table of data, which are relative to the result of some calculation between data from rows in another table? (As an example, for an eshop, I want to find all products (rows)…
I'm trying to come up with a query that will pull the total quantity of an item from its first ever order. I understand how to pull out each item and their first order number was, but I'm trying to…
I have a table Users with id, this table has a million records or more. So when fetching data from the table I am using batching with offset & limit to reduce load on my server. My question is if…
I am trying to learn the best methods to grant user privileges on database CREATE USER IF NOT EXIST `'silas'@localhost'` IDENTIFIED BY '1234' GRANT ALL PRIVILEGES ON *.* TO 'silas'@'localhost'; or GRANT ALL PRIVILEGES ON `my_db.*` TO `'silas'@'localhost'`; I am…
When I run this following select query on the command line in Mysql: SELECT date_sent FROM books; I get this sort of result (eg) | 2024-10-06 | but if I run the same select query from inside python: # Select…
I have a table that stores data about events with id, start_timestamp (timestamp with time zone), end_timestamp (timestamp with time zone) and duration (in seconds): create table my_table( id bigint generated by default as identity primary key , start_timestamp timestamptz…
I have a table like this: ID score1 score2 score3 score4 score5 score6 score7 1 6 6 7 7.5 6.5 7 5 2 9 8 7 8 7 8.5 7.5 3 7 7 7 7 7 7 7 I want…
I am using this php code for MySQL database query: function search_it() { if ( isset( $_GET['s'] ) ) { global $wpdb; $address_table = $wpdb->prefix . 'my_products'; $search = $_GET['s']; $search = trim($search); $keywords = explode(" ", $search); foreach($keywords as…