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
Paul DeBois book knows the answer if you have other VARCHAR fields in the
table:
...you need to change all the columns (of type VARCHAR) at once in the same
alter table statement.The reason is that if you change a single column
at a time, MySQL notices that the table still contains
On 7/30/01 7:38 AM, Mark Lo [EMAIL PROTECTED] wrote:
Hi,
I have a problem with double quotes and single quotes in mysql command,
if I let my user
input the form data and it contains double quotes, the values cut off at
the double quote.
How to override the problem ??
Thank you
,
Kit
Original Message Follows
From: Hannes Niedner [EMAIL PROTECTED]
To: Kit Kerbel [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Parsing text file into mysql database.
Date: Sat, 28 Jul 2001 14:00:03 -0700
You need to provide some more details about your task. What
You need to provide some more details about your task. What programming
language you want to use, and probably a sample from the file that matches a
repetitive subunit within the text. This information is needed since there
is a high chance that you need to exploit regular expression matching for
When I need recreate a table structure I do it like
CREATE db_target.table_copy
SELECT * FROM db_source.table
WHERE 1=0;
The only thing that you have to do now is
DESCRIBE db_target.table_copy;
DESCRIBE db_source.table;
Since you need to manually reestablish the indices in the new table.
I want to update 160 records in a table. The field contains a variable value
and a constant prefex like
'constant: unique value for this record'
Is there such an UPDATE statement that would update this field into
'unique value for this record'
They way I would do it otherwise is using Perls
Thanks Karel,
This worked almost out of the box, just needed to find out that 'len+1' has
to be replaced with the actual number and is not automatically set (like len
= length('CONSTANT%'). But the manual also explains this very well, I just
didn't think of substring.
Hannes
On 7/3/01 9:13 AM,
Has anybody successfully compiled MySQL GUI on the Mac OS X platform (or
rather Darwin)?
Hannes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
I have seen the smart way to insert data into tables based on a select
statement posted recently on this list. Is this also possible for an update
query?
I want to do something like:
UPDATE TABLE foo
SET foo.field1 = SELECT bar.field1
FROM bar
WHERE foo.field2 = bar.field2;
Thanks in advance
Sorry, for quoting the manual but this might be just another example where
it could have the answer right away:
Hannes
http://www.mysql.com/doc/D/A/DATETIME.html
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date
@mail33
Cheers tom
-Original Message-
From: Hannes Niedner [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 5:45 PM
To: tom harrow; [EMAIL PROTECTED]
Subject: Re: DISTINCT
Hi Tom,
The solution to your problem could be simple if the redundancy is across all
fields
not work with MySql.
Is there a general understanding within the MySql community that GROUP BY
and HAVING doesn't conform to the standard ?
Regards
Thomas
-Original Message-
From: Hannes Niedner [mailto:[EMAIL PROTECTED]]
Sent: 26. juni 2001 17:42
To: [EMAIL PROTECTED]
Subject
Peter,
That comes pretty close to the distinct -thread in this mailinglist.
You might want to try:
SELECT device, count(hostname)
FROM your_table
GROUP BY device
HAVING count(hostname)1;
This would display all devices with at least 2 (or more) hostnames.
If you always have the same IP address,
Try
SELECT robotId, max(startTime) as crit
FROM RobotRun
WHERE startTime = '2001-06-26 00:00:00'
AND endTime IS NOT NULL
GROUP BY robotId
This should return the robotId and the most recent startTime labeled 'crit'
for all records specified in the where clause. And have a look in the manual
for
Could it be that you have two mysql client binaries accessing two different
config files - some remainders of a previous MySQL installation?
Hannes
On 6/26/01 9:02 AM, Peter Matulis [EMAIL PROTECTED] wrote:
Just installed 3.23.37 on Red Hat 7.0 from source. I've done this a few
times but
Hi Tom,
The solution to your problem could be simple if the redundancy is across all
fields. Then you could simply issue a
CREATE table distinct_records
SELECT distinct field_1,.field_last
FROM table_duplicate_records
WHERE 1=1;
Or
CREATE table distinct_records
SELECT
On 6/25/01 9:10 AM, anna soobrattee [EMAIL PROTECTED] wrote:
Hi All,
I've been reading up on how to do joins on the mysql site.
Is there not an inverse function for DISTINCT, so that I can pull out
duplicate data as opposed to DISTINCT data...or will I have to get this
information by
On 6/24/01 4:05 AM, Hannes Niedner [EMAIL PROTECTED] wrote:
I am having trouble with DBI. I wrote a little script that should update
fields in one table (uid_test) based on values in another table (merge). I
updates one row and then dies with:
os prompt: blah blah
1 1011877 101
I am having trouble with DBI. I wrote a little script that should update
fields in one table (uid_test) based on values in another table (merge). I
updates one row and then dies with:
os prompt: blah blah
1 1011877 101
Error during processing for table uid_test
Error 19 (fetch()
Hi!
First of all, it is unlikely that you will see some status bar as
operations in RDBMS server are quite complicated and time table can
not be predicted except in some extremely simple cases.
Regarding aborting a client, server operation will continue until OS
on which server runs
Hi Folks,
I just started a create table ... select from ...left-join query from my
laptop. It seems to take a while?
What happens if disconnect my client from the mysql daemon running on
another machine. Will the interupted mysqld-client crosstalk abrupt the
query, or will it continue to run on
On 6/11/01 11:11 PM, Jari Mäkelä [EMAIL PROTECTED] wrote:
Hi,
how a field ( names of products ) of database should be defined so that you
could not enter identical entries at the field?
Or does one need to do the validation before inserting info?
Jari Mäkelä
How about creating a
database hosting to developers
Visit http://www.freesql.org
- Original Message -
From: Hannes Niedner [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 5:48 PM
Subject: Select query
What do I do wrong? The query result is not supposed to be an empty set
What do I do wrong? The query result is not supposed to be an empty set
(please cc your response to [EMAIL PROTECTED])
mysql select sequence_id, mol_wt from sequence_protein limit 1;
+-+--+
| sequence_id | mol_wt |
+-+--+
| 100368 | 53211.62 |
On 6/7/01 4:50 PM, Eric Fitzgerald [EMAIL PROTECTED] wrote:
When comparing float values, you have to use '' around the value.
Your query should look like this:
select distinct sequence_id from sequence_protein where mol_wt = '53211.62';
Ok, I should have mentioned that I tried the quotes.
On 6/5/01 7:35 PM, sanborn [EMAIL PROTECTED] wrote:
How is MySQL used over a network? I assume there is a port involved, and
some kind of transaction server built into mysql? How do I configure, test
this? In the several documents I have read so far, I haven't found much on
the subject.
Hi everybody,
I am new to the list so if my question was answered recently I do apologize
but I could not find the answer neither in the archive or the manual.
Problem: I try to load data into a table using LOAD DATA LOCAL INFILE.
Into a table containing a TIMESTAMP(14) field. The loading
79 matches
Mail list logo