← prev | next →
svart 2022-05-29 22:33:21
Manoj Kumar 2022-05-29 20:18:56
I got 1822 error while trying to give a foreign key
table lacks primary key.
Manoj Kumar 2022-05-29 22:34:11
Yes, got it.
Ruslan_Shade 2022-05-30 09:14:03
hello, anyone can help with promote slave to master on percona db?
KK010208 2022-05-30 09:52:18
Can anyone help?
I am stuck at this problem.
Question:
Write a stored procedure to insert a record into the cancellations table for all cancelled orders.
STEPS:
a. Create a table called cancellations with the following fields
id (primary key),
customernumber (foreign key – Table customers),
ordernumber (foreign key – Table Orders),
comments
All values except id should be taken from the order table.
b. Read through the orders table . If an order is cancelled, then put an entry in the cancellations table.
Swapnil 2022-05-30 10:44:33
KK010208 2022-05-30 09:52:18
Can anyone help?
I am stuck at this problem.
Question:
Write a stored procedure to insert a record into the cancellations table for all cancelled orders.
STEPS:
a. Create a table called cancellations with the following fields
id (primary key),
customernumber (foreign key – Table customers),
ordernumber (foreign key – Table Orders),
comments
All values except id should be taken from the order table.
b. Read through the orders table . If an order is cancelled, then put an entry in the cancellations table.
Insert into cancellation table
select * from order_table
where order = ‘cancelled’
kawusik 2022-05-30 10:55:22
Hi guys, I have a problem with converting my table from utf8 + utf8_general_ci to utf8mb4 + utfmb4_unicode_ci to support emoji to save in my database(MySQL 5.6). I confused because i have data more than VARACHAR(191) and when I converting to utf8mb4 I got Data truncation error. I using InnoDB engine and must to short my VARCHAR(255) to VARCHAR(191) ( 4-byte character encoding in utf8mb4) but I can’t short my column because I already have data > 191 in my table. Does anyone have an idea?
svart 2022-05-30 11:35:46
kawusik 2022-05-30 10:55:22
Hi guys, I have a problem with converting my table from utf8 + utf8_general_ci to utf8mb4 + utfmb4_unicode_ci to support emoji to save in my database(MySQL 5.6). I confused because i have data more than VARACHAR(191) and when I converting to utf8mb4 I got Data truncation error. I using InnoDB engine and must to short my VARCHAR(255) to VARCHAR(191) ( 4-byte character encoding in utf8mb4) but I can’t short my column because I already have data > 191 in my table. Does anyone have an idea?
hey. there is a chat for russian speakers. you can ask your question there using your mother tongue. it would be easier for you to explain what is the issue
kawusik 2022-05-30 11:41:28
svart 2022-05-30 11:35:46
hey. there is a chat for russian speakers. you can ask your question there using your mother tongue. it would be easier for you to explain what is the issue
No, thank you. I do not speak russian in principle. Ukrainian is my native language
kawusik 2022-05-30 11:42:26
If you know the answer to my question, give an answer in English. If you need more information about my problem, let me know
svart 2022-05-30 11:42:27
kawusik 2022-05-30 11:41:28
No, thank you. I do not speak russian in principle. Ukrainian is my native language
as far as i know they are pretty close to each other. i think they will understand ukranian as well
svart 2022-05-30 11:43:02
i can’t even understand what is your issue from what you wrote
kawusik 2022-05-30 11:43:58
In my opinion, everything is clear there
smlkw 2022-05-30 11:44:01
svart 2022-05-30 11:42:27
as far as i know they are pretty close to each other. i think they will understand ukranian as well
No, Russians do not understand Ukrainian
smlkw 2022-05-30 11:45:42
kawusik 2022-05-30 10:55:22
Hi guys, I have a problem with converting my table from utf8 + utf8_general_ci to utf8mb4 + utfmb4_unicode_ci to support emoji to save in my database(MySQL 5.6). I confused because i have data more than VARACHAR(191) and when I converting to utf8mb4 I got Data truncation error. I using InnoDB engine and must to short my VARCHAR(255) to VARCHAR(191) ( 4-byte character encoding in utf8mb4) but I can’t short my column because I already have data > 191 in my table. Does anyone have an idea?
You need to export your data, then create new structures for tables, and then import your data
This way all will be fine
kawusik 2022-05-30 11:48:10
smlkw 2022-05-30 11:45:42
You need to export your data, then create new structures for tables, and then import your data
This way all will be fine
Thank you for your answer, what structures do you mean, could you clarify which tools I should use
smlkw 2022-05-30 11:50:21
kawusik 2022-05-30 11:48:10
Thank you for your answer, what structures do you mean, could you clarify which tools I should use
Do you have phpMuAdmin?
smlkw 2022-05-30 11:50:40
Your structures of tables in the databasee
kawusik 2022-05-30 11:51:02
smlkw 2022-05-30 11:50:21
Do you have phpMuAdmin?
no
smlkw 2022-05-30 11:51:40
kawusik 2022-05-30 11:51:02
no
Then you could export structures using mysqldump command
smlkw 2022-05-30 11:51:50
Have you ever worked with it before?
kawusik 2022-05-30 11:54:08
smlkw 2022-05-30 11:51:50
Have you ever worked with it before?
Unfortunately no
smlkw 2022-05-30 11:55:16
kawusik 2022-05-30 11:54:08
Unfortunately no
Check it out and learn more about this tool
smlkw 2022-05-30 11:55:48
I’ve said above how to solve your problem, you have all you need
suricruise1 2022-05-30 11:56:29
suricruise1 2022-05-30 11:56:30
suricruise1 2022-05-30 11:56:57
What is the query 2nd one
suricruise1 2022-05-30 11:57:14
Any body tell me
kawusik 2022-05-30 12:00:02
smlkw 2022-05-30 11:55:48
I’ve said above how to solve your problem, you have all you need
Ty
B119052_Shashwat_Dev 2022-05-30 12:07:44
B119052_Shashwat_Dev 2022-05-30 12:07:44
trilokinathvishnu 2022-05-30 12:52:08
Anyone using Mysql on docker, I need help on live copying of binary logs
svart 2022-05-30 13:35:56
trilokinathvishnu 2022-05-30 12:52:08
Anyone using Mysql on docker, I need help on live copying of binary logs
You can have at least two options. Use docker volume and configure mysql to write binlogs on it. Alternatively you can consume binary logs with mysqlbinlog or any other third party tool which can consume binlogs
snehakshaylata 2022-05-30 14:02:45
https://www.techonthenet.com/sql_server/and_or.php
SQL Server: Combining the AND and OR Conditions –
TechonthenetThis SQL Server tutorial explains how to use the AND condition and the OR condition together in a SQL Server (Transact-SQL) query with syntax and examples. The AND condition and OR condition can be combined in a SELECT, INSERT, UPDATE, or DELETE statement.
Djspartahcxzoh 2022-05-30 15:48:00
https://t.me/djspartahcxzohworld
Dj Spartah Cxzoh softwares and tutorials world –
TelegramThis channel is for PC softwares, DJ Softwares and tutorials
trilokinathvishnu 2022-05-30 16:06:00
svart 2022-05-30 13:35:56
You can have at least two options. Use docker volume and configure mysql to write binlogs on it. Alternatively you can consume binary logs with mysqlbinlog or any other third party tool which can consume binlogs
We have docker volume in place
But I want to keep my 1 month bin logs safe for any recovery purpose
No doubt volume can be used for Recovery purpose
E.g:- suppose someone deleted binary logs from location then we need to have backup for safer side
← prev | next →
