@@SERVERNAME equivalent in mysql

Hi, we are migrating our DB from mssql to mysql.
please let me know @@SERVERNAME equivalent in mysql
rgds,
vijji
vijji_lakshmiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
vijji_lakshmi,
with due respect, but despite the requests of the moderators, you still have 33 questions open (including this one).
EE is a collaborative site, and you have to follow EE rules.

technically, as I repeated in several questions, your migration from MS SQL server to MySQL is just fool work, especially as you seem to know NOTHING about MySQL, apart from the fact that NOTHING that mssql has apart from the standard sql language is present in MySQL, so WHY do you continue migrating/asking these questions BEFORE even searching the docs/google/? ...


0
UmeshMySQL Principle Technical Support EngineerCommented:
Even I requested in my several posts about open questions but no luck...forget the open/close issues.. you never turn back whether the provided solution works or not.. I'm sure you never look into it once you got the solution otherwise you wouldn't have posted some many comments.... at least you should communicate the end person who is spending time in helping others..

About the comparison and all those things... Im completely agree with Angell..
0
vijji_lakshmiAuthor Commented:
hey angelIII/ushastry:
 i am sorry for not closing the open qtns.
but the sentence you made "as I repeated in several questions, your migration from MS SQL server to MySQL is just fool work"...
this is our project requirement.so,we should do it.
we are not doing it for time pass...
you said i am asking qtns with out searching in google... is completely wrong.
after searching in google only iam posting qtns.



0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

UmeshMySQL Principle Technical Support EngineerCommented:
BTW, Did you happen to check the Migration Tool kit provid3ed by MySQL for converting MSSQL->MySQL ?\

Please check and see if that can help you in any way. Take a look at the download section of www.mysql.com
0
vijji_lakshmiAuthor Commented:
Hi ushastry,
    we should not use any tools to migrate.
please let me know the anser to my qtn "@@SERVERNAME equivalent in mysql"
rgds,
vijji
0
UmeshMySQL Principle Technical Support EngineerCommented:
This way you can get the details..

select @@hostname;
or
show global VARIABLES like 'hostname';

Please close your questions so that anyone will pickup your question and will answer.. if you don't close your questions on time.. then I'm afraid nobody will care to attempt.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.