Contents:
Any documentation on restore mysqldump backup along with binary logs ?
What could be the reason for this?
other attributes could be associated with the tables you have created?
could you help me to find a tutorial for indexing and procedures practically in mysql?
How to import excel data to MySQL?
Any documentation on restore mysqldump backup along with binary logs ?
What could be the reason for this?
other attributes could be associated with the tables you have created?
could you help me to find a tutorial for indexing and procedures practically in mysql?
How to import excel data to MySQL?
Mauryasourabh07 2022-07-16 13:33:39
SOLUTION PLEASE
PlayerNoob0 2022-07-16 14:35:46
Mauryasourabh07 2022-07-16 13:33:32
Without seeing the data no one can
trilokinathvishnu 2022-07-16 15:02:34
Any documentation on restore mysqldump backup along with binary logs ?
V9000000 2022-07-16 18:15:37
We are looking for experienced MySQL dba around chennai location.
sivarishi 2022-07-16 19:03:57
Hi Guys , Anyone have Innodb cluster upgrade document
Harish Kunte 2022-07-17 07:12:29
Hey anyone can send SQL interview Questions
mohd_mujahid02 2022-07-17 10:09:52
https://www.softwaretestinghelp.com/50-popular-sql-interview-questions-for-testers/
Top 90 SQL Interview Questions and Answers (LATEST) – Software Testing Help
In this article, we have covered 90 most popular SQL interview questions with answers. These are useful questions for freshers and experienced candidates.
In this article, we have covered 90 most popular SQL interview questions with answers. These are useful questions for freshers and experienced candidates.
mohd_mujahid02 2022-07-17 10:10:35
https://youtu.be/AWX3kfzxOIw
MySQL interview questions and answers – YouTube
# MySQL interview questions # MySQL development # MySQL interview questions and answers
Most Frequently Asked MySQL interview questions with detailed Answers and Examples for Freshers and Experienced Candidates .MySQL interview questions very easy to understand to fresher and experience candidate.Today mostly candidate stuck MySQL basic interview question to tell answer.So my agenda is that my video help to fresher and experienced candidates for resolving MySQL interview questions.
# MySQL interview questions # MySQL development # MySQL interview questions and answers
Most Frequently Asked MySQL interview questions with detailed Answers and Examples for Freshers and Experienced Candidates .MySQL interview questions very easy to understand to fresher and experience candidate.Today mostly candidate stuck MySQL basic interview question to tell answer.So my agenda is that my video help to fresher and experienced candidates for resolving MySQL interview questions.
Also Watch my below video-
Also Read my Health care blogs-
https://on-and-on-nutrilife-proteins-powder.blogspot.com
https://on-and-on-spirulina-gold-60-capsule.blogspot.com
https://on-and-on-9e5-premium-health-drink.blogspot.com
https://spicy-tadka-kolhapuri-misal.blogspot.com
https://nplink.net/uac4oesh
https://nplink.net/ejzak5w5
https://nplink.net/biljemah
https://amzn.to/2Ukg0Qp
Also visit and likes my facebook pages-
1.https://m.facebook.com/by09051993
2.https://m.facebook.com/Famous-Kolhapuri-Misal-Pav-recipe-for-indian-breakfast-107780434227535
3.https://m.facebook.com/PHP-Interview-question-and-answer-for-fresher-and-experienc-112883427061543
4.https://m.facebook.com/On-On-Spirulina-capsules-are-Pure-Veg-Capsules-112829013716937
5.https://m.facebook.com/On-and-on-9e5-premium-health-drink-102749364716267
m hari prasad 2022-07-17 16:56:16
Group by order by videos pettandi bro
Omkar Bhalerao 2022-07-17 19:16:39
Send in sql queries example
Willowwella 2022-07-17 19:46:00
Hi
I really need this help
I am trying to login mysql
I have tried all the multiple solutions to this problem but it ends up saying
“Can’t connect to local MySQL server through socket ‘var/run/mysqld/mysql.sock’ (2)
What could be the reason for this?
I really need this help
I am trying to login mysql
I have tried all the multiple solutions to this problem but it ends up saying
“Can’t connect to local MySQL server through socket ‘var/run/mysqld/mysql.sock’ (2)
What could be the reason for this?
Gabi 2022-07-18 04:33:07
All thanks to God almighty for bringing such a good person into my life like @Hudson_Kaleb Trader, I invested with a start up capital of $200 and to my greatest surprise I received my profit of $2000 in trading once again sir I’m using this medium to say thank you for no your help and support I’m really grateful to have you in my life…
Join the channel and contact him l swear you will never call forex Binary , https://t.me/joinchat/8Vj8VUurzk1lZTk0
Join the channel and contact him l swear you will never call forex Binary , https://t.me/joinchat/8Vj8VUurzk1lZTk0
FOREX TRADING AND CRYPTO INVESTMENTS – Telegram
WE GUARANTEE THE BEST TRADING STRATEGIES IN OUR PLATFORM
MASSIVE PROFIT 💰
✅Pʀᴇғᴇᴄᴛ Sɪɢɴᴀʟs Sᴇssɪᴏɴ
✅85-100% Aᴄᴄᴜʀᴀᴄʏ Wɪɴs.
✅ Aᴄᴄᴏᴜɴᴛ Mᴀɴᴀɢᴇᴍᴇɴᴛ💵💰
✅ VIP Sɪɢɴᴀʟs
WE GUARANTEE THE BEST TRADING STRATEGIES IN OUR PLATFORM
MASSIVE PROFIT 💰
✅Pʀᴇғᴇᴄᴛ Sɪɢɴᴀʟs Sᴇssɪᴏɴ
✅85-100% Aᴄᴄᴜʀᴀᴄʏ Wɪɴs.
✅ Aᴄᴄᴏᴜɴᴛ Mᴀɴᴀɢᴇᴍᴇɴᴛ💵💰
✅ VIP Sɪɢɴᴀʟs
@Hudson_Kaleb
Mander_8057 2022-07-19 05:04:42
Review the scenario below and complete it by modeling a database using the ER tool
available at MySQL Workbench.
1. Use MySQL Workbench to design an EER diagram for a database that stores
information about a blog. This blog also can have galleries of images that users create.
Save it as a model in a file named LastName_FirstName_Assignment2.mwb
Use the following criteria in order to model your database:
● Each user must have an email address, first name, and last name.
● Each user can have one or more posts.
● Posts can have images.
● Images can be associated with galleries.
● Each image belongs to only one gallery and it must have a filename, date, size,
and the file itself.
● Each user can have one or more galleries.
● Each gallery must have a name, and the date it was created.
● Consider the use of hashtags on posts. Each hashtag belongs to only one post,
and the post can have multiple hashtags. Save the date the hashtag was
created.
Note: when creating this diagram consider the business model of a real-life blog. Which
other attributes could be associated with the tables you have created? If you can
identify them, make sure to add them to your tables.
2. Use MySQL Workbench to open the EER diagram that you created in exercise 1.
Then, export a script that creates the database and save this script in a file named
LastName_FirstName_Assignment2.sql. Next, use MySQL Workbench to open this file
and run it. When the database is ready, Insert a row in each table and run a select
statement that combines two tables from your choice.
available at MySQL Workbench.
1. Use MySQL Workbench to design an EER diagram for a database that stores
information about a blog. This blog also can have galleries of images that users create.
Save it as a model in a file named LastName_FirstName_Assignment2.mwb
Use the following criteria in order to model your database:
● Each user must have an email address, first name, and last name.
● Each user can have one or more posts.
● Posts can have images.
● Images can be associated with galleries.
● Each image belongs to only one gallery and it must have a filename, date, size,
and the file itself.
● Each user can have one or more galleries.
● Each gallery must have a name, and the date it was created.
● Consider the use of hashtags on posts. Each hashtag belongs to only one post,
and the post can have multiple hashtags. Save the date the hashtag was
created.
Note: when creating this diagram consider the business model of a real-life blog. Which
other attributes could be associated with the tables you have created? If you can
identify them, make sure to add them to your tables.
2. Use MySQL Workbench to open the EER diagram that you created in exercise 1.
Then, export a script that creates the database and save this script in a file named
LastName_FirstName_Assignment2.sql. Next, use MySQL Workbench to open this file
and run it. When the database is ready, Insert a row in each table and run a select
statement that combines two tables from your choice.
Mander_8057 2022-07-19 05:04:57
Can anyone send me the answers
Mander_8057 2022-07-19 05:05:00
Of this
Mander_8057 2022-07-19 05:05:09
I only have 5 hrs
Vinay_Vinay 2022-07-19 09:27:05
Mander_8057 2022-07-19 05:04:42
Review the scenario below and complete it by modeling a database using the ER tool
available at MySQL Workbench.
1. Use MySQL Workbench to design an EER diagram for a database that stores
information about a blog. This blog also can have galleries of images that users create.
Save it as a model in a file named LastName_FirstName_Assignment2.mwb
Use the following criteria in order to model your database:
● Each user must have an email address, first name, and last name.
● Each user can have one or more posts.
● Posts can have images.
● Images can be associated with galleries.
● Each image belongs to only one gallery and it must have a filename, date, size,
and the file itself.
● Each user can have one or more galleries.
● Each gallery must have a name, and the date it was created.
● Consider the use of hashtags on posts. Each hashtag belongs to only one post,
and the post can have multiple hashtags. Save the date the hashtag was
created.
Note: when creating this diagram consider the business model of a real-life blog. Which
other attributes could be associated with the tables you have created? If you can
identify them, make sure to add them to your tables.
2. Use MySQL Workbench to open the EER diagram that you created in exercise 1.
Then, export a script that creates the database and save this script in a file named
LastName_FirstName_Assignment2.sql. Next, use MySQL Workbench to open this file
and run it. When the database is ready, Insert a row in each table and run a select
statement that combines two tables from your choice.
available at MySQL Workbench.
1. Use MySQL Workbench to design an EER diagram for a database that stores
information about a blog. This blog also can have galleries of images that users create.
Save it as a model in a file named LastName_FirstName_Assignment2.mwb
Use the following criteria in order to model your database:
● Each user must have an email address, first name, and last name.
● Each user can have one or more posts.
● Posts can have images.
● Images can be associated with galleries.
● Each image belongs to only one gallery and it must have a filename, date, size,
and the file itself.
● Each user can have one or more galleries.
● Each gallery must have a name, and the date it was created.
● Consider the use of hashtags on posts. Each hashtag belongs to only one post,
and the post can have multiple hashtags. Save the date the hashtag was
created.
Note: when creating this diagram consider the business model of a real-life blog. Which
other attributes could be associated with the tables you have created? If you can
identify them, make sure to add them to your tables.
2. Use MySQL Workbench to open the EER diagram that you created in exercise 1.
Then, export a script that creates the database and save this script in a file named
LastName_FirstName_Assignment2.sql. Next, use MySQL Workbench to open this file
and run it. When the database is ready, Insert a row in each table and run a select
statement that combines two tables from your choice.
You need to design tables for this and get a ER diagram for those tables with explanation bro
Mander_8057 2022-07-19 09:29:51
Yeah but I do understand that
Mander_8057 2022-07-19 09:30:01
Which are the table here
Mander_8057 2022-07-19 09:30:25
User is a table image is also table name
Mander_8057 2022-07-19 09:30:37
So like that I need to know
Vinay_Vinay 2022-07-19 10:04:23
1) user details
2) image details
3) gallery
4) posts
2) image details
3) gallery
4) posts
Vinay_Vinay 2022-07-19 10:04:49
May be you can follow above tables and create columns as per business
alirezahaghi2000 2022-07-19 10:41:21
hello all
could you help me to find a tutorial for indexing and procedures practically in mysql?
YouTube video or something else
i tried my self but all I’ve found where theory or very incomplete
could you help me to find a tutorial for indexing and procedures practically in mysql?
YouTube video or something else
i tried my self but all I’ve found where theory or very incomplete
Athepathi S 2022-07-19 11:44:31
LOAD DATA local INFILE ‘C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Lead_Logs.csv’
-> INTO TABLE EMP
-> FIELDS TERMINATED BY ‘,’
-> ENCLOSED BY ‘”‘
-> LINES TERMINATED BY ‘\n’
-> IGNORE 1 ROWS;
ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides
-> INTO TABLE EMP
-> FIELDS TERMINATED BY ‘,’
-> ENCLOSED BY ‘”‘
-> LINES TERMINATED BY ‘\n’
-> IGNORE 1 ROWS;
ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides
Athepathi S 2022-07-19 11:45:05
how to import csv file i am getting this error
Athepathi S 2022-07-19 11:45:23
can any one help me
Athepathi S 2022-07-19 11:47:06
in mysql
Athepathi S 2022-07-19 11:47:33
SET GLOBAL local_infile=1;
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 ‘mysql> SET GLOBAL local_infile=1’ at line 1
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 ‘mysql> SET GLOBAL local_infile=1’ at line 1
Athepathi S 2022-07-19 11:48:07
i try this also getting error again
Max Weber 2022-07-19 14:07:59
How to import excel data to MySQL?
Max Weber 2022-07-19 14:08:09
Pls urgent needed.
Mander_8057 2022-07-19 14:12:38
Vinay_Vinay 2022-07-19 10:04:49
May be you can follow above tables and create columns as per business
Thank you
Max Weber 2022-07-19 14:22:59
Max Weber 2022-07-19 14:07:59
How to import excel data to MySQL?
Help me.
Nagarjun 2022-07-19 14:32:17
Max Weber 2022-07-19 14:22:59
Help me.
Convert to CSV then try