RE: Mysql text search and fulltext

> > EHS> I'm really looking forward to the 4.0.2 release. I hope > we will get some > EHS> more options to tweak and customize the fulltext search/indexing. > > There is a lot of bugs fixed in full-test search in 4.0.2: > http://www.mysql.com/doc/N/e/News-4.0.2.html > Trying to install

RE: mysql query help

Actually it was the alias, but the query is producing the wrong results. It should produce 3 results which I get in Access I cut and paste this query into mysql and get 12371 results. Same databases. "Cal Evans" <[EMAIL PROTECTED]> on 06/06/2002 08:50:51 AM Please respond to [EMAIL PROTEC

ANN: EMS MySQL Manager 1.76 released

EMS HiTech company is announcing the next version (1.76) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 1.76? 1. An ability to log

Re: on update problem?

Hi! don't think ON UPDATE is supported. The manual : http://www.innodb.com/ibman.html doesn't mention anything about it except : Starting from version 3.23.50 you can also associate the ON DELETE CASCADE or ON DELETE SET NULL clause with the foreign key constraint. EG > When I try to change

RE: mysql query help

I've not looked over your query in-depth so I may be off-base here. Try removing the parentheses from the FROM clause and see if that makes it work. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Scott Raley [mailto:[EMAIL

on update problem?

When I try to change the id field in the parent table below, I get the error: 1217 - Cannot delete a parent row; a foreign key constraint fails. What have I got wrong? Shouldn't it cascade the changes that were made to the parent down to the child table? This is done with Mysql 3.23.50-max

mysql query help

I need some help... The query below runs fine in access, when running it in mysql it tells me the column wrainfo.wuc doesn't exist in the having clause.. can't figure out why its giving me this error. the column is in the select statement... any ideas? The column does exist.. I'm looking at th

Re: Tinytext vs. char()

Peter, Thursday, June 06, 2002, 12:29:53 PM, you wrote: PE> I store firstname, lastname, telephone etc in a table PE> Is there any drawback with using tinytext? PE> As I can see when I store strings that differ in length, the PE> best would be to use tinytext, or? PE> http://www.mysql.com/doc/n/

Re: Mysql text search and fulltext

Erlend, Thursday, June 06, 2002, 2:53:02 PM, you wrote: EHS> I'm actually using MySQL 4.0.1-alpha in a production system now. Only using EHS> MyISAM tables. ( http://www.gnist.no ) EHS> The only problem I have is that sometimes the database crash with some EHS> fulltext searches... And with only

Re: Users

Arul, Thursday, June 06, 2002, 1:35:26 PM, you wrote: A> How do i create users in mysql.. A> After installing i just start mysql and connect to it.. A> Whats the default username and password it uses.. Check our manual: http://www.mysql.com/doc/A/d/Adding_users.html http://www.mysql.

Re: processlist

If you include the following flag in the startup command, the logfile will be generated in the given location: --log=/var/log/mysqld.log Eivind - Original Message - From: "Ritu Singla" <[EMAIL PROTECTED]> To: "Eivind A. Sivertsen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Se

Merging Databases (Newbie)

Dear all, it's our first time to realize a project, based on mySQL Database and now we have a problem i hope we can solve easily. There are different partners in this project and the actual solution is based on a MS-Access Fronten (arrrggh!). Now the partner have to do some input and they all ha

Re: Users

Grant on to @host identified by Alexander -- Mensagem Original -- >Hi! > A little effort please > >http://www.mysql.com/doc/A/d/Adding_users.html > >and > >http://www.mysql.com/doc/D/e/Default_privileges.html > > >EG > >> Hi all >> >> How do i create users in mysql.. >> After installing

Re: processlist

If you include the following flag in the startup command, the logfile will be generated in the given location: --log=/var/log/mysqld.log Eivind - Original Message - From: "Ritu Singla" <[EMAIL PROTECTED]> To: "Eivind A. Sivertsen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent

Mysql text search and fulltext

(first some info and 'things that I want', then a few questions) Hi I'm actually using MySQL 4.0.1-alpha in a production system now. Only using MyISAM tables. ( http://www.gnist.no ) The only problem I have is that sometimes the database crash with some fulltext searches... And with only some w

RE: MySQL or MS Access ?

[snip] Lastly only a few people will be able to use you application before MS Access fails... Therefore limiting access to your mission critical applicaiton I do not really think MS Access is for Mission-Critical databases...but I guess that depends on ther definition of mission critical. Most M

New additions on MySQL++ page

Hi! There have been some new additions on the MySQL++ page. First of all, thanks to the efforts of Clint Savage [[EMAIL PROTECTED]] and Arturs Aboltins [[EMAIL PROTECTED]] we have two new files : * mysql++1_7_1win32_borland_1_2.zip a new version of MySQL++ for Borland C++ with many bug fixe

RE: Mysql newbie show table question

* marc malacarme > I can¹t seem to make any of the describe or show queries work > when I apply a search statement: > Query=show table status from demo; > Works fine. Now I¹m trying to get info from only one table: > Query=show table status from demo where name like "user_access"; > Does no work.

Re: Users

Hi! A little effort please http://www.mysql.com/doc/A/d/Adding_users.html and http://www.mysql.com/doc/D/e/Default_privileges.html EG > Hi all > > How do i create users in mysql.. > After installing i just start mysql and connect to it.. > Whats the default username and password it uses

Users

Hi all How do i create users in mysql.. After installing i just start mysql and connect to it.. Whats the default username and password it uses.. -Arul - Before posting, please check: http://www.mysql.com/manual.php (the

RE: Is View supported?

* Borus.Kung > Is View supported by MySQL? no. > if not supported, is there any other way to achieve it? > > I have a table of history data > because the table is growing too much > so I will divide it into 12 > but I therefore have to modify all the programs > if I can have a view of the origi

Is View supported?

Is View supported by MySQL? if not supported, is there any other way to achieve it? I have a table of history data because the table is growing too much so I will divide it into 12 but I therefore have to modify all the programs if I can have a view of the original name that select from all these

Insert into longblob column, it's limitation

Good Day I will attempt to give you as much information about the software as I can before I ask the question. OS : RedHat 7.1 MySQL : Version 3.23.49a for Linux -> binary distribution for pc-linux I want to insert into longblob column very big large data. but.. I have strange Errors... Exam

Re: mysql client

Jetaime, Wednesday, June 05, 2002, 11:45:56 PM, you wrote: J> how can i setup a mysql server on a machine that is on the network to accept J> connections from my machine. I downloaded the client and there is currently J> a server running on a nother machine on the LAN. I inputed it's ip address J

Re: More normalization

I think what you're getting at is that you're trying to consider both 'contactInfo' and 'entity' to be superclasses, with subclasses like 'phoneContactInfo', 'addressContactInfo', etc. and you'd like other tables to have fields which reference the superclass. Inheritance relationships are a common

Re: RE: support UTF-8

Mehdi, Thursday, June 06, 2002, 11:27:24 AM, you wrote: MZ> Hi Shahzad, MZ> I also want to know whether mySQL support Unicode, utf-8 or not. MZ> If you know anything about this please answer me as soon as possible, Unicode support will come in 4.1. Unicode in 4.1 will use UTF-8 and UCS2 with a

Tinytext vs. char()

Hi! I store firstname, lastname, telephone etc in a table Is there any drawback with using tinytext? As I can see when I store strings that differ in length, the best would be to use tinytext, or? http://www.mysql.com/doc/n/o/node_369.html In terms of fulltextsearch/index etc. What is the diffe

Re: I have problem with a Cyrillic

Anelia, Thursday, June 06, 2002, 12:25:25 AM, you wrote: AT> Description: AT> I have problem with a Cyrillic when I use clauses "ORDER BY" AT> and "LIKE". AT> They didn't work correctly. What character set do you use? Change you charset to cp1251 or win1251 or koi8_ru. -- For te

RE: Maximum JOINED tables

* Harald Fuchs > In article <[EMAIL PROTECTED]>, > "Roger Baklund" <[EMAIL PROTECTED]> writes: > > > Yes... that is strange. There could be a bug in the crashme > > report, or the limit may have been lowered after 3.23.39, but > > neither of those seems very likely (to me, anyway)... anyone > > go

RE: Select DATE, help ...

* Tom Jones > I have a table with 2 columns StartDate and EndDate. > > I can't seem to figure out how to write a select statement that will > tell me if the date I'm searching on is between the Start and the End > date. > > Like, I want to know if 7/4/2002 is between 6/1/2002 (startDate) and > 8/1

RE: support UTF-8

Hi Shahzad, I also want to know whether mySQL support Unicode, utf-8 or not. If you know anything about this please answer me as soon as possible, Sincerely, Mehdi Zare -Original Message- From: shahzad sarwar [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 8:35 PM To: [EMAIL P

Re: MYSQL Relation n-m

> >>I have a database on MySql divided into 3 tables >>books (idbook, and other fields) >>author (idauthor, and other fields) >>bookauthor (idauthor,idbook) >>This is to have more than 1 author for every book >>How can I select with a query on one row all the authors of abook? >>Thanks >>Antonio >

Re: replication problem

Hi, I already had a similar problem. I did the following things: I zipped my master database to unzip it on the slave and then I did a "reset master",that's it. The reason why you have this problem it's certainly due to the fact that your master and slave database are not identical. you didn't t

MYSQL Relation n-m

I have a database on MySql divided into 3 tables books (idbook, and other fields) author (idauthor, and other fields) bookauthor (idauthor,idbook) This is to have more than 1 author for every book How can I make a query to select on one row all the authors of abook? >>Thanks >>Antonio > > > > -

replication problem

i am sending it again, maybe this time someone would help ... :) > hello, > > i have major problem with setting up replication. > > both ends are running mysql 3.23.49 > i have set up proper entries in my.cnf on both sides and > have replicated the dbs. slave's data directory is exactly the same

<    1   2