Latest Answer: int varchar char date double long etc are available for mysql ...
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; ...
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: really good question ...
Latest Answer: Images need to be browsed through form (need to use enctype as multipart form data), then take the contents of file into a variable and insert using mysql query. ensure that you don't try to post a file into a field larger than allowed size in your my.cnf, ...
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. ...
How to display nth highest record in a table for example? How to display 4th highest (salary) record from customer table?
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: 1. Primary key does not allow duplocate.2. We can use below query to find duplicate records select count(*),classifiedID as tot from jicka_photos group by classifiedID HAVING count(classifiedID) >1 limit 5;Thanks ...
View page << Previous 1 2 3 4 [5]
Go Top
