Search results for " mysql stored procedure insert"

MySQL Stored procedures

Do you want to know "what's new" in version 5 of MySQL? There are new features added to this version like stored procedures, triggers, views, information_schema. For those who use MySQL for databases administration this is a very good news. For a better understanding of the stored procedures importance I will give a definition and an example. A stored ...

How to make a database faster?

The big pain Did you ever tried to work with some databases that contain big tables? And by BIG I mean one table at least that has more than 1 million records. No matter you are using MySql, SqlServer, Oracle or other DBMS, the problem is same: finding informations in that table ( records as we all know them) is very very slow. Can take minutes if the ...