How To ?

MySQL Storage Engines MySQL is very different from other databases, in that it's storage engine is pluggable, what I mean by this is that the MySQL server core code is separate from the storage engine, which means that you can have a pluggable storage engine that fits your application. MySQL has over 20 storage engines, here is a list of the common ones Storage Engine Transactional Support Locking Level Online Non-blocking Backup Server Version(s) available InnoDB (default) Yes Row Yes 5.1, 5.5, 5.6 MyISAM/Merge No Table No 5.1, 5.5, 5.6 Memory No Table No 5.1, 5.5, 5.6 Marta Yes Row No 5.1, 5.5, 5.6 Falcon Yes Row Yes 5.6 PBXT Yes Row Yes 5.1, 5.5, 5.6 FEDERATED No n/a n/a 5.1, 5.5, 5.6 NDB

Q : how to know Mysql Server is running on your Server . Ans : Just do telnet  localhost 3306 ; then press enter  , if blank window appear just after it ,means server is running other wise not before doing also check whether telnet is enable on your server or not . Q : how to connect a mysql server .   Ans:   Mysql -hlocalhost -uroot -p press enter  .then it will ask for password  ,enter your                    password  ,a prompt like  MySql  > will be shown means you are connected  . Q : how to create user in Mysql and providing privilege and checking for existing user      in mysql . Ans  :             "  create user 'username'@'localhost'  identified by password 'password' ."       if you want to give access to user that can access on network or remote user % sign in       place  of localhost . so command will look as below .                " create user 'username'@'%'  identified by password 'password&#

Question  :  Introduce Your self  ? Ans            : Normally first question starts with point  "Introduce Your self "  either guy is fresher or experience  , so if you are experience  then it is always good start telling from your career then academy  -- then personal achievement  and if it is necessary then family background . if you are fresher , start with academy ,and then some personnel achievement , and try to correlate how you personal achievement with  your current job  interview . Q  :  What is PL/SQL .   ? Ans   : PL/SQL  stands for procedure  programming language for structured query language . Q : Why PL/SQL is needed  ?  Ans  : Normal sql is having some limitation  to work with database , you can not do much more in       in single line query  .. , in this case p/sql is always beneficial  in terms of  you can multi line query  as method or function , you can create a package  , triggers ,cursors , overall in one word ,you can manage your code