Can anyone help me , what the syntax error is ?
how can I kill many processes?
how can I do this?
Hi,Has anyone observed decrease in write performance on mysql rds after migration to UTF8MB4?
What kind of actions I have to do for this ?
Can anyone please help me to find out the answer?
And while inserting data in a table, I am able to insert INT type data in VARCHAR type column, how so?
Ok, so if I try to enter a STRING type data in INT type column, it will not get converted from string to INT type right?
Why did you decide that mysql uses swap?

Can anyone help me , what the syntax error is ?
Actually i wanted to insert data at a time !
but mysql stopped writing logs to this. how to fix this?
Check mysql -e “show variables” for logerror
Actually i wanted to insert data at a time !
desc employees;
kill 1;
kill 2;
if 1 is already finished it won’t run the next one. how can I do this?
Actually i wanted to insert data at a time !
Quotes being missing in id,salary,mobile number
but mysql stopped writing logs to this. how to fix this?
Check if the logs are turned on

2.We are diving the leaves for Quarter wise
Quater 1 = jan to march = 4 leaves
Quarter 2= April to june = 4 leaves
Quarter 3 = july to September=3 leaves
Quarter 4 = October to December = 4 leaves
If any employee used the leaves the leave balance should be deduct from actual leaves.
If not used the leaves should be carry forward to next quarter.
If anyone joins mid of the Quarter we can apply the leaves as per the condition.
Can anyone do this
Answer (1 of 3): There are a few key factors to consider when deciding whether to host a 100 GB MySQL database on Amazon Relational Database Service for MySQL (PDS for MySQL) or Amazon Aurora:
1. Cost: PDS for MySQL is less expensive than Aurora.
2. Performance: Aurora is faster and more scalab…
Those are integer values , we can’t give quotes
Only for string type we use it !
Answer: In SQL you can use the WHERE clause to filter data.
In your case, if you want to filter data from Details table between the date range Jan 1, 2022, to Dec 31 2022 this is how you can use it alongside BETWEEN clause. (in Oracle SQL)
[code]SELECT *
FROM DETAILS
WHERE date_column — Add y…
I am facing “got timeout reading communication packets and got timeout writing communication packet ” warning in MySQL
What kind of actions I have to do for this ?
INSERT INTO mysqlserver_prueba.wpfp_users (ID,user_login,user_pass,user_nicename,user_email,user_url,user_registered,user_activation_key,user_status,display_name) VALUES (NEW.ID,NEW.user_login,NEW.user_pass,NEW.user_nicename,NEW.user_email,NEW.user_url,NEW.user_registered,NEW.user_activation_key,NEW.user_status,NEW.display_name)
just ask
Yes
Because it is being converted into a string
But I am entering, name=9, not name=’9′ , so how can it be converted to string?
Ok, so if I try to enter a STRING type data in INT type column, it will not get converted from string to INT type right?
+—————–+———+
| Variable_name | Value |
+—————–+———+
| key_buffer_size | 8388608 |
+—————–+———+
+——————-+———+
| Variable_name | Value |
+——————-+———+
| query_cache_limit | 1048576 |
+——————-+———+
+——————+———+
| Variable_name | Value |
+——————+———+
| query_cache_size | 1048576 |
+——————+———+
+—————————-+——-+
| Variable_name | Value |
+—————————-+——-+
| table_open_cache | 2000 |
| table_open_cache_instances | 16 |
+—————————-+——-+
+————————-+————-+
| Variable_name | Value |
+————————-+————-+
| innodb_buffer_pool_size | 32212254720 |
+————————-+————-+
+—————–+——-+
| Variable_name | Value |
+—————–+——-+
| max_connections | 25000 |
+—————–+——-+
I have 68 gigs of RAM and 36 core CPU and vm.swappiness set to 5
+—————–+———+
| Variable_name | Value |
+—————–+———+
| key_buffer_size | 8388608 |
+—————–+———+
+——————-+———+
| Variable_name | Value |
+——————-+———+
| query_cache_limit | 1048576 |
+——————-+———+
+——————+———+
| Variable_name | Value |
+——————+———+
| query_cache_size | 1048576 |
+——————+———+
+—————————-+——-+
| Variable_name | Value |
+—————————-+——-+
| table_open_cache | 2000 |
| table_open_cache_instances | 16 |
+—————————-+——-+
+————————-+————-+
| Variable_name | Value |
+————————-+————-+
| innodb_buffer_pool_size | 32212254720 |
+————————-+————-+
+—————–+——-+
| Variable_name | Value |
+—————–+——-+
| max_connections | 25000 |
+—————–+——-+
I have 68 gigs of RAM and 36 core CPU and vm.swappiness set to 5
Why did you decide that mysql uses swap?
MySQL is using the swap. . Double checked using swap and other top commands