Hi Scott,
I think you've been lucky so far...
As you're only ordering on listdate, which is the same
for both homes in your example you might definitely get different
results once you put in the limit.
A basic thing about rdb's is that you must never make assumptions
that it returns resultsets in
Hello,
Each time we run long queries (over around 5 seconds) the mySQL server
fails and restarts (you can see it in the error log that starts with
Database page corruption on disk or a fail.. and then there is a
dump...) and the query return with Lost connection to MySQL server
during
Mark Ahlstrom wrote:
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
Hello everybody.
I use mysql 4.0.24 as found in debian gnu/linux sarge.
$ mysql -u root
[...]
mysql use mydb
[...]
Database changed
mysql select * from SAMPLES S1 where exists (select * from SAMPLES S2 where
S1.ID = S2.ID);
ERROR 1064: You have an error in your SQL syntax. Check the manual
Dear ladies and gentlemen,
Upscene Productions is happy to announce a new version of
the database developer tool:
Advanced Data Generator (version 1.5.0)
A fast test-data generator tool that comes with a library
of real-life data, can generate data to your database,
SQL script or CSV files, many
On 31/05/2005, Lucio Crusca wrote:
I use mysql 4.0.24 as found in debian gnu/linux sarge.
mysql select * from SAMPLES S1 where exists (select * from SAMPLES
S2 where S1.ID = S2.ID);
ERROR 1064: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server
In article [EMAIL PROTECTED],
Scott Gifford [EMAIL PROTECTED] writes:
The problem we're seeing is that when additional tables are pulled in
for the detailed view, the order is different from the summary view,
so the wrong homes are displayed. Here's a simplified example. A
summary query
hi
as per the online manual, i have configured mysql and able to run the server as
mysqld_safe. but if i want to run mysqld_multi with the following configuration
it doesnt work... the config file is like
[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin =
Hi,
Is it possible to update all my encoded data with another password?
Thanks for your advice
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I recently upgraded from 4.0 to 4.1 because of the multilingual support.
But importing the DB dump into the new 4.1 version all foreign characters
(french, spanish, portoguese) have been replaced by ? character...
I've been trying to understand the new collation feature but i seems quite
hi,
your config supports european charcters :
mysql select * from tst;
+--+---+
| a| txt |
+--+---+
|1 | Ceci est un test en Français
hi...
trying to build php4 with mysql4.1-12, for use in apache2. i have the
following ./compile that works for php5. however, when i try to use it for
php4, i get a msg, stating that it can't find the MySQL Headers...
can anybody provide any pointers as far as what the Headers are for mysql,
and
hi,
have you installed php4-mysql ?
look at http://www.coagul.org/article.php3?id_article=169 for example.
Mathias
Selon bruce [EMAIL PROTECTED]:
hi...
trying to build php4 with mysql4.1-12, for use in apache2. i have the
following ./compile that works for php5. however, when i try to use
Hi,
Can you send some more output from the MySQL error log (normally located
at /var/lib/mysq/[hostname].err) . Have you tried myisamchk to check the
tables that are giving the errors? Also you might want to take a look at
http://dev.mysql.com/doc/mysql/en/gone-away.html
On Wednesday 01 June
Salut,
je vois que tu es français, j'aimerai bien continuer en français mais il vaut
mieux en anglais si jamais il y avait quelqu'un avec le même problème ;-)
So what I'm trying to achieve is to have UTF-8 databases in order to support
multilingual content.
But first I have to understand how
Hi,
Here is the table in question.
drop table `portfolio1`;
CREATE TABLE `portfolio1` (
`ccode` varchar(99) default NULL,
`symbol` varchar(99) default NULL,
`transaction_date` date default NULL,
`rate` decimal(11,2) default NULL,
`quantity` int(11) default NULL,
`transaction` enum('buy','sell')
i mean :
if you launch :
into into table (toto) values ('Ceci est un test en Français');
then :
select toto from table;
can you read it correctly ? And if the same row is imported, is there any
difference ?
A bientôt
Mathias
Selon [EMAIL PROTECTED] [EMAIL PROTECTED]:
Salut,
je vois que tu
Hey list,
I need a query that checks if a certain table column has type auto-increment
If not set it to auto increment, else do nothing.
Let's say I have the table objects (object_id, object_name) in which
object_id is the primary field.
Now check to see if object_id is auto_increment
ALL,
Can someone help out with this error:
DBD::Oracle::st execute failed: ORA-03106: fatal two-task communication
protocol error (DBD ERROR: error possibly near * indicator at char 23 in
'select table_name from *all_tables') [for Statement select table_name
from all_tables] at
Hi,
I downloaded and tried to install from the sources.
./configure, make seem ok, however the make install exit very quickly with
an error code 127 (perror gives record-file is crashed, no idea of what
that means!).
My old 5.0.4 istall is working fine, so I don't think the system is in
Hi,
I'll try even if this is not a neither oracle nor perl-dbd list.
1. verify that NLS_LANG is correct in your client env (and all the other ORA
vars)
2. verify the query is simply quoted ( needs \_ for _)
3. Put all oracle variables in BEGIN {ORACLe_HOME=}; in the perl script
4. verify that
Voilà,
Everything works fine: insert, select and importing. I have always the same
text:
'Ceci est un test en Français'
So what could be the problem ? and how to recover foreign characters ?
Thanks
Roberto Jobet
i mean :
if you launch :
into into table (toto) values ('Ceci est un test
Scott Klarenbach [EMAIL PROTECTED] wrote on 05/27/2005 06:57:19
PM:
-- How is 'xFxIxExLxDx1x' easier to search than 'FIELD1'?
It's not easier. It is; however, accurate for the purpose at hand.
FIELD1 isn't completely inclusive...it would miss FIELD-1...
-- However, It seems to me that
I think I have found the solution for my problem. I made the following
changes:
- I added a new field RecordID in GroupMemberInfo to make the records
unique
- Instead of MemberID and GroupID, I'm now using MemberName and GroupName.
I made this change since in Active Directory every name is
Is it possible to update all my encoded data with another password?
Yes. Example for the encoded/decode functions:
UPDATE table
SET pass_colum = encode(decode(pass_column, old_password), new_password);
--
mack /
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
We have the following problem.
Cluster means table 'TABLENAME' is full
We have 11076890 rows in this table.
Where is the limit defined ?
Disk are Not full. RAM not full too.
Table engine is NDBCLUSTER.
Can anybody help ?
---
Powered by: T-Systems Multimedia Solutions
Hi!
I've need to find the largest blobs in a table but I seem not to be able
to figure out what it is. Could anyone please help me with this?
Regards
Roland
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Wrong forum for MySQL but you're getting the error because unless you created a
view/table for all_tables then it doesn't exist. I suspect you're trying to
use the view USER_TABLES or DBA_TABLES (if you have the GRANT to view that
DBA view.
[EMAIL PROTECTED] wrote:
ALL,
Can someone help
You can use joins instead of subqueries if you cannot upgrade to 4.1.x of
mysql.
Actually in my opinion joins are more efficient than subqueries. Subqueries
(more often than not) tend to become bottlenecks in the long run..
http://dev.mysql.com has a some reference material about converting
Reinhart Viane wrote:
Hey list,
I need a query that checks if a certain table column has type auto-increment
If not set it to auto increment, else do nothing.
Let's say I have the table objects (object_id, object_name) in which
object_id is the primary field.
Now check to see if object_id is
Great!! Thx
I looked into the manual and the refer to the create syntax concerning
auto_increment.
The one thing I did not get was the fact I have to 'recreate' the column
definition and can not just add something to it.
It works great now!
The for the effort of replying :)
Greetings,
Reinhart
Frank Schröder [EMAIL PROTECTED] wrote on 05/31/2005 03:18:11 AM:
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
Salut,
i don't see what doesn't work ! Where characters are replaced by ?, since you
say that insert,select and import work fine ? is it in the export ?
see http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html for migration.
Mathias
Selon [EMAIL PROTECTED] [EMAIL PROTECTED]:
Voilà,
look at automatic character set conversion
http://dev.mysql.com/doc/mysql/en/charset-collation-charset.html
mathias
Selon [EMAIL PROTECTED]:
Salut,
i don't see what doesn't work ! Where characters are replaced by ?, since you
say that insert,select and import work fine ? is it in the export
On Tue, 31 May 2005 18:01:48 -0500
Matt Wagner [EMAIL PROTECTED] wrote:
snip
This is the third published Beta release in the 5.0 series. All
attention will now be focused on fixing bugs and stabilizing 5.0 for
later production release.
Just curious - was there a 5.0.5-beta release? The last
On Wed, 1 Jun 2005 10:40:10 -0500
Josh Trutwin [EMAIL PROTECTED] wrote:
On Tue, 31 May 2005 18:01:48 -0500
Matt Wagner [EMAIL PROTECTED] wrote:
snip
This is the third published Beta release in the 5.0 series. All
attention will now be focused on fixing bugs and stabilizing 5.0
for
Well I sent this message to both the mysql mailing list and this perl
list, because I am using perl to accomplish this, and mysql to talk to.
But anyway, thank you very much your number 3 EXACTLY fixed my issues, so
the person with the right answer contacted me.
Again, thank you very much for
On Wednesday 01 June 2005 10:40 am, Josh Trutwin wrote:
Just curious - was there a 5.0.5-beta release? The last beta I had
was 5.0.4 unless I missed a release announcement...
You need to read that email.. it says it was never released.
Jeff
pgpk9pJzWINTK.pgp
Description: PGP signature
I have two tables, cutting out the extra stuff they boil down to:
users:
userID int,
username varchar(11),
realname varchar(40)
logins:
ID int,
lastLogin timestamp
So, what I am doing is:
select user.id, username, realname, lastLogin
from users left join logins on users.id = logins.id
[EMAIL PROTECTED] wrote on 06/01/2005 11:49:35 AM:
I have two tables, cutting out the extra stuff they boil down to:
users:
userID int,
username varchar(11),
realname varchar(40)
logins:
ID int,
lastLogin timestamp
So, what I am doing is:
select user.id, username, realname,
Hello all,
My question is if unix Epoch time started on January 1st 1970 ,and mysql uses
the same implementation of time , what is the logic mysql developers have
used to offset it by 30 odd years that is the max date for mysql is 2068 and
not 2038 18th January, i work in a Financial services
Hi,
try this :
mysql select * from users;
++--+-+
| userID | username | realname|
++--+-+
| 1 | toto1| toto1 toto1 |
| 2 | toto2| toto2 toto2 |
| 3 | toto3| toto3 toto3 |
| 4 | toto4| toto4 toto4 |
Digvijoy Chatterjee [EMAIL PROTECTED] wrote on 01/06/2005
17:13:25:
Hello all,
My question is if unix Epoch time started on January 1st 1970 ,and
mysql uses
the same implementation of time , what is the logic mysql developers
have
used to offset it by 30 odd years that is the max date
Hi!
InnoDB is the MySQL table type that supports foreign key constraints,
transactions, two-phase commit in XA, row-level locking, non-locking
consistent read (MVCC), all four SQL-1992 isolation levels of transactions,
multiple tablespaces, asynchronous unbuffered disk I/O on Windows, and a
Thanks.
On 6/1/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott Klarenbach [EMAIL PROTECTED] wrote on 05/27/2005 06:57:19
PM:
-- How is 'xFxIxExLxDx1x' easier to search than 'FIELD1'?
It's not easier. It is; however, accurate for the purpose at hand.
FIELD1 isn't
[EMAIL PROTECTED] wrote:
Frank Schröder [EMAIL PROTECTED] wrote on 05/31/2005 03:18:11 AM:
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
I'd love to get some feedback here:
MySQL currently falls down by not providing a solution to transparent
MySQL load
balancing. There are some hardware solutions but these are expensive and
difficult to configure. Also none of them provide any information
about the
current state of your
Frank Schröder wrote:
The thing that's really a headscratcher for me is why its possible for
me to set a name for a constraint if it isn't displayed in an error and
I can't get to it. It's useless.
Same as setting a name for an index -- it allows you to alter or delete it
later.
--
Keith
Kevin Burton [EMAIL PROTECTED] wrote on 06/01/2005 02:31:54 PM:
I'd love to get some feedback here:
MySQL currently falls down by not providing a solution to transparent
MySQL load
balancing. There are some hardware solutions but these are expensive
and
difficult to configure. Also
[EMAIL PROTECTED] wrote:
Wouldn't it make better sense to build on the NDB protocol and keep
the native messaging infrastructure than it would be to build a
similar wrapper from scratch? I mean to use the NDB communications on
top of regular MySQL
Biting off an NDB migration would be a
You guys have been so helpful with this, I'm hoping that I can ask for
one more favor...
The reason I needed the greatest(max()) functionality, was to run the
following query...I can make it work from the command line, but
everytime I run it from PHP, the MySQL service shuts down, and needs
to be
We have a client-side load balancer, as well as a central load balancer
for mySQL traffic. I've done many different models at a variety of
companies, all which still use the solutions. Building on top of the NDB
protocol would take a very long time to produce-a HA solution native to
mySQL, when
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kevin Burton wrote:
[EMAIL PROTECTED] wrote:
Wouldn't it make better sense to build on the NDB protocol and keep
the native messaging infrastructure than it would be to build a
similar wrapper from scratch? I mean to use the NDB communications
I'm having a brain freeze and can't seem to figure out why I can't insert a
constant into a table using a column list.
Here is a simple query that inserts blanks instead of the constant.
insert into tmp (cust_id, custname) select cust_id, 'bob smith' from cust table
It inserts the cust_id but
At 04:58 PM 6/1/2005, you wrote:
I'm having a brain freeze and can't seem to figure out why I can't insert
a constant into a table using a column list.
Here is a simple query that inserts blanks instead of the constant.
insert into tmp (cust_id, custname) select cust_id, 'bob smith' from cust
Greetings,
I took a dump of (pretty chunk) database, the output is close to 45G. I
am trying to reload this dump file onto a development server but it's
taking long time to load the database. Is their a faster way to load the
data in? I am using plain and simple mysql dump.sql syntax on
--with-mysql is supposed to be the directory in which configure can find
the mysql header (.h) files and the mysql library (mysql.so) underneath
that directory.
/usr/bin/mysql_config is a program -- a binary if you will
It's incredibly unlikely that your MySQL header files and the mysql.so
I took a dump of (pretty chunk) database, the output is close to 45G.
I
am trying to reload this dump file onto a development server but it's
taking long time to load the database. Is their a faster way to load
the
data in? I am using plain and simple mysql dump.sql syntax on a
Is there a way to tell NOW() in mysql to be based on a time in the future?
Bascially, I am in PST, and they are in EST, I have a ton of reports that
show the time and date, and they want them in EST time, not the time the
server is in.
it is trivial to modify the display output of the time, but
Dear Gleb:
The problem has occured again, and I grab some output.
This box run mysql 4.1.11 on FreeBSD 5.4 AMD64, with 8GB RAM
In this case,
The original query is INSERT INTO LOW_PRIORTY INTO `statistics`.`search`
(`userid`, `id`, `func`) VALUES('lty0105', '8', 2)
The strange query is 'INSERT
60 matches
Mail list logo