Go for Search
PJ
-
Recent Posts
- Generate drop and add constraint query for a table
- change all fields having DATA_TYPE ‘datetime’ to ‘int’ across all table of a DB without data loss
- What is the difference between PHP-4 and PHP-5?
- Difference between require() and require_once().Please explain in details with examples.
- Explain CURL and its use .
My Categories
- Interview Questions (47)
- Sample Codes (2)
- PHP (2)
Monthly Archives: June 2012
How to check case sensitive in query ?
Check case sensitive:BINARY: SELECT * FROM tblname WHERE BINARY email = mail2pjena@gmail.com
Posted in Interview Questions, MySQL
Leave a comment
Difference between LEFT JOIN and Query with comma(,)
SELECT x.aid, b.bid, b.bdesc FROM x LEFT JOIN b ON (b.bid=x.bid) WHERE x.aid=”whatever” VS SELECT x.aid, b.bid, b.bdesc FROM x,b WHERE (x.aid=”whatever”) AND (b.bid=x.bid) The difference between these two SQL will only become apparent if an occurrence of table ‘b’ … Continue reading
Posted in Interview Questions, MySQL
Leave a comment