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 me
to
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] wrote:
On 3/24/03 7:41 AM, Shawn P. Garbett
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
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
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 to
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
] wrote:
At 13:40 -0800 1/30/03, 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 FULLTEXT indices for each of these columns?
The latter
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
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
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 mechanism in
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,
. 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 1/28/03 8:26 AM, Christopher Lyon [EMAIL PROTECTED] wrote:
I am trying to do an sql query and am trying
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
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 suggestions
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 compile
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
conversion. I
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
conversion. I
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 parts of
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 the
, 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 PROTECTED]]
Sent: Thursday, January 02, 2003 10:45 AM
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 enter.
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 pages of
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
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';
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 me
Why
-- 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 post anything to the newsgroup because
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, please check:
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
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
was one
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
.
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 DECIMAL.
Best/h
You are certainly correct, I tried all kinds of expressions and datatypes
and couldn't
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
Why am i getting
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
mysql
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.
HTH,
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
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...
You join
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:
Field0 Integer
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 days and seems like
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 regardless of
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 like to create
I try to access thesearchable documentation with user comments:
http://www.mysql.com/doc/en/index.html
And get:
Forbidden
You don't have permission to access /doc/en/index.html on this server.
Apache/1.3.26 Server at
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_name
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 fields in
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 tell me
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 server
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 computer you
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:
UPDATE
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 (on
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 any
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 improve
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 general
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 general
52 matches
Mail list logo