upgrade from version 5.0.45

are there any important differences i should be aware of between 5.0.45 and 5.0.77 ? any diffferences in password encoding etc. ? the db is properly backed up and replicated on two 5.0.77 slaves. thank you Marco -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Re: Problem with Dynamic table names.

I accidentally sent it before finishing... I am looking for a way to do the following with a single query: > SELECT `ID`, `Name`, `Interface`, > (SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as > `activeListings` > FROM `sites` > I am querying the sites table and I want

Problem with Dynamic table names.

I am looking for a way to do the following with a single query: SELECT `ID`, `Name`, `Interface`, (select count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as `activeListings` FROM `sites`

mysql/os stuck

he problem i have to reboot the entire server. Anyone have some useful information? Thanks Marco

write lock and sql_cache

SQL_NO_CACHE (then SELECT SQL_NO_CACHE FROM foo) is that correct?! there is a way to avoid to specify "SQL_NO_CACHE" ? or there is something wrong ?! thank you in avance. bye bye marco -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to switch off auto-checks ?

My mysql-db starts a "check tables xy fast" for all tables as soon as I re-start the db-server. I didn't find a place where I can control if the db should be checked at start or not. So where can I switch of this checkings at db-server-start ? Thanks in advance Greetings Ma

Too many table-locks

d Memory I can't switch to inno-db in this case. Are there any other conceptional or technical ideas how to reduce the (long lasting) table locks ? Thanks for any idea in advance ! Best regards, Marco smime.p7s Description: S/MIME Cryptographic Signature

Who's locking ?

Hello list, I've a question about understanding table-locks of myisam-tables: >From time to time it happens that my proccesslist gets flooded by Queries, that are waiting for a locked table. Quickly there are 100-500 waiting Queries in the queue - some of them waiting since more than 1000 seconds

Re: Reset (or Defrag) the AUTO_INCREMENT columns

(as in your case) - in db-language it is often the (primary) key - which normaly is never ever changed through the live-time of a data-record. If you change your primary key you'll have to change all references to that key in your detail-tables. Greetings, Marco wolverine my schrieb: > Hi! &g

Re: example when indexing hurts simple select?

Hi Gasper, MySql allows to package the index - to get its size smaller and to gain performance. Some information about that can be found here: http://www.mysqlperformanceblog.com/2006/05/13/to-pack-or-not-to-pack-myisam-key-compression/ Gaspar Bakos schrieb: > Hi, > > > RE: > >> Have you tri

Re: select records not in a *particular* many-to-many relationship

D = ug.userID and ug.groupID = 'Group1' WHERE ug.groupID IS NULL But I have three tables, not two. In other words, I have the name 'Group1,' but not the id. -- Marco Carbone Webmaster/Web Developer Committee to Regulate and Control Marijuana http://www.regulatemari

select records not in a *particular* many-to-many relationship

but they would be for other groups, not "Group1." One more thing: this is easily done with subqueries, but for performance reasons, I need to do it with explicit joins. Anyone know how I can do this? Thanks, marco -- Marco Carbone Webmaster/Web Developer Com

Trouble with aborted connections

ove entries. Actually I've no idea where I could go on searching for the bottleneck or any existing problem. Why are are the connections timing out ? What parameters are relevant ? I'd be thankful for every idea and suggestion. Greetings Marco

Re: error with java

Wild stab in the dark here - Java I/O permissions not set correctly on your machine to allow it? If I recall, Java's sandbox feature means you have to supply a permissions file for I/O. Perhaps that file already exists on the other machine that works? I don't know so much Java, but I didn'

Re: error with java

re are no firewall active... any other suggestion!? thanks :) marco -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

error with java

I'm trying to understand this error: java.sql.SQLException: Server connection failure during transaction. Attempted reconnect 3 times. Giving up. the java program is trying to connect to MySQL (5.0.19 under Mac OSX/ PPC), with user=root, from localhost. the grant privileges seems to be ok (I'm

Re: selecting records newer than say 20 min

select * from table where mytimestamp > (unix_timestamp - 20) ?? Gregory Machin schrieb: > Hi > What, is the easest way to select all the records created in the last 20 min > stay based on a column that has a timestamp record. > > Many Thanks > > -- > Gregory Machin > [EMAIL PROTECTED] > [EMAIL PR

Re: Group By over many colums

gt; (SELECT f4 as 'domain' from sends WHERE gameID = 1) ; > > SELECT MID(domain,INSTR(domain,'@')+1) AS 'domain' , count(*) from t_sends > GROUP by 'domain' > > > And that does the trick > > Is there any way to destroy the "t_

Re: Group By over many colums

January 2006 16:14, Critters wrote: > Thanks for the replies Marco... > mysql Ver 12.22 Distrib 4.0.21 > > So that could be it? > > By the way... > > (SELECT f1 as 'domain' from sends) union > (SELECT f2 as 'domain' from sends) union > (SELECT f3 a

Re: Group By over many colums

union all (SELECT f2 as domain > > Can you spot where I am going wrong? > - > David Scott > > > - Original Message - > From: "Marco Neves" <[EMAIL PROTECTED]> > To: > Cc: "Critters" <[EMAIL PROTECTED]> > Sent: Thursday, January 19, 2006 3:

Re: Group By over many colums

Hi, To this on I just see a solution, that depends on sub-selects, so it's available from Mysql 4.1 forward: SELECT name,count(*) from ((SELECT name1 name FROM ) UNION ALL (SELECT name2 name FROM ) UNION ALL (SELECT name3 name FROM )) tab GROUP by name; Hope this solves you problem. mpneves

Re: Interesting Query Problem

Hi, An alternative for any MySQL version (from 3.23.??) would be: SELECT r1.question_id,count(r1.member_id) FROM Records r1 LEFT JOIN Records r2 ON r1.question_id=r2.question_id AND r2.member_id= WHERE r2.question_id IS NULL;

Re: Database design help

Ian, I'ld like to help you, but a more specific db design would depend on more specific description on your application needs. What I can say is that you need to adapt your database to your reality. What I got til now is that you need a product table, where you can sto

Re: Database design help

Hi, Why don't you create two table: * a product table, with the product discriptions, and other product related info (call it prod): |ID|NAME|SOME|OTHER|FIELDS| |1|ProdA|..|..|..| |2|ProdB|..|..|..| * a stock movements table, with moviments by p

Re: transaction with bdb table gives error "Lock table is out of available locks"

Maybe i got it! For the chronicle: I resolved the problem decreasing the max_bdb_lock to the default value and creating an index on the column used in the where clause of my query. Probably mysql tried to lock the whole table because the primary key wasn't in the where clause. Cheers,

Re: transaction with bdb table gives error "Lock table is out of available locks"

run/mysqld/mysqld.pid -O bdb_max_lock=12 mysql 9184 33.6 3.3 179136 70148 ? Sl 01:00 177:45 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock

Re: transaction with bdb table gives error "Lock table is out of available locks"

e | 32768 | | max_binlog_cache_size | 4294967295 | +---++ How can I estimate the binlog chache size I need? The manual is very vague about this issue.. Thanx, Marco sheeri kritzer wrote: >Hi Marco, > >My hint is to read the BDB section of the manual: >

Re: Wrap Tag Around Result

Mark >Luke >John > >I need to do this with pure SQL - no server side scripting... > >Thanks for your advice > > > > > -- Marco Baroetto Parisi Ribes Informatica - Via Jervis, 60 - 10015 Ivrea (TO) - Italy Tel: +39-0125-62.78.50 - Fax: +39-0125-64.44.39 Web: http:

transaction with bdb table gives error "Lock table is out of available locks"

ion_bdb | Sleepycat Software: Berkeley DB 4.1.24: (May 13, 2005) | +-++ 9 rows in set (0.00 sec) Any hint is welcome.. Thanx in advance for the help, Marco -- MySQL General Mailing List For list archives: http://

Re: Reset root password to mysql?

Jerry Swanson schrieb: How to reset mysql password to mysql? mysql -u root ERROR 1045 (0): Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) You could start your mysqld with "--*without-grant-tables"* option. But keep in mind that this will stop the complete permission

Need Perfomance / Tuning Help

Hey, we´ve a site ( PHP ) where several 1.000 are online at the same time. They´re running many sql statements. Is there a way to find out which statements take a full table scan to optimize them ? And i need some help with configuring the my.cnf. Below you´ll find our one. Which options should

Performance problem

r geringer Priorität auszustatten, dass deren Abfrage nicht über einen bestimmten %-Wert der Cpu-last geht und somit den laufenden Betrieb nicht stören? Vielen Dank für die Bearbeitung meiner Anfrage. Marco Baar -- Gruß Marco 5 GB Mailbox, 50 FreeSMS http://www.gmx.net/de/go/promail +++ GMX

Re: UTF8 support in MySQL 4.0

So how can I do that? I've already tried SET CHARACTER SET and it didn't work since someone said its not available in MySQL 4.0. You can store UTF-8 in any database in the world. UTF-8 is compatible with any application capable of dealing with null-terminated strings of 8-bit characters. Tha

Re: Replication, charset / collations Problem

1 row in set (1.05 sec) The create statements are identical on both servers. I have no more ideas. Should I try to reproduce the error with a smaller example ? Marco --- http://www.tuxoo.org http://www.kontaktlinsen-preisvergleich.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication, charset / collations Problem

edish_ci | | concurrent_insert| ON | | connect_timeout | 5 | +--++ 12 rows in set (0.07 sec) Any ideas ?! Marco --- http://www.tuxoo.de http://www.kontaktlinsen-preisvergleich.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Replication, charset / collations Problem

which came into my mind, is that the server use different default charsets or collations. I checked the configurations and can't find a difference. Is there a possibility to check the default charsets and collations on the running server ? thanks in advance Marco --- http://www.tuxoo.de http://www.kontaktlinsen-preisvergleich.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

UTF8 support in MySQL 4.0

SET CHARACTER SET ut8; won't work. My server admin said UTF8 has not been mentioned in 4.0 thus I am unable to use it. So is there any solution on how I can properly use foreign characters and store them in a MySQL 4.0 database? -- MySQL General Mailing List For list archives: http://lists

Re: Illegal mix of collations

r set utf8 collate utf8_bin NOT NULL default '', ... ) ENGINE=InnoDB DEFAULT CHARSET=latin1; which is identical with the Master create statement: CREATE TABLE `sum_day_key_requests` ( ... `key` varchar(255) character set utf8 collate utf8_bin NOT NULL default '', ... ) ENGIN

Illegal mix of collations

Singleb�se' AND `key` = 'Single Berlin' AND afftraf = 'NULL' I read the docs and compared charset/collation configuration as you can see below, but it seems to be the same on both servers. any hints welcome ! thanks in advance Marco ==

No result at all (expected 0)

:00', state tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; Tanks in advance, Marco -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECT Row Numbers?

y identical to > "LIMIT 4". As long as the original poster doesn't say what ordering > he wants, there's no way to tell him a solution. -- Marco Paulo Neves MySQL Core Certified Linux Certified Professional http://themage.bliker.com -- MySQL General Mailing List

Re: ROW_SIZE or something alike

oix ppl, Nobody have any sugestion that can me help with this issue? thanks mpneves On Wednesday 16 March 2005 14:09, Marco Neves wrote: > oix ppl, > > sorry for the question, but I looked in the Manual online and didn't find > nothing that do this that I'm looki

ROW_SIZE or something alike

)) grpsize FROM tablename GROUP BY group__id; This is what I thought would be great to have, but any other way to get a row size would be good enought. This could be both Data and Index size for each row, but data would be good enought. There is anyway to get this information? Thanks,

counting rows

I would like to count all of the resulting rows of my query. But my query contains a "group by", so select count(*) from table group by field will select an individual group count for each group. Instead, I would like to count the number of groups. Thanks, Marco -- MySQL General Mailin

monthly average for last 12 months?

... Can I do it directly in a mysql query, or (doing this from a Perl script) I need to save the total of each month in the script, and do the average from there? Examples? Right stuff to read? Thank you in advance for any help, Marco -- MySQL General Mailing List For list archives: http

independent database

Hi all! I would like that my users can read/write/execute just them database and that they can not read/write/execute other users's database. How shoul I set up? This is because I have to host some web site and I want to give independent access to features. Tnks! marco -- MySQL Ge

Re: Limit operations by condition

s is not just a SELECT problem. >From another way, can I retrieve Oids (or something like Oids) for records on which I'm going to apply the query? Thanks Scrive Sasha Pachev <[EMAIL PROTECTED]>: > Marco Lazzeri wrote: > > Yes, I know. Perhaps, I'm searching for workaro

RE: Limit operations by condition

Yes, I know. Perhaps, I'm searching for workarounds. Il gio, 2004-05-20 alle 17:58, Victor Pendleton ha scritto: > You can grant those permissions on columns but not on individual rows. > > -Original Message- > From: Marco Lazzeri > To: [EMAIL PROTECTED] >

Limit operations by condition

EATE TEMPORARY TABLE table_a SELECT * FROM table_a WHERE foo = 'bar'; And it was good, but just for SELECT (I can't define rules on UPDATE/INSERT/DELETE to commit the modifies on the original table). If it was PostgreSQL, I will be using VIEWs with RULEs. Any hints? Thanks, Marco

Inserting blob

hould be in the configuration of MySql service. Any suggestion? TIA Marco Paci Marco Paci Divisione Gestionale & Tecnologia PASSEPARTOUT s.a. Via Monaldo da Falciano, 3 - 47891 Falciano (Rep. San Marino) Tel. 0549.877910 From Abroad. +378 877910 [EMAIL PROTECTED]www.passepartout.sm -- My

table name is lower case if there is an index on it (4.0.18 )

its created in upper case 'AB_OBJECTS' as it should be. I have some other tables with and without an index and all should be stored in upper case. Thanks Regards Marco Bluemel

Re: Table selection

What about using UNION? Something like: SELECT * FROM FX5686 UNION SELECT * FROM FX5698 UNION ... WHERE [condition] I obviously need a programming language to compose this query... but it seems clearer to me... if it works! Marco Bresciani -- (o> Utente [EMAIL PROTECTED] da 3,632 anni (2200 un

Table selection

les because they all miss the "FX" string. How can I create this kind of query? Something like: SELECT * FROM ("FX" + SELECT Name FROM List) WHERE [condition] I hope I was clear 'cause my English is not so good. Is there anyone who can help me? Thank you! Marco Bresciani -

Problem with .NET applications

data type attribute violation I verified that I got this error in relation to the insertion of the decimal field. If I switch driver from 3.51 to 2.50 I get no error but in this case I save the number without decimal. Can anybody help me about this error? Thank you Marco Paci -- MySQL General M

Reading securely the value of an autoincrement field used as PK

Insert a new record |Insert a new Record |Read the value of PK field |Read the value of PK field | | | | v TimeThread 1Thread 2 Axis Is the value read by the thread 1 for the PK field correct? T

Re: upgrade mysql3.23.55 to mysql4.0

!!!). Hoping to have been helpful, best regards, Marco Barbato http://www.betaingegneria.it - Original Message - From: "Anselme" <[EMAIL PROTECTED]> To: "Mysql_MailingList" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 11:27 AM Subject: upgrade mysql3.23

ADD CONSTRAINT on InnoDB tables

fine, beacuse I cannot DELETE a row referenced by another table: trying to do it, mysql> delete from dipartimenti where iddipartimento=1; it results a ERROR 1217: Cannot delete or update a parent row: a foreign key constraint fails error. Anyone has

RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

Yeap.. i dont really recommend that combination but its possible... good luck..! Marco Chaires Depto. de Sistemas Miciudad.com <http://www.Miciudad.com> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Enviad

TIMESTAMP field is updated unintentionally

estion: Is it a bug or a feature? (mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686)) -- Best regards, Marco mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

info about an old version (v. 3.22.32)

defined as NOT NULL I have v. 3.23.53-log and with the same statment I have no error; I guess because the new version add 'not null' automagically. Is it right? Can someone tell me from which version is it true? thank you in advance! bye bye! MAS! -- Marco

ERROR

. How can I solve this? Thanks, Marco Querini --- O e-mail enviado está certificado de não conter vírus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.423 / Virus Database: 238 - Release Date: 25/11/2002

mysql update user

his hosting account. username: marco pssword: mysecret database name: lotsofusers. Of first I set the administrative and root password using the document here: ftp://216.94.9.36/Setting%20the%20Root%20and%20Administrative%20Passwords.doc Then What I would like to do is: allow another user access

COLDFUSION AND MYSQL

problem of drivers. for example I may not have JDBC drivers installed on that redhat server???Is it possible???If so, can I install them?? thanx marco - Before posting, please check: http://www.mysql.com/manual.php (

C++ API

I need to use the C++ API for mysql under a Linux system. I compiled the tarball downloaded from mysql.com/Downloads but I get several errors during compilation of C++ code. Can anyone supply some information. Thanks. - Before

my_gui: a gui module for MySQL (using Python) First public release (0.24)

This is the first public release for "my_gui". my_gui.py is a simple Grafic User Interface for MySql. It can be used as a Python module to create your own MySQL interface. Sorry, no documentation yet download it at http://www.prosa.it/projects/projects MAS

Re: Is it possibile to have something similar?

>No you can't, but check out LIMIT. Ops, but I did it! Using a variable and a temporary table as Benjamin and Keith wrote in the prev. messages ciao ciao! MAS! -- I love MySQL :-) - Befor

Re: Is it possibile to have something similar?

>IMHO, The Right Thing to do this, is to create the additional data in >your application (as you said you won't change the table). (...) thank you! >If you want this with SQL for sure, using user-defined variables will >work: cool. sorry, but I'm still learning, since I'm into MySQL from a fe

Re: Is it possibile to have something similar?

>It's not clear from your description whether the numbers are >associated with the records in the table or with the records returned I'm trying to choose a subset only of the select result... (without having any informations about the db/data structure) >should be handling in whatever you're

Is it possibile to have something similar?

1 | | horse | 2 | ... IMPORTANT NOTE: I can't add a (permanent) column with an "auto_increment" value; I'm writing a simple gui for mysql and I don't want to alter the original db.. I'm using MySQL 3.23.49 can someone help

Question...

Hi.. my name is Marco Leiva and i have just downloaded your software... i want to connect Mysql to Visual Basic, I downloaded the ODBC drivers but the following error message keeps on popping: "An error Occurred while copying c:\windows\system\mfc30.dll restart windows and try installing

RE: off-line development tool?

t and that I could unleash a CREATE command on? Thanks, Marco >From: "Eric Mayers" <[EMAIL PROTECTED]> >To: "Marco Bleeker" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> >Subject: RE: off-line development tool? >Date: Fri, 22 Feb 2002 18:27:23 -08

off-line development tool?

php files there. So my question is: how would people normally go about this task. Would I need to write a script for in- and export of data, or would there perhaps be a handy tool that takes this out of my hands? Thanks, Marco Ble

OT: procmail recipe for this list?

> Hello, > > do you have a procmail recipe which will catch ALL the messages to > this list and put them in one folder? Even CCs, reply's, whatever? > > I follow several lists, and this is one of the only two that I > can't come up with a working recipe for. > > TIA > mweb

Re: Syncronization between two databases

Jeremy Zawodny wrote: > On Mon, Jan 07, 2002 at 11:36:54PM +0100, Marco Frazzoli wrote: > >>Hi! > > Have you looked at MySQL's built-in replication? Yes. But it seems to be created for a permanent connection between two databases... or can I make a replica using a d

Syncronization between two databases

Hi! I need to syncronize two indentical MySQL databases. The A database is on a server permanently connected to the Internet trough an ADSL connection, while the B database is on a server equipped with an ISDN connection. How can I keep the two databases identical? Thanx Marco Frazzoli PS

sorting question

, i've been experimenting with starting the mysqld with the option --default-character-set=... different options but that doesn't seem to make a lot of difference? Any idea's Thanx Marco - Before posting, please

Re: help

>you tell me where I can find it? http://www.mysql.com/documentation/index.html - -- Marco Bizzarri - Responsabile Tecnico - Icube S.r.l. Sede: Via Ridolfi 15 - 56124 Pisa (PI), Italia E-mail: [EMAIL PROTECTED] WWW: www.icube.it Tel:(+39) 050 97 02 07 Fax

Re: C++ connecting to a MySQL database

age? Inside there is documentation describing how to connect/query a database... > > Sincerely, > George Graham > [EMAIL PROTECTED] > > - -- Marco Bizzarri - Responsabile Tecnico - Icube S.r.l. Sede: Via Ridolfi 15 - 56124 Pisa (PI), Italia E-mail: [EMAIL PROTECTED]

Re: hi.

I think unless you provide the table definition and the query which is so slow, little help could come from the list. - -- Marco Bizzarri - Responsabile Tecnico - Icube S.r.l. Sede: Via Ridolfi 15 - 56124 Pisa (PI), Italia E-mail: [EMAIL PROTECTED] WWW: www.icube.it Tel:(+39

Telnet

I need to Telnet into my domain in order to run some MySQL utility like mysqldump (for backup). I am not experienced with Telnet. Any pointers? Any way around it (use mysqldump from PHP?) Thanks, Marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker

Faults

on regular intervals) be made persistent. Is there any configurable parameter to do this? Marco Pappalardo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (t

no rights on a spec db,but -show databases- still shows it

have added the user with root, log out and log in with the user bernduser, I am able to see all databases (just the names) is there a way to cut this? Of cource he is only able to work in his own, but I only want him to see his own db bernddb. Th

users in mysql

have added the user with root, log out and log in with the user bernduser, I am able to see all databases (just the names) is there a way to cut this? Of cource he is only able to work in his own, but I only want him to see his own db bernddb. Th

databases disappear...

an I flush that cache? How can I stop this weird behaviour? I hope I am not really damaging my database, because when I will be working with the real thing later on, I can not afford to have to start from scratch over and over again. Is there a workaround? Thanks, Marco | | Marco Bleeker, Ams

delay times, threads

signed up) Marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of mailing list. | | I am now receiving the Snowhite virus 4x a day | - some of you must be infected, please check !

databases disappear...

later on, I can not afford to have to start from scratch over and over again. Is there a workaround? Thanks, Marco (please mail me directly, I am not on the list) | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice plea

databases disappear...

later on, I can not afford to have to start from scratch over and over again. Is there a workaround? Thanks, Marco (please mail me directly, I am not on the list) | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice plea

delay times, threads

signed up) Marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of mailing list. | | I am now receiving the Snowhite virus 4x a day | - some of you must be infected, please check !

KEY and index

non-indexed column? I just want to check if matching a row is present or not, not actually retrieve information ("WHERE ip='$ip' and date>curdate()") Thanks, Marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after

PHP and MySQL result set navigation

could also turn the result set into a 2D array of rows and work with that. Sounds a bit voluminous as well... Thanks, marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of m

domain vs localhost

n't see a MySQL subdirectory with my hosting ISP. I would like to create and fill a database off-line, on my localhost, and then FTP the whole thing to my hosting ISP and make it accessable from my domain (www.ecocam.com). Any pointers? (localhost machine = Win98SE) Thanks, marco | | Marc

inserting a colum into a existing table

---++ | id_t1 | t1_text| t1_text | +---+++ | 1 | NULL | NULL | +---+++ 1 row in set (0.00 sec) Sorry if this stuff is to easy for you, i am working hard to get

mysqldump all dbs

scenario is provided, followed with a few examples. Using mysqldump to backup just one ... I always used mysqldump to dump db by db, how can i get it to dump all? i was not able to figure it out thanks marco - Before posting

Can't login to MySQL from PHP

ugh a procedure to track the problem? Which additional info do you need? Thanks, Marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of mailing list. | | I am now receiving the

User

I'm new with Mysql database there is anybody that could explain to me how to create an user in a specific database with encrypted password? I'll tank you very much Marco _ Get Your Private, Free E-mail from M

Thanks for: Outer and left join definition

Hello, I just wanted to thank everybody who helped me to understand the topic below. I am going to unsubscribe from this list now, so please address any further message, if any, to: [EMAIL PROTECTED] Thank you for your time Marco On 2001/04/14 20:37:15 +0100

Re: Any tool to port from DB2UDB to MySQL

Hi, I'm at the end of a project in which I did exactly that (transfer data from db2 for Linux to MySQL). I used no tool. I wrote some C/C++ programs accessing and tranforming the db2 data in a suitable form for MySQL. The same programs also inserted data in MySQL. Wed, 11 Apr 2001, Venkatesh

Transactions in MySql

MySql support transactions? The OLE-DB provider support transactions? Call the method Begintrans on a connection object (ADO) return an error!!!

Again about skip-locking

rence in using this feature? 2) in the same condition as 1) is there any difference if I use also ODBC clients to access mysql? Thank you all for your replies. Bye Marco -- Marco Bizzarri - Responsabile Tecnico - Icube S.r.l. Sede: Via Ridolfi 15 - 56124 Pisa (PI), Italia E-mail: [EMAIL PROT

Index corruption with mysql 3.22

ith mysql and myodbc concurrent access? Thanks you all in advance Marco -- Marco Bizzarri - Responsabile Tecnico - Icube S.r.l. Sede: Via Ridolfi 15 - 56124 Pisa (PI), Italia E-mail: [EMAIL PROTECTED] WWW: www.icube.it Tel:(+39) 050 97 02 07 Fax:

  1   2   >