I am trying to display two specific persons (a couples income) in a table (by foreach loop PHP). Each person should be shown in a column and the income per row. To connect the couple/persons I have created a table…
I have a MySQL table temp_employee as follows: CREATE TABLE `temp_employee` ( `employee_id` varchar(22) COLLATE utf8mb4_unicode_ci NOT NULL, `application_date` datetime NOT NULL, PRIMARY KEY (`employee_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; And data in the table as follows: employee_id application_date emp.10062808068…
I have a main table called pics that has an ID number and the origin site from which it was pulled from. I also have another table called tags that has a list of all the tags that were also…
I have two tables users and categories. users table has a foreign key linked to categories table. categories table has 2 columns id and name I want to get the value of name when a search_item is sent if(!empty($request->get("search_item"))) {…
I've been trying to make a query more efficient by bringing together counts from multiple tables. I have a schema similar to this: create table "impressions" ( id serial primary key, ip inet, ad_id integer references ad(id), user uuid references…
I have a MySQL dev_table with thousands of products identified by their Name, containing changes to price and availability (among other values) over time. The table contains only the dates where a change occurred. I am looking for an efficient…
The database used is PostgreSQL. I have a query that combines two tables and does a where search on some category and then does order by by some property. The table products has a 10+ million products. If I put…
I have table : CREATE TABLE accounts ( "id" INTEGER, "parrent_account" INTEGER, "merchant_type" VARCHAR(8), "name" VARCHAR(32) ); INSERT INTO accounts ("id", "parrent_account", "merchant_type", "name") VALUES (1, 14056, 'outlet', 'RAA CHA SUKI & BBQ NIPAH MAL'), (2, 14056, 'outlet', 'RAA CHA…
I need your help and I'll try to explain with a simple example. I have Table A: NAME CITY AGE Lucas Dallas 21 John Chicago 30 Tim London 15 and Table B: NAME CITY AGE Lucas Dallas 21 John Chicago…
I am building a custom e-commerce platform for a music store using a client's existing inventory list in which each item has a unique "System ID" (represented by a MySql table inventory). The problem is several "unique" items in the…