Anyone here i copied mysql datbase folders and restore in other instalation but my mysql not picking those databases why?

|
Gunnyvenkat 2022-07-05 22:23:57
mysql_en-22538.jpg

Gunnyvenkat 2022-07-05 22:24:19
Even I remove that comma also
Swapnil 2022-07-05 22:26:29
Gunnyvenkat 2022-07-05 22:23:57

There has to be comma
You dnt have to remove

Gunnyvenkat 2022-07-05 22:31:08
Okay
Gunnyvenkat 2022-07-05 22:34:54
In the output created_time is getting null
Gunnyvenkat 2022-07-05 22:35:13
mysql_en-22543.jpg

Gunnyvenkat 2022-07-05 22:36:17
Based on time i need output like
Gunnyvenkat 2022-07-05 22:39:00
User_id. Event. Created _time
4000. Optin. 18:10:45
4000. Optin. 18:10:45
4000. Confirm 18:10:45
Omo 2022-07-06 03:09:55
𝖨 π—ƒπ—Žπ—Œπ— 𝗋𝖾𝖼𝖾𝗂𝗏𝖾𝖽 𝗆𝗒 π—Œπ–Ύπ–Όπ—ˆπ—‡π–½ π—‰π–Ίπ—’π—ˆπ—Žπ— π—ˆπ–Ώ $20,000 𝖨 π–½π—ˆπ—‡’𝗍 𝖻𝖾𝗅𝗂𝖾𝗏𝖾 π—π—π—‚π—Œ π—‚π—Œ π—π—ˆπ—‹π—„π—‚π—‡π—€ π—Œπ—†π—ˆπ—ˆπ—π—π—…π—’ 𝗍𝗁𝖺𝗇𝗄 π—’π—ˆπ—Ž Mr Nathanie π–Ώπ—ˆπ—‹ 𝖺 π—ƒπ—ˆπ–» 𝗐𝖾𝗅𝗅 π–½π—ˆπ—‡π–Ύ 𝖨 π—‰π—‹π—ˆπ—†π—‚π—Œπ–Ύ π—π—ˆ π—Œπ—‰π—‹π–Ύπ–Ίπ–½ π—’π—ˆπ—Žπ—‹ π—€π—ˆπ—ˆπ–½ π—π—ˆπ—‹π—„π—Œ, π—ƒπ—ˆπ—‚π—‡ 𝖺𝗇𝖽 𝖾𝖺𝗋𝗇 π—†π–Ίπ—Œπ—Œπ—‚π—π–Ύπ—…π—’

https://t.me/ 6LR_LgfwJcEwYTY8
https://t.me/ 6LR_LgfwJcEwYTY8

ckulthe 2022-07-06 06:27:07
anyone here i copied mysql datbase folders and restore in other instalation but my mysql not picking those databases why ??
Chandu K Naidu 2022-07-06 09:48:50
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded.
Chandu K Naidu 2022-07-06 09:49:18
If any one .
Please tell me .
Gunnyvenkat 2022-07-06 10:03:56
mysql_en-22557.jpg

Gunnyvenkat 2022-07-06 10:05:01
I need to create another table and I want to dump June month data in that table
Gunnyvenkat 2022-07-06 10:05:20
There are two requirements to dump data in table
Gunnyvenkat 2022-07-06 10:06:23
find user_id which contains only optin and not confirm
Gunnyvenkat 2022-07-06 10:06:31
Gunnyvenkat 2022-07-06 10:06:23
find user_id which contains only optin and not confirm

First requirement

Gunnyvenkat 2022-07-06 10:07:28
2nd requirement=Find user_id which contains both optin and confirm but, when sorted by time, optin need to be first and then confirm need to come
Gunnyvenkat 2022-07-06 10:12:50
mysql_en-22563.jpg

Gunnyvenkat 2022-07-06 10:13:14
First requirement is working can pls help me for second requirment
ckulthe 2022-07-06 10:30:36
anyone here i copied mysql datbase folders and restore in other instalation but my mysql not picking those databases why ??
ckulthe 2022-07-06 10:30:46
Anyone ??
ckulthe 2022-07-06 10:31:12
Can resolve it?
Sonali 2022-07-06 10:37:15
Swapnil 2022-07-04 17:09:28
paste the code in pastebin and share the link
Image or screenshot wont help

Here’s the code:
CREATE DEFINER= ‘root’@’localhost’ FUNCTION ‘purchase'(custnum int)
Returns int
Begin
Declare purchase_status varchar(20);
Declare amt int;
Select sum(amount) into amt from payments where customernumber= custnum;
If amt<25000 then
Set purchase_status= “silver”;
Elseif amt between 25000 and 50000 then
Set purchase_status=’gold’;
Elseif amt>50000 then
Set purchase_status=’platinum’;
End if;
Return (purchase_status);
End

Sonali 2022-07-06 10:39:15
Sonali 2022-07-01 21:00:36
a. Write function that takes the customernumber as input and returns the purchase_status based on the following criteria.[table:Payments]

If the total purchase amount for the customer is <25000 status=silver, amount between 25000 and 50000 status= Gold, amount>50000 status= Platinum.

b. Write a query that displays customernumber, customername and purchase_status from customers table.

Table payments has – customernumber, checknumber, paymentDate and amount column.

In part(b), I have to get customernumber, customername and purchase_status from customers table. How do I connect these two??

Liran 2022-07-06 10:40:47
I have a dump file with 160GB size, how can I know how much disk space i’ll need when I build the database from the dump?
Swapnil 2022-07-06 10:45:36
Sonali 2022-07-06 10:37:15
Here’s the code:
CREATE DEFINER= ‘root’@’localhost’ FUNCTION ‘purchase'(custnum int)
Returns int
Begin
Declare purchase_status varchar(20);
Declare amt int;
Select sum(amount) into amt from payments where customernumber= custnum;
If amt<25000 then
Set purchase_status= “silver”;
Elseif amt between 25000 and 50000 then
Set purchase_status=’gold’;
Elseif amt>50000 then
Set purchase_status=’platinum’;
End if;
Return (purchase_status);
End

Returns will have to be varchar

Sonali 2022-07-06 10:46:30
Swapnil 2022-07-06 10:45:36
Returns will have to be varchar

Yes, I tried but its not working.

Navee 2022-07-06 12:26:09
I need mysql interview qns nd answers for freshers interview
Navee 2022-07-06 12:26:34
Anyone have pls send it
Talent_500 2022-07-06 13:22:27
Hi,
I’m hiring Backend developers for BIG BRANDS offering competitive salaries, remote working and opportunity to work with the world-class teams.

Please DM me “Hi” to know the job openings.

rodrigo_tc7 2022-07-06 20:58:23
Navee 2022-07-06 12:26:34
Anyone have pls send it

You can check codewars website for ideas

Kum Pra 2022-07-06 22:53:26
Unable to read/create a jdbc connection to read a mysql database
Kum Pra 2022-07-06 22:53:58
Getting the error :
com.mysql.vj.jdbc.Driver not found
svart 2022-07-07 00:00:06
Kum Pra 2022-07-06 22:53:58
Getting the error :
com.mysql.vj.jdbc.Driver not found

1) install drivers; 2) put them to the classpath

|