PHP & MySQL Interview Questions

1. write a query to delete 3rd record from the below table.

table name: test_tbl









Please post your delete query in comment section.

Del.icio.us Add to del.icio.us Digg DiggIt! Reddit Reddit Stumbleupon Stumble This Google Bookmarks Add to Google Bookmarks Yahoo My Web Add to Yahoo MyWeb Technorati Add to Technorati Faves Slashdot Slashdot it

MySQL Query Challenge1

Table Name: contacts_tbl
Table Name: groups_tbl














Challenge :
make use of the above two tables and write the search query to list names of all persons belong to particular group

e.g., if I search for group 'Friends' it should list names of records 1,2,3,8,9,11,12,13 from contacts_tbl


post your query in comment section...

.

Del.icio.us Add to del.icio.us Digg DiggIt! Reddit Reddit Stumbleupon Stumble This Google Bookmarks Add to Google Bookmarks Yahoo My Web Add to Yahoo MyWeb Technorati Add to Technorati Faves Slashdot Slashdot it

Technical Queries / Comment