I am using laravel and mysql ,i am joining two tables based on conditions it's working fine but my requirement was i have to fetch those details inside json ,can anyone give me some idea how to proceed with this…
https://i.stack.imgur.com/0yDsf.png year month no_of_people avg 2005 1 Overall 8 2005 2 Overall 5.0 2005 3 Overall 2.7 2005 4 Overall 4.1 2005 5 Overall 6.8 2005 6 Overall 5.2 2005 7 Overall 4.7 2005 8 Overall 4.4 2005 9 Overall…
I want to create a MySQL syntax to select a field based on a variable, what I have is: book_category = "science" mycursor_a.execute(("SELECT {book_categories} FROM research_papers WHERE book_Name = %s", (book,)).format(book_categories = book_category)) but I get the following error: AttributeError:…
Let's say I have a model called Research. Each research belongsToMany Location models. And each Location model BelongsToMany Contact models. BUT, each Contact is also related to Research. class Research extends Model { protected $table = 'researches'; public function locations()…
EDITED: I am trying to CASE a query from my table when a result meets 2 sets of criteria (Flight Time & Tail Number), but I am receiving the wrong result. I only started SQL a few weeks ago for…
I have a table like sales(product_number, assortment, date) Here 1 assortment contains multiple products. For example 1 assortment i.e. chocolates contains product_number cadbury, 5 star, kitkat etc. Each and every product has date. I'm trying to check that all products…
I have two table with relation, defined in model and migration but when I delete the parent data the child do not delete automatically User model class User extends Authenticatable implements MustVerifyEmail { use Notifiable; use Friendable; use HasApiTokens; public…
I am trying to write a query that returns list of customer names that do not start or end with letter "A" (either in upper case or lower case). Following is my query, SELECT * FROM Customers WHERE CustomerName IN…
I have a project build with Laravel 8. My project will use for creating dynamic report that run with SQL query. So i must save the SQL query in my database to run dynamic every report. It's all fine since…
I have a mysql table with the following columns- Date, country, YEAR, MONTH, supercategory, class, corp_manufacturer, brand, license,item_description,amount, units, arp. Total number of records = 7.1 million Now i want to add a new column which shows the max value…