I am trying to get the ids of the customers who have placed orders on consecutive days. The table is created as follows: create table orders( orderid INT, orderdate date, customerid int ); The values: insert into orders (orderid, orderdate,…
I want to create a dynamic_view using a stored procedure for the following scenario. Table1 has three columns (id, name, operations), and it has the following three records. id|name|operations ------------------ 1 | a |min,max 2 | b |min,max,avg 3 |…
Create a MySQL procedure to declare a cursor to select last name, first name, salary, and hire date from the EMPLOYEE table. Retrieve each row from the cursor and print the employee’s information if the employee’s salary is greater than…
I have the following MSQL query, that is very slow SELECT a.id, a.date, a.Title, a.Text, a.Text2, a.Text3, b.xxx, b.yyyy, c.aaaa, c.bbbb FROM table_a a JOIN table_b b on a.Id = b.Id JOIN table_c c on a.eeee = c.id ORDER BY…
I have an InnoDB table which looks like this right now: The table is around 126GB big, but I have read that InnoDB's default can hold up to 64 TB of data. Is this correct? I ask because of the…
I have tried to populate the table but not working this is the code. i am creating a small application to insert delete update my customer management system i have the execution for the records table to get the data…
I have two tables in my MySQL database: products and sales. The products table has the following structure: Table: products ------------------------ | id | name | category | ------------------------ | 1 | Product A | Electronics | | 2 |…
I'm literally going crazy. I can't figure out where is the error in the code below whose purpose is to retrieve an image from a database and display it in a frame with id 'img1'. I've tried every way but…
I have a table in MySQL with id column (type varchar) as primary: and filled table: I use Laravel for backend. I created Model for this table and put this code inside Model class: protected $fillable = [ 'id', 'titleEn',…
I need to do bulk insert and update on MySQL so I used the ON DUPLICATE KEY UPDATE. I need to ignore the updated by and updated date fields as existing old data if there are no changes in those…