How can I avoid this?

|
Rvs345 2022-08-11 05:54:01
I need support for my students in ssis/ssrs/msbi / SQL i have 10 students whom i have placed .now they are looking for support .u can give offline support in my institute near Ameerpet .
Liran 2022-08-11 11:02:22
i have 2 instaces running on ports 3306 and 3307. but when i run mysql —port 3307 it connects to the default one.
only when running like mysql -u root –port=3307 –protocol=TCP -p it will work. how can I fix this?
Max Weber 2022-08-11 11:40:47
One programme can run using one port. Since it take default to 3306. I would advise try running one programme at a time and close to another one from task manager.
Liran 2022-08-11 11:54:59
the default one will be closed soon. i made new instance just to create new QA database. once i close the 3306 db, i will be able to use —port 3307?
Max Weber 2022-08-11 11:58:40
Yes
Max Weber 2022-08-11 11:59:50
Try, closing 3307 and use 3306. Try both way. What works
Liran 2022-08-11 12:04:46
will try thanks.
I have one more question – when i dump i run this

mysqldump -h localhost -u root -pPassword_here –single-transaction=TRUE db_name | sed -e ‘s/DEFINER[ ]*=[ ]*[^*]**/*/’ | gzip –rsyncable -c > /path/db_name.sql.gz

but since I wrote the password in the command it returned the error into the dump file in the first row. how can I avoid this?

Avinash Singh 2022-08-11 13:14:27
Anyone has the latest mysql for database administrator Volume 1.pdf file ?
piyush 2022-08-11 14:08:48
https://www.linkedin.com/posts/gaurav-goswami-2031_mysql-data-tableau-activity-6963450041546002433-Slhl?utm_source=linkedin_share&utm_medium=member_desktop_web

Hey, Connections I have been working with raw and uninteresting SQL – Gaurav Goswami on LinkedInLinkedin
Hey, Connections I have been working with raw and uninteresting SQL and Python codes for the past few days. I was missing the visualization part a lot …
H_elbaz 2022-08-12 03:30:48
Are you interested in udemy paid courses 100% discount coupons
Charlez 2022-08-12 05:55:52
Interested
Dude 2022-08-12 08:21:34
Is it possible to revoke create schema privilege alone from a user
Swapnil 2022-08-12 09:58:39
Start promoting the crypto now🤣🤣🤣🤣🤣
surendra reigns 2022-08-12 10:57:15
mysql_en-23813.jpg
Photo from Surendra
Swapnil 2022-08-12 10:57:18
🤦🤦stop it else we will have to delete or bann you
surendra reigns 2022-08-12 10:57:37
Any one can help me to get queiry for thia
Swapnil 2022-08-12 10:58:41
Post input table details first
Swapnil 2022-08-12 10:58:50
Directly dont jump for solution
Sandip Londhe 2022-08-12 10:58:50
mysql_en-23817.jpg

Sandip Londhe 2022-08-12 10:58:59
mysql_en-23819.jpg

Sandip Londhe 2022-08-12 10:59:09
A single SQL query for First booking date, Last booking date,Total booking amount and Avg Sales Amount of each employee against their names
Sandip Londhe 2022-08-12 10:59:27
swapnil looking for this query
Swapnil 2022-08-12 10:59:57
Post how your your output look like with example
Sandip Londhe 2022-08-12 11:04:02
mysql_en-23823.jpg

Sandip Londhe 2022-08-12 11:04:13
looking for this kind of output
surendra reigns 2022-08-12 11:04:33
No sir
surendra reigns 2022-08-12 11:05:19
What is the best location to deliver
surendra reigns 2022-08-12 11:14:57
Just want to creat optimization warehouse to know leat deliver cost
Swapnil 2022-08-12 11:15:11
Give me some time
surendra reigns 2022-08-12 11:15:17
Ok sir
Sandip Londhe 2022-08-12 11:36:02
select e.emp_name, min(b.booking_date), max(booking_date) , sum(b.amount), avg(b.amount) from employees e inner join booking b on e.emp_id = b.emp_id group by e.emp_name;
Sandip Londhe 2022-08-12 11:36:13
will it work on db
surendra reigns 2022-08-12 11:48:12
Wait sir
surendra reigns 2022-08-12 11:49:03
I’ll check
Swapnil 2022-08-12 11:49:08
Sum and avg will give wrong ans
|