User Profile

Collapse

Profile Sidebar

Collapse
acesfull
acesfull
Last Activity: Nov 3 '07, 06:49 AM
Joined: Oct 20 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • acesfull
    replied to change value of one element between certain dates
    in MySQL
    This looks like it would be best suited for a cron job executing the something like following:

    UPDATE YourTable SET Active=0 WHERE EndDate <= CURRENT_DATE()

    Depending on your EndDate format, this should work...
    See more | Go to post

      Leave a comment:

    • acesfull
      started a topic INSERT into one table based on data from another table
      in MySQL

      INSERT into one table based on data from another table

      Hi, I am trying to do something in SQL that I have done in PHP, but I am trying to have the operation performed as a stored procedure because of the sheer number of inserts I have to perform in PHP. I could really use some help!

      I'm not how to assign variables based on subqueries, or how to even structure the nested queries...

      I have a table with the following fields

      scores
      userId INT
      testId...
      See more | Go to post
      No activity results to display
      Show More
      Working...