stored procedure to insert data into table from another table

Mysql can insert data to a specified table based on the query results. MySQL can insert the queried record set to the specified table. The example is as follows: First, describe the structure of the three tables: S (sno, sname. sex, age, dept) // student information

| query_ns1 | Query_ns2 | QUERY_NS3 | QUERY_NS4 | Report_date |+----+------------+------------+------+-----------+-----------+-----------+-----------+-------------+| 1 | dnspod.com | Dnspod | com | 1000 | 2000 | 0 | 0 | 2007-02-04 |+----+------------+------------+------+-----------+-----------+-----------+-----------+-------------+1 row in Set (0.00 sec)mysql> insert INTO ' 200702 ' (' Domain ', ' 2nd_doma

You can use the "generate SQL script" tool that comes with SQL Server 2000 to generate SQL scripts for creating tables, views, and stored procedures. So can we generate SQL scripts for the data in the table and automatically import the data to SQL Server after executing these scripts

How to delete a piece of data and insert this data into another one is shown in two tables: sns_topic and sns_topic_del. edit the data on the list page of the sns_topic table, if you want to delete a piece of

A temporary table is a table whose names start with a pound sign. If the temporary table is not removed when the user disconnects, SQL Server automatically removes the temporary table. Temporary tables are not stored in the current database, but stored

Image Type Method: 1. creation process Create procedure sp_textcopy ( @ Srvname varchar (30 ), @ Login varchar (30 ), @ Password varchar (30 ), @ Dbname varchar (30 ), @ Tbname varchar (30 ), @ Colname varchar (30 ), @ Filename varchar (30 ), @ Whereclause varchar (40 ), @ Direction char (1 )) As Declare @ exec_str varchar (255) Select @ exec_str = 'Textcopy/s' + @ srvname + '/U' + @ login + '/P' + @ password + '/D' + @ dbname + '/T' + @ tbname + '/C

How to delete a piece of data and insert this data into another one is shown in two tables: sns_topic and sns_topic_del. edit the data on the list page of the sns_topic table, you need to delete a piece of

Big Table data migration,Every morning1Point5Point execution, The execution interval is 10 minutes,Migrate old data to the History Table. DELIMITER $ USE 'dbx' $ Drop procedure if exists 'Pro _ xx' $ Create procedure 'Pro _ xx

Go A, b two tables, find the ID field, there is a table, but there is no data in table B. A total of 13w data, after the deduplication of about 3W data, b table has 2W

Ocialrelation SET lingqi = 1800 WHERE NodeName = shizuname;24 ELSE25/* Otherwise, normal update */26 UPDATE socialrelation SET Lingqi = Lingqi + WHERE NodeName = shizuname;27 END if;28 EN D if;29 FETCH NEXT from RS toShizuname, currentlingqi;31 UNTIL done END repeat;33 34/* Close cursor */35 close rs;36 END 　　Today write a MySQL stored procedures, according to their own needs to traverse a data t