import logic code

fritz Jung · 07-23-2002, 10:56 PM

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.

Robbie · 07-24-2002, 09:59 AM

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.

fritz Jung · 07-24-2002, 01:55 PM

Quote:

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.