Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: create table via stored procedure (passing the table name to it)
Special Forums UNIX and Linux Applications create table via stored procedure (passing the table name to it) Post 302439879 by rethink on Saturday 24th of July 2010 12:12:43 PM
Old 07-24-2010
thanks Pludi, there definitely is lot more to it than i thought there was..unfortunately it thinks the table i want to create is field !?!.

Ive dropped the WHERE condition to simplify, im creating the table with data from the already existing 'admin' table

Code:
mysql> DELIMITER //
mysql> CREATE PROCEDURE createtable(IN tname varchar(20))
    -> BEGIN
    -> 
    -> SET @s = CONCAT('DROP TABLE IF EXISTS ', tname);
    -> PREPARE stm FROM @s;
    -> EXECUTE stm;
    -> 
    -> SET @s = CONCAT('CREATE TABLE ', tname, ' SELECT * FROM admin');
    -> PREPARE stm FROM @s;
    -> EXECUTE stm;
    -> 
    -> END //
Query OK, 0 rows affected (0.08 sec)

mysql> DELIMITER ;
mysql> call createtable(accounts);
ERROR 1054 (42S22): Unknown column 'accounts' in 'field list'
mysql>

Its definitely getting there though, thank you again for your help
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

passing parameter 4m shell script to a DB stored procedure

hi all please tell me how to pass parameters 4m shell script to a DataBase stored procedure. To be specific i have sybase DB. i mean i want the syntax of the command.. how to connect to DB, pass user id and password, pass the required parameter to SP.. .. need ur help frnds.. hema (0 Replies)
Discussion started by: hema2026
0 Replies

2. Shell Programming and Scripting

loading the data to the partitioned table using procedure

Hi one help, I need one procedure to load data from flat file to table. Table name as input parameter for the procedure. can anyone help me Thanks, Raj, (1 Reply)
Discussion started by: easterraj
1 Replies

3. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies

4. Shell Programming and Scripting

Passing a value to stored procedure from unix shell script

Hi Dudes :) I want a unix shell script to pass value to SQL stored procedure. Below is the procedure declare res varchar2(10); begin odm_load_check('PRE_SANITY',res); dbms_output.put_line(res); end; select * from error_log; truncate table error_log; select * from test; (1 Reply)
Discussion started by: shirdi
1 Replies

5. Shell Programming and Scripting

Read Table,View,Package,Function and Procedure Name in a File

Hi I am new to Unix shell scripting. But i need help to slove the below issue. Issue description: I want to read table, view names and package names in a file my plan to find the table name is : search "From" key word find the table or view To find the packge name : Search "Package... (5 Replies)
Discussion started by: sboss
5 Replies

6. Shell Programming and Scripting

How to create and call mysql stored procedure in perl?

Hi, I want to create MySQL stored procedure and call the stored procedure using perl. I tried like this: use DBI; my $dbh = DBI->connect ("DBI:mysql:test", "root", "ibab", { RaiseError => 1, PrintError => 0}); $create_procedure =... (5 Replies)
Discussion started by: vanitham
5 Replies

7. UNIX for Dummies Questions & Answers

Creating a condensed table from a pre-existing table in putty

Hello, I'm working with putty on Windows 7 professional and I'd like to know if there's a way to gather specific lines from a pre-existing table and make a new table with that information. More specifically, I'd like the program to look at a specific column, say column N, and see if any of the... (5 Replies)
Discussion started by: Deedee393
5 Replies

8. Shell Programming and Scripting

Unix path stored as a column in table

The db2 table stores the unix path as below PARM VALUE RootPath $SRootDir Target $SRootDir/target $SRootDir is set in the env variable as /home/test/root In the shell script i read the table value and store it in a variable pth=db2 -x "select VALUE from... (2 Replies)
Discussion started by: 2jnags
2 Replies

9. Shell Programming and Scripting

Build a table from a list by comparing existing table entries

I am new to this shell scripting.... I have a file which contains list of users. This files get updated when new user comes into the system. I want to create script which will give a table containing unique list of users. When I say unique, it means script should match table while parsing... (3 Replies)
Discussion started by: dchavan1901
3 Replies

10. Web Development

Getting Rid of Annoying Bootstrap Table Borders and Wayward Table Lines

Bootstrap is great; but we have had some issues with Bootstrapped <tables> (and legacy <fieldset> elements) showing annoying, wayward lines. I solved that problem today with this simple jQuery in the footer: <script> $(function(){ $('tr, td, fieldset,... (0 Replies)
Discussion started by: Neo
0 Replies

LEARN ABOUT HPUX

gsscred

gsscred(1M)															       gsscred(1M)

NAME

       gsscred - add, remove and list gsscred table entries

SYNOPSIS

       user oid] uid]] comment]

       user oid]] uid] mech]

       user oid]] uid] mech]

DESCRIPTION

       The  utility  is used to create and maintain a mapping between a security principal name and a local UNIX uid.  The format of the user name
       is assumed to be You can use the option to specify the object identifier of the name type.  The OID  must  be  specified  in  dot-separated
       notation, for example:

       The table is used on server machines to lookup the uid of incoming clients connected using

       When  adding  users,  if no user name is specified, an entry is created in the table for each user from the passwd table.  If no comment is
       specified, the utility inserts a comment that specifies the user name as an ASCII string and the GSS-API security mechanism that applies to
       it.  The security mechanism will be in string representation as defined in the file.

       The  parameters	are  interpreted  the  same way by the utility to delete users as they are to create users.  At least one of the following
       options must be specified: or If no security mechanism is specified, then all entries will be deleted for the user identified by either the
       uid or user name.  If only the security mechanism is specified, then all user entries for that security mechanism will be deleted.

       Again, the parameters are interpreted the same way by the utility to search for users as they are to create users.  If no options are spec-
       ified, then the entire table is returned.  If the user name or uid is specified, then all entries for that user are returned.  If  a  secu-
       rity mechanism is specified, then all user entries for that security mechanism are returned.

   Options
	      Add a table entry.

	      Insert comment about this table entry.

	      Search table for entry.

	      Specify the mechanism for which this name is to be translated.

	      Specify the optional principal name.

	      Specify the OID indicating the name type of the user.

	      Remove the entry from the table.

	      Specify the uid for the user if the user is not local.

EXAMPLES

   Example 1: Creating a gsscred Table
       The  following  shows how to create a table for the Kerberos Security Mechanism(V5).  obtains user names and uid's from the passwd table to
       populate the table.

   Example 2: Adding an Entry
       The following shows how to add an entry for with a specified uid of 0 for the Kerberos Security Mechanism(V5).

   Example 3: Listing All User Mappings
       The following lists all user mappings for the Kerberos Security Mechanism(V5).

   Example 4: Lising All Mappings for a Specified User
       The following lists all mappings for all security mechanisms for the user

EXIT STATUS

       The following exit values are returned:

	       0     Successful completion.
	      >0     An error occurred.

FILES

	      The mapping table.

	      Tables of GSS-API based security mechanism installed.

SEE ALSO

       gssd(1M), gsscred_clean(1M).

																       gsscred(1M)
All times are GMT -4. The time now is 12:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy