I'm trying to connect my MySQL database, set up using this tutorial https://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial-creating-a-model.html Along with creating the model, I created a running server using the tutorial listed in the model tutorial. I've created a table inside of it and populated…
[TABLE 1] shop_name whole_sales_amount A 20000 B 40000 [TABLE 2] shop_name locataion representative_number A NY 1234 A LA 1234 B IL 5678 I want to join Table 1 & Table 2 (I know that the DB table structure is not…
Suppose, we've a table named college. In this database we've the following columns: College ID, College name, State and Established in. Now I want to find the names only of those colleges where the college have another branch in the…
can anybody help? there's a table containing data about games...including: name VARCHAR(255) platform VARCHAR(255) year_of_release YEAR genre VARCHAR(255) publisher VARCHAR(255) na_sales DOUBLE(10,2) other_sales DOUBLE(10,2) global_sales DOUBLE(10,2) when i run this query: select Name, Year_of_Release, Other_Sales, Global_Sales from ( select *…
I have this table, in the left there is the sample input table and on the right desired output How to calculate the number of status per empid basis using SQL on MySQL.
If I have a table A with 1000 rows, and a structurally identical table B but this time with 1000000 rows, will an ALTER TABLE (for example to add two new columns) take longer for table B? If so will…
I'm learning SQL and have come across a problem that needs a self-join. I've been playing around with the query to understand why the self-join table lays it out the way it does, but haven't had much luck Create table…
In mySQL, have a large table of history data and I am looking for an elegant way to be able to select the earliest/latest event types in a single select statement without grouping by Item and Event type and running…
Is there an elegant way to create two date variables in php or mySQL. Essentially I have a query that needs to be run covering 1st October to 30th September the following year, so right now it would be 1st…
I have this JSON data, which I got from an API: [ { "guide_id": 1, "uuid": "AAAA" }, { "guide_id": 2, "uuid": "BBBB" }, { "guide_id": 3, "uuid": "CCCC" }, { "guide_id": 4, "uuid": "DDDD" } ] I have data…