Re: MySQL: Selecting a patricular row

On 3/29/03 7:55 AM, "Marc Bakker" <[EMAIL PROTECTED]> wrote: > Hello, > I am working on a PHP/MySQL/Apache website. I have a MySQL table with 5 > rows. I want to select a patricular row using it's absolute row number. How > can I do this? I found mysql_row_seek() n te MySQL docs but this requires

Re: Allowing a user to change their password

That is all ok but what do you suggest? Row level privileges are not available in MySQL (yet). Or did I miss something? Cheers/h On 3/24/03 12:18 PM, "Shawn P. Garbett" <[EMAIL PROTECTED]> wrote: > On 3/24/03 10:37 AM, "R. Hannes Niedner" <[EMAIL PROTECTED]> w

Re: mysqladmin processlist = weird in version 4.0.12

The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of messages ago): Functionality added or changed: * `SHOW PROCESSLIST' will now include the client TCP port after the hostname to make it easier to know from which client the request originated. I guess whenever th

Re: Newbie Question

On 3/14/03 9:31 AM, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > At 8:04 -0800 3/14/03, Thomas Knight wrote: >> How do I change Mysql default database location? > > Please explain what you mean by that? Maybe you need to look at the commandline options or the my.cnf files. You can specify the data

Re: multiple simultaneous DBI connections?

On 3/13/03 6:47 AM, "Tom Norwood" <[EMAIL PROTECTED]> wrote: > I am currently looking at building a Perl object to handle data from a > a database. > I'm not really sure if it is best to have one connection to MySQL and > let the object just deal with its own properties. > Or to allow the object t

Re: MySQL book TOC

On 2/7/03 2:20 AM, "Vikram Vaswani" <[EMAIL PROTECTED]> wrote: > Hello all, > > My name is Vikram Vaswani, and I'm currently working on the outline for a > MySQL reference book. This is supposed to be a comprehensive reference to > MySQL 4, covering all aspects of the software, including the new

Re: CREATE TABLE, NOT NULL fields, and empty strings

On 2/6/03 9:05 AM, "Doug Beyer" <[EMAIL PROTECTED]> wrote: > I attempted to search various places for my answer but with no luck. So I'm > posting here. > > > > I create the following table: > > create table t1 ( id varchar(5) not null, name varchar(5) not null ); > > > I insert the followin

Re: Fulltext Index

Restrictions.html > > > On Thu, 2003-01-30 at 21:40, R. Hannes Niedner wrote: >> If I create a FULLTEXT index for 2 or more columns in a table will I be able >> to use it for a MATCH only against a single column (of the above) or do I >> have to create additional FULLTE

Fulltext Index

If I create a FULLTEXT index for 2 or more columns in a table will I be able to use it for a MATCH only against a single column (of the above) or do I have to create additional FULLTEXT indices for each of these columns? Thanks/h sql,query,queries,smallint --

Re: Recovery in MySql

On 1/29/03 5:13 AM, "Inbal Ovadia" <[EMAIL PROTECTED]> wrote: > Hi All, > I have MySql on Windows. > Today i had an electrical power interruption in the middle of working. > The database remain not consistent and i could not continue working with it. > > Is there any Recovery after crash mechanis

Re: cannot access mysql and see privileges

On 1/28/03 3:42 PM, "Jon Miller" <[EMAIL PROTECTED]> wrote: > Warning: Access denied for user: 'root@localhost' (Using password: NO) > in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 > > Warning: MySQL Connection Failed: Access denied for user: > 'root@localhost' (Using password: NO) in > /v

Re: sql query using select and row functions

tention. > >> -Original Message- >> From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, January 28, 2003 11:50 AM >> To: Christopher Lyon; MySQL Mailinglist >> Subject: Re: sql query using select and row functions >> >> On

Re: sql query using select and row functions

On 1/28/03 8:26 AM, "Christopher Lyon" <[EMAIL PROTECTED]> wrote: > I am trying to do an sql query and am trying to select the last x rows > from the database. I see the limit function but that seems like that is > from the first row down. I want to start from the last row to the first > row. So,

Why does mysqld_safe look for mysqld in libexec

Iwhat am I doing wrong: After downloading the binary for mysql 4.09-max for Mac OS 10.2 safe_mysql complains: % sudo bin/mysqld_safe The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as

Re: Mac OS X 10.1 build

If you download the binary, there is nothing to compile. Just follow the instructions in the file INSTALL_BINARY and you are ready to go. I did the same on 10.2.2 server and it worked great. Hth/h On 1/20/03 2:21 PM, "James LaFountain" <[EMAIL PROTECTED]> wrote: > > > I've been trying to compi

Re: mySQL, TCP/IP, Mac OS X --- HELP PLEASE !

On 1/20/03 6:18 AM, "Ram Kumar" <[EMAIL PROTECTED]> wrote: > greetings > > can anyone help to get mySQL on Mac OS X (entropy pkg), work on TCP/IP > rather than unix socket, please ? > > Is Marc Liyanage on this list ? > > regards, ram I don't know if Mark is on the list, but I might have some

Re: converting text to hypertext

On 1/8/03 8:34 AM, "Rick Tucker" <[EMAIL PROTECTED]> wrote: > I just imported a .csv file and one of the columns of data was websites > addresses. Those addresses aren't being recognized as links when I output > an html table from my queries. I'm scratching me head on how to make the > conversio

Re: converting text to hypertext

On 1/8/03 8:34 AM, "Rick Tucker" <[EMAIL PROTECTED]> wrote: > I just imported a .csv file and one of the columns of data was websites > addresses. Those addresses aren't being recognized as links when I output > an html table from my queries. I'm scratching me head on how to make the > conversio

Re: host.frm

From that > and my experiences, we're looking at a permissions issue. Hannes needs to > look at the permissions on his data and logging directories to make sure > that they are set to the default mysql:mysql. > > -Original Message- > From: R. Hannes Niedner [mailto:[EMAIL PROT

Re: user/root

On 1/1/03 5:46 PM, "Richard Nagle" <[EMAIL PROTECTED]> wrote: > Well it would appear that I finally have a connection Congrats. > q. since I am root, do I still need to GRANT a database to myself? > or just a to a new user. aka: bob@localhost If you are the only person using the computer that t

Re: host.frm

On 1/1/03 8:43 PM, "Jason Steig" <[EMAIL PROTECTED]> wrote: > > ./myqld: Can't find file : './mysql/host.frm' (errno:13) > > does anyone know how to solve this problem? This file is part of the host table in your mysql database 'mysql'. Did you by any chance copy the mysql data directory or par

Re: user/root

On 1/1/03 2:31 PM, "Richard Nagle" <[EMAIL PROTECTED]> wrote: > Well after 3 times installing mysql, finally > got it working (tks to those whom help) > now I need to take care of user and root. > first root. > > mysql> mysql -u root mysql > > just want to confirm this is correct before I push e

Re: An Idea

On 12/31/02 8:11 PM, "JamesD" <[EMAIL PROTECTED]> wrote: > lists work, and faq's work, some like to call...etc. > personally, I'd prefer a search engine style... > like google, but only for mySQL topics, and with > a visible list of most popular search terms. > > something that can be based upon

Joins are slow?

Scott Ambler recommends in his publication " Mapping Objects to Relational Databases" not to do joins but to traverse tables. He claims that 'several small accesses are usually more efficient than one big join'. Is that true for mysql? I am particularly interested in a scenario where I would retrie

To join or not to join

I am looking for an expert opinion on the speed difference between fetching related data from 2 tables with a join and fetching them in to single selects. The scenario is kind of the following: SELECT a , b, c FROM table1 WHERE a='x'; # gets b='y' SELECT b, d , e, f FROM table2 WHERE b='y'; inst

FW: Can MySQL handle 120 million records? - Impressive! How doyou guys do that?

-- Forwarded Message From: Joseph D <[EMAIL PROTECTED]> Date: Wed, 18 Dec 2002 13:55:47 -0800 (PST) To: "R. Hannes Niedner" <[EMAIL PROTECTED]> Subject: Re: Can MySQL handle 120 million records? - Impressive! How do you guys do that? thanks i actually can't pos

Re: Can MySQL handle 120 million records? - Impressive! How doyou guys do that?

On 12/18/02 9:48 AM, "Qunfeng Dong" <[EMAIL PROTECTED]> wrote: > But I am indeed seeing > not-so-good performance (join on tables much smaller > than yours takes minutes even using index) and I seem > to read all the docs I could find on the web about how > to optimize but they are not working for

Re: alter table syntax

ALTER TABLE town_db1 DROP PRIMARY KEY; ALTER TABLE town_db1 ADD PRIMARY KEY(town, subcity ); On 12/5/02 10:31 PM, "kayamboo" <[EMAIL PROTECTED]> wrote: > sql, mysql, query > > Hello folks > > This is my table structure with MySql 4.0.3-beta-max-nt with InnoDB > > +-+--+

Re: mysql port number

On 12/4/02 9:04 AM, "Mike At Spy" <[EMAIL PROTECTED]> wrote: > > How can I tell what port number mysql is running on? I need it for a chat > program. :) > > Thanks, > > -Mike > Default is 3306 /h - Before posting, plea

Re: Installing MySQL on Jaguar?

On 12/3/02 11:37 PM, "Brian Radford" <[EMAIL PROTECTED]> wrote: > Hello all, > > Could someone be so kind and share with this newbie where he might find > crystal clear step-by-step instructions on how to install MySQL v3.23 > on Mac OS X 2.2. I've looked through the manual and all I could find >

Re: CREATE TABLE and CHECK clausole

NTEGER (alias INT) data type is supported. > > Thanks in advance for any other suggestion. > > Achille. > > "R. Hannes Niedner" wrote: >> >> Maybe it's just to late for me to think clearly but there are NO INTEGERS >> between 0 and 1, try FLOAT or D

Re: CREATE TABLE and CHECK clausole

Maybe it's just to late for me to think clearly but there are NO INTEGERS between 0 and 1, try FLOAT or DECIMAL. Best/h On 12/3/02 1:08 AM, "Achille M. Luongo" <[EMAIL PROTECTED]> wrote: > Dear subscribers, > > MySQL seems to support the CHECK() clausole in the implementation of CREATE > TABLE

Re: Mysql db create error

On 11/27/02 1:24 PM, "Tim V" <[EMAIL PROTECTED]> wrote: > I am trying to create a new db in phpmyadmin with > MySQL 3.23.53a running on localhost. > > > SQL-query : > > CREATE DATABASE `` gulf `` > > MySQL said: > > > You have an error in your SQL syntax near 'gulf``' at > line 1 > > >

Re: MySQL subquery that works

On 11/24/02 4:30 PM, "Bruno Batarelo" <[EMAIL PROTECTED]> wrote: > The question is what does Access do in order to perform subqueries on MySQL > via MyODBC driver since it is obvious that they work? What can I do, but I > do not want to use access database as a layer between my application and > m

Re: Best MYSQL for MaxOSX Server 10.2.2

On 11/22/02 4:32 AM, "Stu Duncan" <[EMAIL PROTECTED]> wrote: > Try going to > http://www.entropy.ch/software/macosx/mysql/ > It's the best Mac MySQL reference around (but seems to be down this > Friday AM). I've used version 3.23.52-entropy.ch on a low bandwidth > website with no problems at all.

Best MYSQL for MaxOSX Server 10.2.2

I am planning on setting up mysql server on a Mac OS 10.2.2 Server running on a Xserve machine. It will be a development system for now, but I still want end up with a good usability status. The server will run Perl, PHP, Apache/Tomcat, Mysql to start with. Are there any recommendations or experie

Error on Mysql Doc website

I try to access thesearchable documentation with user comments: And get: Forbidden You don't have permission to access /doc/en/index.html on this server. Apache/1.3.26 Server at www

Re: support table synonyms?

On 11/12/02 8:59 PM, "Phillip Rhodes" <[EMAIL PROTECTED]> wrote: > I can not find anywhere that says that mysql supports table name synonyms. > > For example, I have two databases (test1 and test2) in the same mysql > instance. > > In test1 schema, there is a table called "table1" > > I would l

Re: Problems

On 11/12/02 7:05 PM, "Daniel Griggs" <[EMAIL PROTECTED]> wrote: > Hi there, > > I am having trouble with connecting to a Mysql host, the host version is > 3.23.51 on debian stable. After countless re- > reads of the documentation and checking the permissions all I get when I try > to connect rega

Re: Count Rows in two tables

On 11/12/02 5:36 PM, "Alan McDonald" <[EMAIL PROTECTED]> wrote: > You can't count the join? > Alan >> >> Hello all, >> >> Does anybody have a SQL string to count the rows in two different >> tables and >> give you a total number of rows? I have been trying to find an >> answer for a >> couple of

Re: Impossible SQL ???

On 11/12/02 12:43 PM, "Charlie" <[EMAIL PROTECTED]> wrote: > I can't seem to come up with a solution to the following SQL query, and have > a project dependent on a solution. I'd rather not load the whole database > and then parse it in the code. > > With the following Database structure: > Field

Re: How to link tables in MySQL

On 11/12/02 12:41 PM, "tmb" <[EMAIL PROTECTED]> wrote: > 2 - In MS Access you have to graphically connect the > table id fields to tell Access how the tables relate. > > How do you do this In MySQL... from the command line > I'm sure... just a code snippit or reference to one > would be nice...

Re: S.O.S. with mysql

On 11/11/02 9:26 AM, "Victoria Meza" <[EMAIL PROTECTED]> wrote: > I've a problem whit some tables in mysql, you know how repair damages > tables? > this is the message error: > Didn't find any fields in table 'criterios_evaluacion' > Didn't find any fields in table 'mensaje' > Didn't find any fiel

Re: access denied

On 11/11/02 9:10 AM, "Inbal Ovadia" <[EMAIL PROTECTED]> wrote: > Hi all > I am working with mysql, in windows, visual c++. > I am trying to run this query from c++ program: > > select * into outfile 'table_name.txt' FIELDS TERMINATED BY '\t' ESCAPED BY > '\0' LINES TERMINATED BY '\r' from table_n

Re: Problem with MySQL-GUI

On 11/10/02 9:42 PM, "daniel" <[EMAIL PROTECTED]> wrote: > i've made connections to a remote mysql from one server to our main one and > the main one is running socket connections ? I guess I lost you. All I wanted to say is this: If you run mysql (client) and mysqld (server) on the same compute

Re: Problem with MySQL-GUI

On 11/10/02 9:14 PM, "daniel" <[EMAIL PROTECTED]> wrote: > running on localhost using the socket connection (as supposed to > tcp/ip ). > > what are you saying that mysql can connect another way other than through > mysql.sock ? If I am not mistaken the socket works only for a connection between

Re: Problem with MySQL-GUI

On 11/10/02 1:50 PM, "Allan J Horwitz" <[EMAIL PROTECTED]> wrote: > Hi there -- I'm relatively new to LINUX (I have RedHat 8.0 on my system) > and I just downloaded MySQL-GUI and can't seem to get it working. It > keeps telling me that it cannot connect through the socket (111). Can > someone te

Re: PHP bias

On 11/9/02 11:04 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > I agree. It's really a drag that you can't use databases very well from > within Perl very easily. I wish that someone would invent a database > inferface for Perl. And it'd be really cool if they'd do it in such > a way that the g

Re: PHP bias

On 11/9/02 11:04 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > I agree. It's really a drag that you can't use databases very well from > within Perl very easily. I wish that someone would invent a database > inferface for Perl. And it'd be really cool if they'd do it in such > a way that the g

Re: PHP bias Stop feeding the troll

On 11/9/02 11:31 PM, "Georg Richter" <[EMAIL PROTECTED]> wrote: > Looks like you're not very familar with the spirit of Open Source: > > Perl, PHP, Python, Ruby etc. are very excellent languages. They all have > benefits and of course some disadvantages. But this competition helps each > one to i

Re: PHP bias

On 11/10/02 5:12 AM, "Robert Macwange" <[EMAIL PROTECTED]> wrote: > I am bothers me. > It bothers me that that the MySQL people have a bias towards PHP. > PHP is an inferior language. Deal with perl instead. > > > Robert Ouch.Death to all fanatics!!! Do you have

Re: little problem, I need some help...

On 11/9/02 3:14 PM, "3mip1s4la-Emilio Pisanty" <[EMAIL PROTECTED]> wrote: > hello everyone: > > to begin with, I apologise for asking a question which is probably > obvious. My name is Emilio Pisanty and I and one of the two makers of my > school's website. recently we updated the database system

Re: MySQL and UPDATE query

On 11/9/02 3:01 AM, "Bruno Batarelo" <[EMAIL PROTECTED]> wrote: > Greetings > > I have problems executing very simple UPDATE query. I do not know whether it > is a bug or not, but it works in Access and also works with mySQL, but only > from access using linked tables. > Query is as followes: > >