And while inserting data in a table, I am able to insert INT type data in VARCHAR type column, how so?

|
Sree 2022-05-11 19:14:01
mysql_en-20559.jpg
Can anyone help me , what the syntax error is ?
Actually i wanted to insert data at a time !
svart 2022-05-11 21:11:37
Liran 2022-05-11 17:01:59
log_error = /var/log/mysqld.error.log
but mysql stopped writing logs to this. how to fix this?

Check mysql -e “show variables” for logerror

myid_3008 2022-05-11 21:17:07
Sree 2022-05-11 19:14:01
Can anyone help me , what the syntax error is ?
Actually i wanted to insert data at a time !

desc employees;

Liran 2022-05-12 00:54:55
how can I kill many processes? when I run:

kill 1;
kill 2;

if 1 is already finished it won’t run the next one. how can I do this?

Grv 2022-05-12 05:07:58
Sree 2022-05-11 19:14:01
Can anyone help me , what the syntax error is ?
Actually i wanted to insert data at a time !

Quotes being missing in id,salary,mobile number

Grv 2022-05-12 05:09:07
Liran 2022-05-11 17:01:59
log_error = /var/log/mysqld.error.log
but mysql stopped writing logs to this. how to fix this?

Check if the logs are turned on

adinath_kamode 2022-05-12 05:56:13
Hi,Has anyone observed decrease in write performance on mysql rds after migration to UTF8MB4? Issue is not reproducible in Dev QE or on perf testing setup, however prod has become suddenly slow. The only change was that the increased size of Max allowed packets to 400MB and converted to UTF8MB4. Mysql 8.0.25. any pointers?
Harsha Reddy 2022-05-12 09:56:16
mysql_en-20574.jpg

G JithenderReddy 2022-05-12 11:22:49
G JithenderReddy 2022-05-11 15:09:31
1.Every year 15 causal leaves
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

Anish Narayan 2022-05-12 11:47:02
https://www.quora.com/An-application-is-using-a-100-GB-MySQL-database-that-is-to-be-migrated-into-AWS-What-are-the-factors-to-be-considered-when-deciding-whether-to-host-the-database-on-PDS-for-MySQL-or-Aurora/answer/Sachin-Jadhav

An application is using a 100 GB MySQL database that is to be migrated into AWS. What are the factors to be considered when deciding whet…Quora
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…

Sree 2022-05-12 13:16:37
Grv 2022-05-12 05:07:58
Quotes being missing in id,salary,mobile number

Those are integer values , we can’t give quotes
Only for string type we use it !

Anish Narayan 2022-05-12 14:30:09
https://www.quora.com/What-is-the-SQL-query-to-print-dates-starting-from-January-1-2022-to-December-31-2022-from-a-table-named-details

What is the SQL query to print dates starting from January 1, 2022 to December 31, 2022 from a table named ‘details’?Quora
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…

Sam093737 2022-05-12 17:51:32
SQL pl-SQL full course video are available ping
PriyaJeevan18 2022-05-13 15:26:29
Hello all,
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 ?

sruthi soul 2022-05-13 16:31:29
Mysql
Sam093737 2022-05-13 16:36:30
Oracle SQL pl-SQL full course video are available
Sam093737 2022-05-13 16:36:43
With matrial
Daniel Regueiro 2022-05-14 00:16:12
Hello everyone, I am trying to use trigger to copy a new user from domain1 to domain2, (mysql) I had 2 tables on the same server, and I did the update without problem, bud for some reason the trigger AFTER INSERT is not working, somebody can tell me what I am missing?

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)

Grv 2022-05-14 06:29:02
Check if the insert trigger is there
ParagKumarDevGoswami 2022-05-14 20:41:30
Hello everyone, I am new here. I have a question regarding MySQL. Can anyone please help me to find out the answer?
Tony 2022-05-14 20:52:43
ParagKumarDevGoswami 2022-05-14 20:41:30
Hello everyone, I am new here. I have a question regarding MySQL. Can anyone please help me to find out the answer?

just ask

Adi 2022-05-14 23:29:00
I am using UPDATE to update a varchar type coulumn, with a integer. Is it possible?
Adi 2022-05-14 23:53:18
And while inserting data in a table, I am able to insert INT type data in VARCHAR type column, how so?
Grv 2022-05-15 02:11:21
Adi 2022-05-14 23:29:00
I am using UPDATE to update a varchar type coulumn, with a integer. Is it possible?

Yes

Grv 2022-05-15 02:11:48
Adi 2022-05-14 23:53:18
And while inserting data in a table, I am able to insert INT type data in VARCHAR type column, how so?

Because it is being converted into a string

Bishnu81 2022-05-15 03:17:37
Any body help me how can learn mysql
Sree 2022-05-15 07:11:17
Can anyone tell query to delete duplicate rows
Adi 2022-05-15 10:47:49
Grv 2022-05-15 02:11:48
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?

Grv 2022-05-15 11:07:30
That is converted from mysql
Grv 2022-05-15 11:07:59
If you want to get errors then change sql_mode to strict_all_tables
Adi 2022-05-15 11:18:36
Grv 2022-05-15 11:07:30
That is converted from mysql

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?

Dude 2022-05-15 12:38:30
MySQL uses swap even when there is enough free ram. . Having hard time to figure out why this is happening .. Any advise please . Below are my my settings.

+—————–+———+
| 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

svart 2022-05-15 13:51:01
Dude 2022-05-15 12:38:30
MySQL uses swap even when there is enough free ram. . Having hard time to figure out why this is happening .. Any advise please . Below are my my settings.

+—————–+———+
| 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?

Dude 2022-05-15 14:00:05
svart 2022-05-15 13:51:01
Why did you decide that mysql uses swap?

MySQL is using the swap. . Double checked using swap and other top commands

svart 2022-05-15 14:11:10
Post graphs here
|