What is the parameter on which you want to judge an table as unwanted?

|
Swapnil 2022-08-04 08:25:04
Create a query or stored procedure that would insert records from last 24 hours of production into dev.
Create a job for same and schedule this job to run on daily basis may be everyday at 12 am
sara sara 2022-08-04 09:09:29
mysql_en-23510.jpg
Hello, this field should be here as well, right? So which one?
sara sara 2022-08-04 09:09:42
mysql_en-23511.jpg

Hybriddev 2022-08-04 10:10:08
Hiii
Z2305597884 2022-08-04 12:53:05
你们好
Z2305597884 2022-08-04 12:53:25
你们学习java吗
smlkw 2022-08-04 12:59:18
please, use English here
Swapnil 2022-08-04 13:04:26
This are Bitcoin people
smlkw 2022-08-04 13:04:59
they ask for learning of Java
Z2305597884 2022-08-04 16:37:58
ok
gaurav kumar 2022-08-04 16:38:24
Hiii i have problem in my SQL query giving syntax error . Please help me
Z2305597884 2022-08-04 16:41:07
why is it?
Z2305597884 2022-08-04 16:41:27
Let me see it
Swapnil 2022-08-04 16:42:10
What is the error ?
Z2305597884 2022-08-04 16:48:13
Yes.If you want to solve this error, you first send a photo to us.
Lopuma 2022-08-04 18:10:32
Hi
I’m trying to run this query and it doesn’t work IF EXISTS (SELECT * FROM users WHERE email=’admin@mail.com’) DELETE FROM
users WHERE email=’admin@mail.com’;
Error
mysql> IF EXISTS (SELECT * FROM users WHERE email=’admin@mail.com’) DELETE FROM
users WHERE email=’admin@mail.com’;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘IF EXISTS (SELECT * FROM users WHERE email=’admin@mail.com’) DELETE FROM users W’ at line 1
mysql>
Z2305597884 2022-08-04 18:15:41
What do you want to do?
Z2305597884 2022-08-04 18:15:59
Copy a table?
Swapnil 2022-08-04 18:18:32
After if exists clause you are missing then word just add that and this query should work fine.
Also inside if exists select * should not come instead use select 1
Code Sample:
IF EXISTS (select 1 from ..)
then
Delete ..
End If
Krishna Sarath 2022-08-04 18:47:05
I want MySQL support
Swapnil 2022-08-04 19:03:49
Query or admin part ?
V9000000 2022-08-04 19:06:46
I can support
Dwijendra 2022-08-04 19:12:59
Any resources to learn mysql stored procedures, function… It would help me to learn concept clearly
suricruise1 2022-08-04 19:36:29
Yes i have
Krishna Sarath 2022-08-04 20:04:16
Swapnil query part
Krishna Sarath 2022-08-04 20:05:02
Share your number
Swapnil 2022-08-04 20:08:36
Please go ahead and share ur doubt
Krishna Sarath 2022-08-04 20:09:25
I need query optimization to sp
Swapnil 2022-08-04 20:22:43
Provide proper details will try help you
Krishna Sarath 2022-08-04 20:23:34
Okay ji and what is table pumping in MySQL
~Arya 2022-08-04 21:17:01
Hey! Can anyone help me out with MySQL workbench.
Actually I am trying to import CSV file by using Import wizard which have approx 50k rows but when I am importing it then only 8 rows are showing in the table.

Can anyone help me in this?🙁

Krishna Sarath 2022-08-04 21:42:22
How to find unwanted tables in MySQL
Swapnil 2022-08-04 22:35:14
What is unwanted table??
Swapnil 2022-08-04 22:35:34
what is the parameter on which you want to judge an table as unwanted ?
P M 2022-08-05 01:06:20
I need help installing MySQL in MAC on Intel
|