Re: Question about state of tables

Check out the tables_priv and db table in the mysql database. It has all the permissions of the MySQL. Insane SQLyog - The Definitive Win32 GUI for MySQl http://www.webyog.com - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 10:43 AM S

RedHat 8 and mysql-server-3.23.52-3

I have recently installed RedHat 8 and the following RPMs: [root@chimp etc]# rpm -q mysql mysql-3.23.52-3 [root@chimp etc]# rpm -q mysql-server mysql-server-3.23.52-3 I am having problems connecting to the server remotely through the TCP connection, the firewall i

Segmentation fault when accessing mysql from non-local host

>Description: I've installed mysql 3.23.52 from source on RedHat Linux 7.3 ... when I try to access the server from a non-local host, it gives the following error: /usr/local/mysql-3.23.52/bin/safe_mysqld: line 273: 5979 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --bas

Re[2]: Same syntax on MySQL and Microsoft SQL Server

>From: Christian Reichenbach <[EMAIL PROTECTED]> > We encountered that MySQL (or MyODBC) uses different quoting characters for legal names and strings. >>>BSJ> Well, let's put it this way : tables names between >>>BSJ> square brackets only exists in Microsoft! >>>That might be right, but th

Re: show processlist ? - sleep .

That's ok , but i got threads (quite a few) that sleeps for say 3000 seconds . Using just PHP with mysql i assumed the connection should close (quote from php manual : mysql_connect -- Open a connection to a MySQL Server - The link to the server will be closed as soon as the execution of the scrip

Problems with char field

Hi MySQL-team! I develop WIN32 software that uses MySQL database. My software uses MySQL ODBC driver 3.51 and ADO interface. MDAC 2.7 is installed. My problem is that while I'm trying to update MySQL record contained char(15) field, I get an error "Microsoft OLE DB Provider for ODBC Drivers Multip

Sun Solaris 2.7 Sparc static binary of MySQLGUI 1.6

When I tried to execute "Sun Solaris 2.7 Sparc static binary of MySQLGUI 1.6", I get the error that it can't find, libstdc++.so.2.10.0. I thought this was suppose to be a statically linked executable? I can fine the ".a" file but not the ".so" file. - Bob --

Question about state of tables

Hello; newbie to this list. I wonder if there is a clear method of obtaining a user's permissions on a table. The reason I ask is that I am attempting to setup a catalog solution for a user I am hosting, and I believe I have provided access to the d/b but I need to confirm. I thought I might g

Re: Fw: Which files to download/install - problems running MySQL

At 20:22 21/10/2002 +0100, Nikki Mason wrote: Hi, My email below was rejected for some reason, so I am trying again to send it. No problems, but I need to clarify you that behavior: 1- When you start the server with: name_server --standalone --console. The DOS prompt screen is owned by the

Re: SHOW question

At 17:06 +0200 10/21/02, Fabio Checconi wrote: I'm writing a program using the C API. When I do a query "SHOW TABLES" am I sure that on every installation it will return a result set of one column containing the tables name, or there are systems where that's not true ? Am I sure that from a "SHOW

Re: Using AUTO_INCREMENT like SEQUENCE - Resolved

At 16:57 +0200 10/21/02, Joseph Bueno wrote: Hi all, Sorry to jump in the middle of this thread but there is a much simpler way to generate sequence numbers: You create an auxiliary table with a one row: CREATE TABLE sequence ( code int(11) DEFAULT '0' NOT NULL ); INSERT INTO sequence VALUES (

where is the mysqladmin?

Hi there, I'm have just installed mySQL and I'm completelly new at it. When it was installed it showed a message telling me to change the mySQL root user's password using the mysqladmin, but I don't have this file. I installed the mySQL 3.23 using the rpm file on a computer runing Linux. So, do I

Where is the mysqladmin?

Hi there, I have just installed the mySQL 3.23 and don't know nothing about it yet. When I installed it there was a message telling me to change the mySQl root user's password with the command mysqladmin, but I don't have this file on my computer. Do I need to install something else? I have instal

Re: how do you define a relationship?

> Unfortunately this goes well beyond the scope of my original question. > Although the inputs that you all have provided thus far have been a very > good read, I still don't grasp the concept of defining a relationship. Is > it simply referring to a primary key in a field other than the one where

PRI key

In MYSQL I'm using MYISAM. Should the 2 fields in each of the Stars & TitleGenres table be Primary keys since they are 'tied' to other fields? Studios (StudioName, StudioID) Genres (GenreName, GenreID) Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) Actors (F_Name, L_Name, Ac

RE: What is relay-bin log?

Well... Then when is the time for replication logs to be deleted? Can I change the conditions for it? I'm not able to find out related section in the official manual. No mention about auto deletion, either. -- Chung Ha-nyung Sayclub NeoWiz

Re[2]: Same syntax on MySQL and Microsoft SQL Server

Hi Jan, >>>We encountered that MySQL (or MyODBC) uses different >>>quoting characters for legal names and strings. >>BSJ> Well, let's put it this way : tables names between >>BSJ> square brackets only exists in Microsoft! >>That might be right, but this is how Microsoft works. JS> I'm sorry, but

Re: mysql grant ?

At 15:29 -0500 10/21/02, Terry & Cheryl Haimann wrote: I want to give read access to all users on the localhost for a specific mysql table, I have tried the following: grant select on database.table to %@localhost; grant select on database.table to "%"@localhost; grant select on database.table t

Re: Japanese, Korean and English in same mysql db

At 16:04 -0700 10/21/02, Jimmy Vo wrote: Hi, I have a need to store many languages (Japanese, Korean, Spanish, English..) in the same mysql db. I also need to search for these strings to see if they are already in the db for updates. Of course, this is a problem since the charset setting drives

Japanese, Korean and English in same mysql db

Hi, I have a need to store many languages (Japanese, Korean, Spanish, English..) in the same mysql db. I also need to search for these strings to see if they are already in the db for updates. Of course, this is a problem since the charset setting drives the logic for searching. I've browsed ov

Re: show processlist ?

On Mon, Oct 21, 2002 at 02:51:14PM +0200, cristian ditoiu wrote: > Hi . > Using Mysql3.23.49 on RH 7.3 + PHP + Apache . > When issuing 'show processlist' i get a lot of these : > > What exactly means 'sleep' ? The thread (connection) is idle. -- Jeremy D. Zawodny | Perl, Web, MySQL, L

Re: Re: Bug report

Hello Douglas, Saturday, October 19, 2002, 2:47:06 PM, you wrote: D> cd /home/mysql/mysql/data D> touch ibdata1 D> How do I control that size? It means that you already have file ibdata1 and this file has another size that you are specifying in my.cnf ... D> - Original Message - D> From

Re: Error 1034: 136 when fixing table from Create Index on long table

Hi, [root@forum] /usr/local/mysql/var> perror 136 Error code 136: Unknown error 136 136 = No more room in index file Are you sure your file system can handle the size of your index file ? Regards, Jocelyn - Original Message - From: "Chris Stoughton" <[EMAIL PROTECTED]> To: <[EMAIL PRO

Error 1034: 136 when fixing table from Create Index on long table

I am running 3.23.52-Max under Linux. I now have a table with 54M rows: mysql> select count(*) from targetTsObj; +--+ | count(*) | +--+ | 54549046 | +--+ 1 row in set (0.05 sec) Creating an index on this takes 1 hour 10 minutes, with this error: mysql> create index targ

RE: Tips for LARGE system

> handling from 3M to 20M records/day with potentially a lot > of processing, live inserts/ updates etc. How many records do you forsee? (There are some things to look up in the manual to give MySQL a hint at the total size of the table so it can start using longer internal pointers.) How big ar

Timestamp field in the InnoDB table

Hi, I have found one unclear place for me regarding to the timestamp field in the InnoDB table. Please, explain me am I correct or not. Let's say we have a table Test with 'timestamp' field: CREATE TABLE `Test` ( `id` int(3) NOT NULL auto_increment, `UpdateDate` timestamp(14) NOT NULL, PRI

Compiling mysql with correct libraries

Hi all. I want to compile MySQL statically with my own UDF and InnoDB support in one box and with make_binary_distribution install it in a RedHat 8.0 box. Which are the correct versions for gcc and glibc? And automake, autoconfig, and any another posible package needed for compile MySQL? Which is

Foreign keys in InnoDB tables

Hello I am a brand new user of MySql, and have some questions about using InnoDB tables. I noticed in the manual that you can only specify - ON DELETE SET NULL Or - ON DELETE CASCADE What is the default behaviour if nothing is specified? Also, does anyone know if there are any plans to s

RE: Seeking the minimum value of DateTime column type in MySQL

On 21-Oct-2002 Prabu Subroto wrote: > > Dear friends, > > > > I am developing a database application for our saleses > > with PHP and MySQL. > > Our sales must call the customers on time. They may > > not be late to call the customers. The may not miss > > the appointment to meet the custom

Test for table lock

Hi, Using MySQL, perl and DBI, is there a way to test to see if a table is locked (as in "LOCK table..."). We batch process our updates every 3 hours or so (it's not a set schedule though, it depends when a certain level of new updates is reached), and our main tables are locked during this t

Table gets wiped out!

Still need help with this, guys. :) I read that was a problem with the list being over some limit (?). So, in case you did not receive this, I hereby resent it. Otherwise, I am sorry for posting it twice. Thanks, - Mark Ok, rebuillding a table, I did (in Per

Connection pool

Hi, Does anyone has a connection pool built for MySQL using JAva (the application run on Tomcat).. I have one but its not running satisfactorily and leaves some processes suspended.. thnx in adv, sands - Before posting, pleas

Re: Timestamp field in the InnoDB table

Mikhail, - Original Message - From: "Mikhail Entaltsev" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 21, 2002 1:11 PM Subject: Timestamp field in the InnoDB table > Hi, > > I have found one unclear place for me regarding to the tim

RE: What is relay-bin log?

It is seems that "RESET SLAVE" query sholud not be done while replication is working. Slave forget its replication position and cannot continue replication since it tries to do the queries already executed. Do I need to do "SLAVE STOP" before "RESET SLAVE"? Or any other means to delete replicat

RE: Compiling mysql with correct libraries

> -Mensaje original- > De: Sinisa Milivojevic [mailto:sinisa@;mysql.com] > Enviado el: lunes, 21 de octubre de 2002 14:28 > Para: Iago Sineiro > CC: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Asunto: Re: Compiling mysql with correct libraries > > > On Mon, 21 Oct 2002 09:51:41 +0200 > "Iago Sin

RE: RAM needed for a mysql server

On 21-Oct-2002 Francesc Guasch wrote: > Hi. > I asked this question last week and nobody answered. Please > someone give me a hint. > > I need to buy a new server that must handle 500 concurrent > connections to a mysql server and I don't know how many RAM > should have. > I've a server that do

AW: Strange behavior of MySQL 3.23.51

Hmmmnn ... I don't think so ... COUNT() is also an aggregate function and a SELECT COUNT(*) FROM table should work on every database without grouping. I think it's an error in MySQL. Why else this different behaviour with and without unique index? > -Ursprüngliche Nachricht- > Von: Mikh

ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) - WINXP

Hi, I wonder if this is a bug, or my mistake. First I had installed a running version of mysql 3.23.52. Everything was fine, Mysql worked fine. Afterwards, I wanted to try MySql 4.0.4. I installed it on a different folder. After the install, I could not connect to the database with the follo

Re: Normalization sql

John Chang wrote: What is the Title.ID and Actor.ID? Will this work if someone is doing a text search on a webpage? The results will go to another page. Does the below go to the first page or the results page? You need a good SQL book and a good CGI/web programming book. The .ID's are usua

MySQL - ERROR 2003: Can't connect

Hi. I am new to this and can't get started because I receive the error message: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061). o/s : WindowsXP. Any ideas? Thanks, Clive. - Before posting, please check: h

Re: Timestamp field in the InnoDB table

Mikhail, - Original Message - From: "Mikhail Entaltsev" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 21, 2002 2:34 PM Subject: Re: Timestamp field in the InnoDB table > Heikki, > > thank you for your response. > > > Is this a big p

Re: normalization question

Except in the case that cars aren't held at the dealers and any one car can be purchased from a range of dealers. In which case you will need a seperate table like, Dealer_Car_Map (dealer_id,car_id). Ric. - Original Message - From: "Artem Koltsov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED

Re: ERD, Scripts, and Reverse Engineering

I did the same seach and evaluation a couple of weeks back. Ended up buying Dezign for Databases, partly on cost (compared to Case Studio which seems the most comprehensive product), but also because the evaluation version allowed enough tables/releationships to do a realistic eval + good doc

RE: RedHat 8.0 and MySQL

Luc, I just installed RH 8.0 (i86) and also installed the MySQL (4.0.4) rpm's from the MySQL site (didn't use the ones on the RH 8.0 CD's -- they were 3.x.x). My machine is standalone so there are no other users accessing MySQL. MySQL worked fine except that it wouldn't launch when the system boo

Obscure FULLTEXT search problems

Hi there, I have some trouble understanding some results I'm getting when executing a SELECT statement in an FULLTEXT indexed table in my MySql db. In scenario 1 I'm using this SQL-statement: SELECT * FROM tArticles WHERE ( Title LIKE '%HYDRO%' OR Body LIKE '%HYDRO%' ) In scenario 2 I'm using t

Setup Query to search smallest subset on a Conditional And?

Hi, In previous e-mail I asked how to improve a word search and used some of the suggestions. Now I'm doing a 2 word search and need a little advice. Background: There are 2 tables: word and content. content consists of 2 fields: rec_id int(11) unsigned not null,

adUseClient

SQL The docs say that recordset1.RecordCount will return the correct value if adUseClient is used as the cursorlocation setting. I find that this is not correct - is there another setting which needs to be mae to make this return correctly - my return matching rows setting is also set. Alan McDona

Re: Timestamp field in the InnoDB table

Heikki, thank you for your response. > Is this a big problem? Well, actually it is not very big problem for me now, because I already know about that feature. ;) But I would prefer to have timestamp that means the end of the transaction. Anyway it would be very useful to have some notices in the

ENABLE KEYS

Please help me! mysql>alter table a_log ENABLE KEYS; ERROR 1064: You have an error in your SQL syntax near 'ENABLE KEYS' at line 1 Thank's - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

Need help installing PHP (Linux) with MySQL and Apache

I can't get PHP-4.2.3 compiled to work with MySQL and Apache, despite months of trying. Apache compiled ok, and so did MySQL -both work, on my Debian Linux box. I've tried various combos of installing the Deb packages, compiling from source, and various combinations thereto. I started out usi

Re: how do you define a relationship?

Arthur Fuller wrote: Create a new table called Roles, which contains rows for Actor, Director, Producer, D.O.P. and whatever else is of interest. For what its worth, I would consider it more appropriate to simply do: Movies: ID, etc. People: ID, Name, etc. MoviePeople: MoviesID, PeopleID, Rol

RE: why so late with Mac OS X versions?

> Marc Liyanage has been doing MacOS X binaries in Switzerland. > When I lived there, they took month-long vacations, two-hour > lunches, and frowned on weekend work. Maybe he has a life > outside of MySQL? :-) How do I get a job in Switzerland? ;) sql, query -

Strange behaviour of MySQL-3.23.51

I have a database structure as follows (simplyfied) : CREATE TABLE masterTABLE ( pid int(11) unsigned NOT NULL default '0', c1id int(11) unsigned default NULL, c2id int(11) unsigned default NULL, value int(11) unsigned NOT NULL default '0', UNIQUE KEY pid2 (pid,c1id,c2id), UNIQUE KEY

RE: how do you define a relationship?

>From: "Arthur Fuller" <[EMAIL PROTECTED]> > >Unfortunately that oversimplifies the situation. A least a few movies have >more than one director. My motto: "Generalize for the norm; specialize for the exception." The vast majority of movies have but one director. And I suspect that movies with m

Re: problem upgrading

> I believe you need to move the socket which defaults to /tmp. If you move > it to /var/run or /var/tmp, you should be good to go. I think you can > either set the location at compile time or in the config files. Thanks for the response! I have /tmp symlinked to /var/tmp, and /var is mounted w

RE: mysql problems

On 21-Oct-2002 porcupine wrote: > > Hello guys > Here is the problem. You may find it trivial, but it is a serious > obstacle for me. I make a database, a table in mysql and it goes fine. > Then I try to view my table with PHP. I am pretty sure that I can't > connect to the database. > In parti

RE: how do you define a relationship?

Unfortunately that oversimplifies the situation. A least a few movies have more than one director. AI, for example: first half by Kubrick, second (lousy) half by Speilberg. Another example is The Twilight Zone, which had four directors. This calls for a junction table between Movies and Directors,

Re: MySQL with InnoDb Tables - A Big Confusion

change your my.cnf to use the following variables:(I left our info in them for reference) innodb_data_file_path = ibdata1:400M innodb_data_home_dir = c:\ibdata innodb_log_group_home_dir = c:\iblogs innodb_log_arch_dir = c:\iblogs also make sure the MySQL my.cnf is place in the /etc directory in U

Re: Tips for LARGE system

On Sun, Oct 20, 2002 at 10:52:22PM -0700, Steven Roussey wrote: > > Other people can tell you more about replication and how it is > different from clustering or load balancing. And you can use it for > backup in a way too. It depends on your requirements though. Yeah. And you can use replicatio

Strange behaviour of MySQL 3.23.53

>Description: Hello sirs, Mr. Benjamin Pflugmann told me to send this problem to [EMAIL PROTECTED] I have a database structure as follows (simplyfied) : CREATE TABLE masterTABLE ( pid int(11) unsigned NOT NULL default '0', c1id int(11) unsigned default NULL, c2id int(11) unsigned default N

Multi-join timings

*horribly unrealistic test warning* movies table: 1004 entries (id, directorid, name) directors table: 1765 entries (id, name) moviedirectors table: 1004 entries (movieid, directorid) (duplication of data with directorid is purposeful, for the sake of testing two query types with the same data).

mysql grant ?

I want to give read access to all users on the localhost for a specific mysql table, I have tried the following: grant select on database.table to %@localhost; grant select on database.table to "%"@localhost; grant select on database.table to " "@localhost; None seem to work, what is the correc

Please help: MySQL automatic reconnect

Hi, I have read the MySQL manual that the automatic reconnect is implemented since version 3.21.18. Also according to the C API manual, the mysql_real_connect will set the automatic reconnect flag in MYSQL structure. However, I cannot find any instruction to switch off this automatic reconne

Seeking the minimum value of DateTime column type in MySQL

> Dear friends, > > I am developing a database application for our saleses > with PHP and MySQL. > Our sales must call the customers on time. They may > not be late to call the customers. The may not miss > the appointment to meet the customer on the telephone > line. > But I have a problem to impl

ANN: EMS MySQL Manager 1.92 released

EMS HiTech company is announcing the next version (1.92) 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.92? 1. Grant Manager: Ext

logging into mysql on mac os x

Hi everyone, I'm a newbie to mysql and i'm trying to log into the mysql monitor from the terminal in mac os x (10.2.1). I was able to do it when i installed the system but for the life of me i can not figure out how to go back into it. Whenever i type the commands the articles i read say it n

RE: Which files to download/install - problems running MySQL

Hello, This is the my.cnf that I use in my syste. It is located in C:\. You can use it as guide. Start ## #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=D:/MySql datadir=D:/

Fw: Which files to download/install - problems running MySQL

My email below was rejected for some reason, so I am trying again to send it. Regards, Nikki - Original Message - From: Nikki Mason <[EMAIL PROTECTED]> To: Miguel Angel Solórzano <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 20, 2002 8:41 AM Subjec

AW: Strange behavior of MySQL 3.23.51

And what about the WHERE-Clause?? It is not used in Statements with Aggregat functions? ... cool answer ... but I really can't think so ... > -Ursprüngliche Nachricht- > Von: Mikhail Entaltsev [mailto:mike_lynx@;smtp.ru] > Gesendet: Montag, 21. Oktober 2002 18:42 > An: [EMAIL PROTECTED];

Using auto-increment like sequence

Mike Hillyer wrote: two rows simultaneously was nil. So, that may work for you as long as each user is logged in separately, and you can accept putting a field in your row referring to the row creator. FWIW, you could always grab the current PID of your process and make your primary key '

Re: safe_mysqld fails. Can't read .err log

Hi, Go to in the /etc/init.d and just type : "mysqld start" It should be no problem to open the err.log file. Try: more err.log Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED]

Re: mysql socket problem in win98 (thanks for the help!)

First of all, thanks to everyone for no reply and no help! If someone is interested, I've found that i Win9x systems, if there are persistent connections open, the system instead of used the same opened connection for the same session, it opens a new connection for each script call, and, because i

Re: MySQL - ERROR 2003: Can't connect

Clive Grigg wrote: > Hi. > I am new to this and can't get started because I receive the error message: > > ERROR 2003: Can't connect to MySQL server on 'localhost' (10061). > > o/s : WindowsXP. > > Any ideas? > > Thanks, > Clive. > Hi, I don't use MySQL on Windows so I can't really help you;

RAM needed for a mysql server

Hi. I asked this question last week and nobody answered. Please someone give me a hint. I need to buy a new server that must handle 500 concurrent connections to a mysql server and I don't know how many RAM should have. I've been looking to the process list but I'm clueless about how much memory

mysql quota

I want to let users on my system use MySQL, but I want them to have some sort of quota. Is there anyway to create a max database size with MySQL? I could just chown the directory in /var/lib/mysql, but that means I would have to create a username for each person and set filesystem quota. I re

3.23.52 source code .... where?

Can anyone tell me where I can find the source code for 3.23.52? I looked on source forge and there is a section for 3.23.52, but there is no source code for 3.23.52 in it (No Files). The latest it seems to have is 3.23.51.   Thanks,     Wim   sql,query  

normalization question

I'm working on a design for a database that is leaving me with some normalization issues that I havent had to deal with before. For example, if im trying to store information about car dealerships I end up with the following situation: I want to store the cars in stock at each physical dealership,

Re: Compiling mysql with correct libraries

builds with these compilers have been tested extensively. We would suggest, however, that you stay away from gcc 3.0 series until we have had some time to do some more extensive testing. Speaking of which, how /is/ testing of gcc 3.x going? Is this an active issue for the new MySQL major rel

RE: ERD, Scripts, and Reverse Engineering

I work with DeZign as well and chose it for basically the same reason as you. I particularly love the fact that it supports domains. I have been communicating with the author and encouraging him to add specific InnoDB table types. I also suggested another feature to him that he really liked; we ju

RE: normalization question

Hi! I don't understand problem. Car can belong to only one Dealer, and one Dealer can have many Cars, therefore DealerID should be in Car table. Also Car can be only one Model, but there are many Cars the same Model. It looks quite normal to put ModelID into Car table, and I don't see any possib

RE: ENABLE KEYS

>mysql>alter table a_log ENABLE KEYS; >ERROR 1064: You have an error in your SQL syntax near 'ENABLE KEYS' at >line 1 What version are you running, I think I read ENABLE/DISABLE KEYS just work in 4.0. STIBS - Before posting, pl

Re: why so late with Mac OS X versions?

Ed Carp wrote: Marc Liyanage has been doing MacOS X binaries in Switzerland. When I lived there, they took month-long vacations, two-hour lunches, and frowned on weekend work. Maybe he has a life outside of MySQL? :-) How do I get a job in Switzerland? ;) Funny, that's exactly what I

Strange problem with MySql & IIS & ASP

Hi All! I've Select like this: SELECT ExpDepDate, ActArrDate FROM oceandata It works beautifully But When I modify it like this SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs FROM oceandata I'll get nothing, just a empty screen with a browser! I'm using Ultradev to create this and whe

Re: Compiling mysql with correct libraries

On Mon, 21 Oct 2002 09:51:41 +0200 "Iago Sineiro" <[EMAIL PROTECTED]> wrote: > Hi all. > > I want to compile MySQL statically with my own UDF and InnoDB support in > one box and with make_binary_distribution install it in a RedHat 8.0 > box. > > Which are the correct versions for gcc and glibc?

Re: Timestamp field in the InnoDB table

Devi, As I understand you need to update timestamp field in some tables. And you have only 4-5 milliseconds for it? Is it correct? What is the problem? Best regards, Mikhail. - Original Message - From: "Devi Annisetty" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; "Mikhail

Re: using mysql successfully for 2 years-now getting connection error

Hi, In /etc/my.cnf you must put the right path to this file. E.g. [mysqld] datadir=/var/lib/mysql socket=/tmp/mysql.sock . Or if you don't want to make changes int my.cnf file you can connect using : mysql -S /tmp/mysql.sock Regards, Gelu _

RE: What is relay-bin log?

Hi! > "Chung" == Chung Ha-nyung <[EMAIL PROTECTED]> writes: Chung> If all works correctly, can I delete replication logs by "RESET SLAVE" Chung> safely? Chung> I'd like to configure two servers with two-master scheme, each is the Chung> master of Chung> another. relay logs should automat

RE: Test for table lock

On 21-Oct-2002 Mailing Lists wrote: > Hi, > > Using MySQL, perl and DBI, is there a way to test to see if a table is > locked (as in "LOCK table..."). We batch process our updates every 3 > hours or so (it's not a set schedule though, it depends when a certain level > of new updates is reach

RE: how do you define a relationship?

Unfortunately this goes well beyond the scope of my original question. Although the inputs that you all have provided thus far have been a very good read, I still don't grasp the concept of defining a relationship. Is it simply referring to a primary key in a field other than the one where the key

Automatic rounding in INTERVAL calculations

>Description: When attempting to select rows periodically (as in scheduling) the INTERVAL function will round the parts of an expression before doing the calculation of the expression. For example: now() - INTERVAL 0.1*60 MINUTE == now() The correc

Re: problem upgrading

> > I believe you need to move the socket which defaults to /tmp. If you move > > it to /var/run or /var/tmp, you should be good to go. I think you can > > either set the location at compile time or in the config files. > > Thanks for the response! > I have /tmp symlinked to /var/tmp, and /var i

Static linking

Hi, I tryed to link mysqld static but its give me some strange reports: its say that i have no enogth memory! mysqld is version 3.23.52 Other problem is when i use --prefix in configure script basedir is set to //va/ - thats very strange. TNX Dishko Georgiev

using mysql successfully for 2 years-now getting connection error

Hi, I have been running MYSQL without a problem for 2 years. Today I received a message as follows: ERROR 2002: Can't connect to local MYSQL server through socket /tmp/mysql/sock(111) Did some preliminary search on message on MYSQL.COM site. This file does exist on server but appears to be empty. I

Re: 3.23.52 source code .... where?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 21 October 2002 20:55, Wim van den Berge wrote: > Can anyone tell me where I can find the source code for 3.23.52? I > looked on source forge and there is a section for 3.23.52, but there is > no source code for 3.23.52 in it (No Files). The

Re: Strange behavior of MySQL 3.23.51

Hello. On Mon 2002-10-21 at 18:42:05 +0200, [EMAIL PROTECTED] wrote: [...] > > I think it's an error in MySQL. Why else this different > > behaviour with and without unique index? > > IMHO it's different issue. IMHO, it's the main issue. Adding or removing an index, even an unique one may not ch

Re: how do you define a relationship?

Jan Steinman wrote: My motto: "Generalize for the norm; specialize for the exception." My motto: "Do it right, then optimize it later if it sucks." Keep a single director field, with a second NULL FULLTEXT field for additional directors. The NULL test for the normal case is much cheaper than

SHOW question

I'm writing a program using the C API. When I do a query "SHOW TABLES" am I sure that on every installation it will return a result set of one column containing the tables name, or there are systems where that's not true ? Am I sure that from a "SHOW FIELDS FROM table" i'll get a result set with t

Re: SHOW question

Greetings... In the "show tables"if there is no database selected in the Server...it will give an error that no database is selected. In the second query...it will always return a resultsetmaybe an empty resultset if there are no fields in the table. hope it helps. Insane SQLyog - The D

Re: Same syntax on MySQL and Microsoft SQL Server

>>We encountered that MySQL (or MyODBC) uses different >>quoting characters for legal names and strings. At present we >>are using square brackets for names (like [my table], [my column] or >>[my table].[my column]) and inverted commas for strings >>(like mytxt = 'text'). >> >>Is there an option fo

Re: why so late with Mac OS X versions?

>From: Ray Kiddy <[EMAIL PROTECTED]> > >Can someone tell me what the holdup is in getting binaries built for Mac OS X? Uhm, volunteer labor? Marc Liyanage has been doing MacOS X binaries in Switzerland. When I lived there, they took month-long vacations, two-hour lunches, and frowned on weekend

  1   2   >