How many joins in sql?
what tools available for managing mysql server? : Sql dba
What are all different types of collation sensitivity?
explain the difference between myisam static and myisam dynamic. : Sql dba
What are stored procedures in mysql?
what are the type of locks ? : Sql dba
What are tables in sql?
Can we create table inside stored procedure?
have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
What is an alias command?
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;
What operators deal with null?
Which command is used to call a stored procedure?