I have a query with lots of JOIN and selected fields.
SELECT t1.field1, t2.field2, .... t8.field8
FROM table1 t1
LEFT JOIN table2 t2
LEFT JOIN table8 t8
WHERE t1.fieldX = ?
ORDER BY ...
I am having some trouble while migrating data from SQL Server to MySQL--it seems some data does not want to place nice. I am recieving the error: Incorrect string value: '\xA0\xA0' for column '...
I am creating app with ExpressJS and want to use MySQL with password, but I have problem with connection string
in this string where to specify password to connect to ...
I tried to check what is consumming my Disk Space on Centos 7, I found these 2 database file:
I would like to delete them. ...
It would be convenient for me to whitelist a server so that anyone with the username and password can connect to it remotely? Is this possible? I do understand this is horrible for security purposes ...
Is there a way to get a notification when a row in a table is created or updated? Much like RethinkDB's change feeds.
Anything would work really - a message on a WS channel, or a HTTP request with ...
I am trying to implement some parts of MERGE in the MySQL driver in Drupal. Of course, Drupal has something but in truth it only works because the most frequent MERGE issuer just eats exceptions.
My database setup is modern (My)SQL.
I've got a Content Table, including ids.
Now, users should be able to comment on content.
To achieve this, arrays have come to my mind.
Now I see several options ...
I have a query that I want to save as a view because it will be used on a different system that we don't have access to. The query basically gets running balances on debit and credit columns from a ...
Anyone can help me to check this MySql configuration? I have a VPS 32GB RAM - 8 vcpu and running 1 ecommerce
Mysqltuner return me
Variables to adjust:
*** MySQL's maximum memory usage is ...
$query_importer1 = "SELECT item_name FROM items where item_id ='".$row1["item_id"]."' limit 5"; // need to be a space before LIMIT
$result_importer1 = mysqli_query($conn,$query_importer1);
I have a table with about 4 million rows and a bunch of columns on each row and I'm doing a simple select * from table in the mysql client and it doesn't return data right away. A count(*) of the same ...
What is difference between SELECT * FROM table and SELECT * FROM table WHERE 1
SELECT * FROM table
Number of records : 103
Load time : 0.0005 sec
SELECT * FROM table ...
When I telnet to a MySQL DB, the connection gets dropped quickly. Should I increase the interactive_timeout or the wait_timeout?
(Background: trying to keep SSH port forwarding alive on 3306)
I would like to create a backup of different MyISAM tables on a server using mysqlhotcopy. These tables are about 6GB in size. I would like to know, does mysqlhotcopy block users from SELECTing (...
Hello everyone, I'm really troubled about how to design a database and I could use some help. I've done my research and found nothing about it.
I'm trying to build a simple app for my class that ...
mysql> select count(*) from num;
| count(*) |
| 9918530 |
1 row in set (59.18 sec)
It is horrible, 59.18 sec for just a simple select command!
How to ...
I have table that have the following columns:
id, state_id, name
the id is auto_increment
now I want to insert into it multiple rows at once as following:
insert into tbl (name, state_id)
I am attempting to lock some tables while running some code and unlocking the tables when I am done.
Run Lock Tables MySQL Query.
Run some PHP Code.
Run Unlock Tables MySQL Query.
On MySQL 5.0 on CentOS 5.11, MySQL service has crashed and fails to start. Adding innodb_force_recovery=3 in /etc/my.cnf, creates the following error, which repeats with all table names of database ...
I have 3 three tables, products, discounts, and discounted_products:
products stores title, desc, price and etc information about products;
discounts stores discounts' start date, end date, and status;...
I have a lot of tables in my database and some of them are beginning with a prefix "amb_"
Any Idea how to select all tables who are ...
I had a problem on my MySQL server, where creating tables/databases is really slow (had to wait a couple of hours), so I reinstalled the server and MySQL from scratch, but the problem didn't go away.
I have a database folder from a crashed server called gain_wordpress. I'm trying to put that database on a new server but I'm not able to do it successfully. I don't have a .sql dump, all I have is ...
I seem to have the following error:
Lost connection to MySQL server during query
However, I know for absolute fact that this is not about the wait_timeout nor the max_allowed_packet, as I've set ...
I'm working on some dead-lock troubleshooting, particularly involving a row-swap.
Currently the statements look like this, all running under the same transaction:
SELECT IDENTIFIER FROM tables WHERE ...
I have a few questions related to MySQL security.
How do we backup the data in MySQL database? I know there's an output function where you can export your data in the db as sql statements. Is this ...
I have two tables, one table stores the GPS data of various users and another table stores the idle time of the users based upon the GPS latitude and longitude values and timestamp difference.
I want to permit access to a mysql server over IPv6 and limit access to the particular account to our ULA subnet we are using (fdd7:03d7:6247::/48).
The manual seems to suggest that wildcards are ...
If I understand SELECT ... LOCK IN SHARE MODE correctly, you can place it into a mysql transaction to select the rows you will be working with during that transaction.
This is done in order to "lock ...
Using 5.6.35 MySQL Community Server (GPL). I have setup the local MySQL instance as follows
show variables like '%slow%query%log%'
We are migrating our system to a cloud environment (AWS), and have been given new client requirements for having our MySQL data-at-rest encrypted.
Currently it is unclear how far this should go. It ...
I tried moving MySQL data directory to an external Hard disk (which has been formatted using NTFS).
I followed the steps given in the answer to the question How to change MySQL data directory?
We have some web applications based on databases using utf8mb4 as character set and utf8mb4_Standard as collation.
We saw that we can use any character we want with this setting.
In SQL Server ...
I have a relation in a MySQL database with the following schema
Data(x: INTEGER, y: INTEGER, value: INTEGER)
The combination of (x, y) is unique and spans from 0 to 100.
Is it possible to combine ...
Where is the cache for the new default authentication plugin caching_sha2_password in MySQL 8 stored? I want to know for future reference how to clear it in case I ever run into any problems using it.
I am using MySQLi for my webapp but whenever I want to visit some particular page, I get mysqli_connect() [function.mysqli-connect]: (42000/1203): User ***_user already has more than '...
I am looking to perform real-time I/O encryption and decryption on MySQL 5.6 Database. I have few questions to understand Transparent Date Encryption (TDE):
Note: I am using AlibabaCloud
Can I ...
I've been trying to get two databases in docker containers to replicate. I've been working off this article:
I am facing issues with my table structure :
CREATE TABLE `My_Table_Name1` (
`twitter_id_str` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
This problem starts after connect a new slave to my master replication server.
All servers have
16 GB Ram available
12 GB RAM for innodb_buffer_pull_size
my.cnf (only ...
Consider I have a master on DC1 and slave on DC2. Now, DC1 network is completely down for indefinite time and I want to resume the service as soon as possible on DC2 by promoting the slave to master.
I have two tables, users and scores
| id | name |
| 1 | John |
| 2 | Jane |
| 3 | Clarke |
I do have a DB on MySQL Galera 5.6.34 with a table that contains an index on ID,date. The table is fully functional and I have used repair and check to verify the table. However, upon backup/restore ...
I have the following table definition:
CREATE TABLE `invite` (
`id` varchar(255) CHARACTER SET utf8 NOT NULL,
`email` varchar(255) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `...
In MySql, is better to do 1 select to all the table and then filter in the backend or do 2 selects that retrieve a half of the table each and not filter in the backend?
I am issuing a relatively simple SQL query in my C# app:
select * from myTable where myValue > 10 order by myValue;
There are ~180 million rows in the table and there is an index on myValue. When ...
I have an xml with 2 columns value in numbers. First column categories and second column for sub categories. How import in categories Woocommerce?
I want to find an efficient way to represent the JSON objects below. I made an ERD diagram to represents the JSON objects. This diagram below is a small piece within a much larger structure. There ...
I have this query:
, Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
Does this query ...