MySQL Database Forum

I think I understand the concept of repeatable read, but this scenario doesn't make sense to me, if someone can explain. Say you have an innodb table test with a string column s = 'blank' and are using the default isolation level of repeatable read. Session 1: begin; Session 2:

I'd like to create a table with PRIMARY KEY k (a,b,c) where a, b, c are foreign key. Is it possible? How can I do? Thanks Bye

Hello, I'm running MySQL 3.23.58 which came with Red Hat Enterprise AS 3.0 and am having a few problems with starting it up if I modify the /etc/my.cnf file to try and log the SQL running etc. (apologies but I'm doing this from memory having left my notes elsewhere). The essentials are: Stopping and starting the database via:...

Currently I have a database of about 3.5 GB which contains about 5 text fields and to enable fast accesses to search this I have to use FULL TEXT INDEXES. My server has a RAM of 3.5 GB and I need to find a way so that I can have fast search process on this database. Please let me know of the best possible solution.

Dear All I've come across a strange issue when using UNION via MyODBC on my Fedora linux box (I'm using MySQL 4.1.3-standard-beta) **This doesn't work: (select a from tbl_name where a=10 and b=1 order by a) union (select a from tbl_name where a=11 and b=2 order by a)

Hi, I can only access mysql through the root by typing mysql -u root -p. But when I use any other user to connect to mysql I get the access denied error message. Mysql is installed on windows xp. I looked up information online to solve this problem and saw that there are some scripts that i may be able to run in order to fix the problem. But...

Qui peut m'indiquer où je peux trouver une documentation en français ? d D'avance merci Eric

Hi, i am really new to mysql so plz dont hit me if i am wrong. Here the problem: i have 2 tables. Voters(IP,Maprated) Maps(Name,Info)

This is a multi-part message in MIME format --bd66c891-6bf4-4a52-a1a2-3fd37a55e923 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Dear friend, Compliment of the day, I am JAMES KYARI, The son of late General Kubwa Kyari of the Democratic Republic of Congo. My father was a General in the Congolese...

I am a newbie in MySQL. I would like to know how to avoid repeating typing an SQL statement when an error occurs after execution. That is, if an error occurs I should be able to retrieve the statement that I had written and correct the mistake. It is agonizing to keep on repeating a statement that can take five minutes to write just because...

Hi, Is there a way to only let the users see databases in there own account. After whats the point of having a username and password if they can see the other databases. I'm trying to setup a server with many users I want to grant each user a database but how on earth do I stop them seeing other databases. I've searched hi and lo for an...

I notice in the mysql/data directory the following binary files: ib_arch_log_0000000000 ib_logfile0 ib_logfile1 ibdata1 Some are rather large. I can't seem to find any explanation in the documentation. What are they? What needs to be done with them? Thank,

Hi, is there anything wrong with using and older version of libMySql.dll to build version 1.7.1 of MySql++, which is then used by my C++ programs (building with Visual Studio v6) to access MySql v4.1.1? Things seem fine that way so far... Here's why I want to do that: a) I can't seem to find v1.7.9 of MySql++ that I can build with Visual...

I'm trying to get the GUI to connect to a remote mysql database from my client machine. What is the proper syntax for this in the GUI? I have tried everything with no luck: using the ip of the host, using the complete dns hostname of the host, using root as the user, using root@hostname as the user. I keep getting access denied for every...

Folks, I have a table containing addresses. I have a seperate contacts table that contains peoples names - This allows me to record more than one persons name related to a single address. My address table contains a numeric field/value. It counts the number of people that are related to a single address. I am wondering if there is a...

Is there an elephant in the room and that no one is talking about it? Can anyone say, officially or unofficially, what the strategy is for MySQL and MaxDB? Will they be converged? Remain separate? What are the benefits and risks of using each? I appreciate any feedback you have. --Steve

http://bugs.mysql.com/bug.php?id=868 Red Hat suggests the LD_ASSUME_KERNEL and the "nosysinfo" parameter on boot as two ways to disable the NPTL support (on RH9 and FC2, probably others). How can I, for example go the "nosysinfo" route, and check that the NPTL support was actually disabled? I have found tons of documentation on what...

Hello Sorry if this has been asked before but here we go any way. I am running Mandrake Linux 9 with MYSQL 3.23.52 ( I know not the latest but it did work). I have been running/using the database for about 6 weeks now without a problem. I rebooted the Linux box and now MYSQL doesn't seem to be running and will not start. I get the...

I just installed mysql 4.0 .There were many problems with upgrading from 3.23 to 4.0 so I deleted 3.23 and made a fresh start with 4.0. Everything works fine now but the only problem to connect to the server is via the /usr/local/mysql/bin directory. Is there a way to connect if I am root. thanks for your help. -aaldrik ...

Hello everyone, We are looking for beta-testers for our new product - Scribe Report Generator. At this moment, Scribe supports 6 relational databases, including Oracle, MS SQL Server 2000, and Sybase. Very briefly: Scribe is written in Java, is based on visual programming and can be extended by adding user-written Java classes; it comes...

Hi I have this query: SELECT id, name, YEAR(born) AS year FROM people WHERE DAYOFMONTH(born) = 7 AND MONTH(born) = 12 ORDER BY year DESC, name

Updated to the latest version of DBD-mysql using perl -MCPAN -e "install DBD-mysql" and now the calling mysql function r2() within perl work > $SQL_Text = "select r2() from dual " ; > $sth=$dbh->prepare($SQL_Text); > $sth->execute(); > while ( ($tt) = $sth->fetchrow_array( ) ) { print $tt; } for reference here is the mysql...

Hi I have 3 machines M1 M2 and M3, i need to setup the following : M1 is the master M2 is reading from M1 M2 is a master for M3 M3 is reading from M2 The problem i got, is when i run a command in M2, it's replicated in M3, but when the command is being run in M1, it's replicated in M2 but not in M3. does anybody know how i can fix this...

--0-536761300-1061326346=:17114 Content-Type: text/plain; charset=us-ascii I am unable to find any information about master-master replication. I need to replicate 1 mysql server over to other as a standby master server. Any help ? Any ideas at all ?