I wonder if anybody is using Zeos and MySQL 5. Especially stored procedures. Is there any good tutorial on stored procedures for dummies?
MySQL 5
Moderators: gto, cipto_kh, EgonHugeist
I'm attempting to write a small database just for the purpose of learning how.
I'm using Delphi 7.1 (Delphi 2005 looks too weird for words!), MySQL 5.1, Zeos Database Designer...
Two problems persist:
1) Delphi won't connect with MySQL
2) Zeos produces SQL database definition files.... that do what?
I can tell I'm misisng a lot of information... for example... do you have to create a "user" in MySQL before you can connect?
Zeos seems like a fine product, but I don't know what to do with the files it produces. They look like batch files... that is...batches of commands one might type by hand in MySQL. That's nice, and I'm sure it's easier to produce these text files than type everything by hand, but how do I get MySQL to open these files and execute the commands?
help!
I'm using Delphi 7.1 (Delphi 2005 looks too weird for words!), MySQL 5.1, Zeos Database Designer...
Two problems persist:
1) Delphi won't connect with MySQL
2) Zeos produces SQL database definition files.... that do what?
I can tell I'm misisng a lot of information... for example... do you have to create a "user" in MySQL before you can connect?
Zeos seems like a fine product, but I don't know what to do with the files it produces. They look like batch files... that is...batches of commands one might type by hand in MySQL. That's nice, and I'm sure it's easier to produce these text files than type everything by hand, but how do I get MySQL to open these files and execute the commands?
help!