How to prevent duplicates in MySql table rows? How to find duplicate data in MySql and How to delete them from table?

Hi Folks, These are the very common questions to all of us. This post tells you how to prevent duplicates in MySql while creating tables, how to find duplicates in MySql if we missed ...

How to select table name with column name in oracle?

To select the tables which are containing particular column name, use following query. SELECT * FROM user_tab_columns WHERE column_name LIKE 'ATR%' Above query displays table names ...

How to select tablespace name with table name in oracle?

To select tablespace name which is containing specific table name in Oracle, SELECT * FROM all_tables WHERE table_name LIKE 'ORDER%' Above query searches for the table name which starts ...

How to Backup or Restore MySql Database in Ubuntu platform?

Hi Friends, I’m always spending some 10 or 15 minutes for searching commands to Mysql Backup and Restore. It may reduce your time. Here is the commands to Backup and Restore. Backup mysqldump ...
© 2018 Techy Diary. All rights reserved.
Powered by Charvi Groups