Re: query help needed.

anders thoresson schrieb: I'm building a planning system for a newspaper. Article ideas are defined as articles with no deadline, no publication date or no reporter assigned. I wan't to show all entries from table un_article that matches those three criterias. I have three tables: CREATE TABLE

Re: mystry about mysqlcc

Andreas wrote: I got me a copy of mysqlcc 0.9.2-beta and installed it on my win 2000 box. No complaints so far. There is an icon on the desktop. I click it and for a really short moment there is a sandclock and then nothing happens. Mysqlcc just dosn't bother to appear. I went to the c:\programme

Re: Newbie SELECT Question

Steve Cote wrote: We are having problems with what we think is a simple select statement: select ENTITY from ATTRIBUTE where (NAME='FavoriteSport' and VALUE='Soccer') and (NAME='FavoriteFood' and VALUE='CornDogs'); You are trying to find a row with a NAME value of 'FavoriteSport' and 'Favor

Re: Jumping to prev and next records

Scott Haneda wrote: [...] Is perhaps there some way to get the next id and prev id in a mysql query based on id being sorted? You could do this using LIMIT. For example: SELECT id FROM foo WHERE id > $current_id ORDER BY id ASC LIMIT 1; SELECT id FROM foo WHERE id < $current_id ORDER BY id DESC LI

Comments/questions on "High Performance MySQL"

Hi, I just finished reading "High Performance MySQL". Congratulations to the authors, it's a great book and I enjoyed reading it. Would be great if someone now started to write "MySQL Internals" ;-) There are some items in the book I'd like to comment or ask questions about. I hope the list is

Re: table locking using perl DBI

Andy Ford wrote: I have a perl cgi script that needs to lock the tables. Unfortunately, as HTTP is a one shot protocol, once the cgi script completes execution, the tables are unlocked. I need it to stay locked until another cgi script unlocks them! Is there any other way of achieving this!? You c

float in PROCEDURE ANALYSE() / misleading CREATE TABLE error

Hi, I think there is 1) a problem with FLOAT recommendations in PROCEDURE ANALYSE 2) a minor problem with CREATE TABLE(f FLOAT(,...)) Please correct me if I'm wrong. With MySQL 4.0.17, the query SELECT * FROM my_table PROCEDURE ANALYSE(); gives me the following result for a DOUBLE NOT NULL col

mysql_install_db.sh mini patch

Hi, I tried to install 4.1 (Bitkeeper tree) on SPARC Solaris 9 today. There is a line in mysql_install_db that is bash-specific and does not run with /bin/sh (at least not on my system): # scripts/mysql_install_db Installing all prepared tables scripts/mysql_install_db: syntax error at line 215

Re: Comments/questions on "High Performance MySQL"

Hi, Sasha Pachev wrote: Hans-Peter Grimm wrote: I just finished reading "High Performance MySQL". Congratulations to the authors, it's a great book and I enjoyed reading it. Would be great if someone now started to write "MySQL Internals" ;-) I actually do have a fa

Re: User information in the binlog (again...)

[EMAIL PROTECTED] wrote: I remember reading about someone inquiring about including the user's information in each query logged to the binlog. Neither "mysqlbinlog" or "show binlog events" shows which user performed which changes to the database (at least for me:4.1.1a-alpha-nt-log / binary distro

Re: mysql on solaris 8/9

Aysun Alay wrote: Our application needs to support both solaris 8 and solaris 9. I was wondering if mysql has a backwards compatibility in terms of operating systems. Can I use mysql-pro-4.0.20-sun-solaris2.9-sparc.tar file to install mysql on Solaris 8? Not sure, but it is usually not too hard to

Re: grant replication slave ...

[EMAIL PROTECTED] wrote: I am running MySQL 3.23 and want to setup replication. I execute the following command(copied from MySQL document) on the master server: GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%.mydomain.com' IDENTIFIED BY 'slavepass'; And it return the following message: ERROR 1064: You

Re: Databases not seen in MySQLCC

Marvin Cummings wrote: Have a strange problem where only one of my databases shows up in the MySQLCC console, yet if I look in the MySQL Admin console all databases are seen. Anyone experience this before? If you right-click the server entry in MySQLCC and select "Edit", there is a "Databases" ta

Re: How to select without using sub-select?

[EMAIL PROTECTED] schrieb: I am running MySQL 4.0.10 gamma. I have records with data: id title version 1a 1 2a 2 3b 1 4b 2 How do I select all the records with highest version for each title? [...] Try: SELECT t1.id, t1.title, t1.version FROM table