Select resortname from table2 where resortid = (select MAX(resortid) from table1)


Try this.

Then such people aren't worthy of telling anything at all. Because this community attempts to nurture an environment that makes people learn while helping them. Giving away readymade answers just...

@almostbob : Rather than posting the exact queries as answer, why not just mention that MySQL contains something like 'LIKE' and then maybe point him towards the documentation page for the same and...

If that solves the query mark the thread as solved so that people are aware of the fact and do not post anymore on this thread. Else we do have a lot of old threads revived unnecessarily.

You can assign only access privilege to the standard set of records (I assume they are in a separate table) to the group. So that they can certainly generate other records using values from the...

Depends upon how much data you would want to store.
varchar is a choice, tinytext - max 255 chars, text - max 65535 chars are other options. There are also mediumtext and longtext.
Choose according...

While specifying the foreign key constraint you have specified "ON UPDATE NO ACTION" while this seems to mean that no action would be taken on update, it specifically means that you will not be...