Questions tagged [routines]
103 questions
0
votes
2 answers
Python how to use inputs from sub routines in another sub routine
I have a problem to solve in Python whereby the user inputs variables such as number of items they want to buy. I've got this as a def customer, with an output 'how many widgets would you like' and then their input multiplied by a price of say £10.…
A.Teacher
- 11
- 3
0
votes
1 answer
MYSQL Stored Procedure - Can not create procedure
Now trying to create a new procedure as root user with some additional parameters
DELIMITER //
USE `user_main_table`;
DROP PROCEDURE IF EXISTS insert_user_temp;
CREATE DEFINER='root'@'localhost' PROCEDURE insert_user_temp()
BEGIN
DECLARE…
Slimshadddyyy
- 4,085
- 5
- 59
- 121
0
votes
1 answer
PDO fails to excute after first attempt, args will not be added to prepared statement in a routine?
Enviro: MySQL, PHP 5.5
I have a situation where I need to return a random result from the Database. I have tried two methods of doing this. One which returns an array of results and I randomly pick one using the array_rand($results) and the other is…
mcv
- 1,380
- 3
- 16
- 41
0
votes
1 answer
How to count select distinct MySQL with 3 column
I've a table like:
ID_USER USERNAME_USER REF_USER STATUS_AKTIF
1 a aktif
2 b a tidak
3 c a aktif
4 d b aktif
5 e a …
pr4mz
- 5
- 6
0
votes
0 answers
Adding Routines MySQL Workbench
I'm using MySQL Workbench 6.2.4 and I am trying to create a routine. However, I have no option to create a routine. I've seen the folder come up in the object viewer on other people's application, but it doesn't on mine. I've updated to the latest…
Demetrick Norris
- 41
- 1
- 2
- 9
0
votes
1 answer
Multiple installation of device, the windows xp shows the error code 28
I have created the driver for our device and installed in windows xp. While installing first time it will install successfully and shows in windows driver list. But when again install the windows xp shows that error code 28 and in driver list is…
CrazyCoder
- 772
- 5
- 11
- 31
0
votes
1 answer
Why does this mysql routine always returns a false in phpmyadmin sql console of XAMPP?
I just reinstalled XAMPP using this installer: xampp-win32-1.8.3-2-VC11-installer. The issue below still exists. I have saved the routine, and have called it from the phpmyadmin sql console.
Environemnt: 5.6.14 - MySQL Community Server (GPL),…
mcv
- 1,380
- 3
- 16
- 41
0
votes
1 answer
use mysql functions for multiple databases with same pattern name
Can I import Mysql function and use it for multiple database with same pattern name without import that function any more ?
I know Mysql save function in two table :
information_schema.ROUTINES and mysql.proc
Does anyone have an idea to do this?
user2952708
- 11
- 4
0
votes
1 answer
Insert results of a stored procedure into an existing table
I have a table called Percentages with a Column called 5StarResults, I would like to populate this with the results of a stored procedure names 5star.
When I use 'Call 5star' it returns just a percentage, I would like this percentage inserted into…
user2785062
- 5
- 3
0
votes
0 answers
MYSQL Routine with fulltext search on temp table. Performance Issues
I have a table Called "Item" that is INNODB and has the following layout:
ID
DESCRIPTION ->fulltext index.
DATE
The Fulltext Index is set to index words that are 1 character, unfortunately I can't get around this requirement. The following Routine…
mscard02
- 315
- 4
- 15
0
votes
1 answer
how to determine whether a function can sleep or not?
In the Linux, interrupt handler which also called top half cannot sleep.
The issue is that How can I determine whether a function can cause sleep?
Can I use input_event, input_sync in top half?
Bill Wang
- 197
- 1
- 10
0
votes
1 answer
is it possible to write the sum of one column into a new dataset of the same table every hour by a routine only with mysql?
For a smart metering application i would like to aggregate counter data every hour.
For this a query like 'select sum(value) as GasCounter from data where channel_id=8' gives the actual counter value.
For another display task i need this as data of…
Bernd Gewehr
- 97
- 1
- 12
0
votes
1 answer
Count by range doesnt give desired output
Im creating a routine to give me a output like
| Row | Voters | Households |
| Total | 15235 | 7250 |
| Poll | NULL | NULL |
| <70% | 5000 | 2500 |
| <80% | 3500 | 2235 |
.....
| AV | …
razerer
- 79
- 1
- 8
0
votes
1 answer
Open ssl unkown protocol
I wrote a code that worked for me great, I don't remember modifying it..
I compiled it today and tried to run it, but I got this error:
error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol
I also tried to connect to the host name with…
TryTech
- 41
- 2
- 3
0
votes
1 answer
Issue with MySql Routine
I am having an issue with making a MySql Routine.
Here is the code:
DELIMITER '$$';
CREATE PROCEDURE User.Login(IN UserName CHAR(32), IN PWord CHAR(32))
BEGIN
Select `userID`, `userType`, `userMainEmail`, `groupID`
From `at_users`
Where…
Kevin
- 2,684
- 6
- 35
- 64