Help for a query with MYSQL 3.23.58

Could you help me with a query? 1) I know some values of id_value in the table below : PRODUCTS_VALUE. 2) I'm looking for id_product that can contemporaneously satisfy more than an id_value (NOT ONLY ONE!!) For example I'm looking for all id_product that can contemporaneously satisfy (id_value=

Re: Help for a query with MYSQL 3.23.58

> 2) I'm looking for id_product that can contemporaneously satisfy more > than an id_value (NOT ONLY ONE!!) contemporaneously? that's got be one of the best made up wor... wait what? you mean it's a real word? http://dictionary.reference.com/search?q=contemporaneously I'm not sure to understand

didn't find any fields error

Hi, i'm a new user. I copied a db in the mysql db path but when I try to use database I obtain : didn't find any fields from table ... for each table. What may I do to read the database? I read the documentation but I didn't find any solution. Thanks. Mic

Re: didn't find any fields error

Reading a hint in the net I created a dbfile with mysqldump on the source pc (WinXP): mysqldump dbfile > mysqldbname Now I have to take this file and create the database in the dest pc (Linux). I should use mysqladmin (is it true?) but what's the right command? Thanks Mic. -- MySQL General

Re: didn't find any fields error

I solved!! The dbfile was a sequence of sql commnds, so the command to import that file was mysql dbname < dbfile after creating dbname. My job chair is saved (maybe)! - Original Message - From: "michele digioia" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>

Enabling Mysql in php

Hi. I haven't mysql enabled in php. How may I do it? I have php 4.0.4, mysql 3.23.36, both installed on linux RH 7.3. Thanks Mic.

Re: Enabling Mysql in php

php-mysql RPM is already installed. In any case, I downloaded last php version. Now configuration requires both mysql and apache path to specify in --with-mysql and --with-apache options. But what are these paths? Mysql and Apache files are everywhere. Thanks a lot. Mic. - Original Message ---

Can't execute the given command because you have active locked tables or an active transaction

reign keys. The db is READ-COMMITTED mode, and no other strange things are around. I woldu like to truncate all the table, then insert new records. I found that a bug was discovered on 4.0.2, but i have 4.0.20... Thanks for any help. Michele -- MySQL General Mailing List For list archives: http://

Web interface

but I'll appreciate to know any other language available. Thank to everyone who'll spent time to send me a fee-back. Regards, Michele http://www.devspy.com/ - Before posting, please check: http://www.mysql.com/manu

RE: ADO to MySQL interface?

ADO supports ODBC drivers and all ODBC functionality as well as the newer ADO/OLEDB interfaces. You should be fine with the ODBC. Michele Harlass DBA AbcEd.com, Inc -Original Message- From: Guy Davis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 1:29 PM To: [EMAIL

Need help with query result

R AS C WHERE WC.PERS_ID = C.PERS_ID AND C.COMM_TYPE = 'Telephone'; This returns: NamePhone Michele Memon 212-290-8848 My second selecyt query looks like this: SELECT WC.FIRST_NAME & ' ' & WC.LAST_NAME AS NAME, C.COMM_NO AS EMAIL FROM WRK_C

Recall: Need help with query result

Memon, Michele would like to recall the message, "Need help with query result". - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Newbie MySql

experience with selecting data that I need based on a where clause and spooling the info to a file. But I haven't had any experience parsing through a field for invalid characters. Any ideas on how I should approach this? Michele Memon Developer (212) 290-8

Re: [OT] "ourName.BEST321.com" FREE §K¶O°ì¦W !!!!!

Water wrote: > Dear Webmaster, Ok, qhat i think is that son of a bitch is going to subscribe the list to any kind o maling lists. It is going to subscribe and unsubscribe only to joke Soem solutions need to be taken from the owner of the lists: A) DUL,RBL B) new subscriber will be moderate

PHP & MySQL

I have a stupid problem with PHP & MySQL (I'm a newbie of course): I push in a text/blob record a string like this: when I read & print this record with PHP (using a simple echo statement ) I got back the string translated in this way: How can I prevent P

Re: PHP & MySQL

> How'd you put it into the database in the first place? I'm betting that, if > you look at your database directly (not through a UI), you'll find the data > is stored as "

A problem relative ibdata1

Hello! First of all sorry for my terrible english. Well I've a big problem with ibdata1, this damn file increase its size constantly. I tryed to use innodb_file_per_table... but: - MySQL create a lot of ibd files for all DB (correct) - ibdata1 is however created and increase its size... how