Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Jul 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    import logic code

    I have been using PHPmyadmin to do daily imports...

    1. empty the table...
    2. import the text file

    I'd like to FTP all my files up and then create a statement that will

    do this for several tables...

    This will both automate the process and enable to deal with a SSH ftp connection instead of the 'clear' phpmyadmin...

    Can anyone point me to a resource for this logic OR a way to grab what PHPmyadmin is doing????

    Thanks.
    Fritz Jung
    co-founder
    the Witches' Voice
    www.witchvox.com

  • #2
    New Coder
    Join Date
    Jul 2002
    Location
    Behind my PC :)
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    OK, lemme see....

    if you click _something_ in your PMA, eg 'empty' or somthing, on the page that loaded you will see on the top something like this:

    ---
    affected rows: xxx
    SQL-query:
    DELETE FROM [tabel] WHERE some = 'thing'
    ---

    and that's the query you need, and on this way you can find your needing querycodes.

  • #3
    New to the CF scene
    Join Date
    Jul 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Originally posted by Robbie
    OK, lemme see....

    if you click _something_ in your PMA, eg 'empty' or somthing, on the page that loaded you will see on the top something like this:

    ---
    affected rows: xxx
    SQL-query:
    DELETE FROM [tabel] WHERE some = 'thing'
    ---

    and that's the query you need, and on this way you can find your needing querycodes.
    thanks... That is a path...

    Now to get this all together.
    Fritz Jung
    co-founder
    the Witches' Voice
    www.witchvox.com


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •