Latest Answer : MySql has many advantages in comparison to Oracle.1 - MySql is Open source, which can be available any time 2 - MySql has no cost of development purpose.3 - MySql has most of features , which oracle provides 4 - MySql day by day updating with new facilities.5 ...
Latest Answer : MySQL only supports one index type, but implements different data access paths using the various table types. The eight types of Oracle indexes are B-tree, B-tree Cluster, Hash Cluster, Reverse Key, Bitmap, Bitmap Join, Function-Based, and Domain. ...
Latest Answer : really good question ...
1. How to create the stored procedures in mysql and it will be write on where?2. Difference between SQL stored procedures, MYSQL stored procedures, SQL Server stored procedures?
Latest Answer : CREATE TRIGGER `tgr_name` AFTER UPDATE ON `addresses` FOR EACH ROW begin update products set countryName = new.countryName where products.shippingAddressId = old.id;end; ...
Latest Answer : int varchar char date double long etc are available for mysql ...
Latest Answer : ans of this question is given above ...
Latest Answer : Reload privileges are mainly used when a new user is created andyou want to apply the changes without re starting Mysqlsyntax to use:mysql -u username -ppassword -e"flush privileges"; ...
Latest Answer : Sub queries in MySQL handled nested way, You can see the example and understand yourself -SELECT name, headofstate, population FROM Country WHERE population=(SELECT MAX(population) FROM Country); ...