Any one have interview questions and answers for MySQL?

|
shahinur rahman 2022-09-01 13:32:00
mysql_en-24568.jpg
here is my journalctl -xeu mariadb.service command output
N K 2022-09-01 13:39:48
Hi..
Any one have interview questions and answers for MySQL ?
sk33p34 2022-09-01 19:57:33
Just follow on the command you told there
parkash69 2022-09-01 20:09:43
I have sql file i want to convert the data into sqlite any help
svart 2022-09-01 20:47:57
shahinur rahman 2022-09-01 13:32:00
mysql_en-24568.jpg
here is my journalctl -xeu mariadb.service command output

You should check the mysql error log

Doman02 2022-09-01 20:50:14
same result right ?
~ 2022-09-01 22:37:19
Hi All

Can anyone help on
Whether pluggable authentication works in MySQL 5.1 ?

surya Jai 2022-09-02 04:08:36
Client: Tanla platforms
LocAtion: Hyderabad
• Experienced with MySQL & MySQL Architecture
• Installation & Configuration.
• Schema handling.
• Database user roles and Security related permission.
• User creation, object Backup & Restore.
• Architect level Server security.
• Creating and Managing MySQL Databases
• MySQL Index Management
• MySQL Partitioning and System Catalogs
• MySQL cluster management
• Backup & Recovery
• Monitoring disk usage
• MySQL event manager handling and monitoring
• Backup data movement to archival storage
• Moving Transaction Logs
• DBA development (Preparing complex queries and writing stored procedures for integration with other systems)
• High Availability Failover Replication.
• DR Replication monitoring and configuration.
• Implementing MySQL related tools.
• Writing shell script for MySQL
• Database Performance tuning.
• Checking logs.
• Willing to work in shifts.
Competencies: The position must have the following competencies:
• Action oriented
• Applied Learning
• Strong Communication
• Building trust
• Decision making / problem solving
• Delegating Responsibility
• Customer / client focus
• Initiatives
• Planning & Organizing
• Managing Stress levels at critical times
•Team Player
• Troubleshooting skills in DBA operations.                 
   Knowledge and Skill set:
• B.E/B. Tech/MCA with 4-5 years of experience in MySQL DBA Operations.
• Strong experience with SQL (NoSQL experience is a plus).
• Strong background of automation of consolidation jobs.
• Knowledge of best practices and IT operations in an always-up, always-available service
• Candidate should have excellent written and verbal communication skills.
• Candidate must be organized, detail oriented, personable and can prioritize tasks
• Ability to work in a team.
• Work experience with Percona MySQL is preferred       
Ryan 2022-09-02 05:33:02
Hello sir @James_Walker_fx please tell me about the wining process

https://t.me/joinchat/FZh1YQ4IOcZlNTM0

Max Weber 2022-09-02 08:08:01
Doman02 2022-09-01 20:50:14
mysql_en-24568.jpg
same result right ?

Nope. Your 2nd query will get error. Because, we can not use aggregate function like SUM,MIN,MAX,COUNT() with WHERE clause.
:Remove MAX (aggregation) in with where just simply write WHERE (amount)>2000
GROUP BY ….

AND query will run and give same result as above query.

Note: where clause used to place condition on column and HAVING us used to place condition over GROUP.

Deepak Keni 2022-09-02 15:02:28
mysql_en-24593.jpg
Is anyone know how to solve this
Gnation88 2022-09-02 15:28:40
Anyone working or upgraded to MYSQL 8.0.30 version
snehakshaylata 2022-09-02 15:52:33
anyone can help me on sql??
snehakshaylata 2022-09-02 15:52:36
please
Bhavarkar 2022-09-02 18:37:53
https://t.me/+KW06Gp6jW602M2Zl

Data/Business Analyst Job UpdateTelegram
Getting Updates on Data analytics
meddhiaka 2022-09-02 19:34:39
Any available virtual internships offers ?
piyush 2022-09-02 22:00:00
https://t.me/+YqMn2Z6YBr80ODVl
Chandu K Naidu 2022-09-03 05:22:42
I have 4+ years of experience in MySQL DBA
Any reference?
Krishna Krish 2022-09-03 07:18:27
Chandu K Naidu 2022-09-03 05:22:42
mysql_en-24568.jpg
I have 4+ years of experience in MySQL DBA
Any reference?

Apply in Naukari. Lot of calls for MYSQL DBA

surya Jai 2022-09-03 08:34:12
any referrals for My SQL DBA..i have an opening for Hyderabad Location for a product based Organization
Chandu K Naidu 2022-09-03 09:58:53
surya Jai 2022-09-03 08:34:12
mysql_en-24568.jpg
any referrals for My SQL DBA..i have an opening for Hyderabad Location for a product based Organization

Yes
Give me your phone number

P M 2022-09-03 12:35:46
Krishna Krish 2022-09-03 07:18:27
mysql_en-24568.jpg
Apply in Naukari. Lot of calls for MYSQL DBA

Naukri is fraud and asks money

Krishna Krish 2022-09-03 12:45:29
P M 2022-09-03 12:35:46
mysql_en-24568.jpg
Naukri is fraud and asks money

No bro.. I got job through naukari. And also all my friends got job through naukari

Shroff_azago 2022-09-03 13:39:00
None object has no attribute Cursor.

Anyone help me?

R 2022-09-03 14:45:08
mysql_en-24632.jpg
tell me what is the query
Swapnil 2022-09-03 15:26:45
R 2022-09-03 14:45:08
mysql_en-24632.jpg
tell me what is the query

Select
c.CompId as CompId,
c.Name as CompanyName,
count(d.*) as TotalDept,
count(e.*) as TotalEmp,
Max(e.Salary) as MaxSalary
from Departments d
left join DeptEmp de on d.deptId = de.deptId
left join Employees e on de.EmpId = e.EmpId
left join Companies c on de.CompId = c.CompId
group by 1,2

R 2022-09-03 15:28:16
Swapnil 2022-09-03 15:26:45
mysql_en-24632.jpg
Select
c.CompId as CompId,
c.Name as CompanyName,
count(d.*) as TotalDept,
count(e.*) as TotalEmp,
Max(e.Salary) as MaxSalary
from Departments d
left join DeptEmp de on d.deptId = de.deptId
left join Employees e on de.EmpId = e.EmpId
left join Companies c on de.CompId = c.CompId
group by 1,2

Thank you so much 😊

Nitin Rao 2022-09-03 15:32:15
Chandu K Naidu 2022-09-03 05:22:42
mysql_en-24632.jpg
I have 4+ years of experience in MySQL DBA
Any reference?

Update the same yrs of exp profile on linkedin.

Yu will get references.. Or direct calls from HR

Raju TUPE 2022-09-04 11:36:36
Hi,
I am Raju Tupe .i have done BECSE 2019.I am looking job for MySQL fresher pune location .
rajutupe21@gmail.com
Candy Blinks 2022-09-04 17:39:28
All thanks to Mr Robert Benjamin for making my dream come true easy through bitcoin investment I never believed in online trading after testimonies about her I decided to give her a try and today I’m a own of house I’m sharing this because a lot of people out there having financial problems free free to join Mr Robert Benjamin forex trading platforms
https://t.me/Globfinancaltrd53

BEST ONLINE OPTION TRADINGTelegram
🌏 Tʀᴀᴅᴇ Exᴘᴇʀᴛ Cʀʏᴘᴛᴏ/FX
📊 Aᴄᴄᴏᴜɴᴛ Mᴀɴᴀɢᴇʀ
🤝 𝚂𝚞𝚌𝚌𝚎𝚜𝚜 𝚁𝚊𝚝𝚎 93.3%

𝑆𝑒𝑟𝑣𝑖𝑐𝑒𝑠;
✅BEST SIGNALS 📡
✅IQ BINARY 💯
✅BEST PAYOUTS IN DUE TIME 💰

𝑭𝒐𝒓 𝑴𝒐𝒓𝒆 𝑰𝒏𝒇𝒐 𝑫𝑴 @RobertBenjaminFx

SN 2022-09-04 18:27:17
Any mysql db installation documents on Linux platform
svart 2022-09-04 18:30:12
SN 2022-09-04 18:27:17
mysql_en-24632.jpg
Any mysql db installation documents on Linux platform

Depends on version/os there could be slight differences. Google for it

Hybriddev 2022-09-04 21:57:31
how to insert data in next column if data already present in current column
parkash69 2022-09-04 23:16:57
I am looking for freelance who can convert my sql database to sqlite have 12-13 table in it
Gnation88 2022-09-05 00:11:13
parkash69 2022-09-04 23:16:57
mysql_en-24632.jpg
I am looking for freelance who can convert my sql database to sqlite have 12-13 table in it

Migrate data from MYSQL to sqlite ?

|