wysiwyg web soft
Hi to all, I'm fed up with Access as a wysiwyg editor for mysql. Generaly, i'm fed up with client that i have to install on each comp. Actualy, i'm looking for an opensource wysiwyg web software. Something like the very good phpMyAdmin but with 'visual' request editor for simple users. If anyone knows such thing. Thanx. fab. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sql prob
Hi all :) I have 1 relation A. Structure of A: NoPeople Date_entry Date_departure and key is (NoPeople + Date_entry) exemple of records: NoPeople Entry Departure P1 E1 D1 P1 E2 D2 P1 E3 NULL P2 E1 NULL P3 E1 D1 P4 E1 NULL P4 E2 NULL P4 E3 D2 E3E2E1 and D2D1. P1,P2,P3 and P4 are different persons. I would like to query all the people whose date_entry is their MAX date entry AND that have their date departure to NULL. In this exemple, P1 and P2 are ok. P4 isn't ok because max(Date_entry) is E3 and Date_departure - when Date_entry is E3 - isn't NULL. I tried some queries with 'group by' but i can't make it working. Any hint sql masters :) fab -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: sql prob
Thanx a lot Tom :) I guess you forgot 'group by NoPeople' at the end of the first query. right ? fab Tom Cunningham wrote: Try this: CREATE TEMPORARY TABLE max_entry SELECT NoPeople, Max(Date_entry) AS Date_entry FROM table; SELECT NoPeople FROM table NATURAL JOIN max_entry WHERE Departure IS NULL; Hi all :) I have 1 relation A. Structure of A: NoPeople Date_entry Date_departure and key is (NoPeople + Date_entry) exemple of records: NoPeople Entry Departure P1 E1 D1 P1 E2 D2 P1 E3 NULL P2 E1 NULL P3 E1 D1 P4 E1 NULL P4 E2 NULL P4 E3 D2 E3E2E1 and D2D1. P1,P2,P3 and P4 are different persons. I would like to query all the people whose date_entry is their MAX date entry AND that have their date departure to NULL. In this exemple, P1 and P2 are ok. P4 isn't ok because max(Date_entry) is E3 and Date_departure - when Date_entry is E3 - isn't NULL. I tried some queries with 'group by' but i can't make it working. Any hint sql masters :) fab -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dbf2mysql
Does anyone have an example of a dfb2mysql (contributed software) character conversion file (-e)? I need to know which format should be used when specifying the characters (octal, hex, ascii etc). Many thanks for any help! fab. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Web client
Hi to all, I'm fed up with Access as a wysiwyg editor for mysql. Generaly, i'm fed up with client that i have to install on each comp. Actualy, i'm looking for an opensource wysiwyg web software. Something like the very good phpMyAdmin but with 'visual' request editor for simple users. If anyone knows such thing. Thanx. fab. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
minus operation
Hi to all, My question is rather about sql langage than mysql. Here it is: i have 2 tables (A and B) with the same structure (4 fields called f1,f2,f3,f4). Table A counts x records and table B counts y records (and x y). Then, table A has records that do not belong to table B and table B has records that do not belong to table A. My question is: how to get the records that belongs to A and not to B and the records that belongs to B and not to A. If i was using oracle, i guess i could use the minus sql command. More over, i don't think i can use a simple left join because i have to verify the 4 fields and not only the first one. If anyone could answer, it would be great. Actualy, i lost lots of records and i try to rebuild my table with the help of the savings of this table. f. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: file:/// protocol
oops, sorry, i missed the right forum ;) [EMAIL PROTECTED] a écrit : Hi to all, I'd like to use the file:/// protocol with mozilla mail. But how ? When i create an html document, i can insert links with file:/// protocol. Exemple: !DOCTYPE html PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head/head body a href=file:///C:/Mydoc.pdfwanna read MyDoc ?/a /body /html And it works fine. When i click on the link, acrobat reader opens. However, when i write a mail with this link inside then , when i receive this mail and click on the link, nothing happens (despite the fact i can see (in the status bar before i click on the link) the sentence :file:///c:/MyDoc.pdf. What did i miss ? thanx in advance ;) fab. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dbf2mysql
Hi to all :) I'm looking for the rpm of the great prog dbf2mysql version 1.14. I've found a rpm of an older version (1.10) but that's not enough. Anybody ? thanx in advance ;) fabrice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: LOAD DATA INFILE syntax
Hi and thanx :) I've found dbf2mysql and it should solve my prob. However, my linux server is a production server (web + mail) and none programmation environnement is installed on it (no gcc and so on) and i don't want to. So, could anyone send me the binary for dbf2mysql ? I use Red-Hat 7.3 on i386. thanx fabrice. gerald_clark a écrit : 1 will work. 2 will not work. 3 Use dbf2mysql. ( It should be in the downloads section on mysql.com ) fab wrote: Hi all, I'm quite new in mysql. Despite i've read a part of the doc, i can't fix my prob. Here is my question: I want to convert a DBASE IV file into mysql table: 1) Have i to convert the dbf into flat file then use the LOAD DATA INFILE cmd ? or 2) Can i directly use the LOAD DATA INFILE cmd with my dbf file ? I've tried the second point but it doesn't seem to work. Thanx in advance. fabrice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: LOAD DATA INFILE syntax
I've found the rpm. fab a écrit : Hi and thanx :) I've found dbf2mysql and it should solve my prob. However, my linux server is a production server (web + mail) and none programmation environnement is installed on it (no gcc and so on) and i don't want to. So, could anyone send me the binary for dbf2mysql ? I use Red-Hat 7.3 on i386. thanx fabrice. gerald_clark a écrit : 1 will work. 2 will not work. 3 Use dbf2mysql. ( It should be in the downloads section on mysql.com ) fab wrote: Hi all, I'm quite new in mysql. Despite i've read a part of the doc, i can't fix my prob. Here is my question: I want to convert a DBASE IV file into mysql table: 1) Have i to convert the dbf into flat file then use the LOAD DATA INFILE cmd ? or 2) Can i directly use the LOAD DATA INFILE cmd with my dbf file ? I've tried the second point but it doesn't seem to work. Thanx in advance. fabrice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LOAD DATA INFILE syntax
Hi all, I'm quite new in mysql. Despite i've read a part of the doc, i can't fix my prob. Here is my question: I want to convert a DBASE IV file into mysql table: 1) Have i to convert the dbf into flat file then use the LOAD DATA INFILE cmd ? or 2) Can i directly use the LOAD DATA INFILE cmd with my dbf file ? I've tried the second point but it doesn't seem to work. Thanx in advance. fabrice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]