Hi there.
I've been having this problem when retrieving rows from a table
using mysql_fetch_row(). The problem is that sometimes it returns
null when I know that there are more records available. The behaviour
is intermittent too so its really difficult to track down.
I've tried it with MySQL
Hallo Peter,
Op 30 May 05 schreef Peter aan [EMAIL PROTECTED]:
P http://dev.mysql.com/doc/mysql/en/load-data-local.html
P #
P If LOAD DATA LOCAL INFILE is disabled, either in the server or the
P client, a client that attempts to issue such a statement receives the
P following error
I'm trying to SELECT the most recent record in a table for each person
record in another table. Here's what I have so far:
SELECT
history.*,
persons.person_short_name,
persons.person_long_name
FROM
history, persons
WHERE
Hi,
mysql -S /opt/usr/mysql4/var/mysql.socket -uusr -p11
is 11 your database, i don't think so. That should dbe the password.
so, the command to connect that can be found in the doc can be :
mysql -uusr -p mysql
this will prompt you tu enter the password
Password:
here type 11
and
Hello list!
Im loading rows from a txt tab separated fields file into a MySQL table.
It mostly works, but the date format in one field is not the type that
MySQL likes. So right now Im loading it as a char field. Yes, it is ugly
and a pain to work with. I would like to some how automate it and
Hello.
Are you sure that mysqld uses /etc/mysql/my.cnf? See:
http://dev.mysql.com/doc/mysql/en/option-files.html
I suggest you to use official binaries and perform installation
according to the following:
http://dev.mysql.com/doc/mysql/en/installing-binary.html
Hello.
Not enough information to make a conclusion. What version of
MySQL do you use? Usually debugging of replication problems
begins from researching of binary logs with mysqlbinlog. See:
http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html
Hello.
You should solve the issue with server crashes. I'm not familiar with JDBC,
and if changing the values of parameters with SET statement doesn't work
with JDBC, probably somebody clever on the list could help you. You may
forward your message to:
http://lists.mysql.com/java
Hello.
See:
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/resetting-permissions.html
Hi,all
I have installed a Mysql4 verion on Turbo Linux successfully
recently.But I alwaysgot the error prompt from the database when I
GROUP BY returns grouped columns and aggregate functions, not rows. You
are grouping on history.person_id, so it makes no sense to select any
column that does not have a unique value for each history.person_id.
Indeed, other systems wouldn't even allow selecting non-grouped columns
Hello,
I have an InnoDB table running on MySQL 4.1.11 with multiple FK
constraints. I'm accessing it via JDBC from Java.
When an FK constraint fails with error 1216 I need to know which of the
constraints failed.
SHOW INNODB STATUS returns the following output
...
CONSTRAINT
I'm looking for a feature in mysql where it will email me if ther are
any changes in a particular database or table.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
You may debug your client. See:
http://dev.mysql.com/doc/mysql/en/debugging-client.html
Have you been at:
http://dev.mysql.com/doc/mysql/en/gone-away.html
Increase your packet size. See:
http://dev.mysql.com/doc/mysql/en/packet-too-large.html
Bradley Kite [EMAIL
Hi stephano,
Just read the last comment at this link
http://dev.mysql.com/doc/mysql/en/optimize-table.html
and you will have positive answers to your questions.
Mathias
Selon [EMAIL PROTECTED]:
Hi all,
I have an Innodb database (MySQL 4.0.21 on Linux). The db is made of 11
tables. 10 of
Thank you for all of your answers and suggestions. I feel a lot more
confident finishing my table designs
-James
At 05:23 AM 5/31/05, James M. Gonzalez wrote:
Im loading rows from a txt tab separated fields file into a MySQL table.
It mostly works, but the date format in one field is not the type that
MySQL likes. So right now Im loading it as a char field. Yes, it is ugly
and a pain to work with. I would
Hi All,
I'm trying to get data from Active Directory and storing in database. So I
have the following tables with their corresponding primary keys:
Group (GroupID)
Host (HostID)
User (UserID)
GroupMember(GroupID, MemberID)
The
I doubt you would find this feature in any database. You would have to
implement at the application code level. Basically whenever you insert
into a table have the application framework send an e-mail.
The log4j package provides this kind of functionality.
See http://logging.apache.org/
And
If the data is on a spreadsheet, then why not use excel to rewrite
the date?
For example, copy the text where the dates are,...then format the
entire column to be text and not a date (because excel stores dates
as numbers,...but displays them as dates),...then paste the dates
back into
Is this not the proper way to use a function in a select statement?
SELECT
t.field1,
t.field2,
functionPerformAdditionalQueryFromField(t.field2) AS 'customField'
FROM Table t
I'd like to perform the function on every row in the result set, and
store the returned value of that function in EACH
Hi,
A simple question. How to delete the user variables
created on the server using set @varname=expr
syntax?
thanks,
Samit
__
Discover Yahoo!
Stay in touch with email, IM, photo sharing and more. Check it out!
Are you getting a error Lost Connection to Server error? If you are
reconnect to the server every time you issue the SQL request. OR issue
the command set GLOBAL wait_timeout=28000; Then issue the select
DVP
Dathan Vance Pattishall http://www.friendster.com
-Original
If we get triggers in mysql 5, couldn't you setup something like this?
--ja
On Tue, 31 May 2005, Philip Denno wrote:
I doubt you would find this feature in any database. You would have to
implement at the application code level. Basically whenever you insert
into a table have the
I don't think there is an SMTP API built into MySQL. A trigger could
insert a record into another table and a crontab could send mails
based on the contents of this table..
On 5/31/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
If we get triggers in mysql 5, couldn't you setup something like
Jayson,
Are you working with Windows or UNIX versions of MySQL?
Mikhail Berman
-Original Message-
From: Jayson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 31, 2005 9:59 AM
To: mysql@lists.mysql.com
Subject: email notification
I'm looking for a feature in mysql where it will email me
Tried that, but to no avail. I'm running Mysql 5.0.4 and PHP 5.0.4,
and was hoping it is a bug in one of these, but I don't think so...
I can run the query as I said from the command line, but in PHP, I get
a real_connect_error, immediately after executing the query...
that is...the windows
Hi Samit,
mysql select @toto
- ;
+---+
| @toto |
+---+
| NULL |
+---+
1 row in set (0.00 sec)
mysql set @toto:=5;
Query OK, 0 rows affected (0.01 sec)
...
use @toto
...
mysql set @toto:=NULL;
Query OK, 0 rows affected (0.00 sec)
mysql select @toto;
+---+
| @toto |
Hi,
i think you must normalize your table to more than one table.
Users/Groups : N:1
Groups/Groups : N:1
Table Users :
User_id
Host
Group_id
Table Groups :
Group_id
Group_parent_id- is a another group_id
No data redondancy and robust implementation.
see for example /etc/passwd and
IF GroupID, HostID and UserID are unique between the three sets then your
GroupMember table will work although I would still be tempted to add a
MemberType in the GroupMember table.
Isn't MemberID the Foreign Key to UserID/HostID/GroupID althugh I don't know
if you can have three different
I have never got mysql to start because each time I input my password, the
window closes (I am using Windows XP). The error is something like: ERROR
2013: Lost connection to mysql server during query. How do I resolve this?
-M.B.
--
MySQL General Mailing List
For list archives:
Here's an odd question for you, how do you become a MySQL DBA?
I've got enough Solaris/Linux Experience under my belt and I was a Jr.
Oracle DBA for a year, which got me really interested in RDBMS. I try
to work with MySQL as much as possible, but I work with one of those
large telco's that does
Hi,
A new version of MySQL Community Edition 5.0.6-beta Open Source database
management system has been released. This version includes support for
Stored Procedures, Triggers, Views and many other features. It is now
available in source and binary form for a number of platforms from our
If you use MyISAM tables you could always do:
SHOW TABLE STATUS LIKE 'tablename'
Then look at the Update_time column.
If that has changed since last time then something has changed. Then
implement a php/perl/whatever script around it to email you.
Note: On my InnoDB tables this time seems to
iH Mark,
i work for a small independent telco where i have developed a number
of apps that interface with class 5 switches and other telco gear. if
you would like to email me off list i would be happy to give more
details
On May 31, 2005, at 2:50 PM, Mark Ahlstrom wrote:
Here's an odd
Hi Mark,
(B
(BThat is actually a very interesting question.
(B
(BI found the "Certification study guide" from Paul DuBois an indispensible
(Bguide.
(B
(BOther then what you would expect from a "study guide" it does actually go
(Bmuch further than just preparing you for an exam.
(B
(BYou
On Sat, 2005-05-07 at 08:18, Greg Whalin wrote:
Hi Peter,
As for reporting bugs ...
http://bugs.mysql.com/bug.php?id=7437
http://bugs.mysql.com/bug.php?id=10437
We have found Opteron w/ Mysql to be an extremely buggy platform,
especially under linux 2.6, but granted, we are running
I've added a fair bit of information on the Opteron HOWTO Wiki at:
http://hashmysql.org/index.php?title=Opteron_HOWTO
for using Fedora Core 3 with X86-64.
In my performance testing, I was finding that with so much RAM, everything
was coming from RAM anyway. RAID10 seemed to be most stable, and
Hello,
I have an application that does searches against a database of homes.
A summary of initial search results is displayed by showing a few
columns of information about each home. When the user clicks on one
of the listings, it retrieves additional information (some from other
tables) and
38 matches
Mail list logo