TINYTEXT field uniqueness question

Hello, Is that possible to ensure uniqueness for a TINYTEXT field? I tried to create an index (with UNIQUE constraint) but my GUI tool always says me 'Duplicate entry 'X' for key N' Best regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd. www.vekos.ru -- MySQL General Mailing

time inserting problem

Hi , Is there any way to insert time value as '10:00:00 PM', without converting it as 24 hrs format means 22:00:00. My table has one column type, as time , so i wnat to insert as 10:00:00 PM __ Do You Yahoo!? Tired of spam? Yahoo! Mail has

Re: myql command-line no warning

:-) I see. Thanks! It w(not vv)orks!!! Qunfeng At 10:48 PM 12/21/2004, Paul DuBois wrote: At 20:44 -0600 12/21/04, Qunfeng wrote: Paul, Thanks for your reply. I tried mysql -p -w DB < test.sql still no warning. I tried -vw it simply echo the sql statement, no warning. I didn't suggest using -w or -

Re: myql command-line no warning

At 20:44 -0600 12/21/04, Qunfeng wrote: Paul, Thanks for your reply. I tried mysql -p -w DB < test.sql still no warning. I tried -vw it simply echo the sql statement, no warning. I didn't suggest using -w or -vw. I suggested -vv (two v's) or -vvv (three -v's). Qunfeng At 05:45 PM 12/21/2004, Paul

mysqldump and innodb - set foreign_key_checks=0

Hi, After reading the docs I realise that in order to use mysqldump with innodb tables i need to include SET FOREIGN_KEY_CHECKS=0; at the top of my dump file. Is there anyway to do this when my slave starts up or some other way. The dump file is huge and it takes ages to open and put the line a

Re: myql command-line no warning

Paul, Thanks for your reply. I tried mysql -p -w DB < test.sql still no warning. I tried -vw it simply echo the sql statement, no warning. Qunfeng At 05:45 PM 12/21/2004, Paul DuBois wrote: At 17:43 -0600 12/21/04, Qunfeng wrote: Hi, I am using mysql 4.1 on linux. When I execute an mysql command (e

Re: Weird load issues

Daniel, - Original Message - From: "Daniel Andersen" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, December 21, 2004 1:04 AM Subject: Re: Weird load issues On Mon, 20 Dec 2004 09:29 pm, Heikki Tuuri wrote: Daniel, it is simply processing big SELECT queries. Maybe

How to execute selected text in Query Broswer?

I was wondering what's the shortcut for executing only selected text in the query window (SQL Query Area) in MySQL Query Browser. Using Ctr-E or Ctrl-Enter executes everything in the window, not just the selected text, as MS Query Analyzer does. It's a great hassle to have to comment all the othe

Re: Need more info about currently running queries

Yep, mysqladmin can give the same info. As noted in my original message, I need much more detailed info. The crux of the problem is that I need to run a query that could take several hours when it's using indexes correctly, but it is not working correctly so it takes longer than I've been wi

Re: Mysql upgrade problem 3.23 to 4.1

Hi Jerry, (B (B (BDid you read the documentation ? (B (BIt explains that you have to upgrade the mysql database wqith the (Bmysql_fix_privileges script. (B (B (BBest regards (B (BNils Valentin (BTokyo / Japan (B (Bhttp://www.be-known-online.com (B (B (B (B> I upgraded mysql mysql

Re: myql command-line no warning

At 17:43 -0600 12/21/04, Qunfeng wrote: Hi, I am using mysql 4.1 on linux. When I execute an mysql command (e.g., UPDATE statement) at the mysql prompt, it gives me warning if something is not running correctly. e.g., mysql> update testTable set col='abcd' where col='ab'; Query OK, 0 rows affecte

myql command-line no warning

Hi, I am using mysql 4.1 on linux. When I execute an mysql command (e.g., UPDATE statement) at the mysql prompt, it gives me warning if something is not running correctly. e.g., mysql> update testTable set col='abcd' where col='ab'; Query OK, 0 rows affected (0.0 sec) Rows matched: 2 Changed: 0 Wa

Re: Performance of Joining Tables From Different Storage Engines -- Re: MyISAM vs. InnoDB for heavily-indexed, read-mostly data

Thanks Mike. I think testing ultimately determines how efficient heterogeneous engine joins are. I just wanted to know if someone had issues with them in a heavy-load environment. --- mos <[EMAIL PROTECTED]> wrote: > At 04:00 PM 12/21/2004, Homam S.A. wrote: > >Thanks Mike for the information.

Re: Performance of Joining Tables From Different Storage Engines -- Re: MyISAM vs. InnoDB for heavily-indexed, read-mostly data

At 04:00 PM 12/21/2004, Homam S.A. wrote: Thanks Mike for the information. Yes, Emmett mentioned the same thing in a private message, and it seems that MyISAM is exactly what I'm looking for: a heavily-indexed large table that will be also indexed for full-text search and built off-line -- no updat

Re: MySQL tweaking.

Mick Pollard wrote: Hi list. I have a server that is having a little MySQL load issue. I have done many hours of reading and can't quite get this worked out. I am asking for your help please. The server is to be a dedicated MySQL server only. The following is the current setup but currently is do

[Fwd: Re: MUTIPLY function?]

Michael Stassen wrote: No, but Harold Fuchs gave the following solution to Shawn Green in an earlier thread on this topic . EXP(SUM(LOG(COALESCE(*the field you want to multiply*,1))) which works because LOG(xy) = LOG(x) + LOG(y), and EXP(LOG(x)) = x. Hence,

Re: MyISAM vs. InnoDB for heavily-indexed, read-mostly data

Homam S.A. wrote: I'm new to MySQL and I was wondering which storage engine is the best choice for heavily-indexed, read-mostly data. From skimming over the documentation, it seems that MyISAM is a better choice since it doesn't have the transactional overhead. Yet I'm worried that it's becoming de

Performance of Joining Tables From Different Storage Engines -- Re: MyISAM vs. InnoDB for heavily-indexed, read-mostly data

Thanks Mike for the information. Yes, Emmett mentioned the same thing in a private message, and it seems that MyISAM is exactly what I'm looking for: a heavily-indexed large table that will be also indexed for full-text search and built off-line -- no updates whatsoever. However, I will be joining

Re: Help with a join query please!

shaun thornburgh wrote: Hi, I have (among others) three tables in my database that i am struggling with a join query on. The database holds dates for Bookings. If Users are Allocated to a particular Project they can be booked. However if a user is booked but then unallocated I want to be able to

Re: MyISAM vs. InnoDB for heavily-indexed, read-mostly data

At 06:37 PM 12/20/2004, you wrote: I'm new to MySQL and I was wondering which storage engine is the best choice for heavily-indexed, read-mostly data. From skimming over the documentation, it seems that MyISAM is a better choice since it doesn't have the transactional overhead. Yet I'm worried that

Re: Mysql upgrade problem 3.23 to 4.1

Jerry Swanson wrote: I upgraded mysql mysql-3.23.58-1 to mysql4.1 In mysql-3.23 ( I have this field) password | varbinary(45) | YES | | NULL | I inserted data into this field as password('pass'). I have php script that checks if login valid. mysql-3.23 and mysql-

Re: Unique IDs

Thank you. I'll have to review the SQL carefully as I haven't used inner joins in quite some time :) Quoting [EMAIL PROTECTED]: > Create a temporary table that will act as a map between your old IDs and > your new ones. That way you can re-use those values and change them from > the old val

Re: Unique IDs

Create a temporary table that will act as a map between your old IDs and your new ones. That way you can re-use those values and change them from the old values to the new values. LOCK TABLE table1 WRITE, table2 WRITE, table3 WRITE; select @max_id:=max(id) FROM table1; CREATE TEMPORARY TABLE

Mysql upgrade problem 3.23 to 4.1

I upgraded mysql mysql-3.23.58-1 to mysql4.1 In mysql-3.23 ( I have this field) password | varbinary(45) | YES | | NULL | I inserted data into this field as password('pass'). I have php script that checks if login valid. mysql-3.23 and mysql-4.1 have identical

MySQL/InnoDB-4.0.23 is released

Hi! InnoDB is the MySQL table type that supports transactions, FOREIGN KEY constraints, row-level locking, non-locking consistent reads, and a non-free Hot Backup utility. Release 4.0.23 is a bugfix release of the stable MySQL-4.0 branch. This release fixes the critical hang bug of mysqld in My

RE: Default connection codepage

Hello, > -Original Message- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 21, 2004 1:29 PM > To: [EMAIL PROTECTED] > Subject: Re: Default connection codepage > > Hello. > > Put default_character_set='blah123' in your [client] and [mysql] > sections of your c

Re: Unique IDs

You are correct in that I need to merge two tables. However, I'm not clear on how to update the FKs in the sub tables. Example, the main table (Person) has a sub table (Address). Person has a 1:N relationship with Address. So Address has the Person's ID as a FK. How do I update the FK in

Re: Unique IDs

Andrew Mull wrote: I'm working on a rather large database with many cross-linked tables currently using auto increment IDs. The system is primarily a web based system, however, there will be times that the system will be run as a stand alone server...meaning no internet connection is available.

Re: Federated Engine

Hi, On Tuesday, December 21, 2004, at 07:59 AM, Luciano Barcaro wrote: Sergei, thanks for the reply, but I coudn´t see any 'useful' info about it . I would like to know the differences (characteristics) between federated and other engines The federated engine allows you to have remote tables (i

Upgrading from MySQL Max 3.23 to 4.1.x

Greetings all, I am currently running mysql-max-3.23.54a-sun-solaris2.9 and would like to upgrade to a 4.1 sparc 64 equivalent. As I'm also running 'depot' on the same machine that has MySQL, I wonder what the easiest way to do this upgrade would be. I presume that it would be to do a seper

Re: Monitoring replication in mysql

Tucker, Gabriel wrote: Anil Write a script that does a slave status and check if either of the threads are running. You could further check for error numbers and descriptions. This is what we do. Gabe -Original Message- From: Anil Doppalapudi [mailto:[EMAIL PROTECTED] Sent: Tuesday, Dece

Re: User seeing their own permission

That syntax only works in 4.1.2 and up, however. Prior versions only take a string for the user, not a function call or variable. In that case, you can find out who you are with SELECT CURRENT_USER(); +-+ | CURRENT_USER() | +-+ | [EMAIL PROTECTED] |

RE: Monitoring replication in mysql

Anil Write a script that does a slave status and check if either of the threads are running. You could further check for error numbers and descriptions. This is what we do. Gabe -Original Message- From: Anil Doppalapudi [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 21, 2004 6:05 A

Re: HELP: utf8 chracters replace by ?

Hello. There a lot of things that can produce such unexpected behavior (even wrong codepage in you browser). At first you should carefully read pages from manual related to character sets. See: http://dev.mysql.com/doc/mysql/en/Charset.html "Andy Low" <[EMAIL PROTECTED]> wrote: > Hi, >

Re: problems with russian characters

Hello. When you are using mysql command line client under windows, all data you see is in cp866 character set (property of all console programs). And at the server side data is in cp1251 character set. So you should use sql statements for correct work: SET character_set_client = 'cp866';

Re: Need more info about currently running queries

Hello. Using SHOW PROCESSLIST you can just check if your query running, or is waiting for some lock. For more info, you can run "ps axm" in shell and look for the thread state, but that's more related to the kernel stuff. See: http://dev.mysql.com/doc/mysql/en/SHOW_PROCESSLIST.html Gr

Re: Default connection codepage

Hello. Put default_character_set='blah123' in your [client] and [mysql] sections of your config file. "Denis Gerasimov" <[EMAIL PROTECTED]> wrote: > > Hello, > > Is there any way to change default MySQL _connection_ codepage? > (e.g. by ini/cnf files setting, by startup parameters or

Re: 4.1.7 has --old-passwords set but mysqladmin client still using new hash

Hello. I've reported a bug: http://bugs.mysql.com/7451 Jason Joines <[EMAIL PROTECTED]> wrote: >I've got a 4.1.7 server on Linux and I need to use the old-passwords > option. It has taken effect as 'show variables' confirms. Also, if I > set a user's password using 'set pass

Re: User seeing their own permission

Hello. SHOW GRANTS FOR CURRENT_USER(); Law Poop <[EMAIL PROTECTED]> wrote: > Can a user see their own permissions for a database? > > I'm working on a PHP project that will hopefully automagically > generate forms based on a user's permissions. Do I have to create a > seperate account

MySQL 4.0.23 has been released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.0.23, a new version of the popular Open Source/Free Software Database Management System has been released. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads

Re[2]: How to use character_set_xxx in my.ini ?

Hello Gleb, Sunday, December 19, 2004, 10:02:58 PM, you wrote: > Also you can put in your [client] section of my.cnf something like: > default_character_set=gbk I use my.ini in MySQL install directory, not my.cnf . My MySQL Server in windows services.msc is "C:\Program Files\MySQL\bin\

RE: Restore help! been going 2 weeks

here is my my.cnf file contents # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M myisam_sort_buffer_size = 64M thread_cache = 40 query_cache_si

Re: Federated Engine

Sergei, thanks for the reply, but I coudn´t see any 'useful' info about it . I would like to know the differences (characteristics) between federated and other engines Thanks Sergei Golubchik wrote: Hi! It was added ony a few days ago - documentation is catching up still. For now - take a look at

Re: Question - SubQuery syntax

> I have problem with this syntax: > SELECT game_id FROM game WHERE game_id NOT IN (SELECT game_id FROM player WHERE user_id!=$id_user) > > I need select games where user is not connected. I have two tables game(game_id, ) and player(player_id, game_id, user_id, ...). In table player are many p

MySQL tweaking.

Hi list. I have a server that is having a little MySQL load issue. I have done many hours of reading and can't quite get this worked out. I am asking for your help please. The server is to be a dedicated MySQL server only. The following is the current setup but currently is doing some apache aswe

Monitoring replication in mysql

Hi, we have no of mysql replication setups in our setup. how to monitor those replication setups.my aim is if any slave goes down my script should immediately send an alert mail to me. if anybody having already developed scripts please let me know otherwise just give me an idea what to monitor in

RE: Boolean search showing zero results in error

Thank you very much, that is a great help. Alisa -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: lundi 20 decembre 2004 22:06 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Boolean search showing zero results in error "keep" is a full-text stopword, by

Question - SubQuery syntax

Hello, I have problem with this syntax: SELECT game_id FROM game WHERE game_id NOT IN (SELECT game_id FROM player WHERE user_id!=$id_user) I need select games where user is not connected. I have two tables game(game_id, ) and player(player_id, game_id, user_id, ...). In table player are m

Re: Federated Engine

Hi! On Dec 20, Luciano Barcaro wrote: > Hi all, > I downloaded the source from bk tree and I saw the federated engine. > Taking a look into documentation > (http://dev.mysql.com/doc/mysql/en/index.html) I didn?t find anything. > So, where I can find some info about it ? It was added ony a few da

HELP: utf8 chracters replace by ?

Hi, I need assistance pertaining to utf8 errors. I am having troubleshottings for weeks already and still can't solve it. I am running MySQL 4.1.8 and PHP 4.3.10. When I am trying to insert these characters: é æ è MySQL table will displays: é æ è Below is my code. What could be the problem?

Default connection codepage

Hello, Is there any way to change default MySQL _connection_ codepage? (e.g. by ini/cnf files setting, by startup parameters or some other way) Please, do not suggest running SET CHARACTER SET blah123 Thanks. Best regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd. www.vekos.ru