User Profile

Collapse

Profile Sidebar

Collapse
DougieC
DougieC
Last Activity: Jul 10 '07, 03:36 PM
Joined: Jun 12 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • DougieC
    replied to MySQL : Looping query
    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.
    See more | Go to post

    Leave a comment:


  • DougieC
    started a topic MySQL : Looping query

    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...
    See more | Go to post

  • DougieC
    replied to MySQL - Chaining a Series of SQL commands
    Thanks, thats exactly what I needed. I believe that my biggest problem is figuring out what everything is called :) thanks for the help....
    See more | Go to post

    Leave a comment:


  • DougieC
    started a topic MySQL - Chaining a Series of SQL commands

    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...
    See more | Go to post

  • 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,...
    See more | Go to post

    Leave a comment:


  • DougieC
    started a topic MySQL Auto_increment with large number of records

    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?
    See more | Go to post

  • DougieC
    replied to MySQL Append Query question
    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))
    See more | Go to post

    Leave a comment:


  • DougieC
    replied to MySQL Append Query question
    In this table, each record (or individual) has a SSN as a unique identifier.
    See more | Go to post

    Leave a comment:


  • DougieC
    started a topic MySQL Append Query question

    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...
    See more | Go to post
No activity results to display
Show More
Working...