Questions tagged [mysql-manager]
4 questions
1
vote
1 answer
Get second recordset from stored procedure
I have a stored procedure in MySQL. It has 2 select queries there. Here is part of it.
@query="select SQL_CALC_FOUND_ROWS...LIMIT 1, 20"
PREPARE query FROM @query;
EXECUTE query;
DEALLOCATE PREPARE query;
select FOUND_ROWS() as…
Sergey Scopin
- 2,217
- 9
- 39
- 67
1
vote
2 answers
MySQL Manager: You tried to execute empty string,please type sql command into sql edit field and execute
I am facing a very strange issue of executing query into mysql manager tool
i exported my database from phpmyadmin using wamp server and now on client's server i am trying to run that query and it gives me that error.
any one help me how to resolve…
UMAR-MOBITSOLUTIONS
- 77,236
- 95
- 209
- 278
0
votes
0 answers
Negative TIME values in MySQL
I was using MySQL with phpMyAdmin to manage a small database and system that my company was using to store the time a employee starts and finishes his shift.
If say employee works 8 hours a day but starts at "08:00" and finishes at "15:00", for…
Carlos Yasuda
- 121
- 12
0
votes
2 answers
Truncating Errors in Microsoft Mysql Manager
I'm trying to import a csv file into a mysql database in Microsoft Mysql Manager. There are about 40,000 records in total and I've already made the database I'm trying to get the data into.
This is the error message that I'm getting:
Msg 4864,…
