Re: mysqldump

hi kalle, i had exactely the same problem as you before from the command prompt. All i did to go around that was to create a blank user before running the script, remove it after and then flush. _ MSN 8 helps eliminate e-mail viruses

How to rewrite this query??

hi, i have the following query working perfectly with Dbase 4, but it crashes in mysql : SELECT SUM(DISTINCT A.AMOUNT) AS AMT FROM table1 A I'd like to get that amount in only one query if possible, even though i could do it by using a temporary table, selecting into it all the distinct amoun

Re: Select name, email where birthday = ??

Hello, I have a date field in my database Format is -MM-DD Once a day at 12:01AM a script is going to run that will Select name, email from users where birthday = ?? And the ?? Is where I am stuck, I don¹t care about the year at all, I just need to match on the month and day, how would I do t

how to Import from tab delimited text file?

hi, i'd like to have the syntax to import in a mysql table from a tab delimited text file, and also the same thing from an excel file. Thanx _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=fe

Re: InterBase vs. Mysql

hi heikki, thanks for correcting me on the salary aspect. Most benchmark published actually give credit to mysql when it comes to Mysql Vs Interbase, but as an end user, the best tests are the one i conduct myself in my premises. Therefor when i say that mysql Vs interbase definitely goes to inte

Re: InterBase vs. Mysql

MySQL Licence will cost us more than our product price. Wow, what a company!! how much do you sell your products ?? MySQL sails staff are rude and unfriendly. Can't tell, anytime i needed help, i used this forum, and i rather met some real interesting guyz and dedicated guyz (widenius, egorov,

Re: InterBase vs. Mysql

hi Maciej, the only arguments you can get in favour of mysql is that it's free, and some of its SQL statement are faster than interbase. Interbase has the advantage of having views, stored procedures,triggers,and it's crazily fast. Don't forget that interbase is also written by professionnal on

RE: How to write delete query??

thanx joe, i checked. I just thought that there could be a way around this problem! From: "Joe Stump" <[EMAIL PROTECTED]> To: "Inandjo Taurel" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: RE: How to write delete query?? Date: Mon, 17 Feb 2003 09:

How to write delete query??

SQL SQL hi all, i have a query that works just fine on Dbase, but just crashes on mysql. How can i write it in one statement for it to work both on Dbase and mysql? the query: - delete from table1 where table1.field1 in (select distinct field2 from table2). Thanx _

A sensible way to create indexes!

hi all, i wanted to know how best i could create indexes on a given table. My database is not normalised, so i have a huge transaction table that i used to generate my reports. The thing is that there are at least 5 fields that i can use as indexes in my queries, to speed them up. Do you think it

How to write this query??

hi all, i have a table trans with this structure: today(date) | heure1(time) | amount(double) | client(varchar 30) Now i need to write a query that would take the start date and time, end date and time, and return all the records between the two. So for example, the query should return all

How to write this query??

hi all, i have a table trans with this structure: today(date) | heure1(time) | amount(double) | client(varchar 30) Now i need to write a query that would take the start date and time, end date and time, and return all the records between the two. So for example, the query should return all

How to write this query??

hi all, i have a table trans with this structure: today(date) | heure1(time) | amount(double) | client(varchar 30) Now i need to write a query that would take the start date and time, end date and time, and return all the records between the two. So for example, the query should return all reco

Pointer showing SQL and hanging!

hi, after issuing a query from my application, the pointer changes and has an inscription (SQL) underneath it. Normally the pointer should come back to normal, after the query is complete. unfortunately it doesnt, i have to click on other buttons before it comes back to normal. Is there somethin

killing a hung thread

hi, i'd like to know if there is a way to tell the mysqld to remove a thread that has hang, without human intervention. Let say an update query is fired to the engine, and the client just freezes and we have to reboot the machine manually: how can i make sure that mysqld will remove that threa

Constant table CORRUPTION problem!!!!!

sqlsqlsqlsqlsqlsqlsqlsqlsql hi , I've been having a constant nightmare for the past 2 weeks: a particular table gets corrupted every at least twice. Am using the 3.23.49 windows version and Myisam table types on Win2k, and the operation crashing the database seems to be an update. I get an erro

UDF on win2k??

hi, i checked the manual, but i want a confirmation here: Mysql for window doesn't have UDF, right? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

how to delete from one table based on external conditions?

hi, i would like to know how i can achieve this kind of query: delete form table1 where table2.x=table1.y I checked the manual, there nothing like that! Am using mysql 3.23.49 SQL SQL SQL SQL SQL _ Send and receive Hotmail on your

Query problem with insert into....select

hi, i have 2 tables: currencyrates +-+++ | code char(3)|| currency char(3) | | name varchar(10)|| rate double| | bcurrency char(1) |