Very new to coding. I have 2 tables, zips_usa which includes all properly formatted zips (zipcode, lat / lon / city / state etc) in the US, and table ageus which includes columns such as first name, last name, category,…
I have a MySQL query that searches through a zipcode database for city names. The query takes about 4 seconds, to search through 620,000 zipcodes. I would like ideas how I can make this faster. First, the tables: I have…
Question Imagine having the following PostgreSQL table: CREATE TABLE setting ( user_id bigint PRIMARY KEY NOT NULL, language lang NOT NULL DEFAULT 'english', foo bool NOT NULL DEFAULT true, bar bool NOT NULL DEFAULT true ); From my research, I…
Select one if the image name is found in any column. name | col1 | col2 ----------------------------- Jack | img_3.png | img_1.png Jack | img_2.png | img_2.png Jack | img_3.png | img_1.png John | img_4.png | img_3.png Now, What I…
I'm having trouble manipulating certain information in a Select. I've tried a few ways but with no positive result. Select: select cpri.sequential, cpri.id, coalesce(sum(pdr.something), 0) something, ... from cpri inner join cpr on cpr.id = cpri.id left join pdr on…
I had to get the town name and state from database which deployed the first reciever(a device to sense sharks). I used the following query with a subquery computing MIN of deployed dates: SELECT t.town,t.state,r.deployed FROM receiver as r inner…
I have the following situation: A user can have maximum number of partnerships. For example - 40.000 Question: In case user wants to add a new partnership, how it will be faster to check the current number of partnerships ?…
I have a relation in a database as follows: constituents Symbol [{"weight":0.5, "ticker":"WPM"},{"weight":0.5, "ticker":"AEM"}] GLD [{"weight":0.5, "ticker":"XYZ"},{"weight":0.5, "ticker":"ABC"}] KLE [{"weight":1.0, "ticker":"TSLA"}] TSLA [{"weight":1.0, "ticker":"MSFT"}] MSFT [{"weight":0.4, "ticker":"XYZ"},{"weight":0.6, "ticker":"ABC"}] KLE [{"weight":0.3, "ticker":"BBBY"},{"weight":0.7, "ticker":"GME"}] MEME I want to get the distinct symbols…
I have names table with columns id, name and last_name. So what i'm trying to do is select random name and last_name from it, i tried this: SELECT (SELECT name FROM names WHERE ID =floor(random()* 18 + 1 + x…
I have table names with name and surname columns. I want to grab random name and surname from it, i tried this, but it takes one name and surname and prints it 100 times so it makes only one select…