Hi all,
I have run a batch file contains,
mysql -uroot -proot -Dsample_db < "create_sp.sql"
The "create_sp.sql" file contains definition for the stored procedure by the name get_account_details()
Now i opened SQLyog and when I executed get_account_details() it generates error with message "zero rows fetched, selected, or processed"
But when i move to particular procedure and say alter,
without making any change i will click on execute querry button to alter the procedure.
Now when I call the sp get_account_details(), it returns me some output without any error.
What is the reason for this error, when i create procedure using, mysql -uroot -proot -Dsample_db < "create_sp.sql" ?
And how do I solve this problem, because i dont want to again open the SQLyog and locate the sp and run it again ?.
4 2925
Hello..
Sorry but i'm not really good at MySQL but have you tried Googling it?
Better Than Yesterday ^^
mysql dump functions can be quirky.
This doesn't look right - mysql -uroot -proot -Dsample_db < "create_sp.sql"
No space for the password but space for the user.
Shouldn't need d.or quotes unless space in file name (or path). - mysql -u root -proot sample_db < create_sp.sql
Is your username and password the same?
I have only ever got this function to work using full path names
to the mysql.exe and the backup file
mysql dump functions can be quirky.
This doesn't look right - mysql -uroot -proot -Dsample_db < "create_sp.sql"
No space for the password but space for the user.
Shouldn't need d.or quotes unless space in file name (or path). - mysql -u root -proot sample_db < create_sp.sql
Is your username and password the same?
I have only ever got this function to work using full path names
to the mysql.exe and the backup file
Hello,
For running a script file we can give commands in different ways,
My command: mysql -u<user name> -p<password> -D<database> < "<file name in same directory>"
The command i have given is right, also the your syntax is correct.
If you still doubt you can try with the command I have given.
But my doubt is not about "how to execute a script file". I have explained in my first question.
If u didn't understand my question, I can explain more deailed.
Can anyone help me to solve this ?
Thank you,
My understanding is, and I have read your question again
you have
error when executing dump file
But I must confess I have no idea what the following means
But when i move to particular procedure and say alter,
without making any change i will click on execute querry button to alter the procedure.
Now when I call the sp get_account_details(), it returns me some output without any error.
So I was making an educated guess on your problem. - The command i have given is right, also the your syntax is correct
No doubt. But there is a difference between correct syntax and working syntax
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Vijay Chegu |
last post by:
I have built a 64bit ATL COM dll.
When i register the dll on IA64 windows Enterprise server 2003, i get
following error.
DllRegisterServer in mydll.dll failed.
Return code was : 0x80020009
...
|
by: John Mason |
last post by:
Hi,
I have developed an asp.net application that uses forms authentication.
I have a local install and a remotely hosted install of the application.
Intermittently the remote application falls...
|
by: Rob |
last post by:
In the code below, I am executing 2 stored procs that are returning row
counts.... I am storing a summary of the row counts into a Textbox... why,
when I am adding Salespeople (the first section of...
|
by: David Roche |
last post by:
Hello,
I searched all through Google Groups, Google, and the Postgres docs, but
to no avail. I hope someone can help me out here!
I have a file that contains SQL, and some Postgres-specific...
|
by: snicks |
last post by:
I'm trying to exec a program external to my ASP.NET app using the following
code. The external app is a VB.NET application.
Dim sPPTOut As String
sPPTOut = MDEPDirStr + sID + ".ppt"
Dim p As...
|
by: Mahesh S |
last post by:
Hi
I would like to write a SQL select statement that would fetch rows
numbered 50 to 100.
Let me clarify, if i say "fetch first 10 rows only", it returns the
first 10 rows from the resultset....
|
by: matias.cornejo |
last post by:
I was looking de db2diag.log (DB2 V7, AIX) and I have this error and
It's creating every 5 minutes the file .000
PID:312050(db2agent (idle)) Appid:none
drda_as sqljp_ddm_dict_search Pdrobe:413...
|
by: =?ISO-8859-1?Q?Lasse_V=E5gs=E6ther_Karlsen?= |
last post by:
I get the above error in some of the ASP.NET web applications on a
server, and I need some help figuring out how to deal with it.
This is a rather long post, and I hope I have enough details that...
|
by: preejith |
last post by:
Error Code : 1329, No data - zero rows fetched, selected, or processed. MYSQL
I am getting the following error while running a stored procedure in mysql5.0
Error Code : 1329
No data - zero rows...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |