Usually, if conditions are not required in our query statements, we don't use a WHERE clause. But I've seen a WHERE 1 clause being used in many places, even where other conditions are not present.
Why is this done?
Are there specific benefits to…
If I have a table that looks like this
CREATE TABLE foo (
id INT NOT NULL AUTO_INCREMENT,
aa INT NOT NULL,
bb INT NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY (aa, bb),
CONSTRAINT aa_ref FOREIGN KEY (aa) REFERENCES bar (id),
…
I'm receiving an error ERROR 1137 (HY000) at line 9: Can't reopen table: 'temp_table' when executing a query similar to the following:
USE database_name;
CREATE TEMPORARY TABLE temp_table (status varchar(20));
INSERT INTO temp_table (status)
…
I have 4 servers which has it's own MySQL server along with databases and users.
Now we have a new server dedicated only for MySQL and we would like to merge those MySQL servers into this new one.
What is the most efficient way to move those MySQL…
I have a list of row to be converted into a dynamic column that depends on the record in one particular column.
From this statement
FID |Steps | Action
---- |------|--------
1416 | 1 | Sit
1416 | 2 | Run
1416 | 3 | Jump
1416 | 4 …
I have one query that runs a SUM statement based on daterange 1, and worked fine, and another query that run same SUM statement, but on a different date range. I would like to merge/combine the two queries in one but I don't know how.
This is my…
I have a complex query including join of 4-5 tables. 1 months back, I have optimized this query and it was using the index. Also, two months back, index of all tables had been rebuilt by just export and import the database. Just few days back, I…
I'm analyzing a database of login records for a university and I'm trying to write a query that will give me an idea as to how many users are using the labs for short bursts, verse a more extended stay.
I have the query below query, which tells me…
I want to import 3 specific tables from a dump file that contains 270 tables.
The dump file, naveen_ifs_db.sql, is 20 GB.
How do I restore 3 tables from that dump-file using the command line in windows?
I am trying to transfer data from remote Server to localhost through MySQL.
In the remote server I created a database HOD and a table tab.
In the localhost I created the database "HOD" and a table "tab". I also created a stored procedure…
