Recent questions tagged stored

0 votes

819 views

1 answer

stored procedures - use a variable for table name in mysql sproc

I'm trying to pass a table name into my mysql stored procedure to use this sproc to select off of different tables ... TableName doesn't exist...which I know :) Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

540 views

1 answer

stored procedures - Can I create view with parameter in MySQL?

I have a view like this: CREATE VIEW MyView AS SELECT Column FROM Table WHERE Value = 2; I'd like to make it ... workaround. Is there a proper way to do this? Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

675 views

1 answer

stored procedures - NZPLSQL: How to stop backslash from escaping single quote

First time posting a question here, so please excuse me if there are formatting issues. I am trying to write ... /65598372/nzplsql-how-to-stop-backslash-from-escaping-single-quote...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

stored procedures - Mysql Error Code: 1329. No data - zero rows fetched, selected, or processed

so i have a store procedure where the function is to find out the column which contains the name expired or end ... -error-code-1329-no-data-zero-rows-fetched-selected-or-processed...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

821 views

1 answer

stored procedures - use a variable for table name in mysql sproc

I'm trying to pass a table name into my mysql stored procedure to use this sproc to select off of different ... /questions/2754423/use-a-variable-for-table-name-in-mysql-sproc...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

689 views

1 answer

stored procedures - Sum at each level of a tree view in sql

I have a table that looks like this CREATE TABLE [dbo].[CNF_StatisticalGroup] ( [StatisticalGroupId] [int] IDENTITY(1,1) ... in a SQL statement or a view or a stored procedure?...