Stored Quieries / Procedures and relationships

[phill_ridout]

I've only ever used Access, and i started using mysql on monday, two questions i have?

How do i create stored procedures? I know in access, this speeds things up abit, is it the same for mysql? Is it worth the trouble, as mysql is more robust and can handle more users?

and how to i creat relationships between tables?

Im using the easyphp package.

Thanks

[guelphdad]

you need to be using mysql 5 in order to use stored procedures. you can check the manual for details on creating and using them.

as for relationships between tables you would use foreign keys. note that foreign keys can only be enforced on innodb table types. myisam does not support them, though you can declare them.

many things will be the same as with access, with slight syntactical changes.