Posts

Showing posts from August, 2012

2021 Top 4 Best Upcoming Flagship Smartphones : which are the best mobile phones for you..?

Image
  Hi here are the top 8 best upcoming flagship smartphones of 2021 with high-end level features improved cameras stunning design and many other next-generation technologies will be applied that you will really enjoy also the price and the release date of the smartphones are discussed. Number four Asus Zenfone 8 Number three OnePlus 9 Number two Huawei P50 Number one Apple iPad Pro 12.9

MySQL: deleting tables with prefix

You cannot do it with just a single MySQL command, however you can use MySQL to construct the statement for you: In the MySQL shell or through PHPMyAdmin, use the following query SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' )     AS statement FROM information_schema.tables     WHERE table_name LIKE 'myprefix_%'; This will generate a DROP statement which you can than copy and execute to drop the tables. EDIT: A disclaimer here - the statement generated above will drop all tables in all databases with that prefix. If you want to limit it to a specific database, modify the query to look like this and replace database_name with your own database_name: SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' )     AS statement FROM information_schema.tables     WHERE table_schema = 'database_name' AND table_name LIKE 'myprefix_%';   Thanks to Andre Miller

Move specific records on top of the list beside ORDER BY

Image
Suppose you have all countries name in MySQL db table like: and you want to show some specific countries on top of the list and remaining countries will start after them. So this query can do it. SELECT * FROM countries ORDER BY country_name = 'Australia' desc,          country_name = 'United arab emirates' desc,          country_name = 'Pakistan' desc,          country_name = 'United kingdom' desc,          country_name = 'United states' desc,          country_name asc;

Log out skype on mac

Image
Follow this quick video  or At the bottom of the screen, on the left hand side there are 4 virtual buttons, Back, Home, Recent Apps and Menu. Menu is the one with 4 lines. Tap that and then there is an option to Sign Out.