How can I delete from table element exist in other one

Hello, How can I delete from teble "news" all that are existing in table "news2" the following don't work delete a.* from news where a in news2 Thanx ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Courrier :

Urgent : Execute querys stored in file but from phpmyadmin

hello, I want Execute querys stored in file but from phpmyadmin interface, I want to use telnet to execute the command : # mysql mydb_name < file.sql but in telnet prompt its invalid command Can you help me? Thanx ___ Do You Yahoo!? -- Pour

Please How can I password protect my database?

Hello, I use telnet to manage my mysql database, Please How can I password protect my database, or the database directory. Thanx ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com --

Re: how to do a query using a file?

He, you can download the documentation file from http://www.lri.fr/~aze/PHP/docs/ or others and see the example chapter, In my case, I Store my Access data base in a text file and upload to my serveur, then I execute this sql query: load data local infile "file.txt" into table my_table it works

Is there mysql client under Windows?

Hello, Is there a windows mysql client to manage a distant unix mysql server? Thanx Sofiane ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com ---

What is SSL ?

Hello, I am a Java developper, I use Mysql and TOmcat, I want to know what SSL is? Thanx ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -

Please french character problem

Bonjour, J'ai le probleme des caracteres accetués (é è à,..) qui sont remplacés par '?', j'utilise TOMCAT et apache comme web server, et j'utilise mysql comme serveur de données la génération du code html se fait par des servlets java. Ce que je suis sure est que le probleme n'est pas au niveau

Please, problem with french accentual characters like à é è

Hello,I am a java developper and using mysql database engine, I am using tomcat, I wrote a servlet wich writes a sentences, it works fine but the accentual characters like à é è are replaced by ? character, can some one help me, it's urgent. Thanks

Please Problem : French accetual caracters (like è, à) in html

Hello, I have a problem in writing a servlets which access to mysql database, that can generate a french caracters like é, à Can some Help me. ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yah

Can you Help me? I have Appostroph problem

Hi, I'm new in mysql, I have a problem in the apostroph, I would write a query like : select ID from table where sentence = 'does't take' Can you help me? ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger :

Can I return select (sub query) in array?

Hello,select ... in (select ) dosn't work, can I return the second query in array and use it in the first? Thanx ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com ---

URGENT: select in (select) or Join?

Hello, Please, I use MySql, I would use INTERSECT/UNION functions and they don't work, I need help, My query is : select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From Entreprise E, Mot_Entreprise ME, Mot M, Categorie C where (E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot like 'word1%') and