No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Right, I poster earlier with a practice table I was working on. I appreciated the reply and have been working on that.. but yesterday I got a real client's project. I have been given the task of optimizing the database design. The database keeps track of the transactions the company … |
|
I have made stored procedures in Oracle...but need to export them to mysql. I have searched on google but cant figure out the syntax. Here is the oracle procedure: [code=sql]create or replace procedure delgroup (g_id in number) is begin DELETE FROM grouptable WHERE GROUP_ID=g_id; commit; end;[/code] I jus basically want … |
|
I am fairly new to mysql and wanted to practice making a database and tables. As well as filling the tables with made up data and then practicing queries. I wanted to emulate a real life database project. So I decided to make a database for a Car Dealership. the … |