473,406 Members | 2,336 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

How do I run an SQL script and an SQL procedure?

4
Beginner - Needs to learn how to run an SQL script, Store the Procedure it creates and then run that procedure to populate a table.

I am working on modifying tables within the MaNGOS project. Specifically I have a table with some Rows of data missing.

I have an SQL file which has a script that will populate the table.

But I don't now how to run a script in SQL. I am told if I run this script it will generate a procedure.

I assume this procedure is to be imported to "stored procedures" within the MySQL MaNGOS project I have been working on.

But I would not know how to run this procedure in order to populate the table.

I hope this makes sense.

Thank you for taking the time to read this and if you need more info please let me know.

Septus

*I am using MySQL 5.0 - editing tables using Navicat 8. All running in WindowsXP OS.
Nov 17 '07 #1
5 5951
pbmods
5,821 Expert 4TB
Heya, Septus. Welcome to TSDN!

Have a look at this article.
Nov 18 '07 #2
septus
4
Hiya -

I followed you link - Got the script imported into SQL and now it sits correctly in the Stored Procedure folder.

Would you have a link that demonstrates how to run this procedure to alter a table within my MySQL database?

Thanks.
Nov 19 '07 #3
septus
4
I'll read around more and see if I can solve this next step. You have pointed me in the right direction. Thanks.
Nov 23 '07 #4
pbmods
5,821 Expert 4TB
Heya, Septus.

MySQL uses the CALL command to run stored procedures.
Nov 23 '07 #5
septus
4
Thanks - Will read up on the call function.

Muchos gracias
Nov 30 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Bill Kellaway | last post by:
Hi there - this should be fairly simple for someone. Basically I can't figure out how to pass the parameters from ASP to a Stored Procedure on SQL. Here's my code: I just need to help in...
5
by: vishal | last post by:
Hi, I am writing my first script to execute a Oracle procedure through a unix script. Could you tell me how do I do error handling here? How do I know in my script if the procedure executed...
3
by: aaj | last post by:
SQL SERVER 2000 Hi all This is my first attempt at writing a stored procedure. I have managed to get it working but its unlikely to be the best way of handling the problem. While writing it I...
2
by: Paul Sieloff | last post by:
I am trying to conditionally create a stored procedure in a Query Analyzer script. When I have the CREATE PROCEDURE statement by itself in the script, it compiles and runs ok. Once I put a...
6
by: Clay Beatty | last post by:
When you create database diagrams in Enterprise Manager, the details for constructing those diagrams is saved into the dtproperties table. This table includes an image field which contains most of...
1
by: Evgeny Gopengauz | last post by:
Hi! I need to write a t-sql-script like this: (case-1) IF {stored procedure SP is not exists} BEGIN CREATE PROCEDURE SP AS BEGIN //dummy body END
1
by: DB_2 | last post by:
Hello, I created the following stored procedure. (Please ignore the logic in it; at this point it is not complete and I am trying to get the basic structure working first.) CREATE PROCEDURE...
3
by: BONTZ | last post by:
Hi all, I have generated a huge SQL script which installs the whole database starting from creating database, tables,creating procedures, creating users and everything thats required by my...
0
by: istruttorenuoto | last post by:
hi! I have some problems to call a stored procedure from an Unix Script. Here's the script stty istrip stty erase ^H export ORACLE_BASE=/product/oracle export...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.