Tag: databases

DBD is physical description of database.

The mysql contains a user root?

The default password of root user is

What will be the output of the query select * from table1 order by rand()

Is it a valid mySQL statements? SELECT @min_price:=MIN(price),@max_price:=MAX(price) FROM shop; SELECT * FROM shop WHERE price=@min_price OR price=@max_price;

What will be the output of the query SELECT column FROM table ORDER BY column DESC LIMIT 7,10;

The mysql contains a user root?

The default password of root user is

What will be the output of the query select * from table1 order by rand()

Is it a valid mySQL statements? SELECT @min_price:=MIN(price),@max_price:=MAX(price) FROM shop; SELECT * FROM shop WHERE price=@min_price OR price=@max_price;