User Profile
Collapse
-
Didnt work. I believe the problem is that it can not generate multiple auto_incremente d numbers simultaneously. I would like to figure out how to do this with looping. Any links or walk throughs on looping would be helpful. -
MySQL : Looping query
I am trying to insert records into a mastertable. The first field is auto-incrementing and therefore I am unable to insert all records at the same time. I have create the following code to insert one record in at a time.
insert into `mastertable3`
select ' ', 0301_2500.ssn, 0301_2500.vsssn , 0301_2500.name_ ind, 0301_2500.pay_g r_aa
from time_period, Mastertable3 right join 0301_2500 on mastertable3.ss n = 0301_2500.SSN... -
Thanks, thats exactly what I needed. I believe that my biggest problem is figuring out what everything is called :) thanks for the help....Leave a comment:
-
MySQL - Chaining a Series of SQL commands
Hello all,
I am still relatively new to MySQL and databases in general. I am working on populating a mastertable for Human Resource and have developed a series of MySQL commands to accomplish this. I would like to automate this as much as possible.
Is there a way to link several different SQL commands together?
Many commands rely on the command prior to it.
Just for reference, these... -
Sorry maybe I was unclear. I have 10 years of monthly Human resource data, composed of hundreds of thousand records per extract. I am taking raw data, and after shifting through to find reliable data, am creating a usable database.
I have multiple tables that I am populating. In some tables I can use a unique identifier of a SSN. But in other tables, individuals (SSNs) will be duplicated when there are changes to their information,...Leave a comment:
-
MySQL Auto_increment with large number of records
Hello all,
Here is my problem. I am inserting time series data into a mastertable. I would like to use an Auto_incrementi ng field as my primary key. Is this possible when inserting multiple records at the same time?
Any special script needed? -
I appreciate the help. This was the script that I finally used to solve the problem.
insert into `mastertable`
select Table2.*
from Mastertable right join Table2 on mastertable.ssn = table2.SSN
where (((if(mastertable.ss n=Table2.ssn, 0, 1))=1))Leave a comment:
-
In this table, each record (or individual) has a SSN as a unique identifier.Leave a comment:
-
MySQL Append Query question
Hello all. First off, Im not a programmer so I am some what stumbling through this. 8 years of social science education never trained me to handle real world problems, such as figuring out how to develop a Data Base for the military.
So a summary of my problem. I am using MySQL, on the suggestion of the higher ups, to combine multi-yeared data into one master table. My logic works like this.
Populate a Master Table...
No activity results to display
Show More
Leave a comment: