Tellico and MySQL

2007-05-26 Thread John Meyer
I'm still searching online, but does anybody know of a script that will input a tellico database into MySQL? -- The NCP Revue -- http://www.ncprevue.com/blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED

General Questions About Indexes

2007-05-26 Thread John Kebbel
I have a few questions about indexes. I understand (1) what an index is, and (2) why indexes are useful, but I don't have even a rough idea about HOW they work. The internet resources I've been able to find don't answer the questions I'm asking. I also tried cat /var/lib/mysql/srms07/staff.

RE: restore one database.

2007-05-26 Thread Ezequiel L. Pellettieri
Hi Ananda, I don't know how to solve this, but if you have space in another storage, try restoring your all-databases dump there and then create a new onlyone-database dump to restore in your server. Regards. Pelle.- -Mensaje original- De: Ananda Kumar [mailto:[EMAIL PROTECTED] Envia

restore one database.

2007-05-26 Thread Ananda Kumar
Hi All, I have take mysqldump of all the databases. If somebody accidently drops one database, can i restore just that database from mysqldump and apply the binary logs to restore all the data to that database. If yes, can you please let me know how that can be done. I am using version 5.0.40 r

LAST_INSERT_ID & LAST_UPDATE_ID

2007-05-26 Thread sam rumaizan
How can I select (retrieve) the last updated cell (field). Basically I need to pull the new information only. I'm using for updating my database: UPDATE table SET column = CONCAT_WS ('column,'" . $column."') WHERE column= value; I need to select data: SELECT * FROM table WHERE column=What

RE: Avoiding TIMESTAMP

2007-05-26 Thread Tim Lucia
> -Original Message- > From: Miguel Cardenas [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 26, 2007 8:21 AM > To: mysql@lists.mysql.com > Subject: Avoiding TIMESTAMP > > Hello list > > I need to solve a little problem but don't mind how, maybe you could > suggest > something. > > I hav

Avoiding TIMESTAMP

2007-05-26 Thread Miguel Cardenas
Hello list I need to solve a little problem but don't mind how, maybe you could suggest something. I have a database which registers payments, records have a AUTO_INCREMENT field to assign a unique consecutive number associated to every payment, some other fields that store the amount, type of