MySQL Interview Questions

Hello all , Could some one send me MySQL Interview Questions... Thanks

--
techguruMessage posted via http://www.exforsys.co

Hello techguru, you wrote:
"techguru" <techguru.1v1u16@no-mx.forums.yourdomain.com.au> wrote in message
news:techguru.1v1u16@no-mx.forums.yourdomain.com.au...
>
> Hello all , Could some one send me MySQL Interview Questions... Thanks,
>
>
> --
> techguruMessage posted via http://www.exforsys.com
>

1, name common mysql datatypes (INT, VARCHAR, CHAR, DATETIME...)
2, which is not a mysql function? CAST IFNULL CONCAT IF CASE
3, create a simple table with two fields an integer which is also a primary
key called id and a variable character string called somename that can be
up to 50 characters in length.

create table tablename (
id INT not null primary key auto_increment,
somename varchar(50) not null
);

4. provide an example of the use of ANSI joins in a query involving two
tables: (Lots of possibilities here)

select a.column1,b.column3
from table1 a join table 2 b
on ( a.column1 = b.column1 and b.column2 = 'SomeString'

5. Mysql maintains a number of tables to manage permissions for users. What
MYSQL function should you use to compare the encrypted password in the users
table.is the function name: AES_DECRYPT, PASSWD,DECODE, PASSWORD,
OLD_PASSWORD?

(PASSWORD if MYSQL version <4.1, OLD_PASSWORD if old password encoding on
version >4.1 otherwise PASSWORD)


Joseph Melnick
JM Web Consultants.
Toronto ON Canada
www.jphp.com