Hi, Tom Cunningham wrote:
I have a funny problem: I'm getting thousands of Data Truncated
warnings when I insert a single row of data into a table, using an
INSERT...SELECT.
I bet that the columns you're joining on have different sizes.
--
Matthias Urlichs | {M:U} IT Design @ m-u-it.de
Hi Christopher
You need the FROM MembersData directly after the SELECT and before
outputting.
HTH
Steve
Christopher Chamber wrote:
I have a query:
$QRY = SELECT * FROM MembersData;
-- Executes fine, no problems.
I have another though:
$DataSet3 = SELECT * INTO OUTFILE '/www/Export/DataSet3.csv'
Hi.
Usually myisamchk doesn't have the suid bit set, and it seems to be ran as root.
See
http://dev.mysql.com/doc/mysql/en/Table_maintenance.html
Especially
http://dev.mysql.com/doc/mysql/en/myisamchk_memory.html
J S [EMAIL PROTECTED] wrote:
Hi,
I've run myisampack to compress a
Sorry I forgot to include table-defs: ..
OK, I've got it entirely reproducible now, without giving away any
sensitive data.
No, the column-lengths are the same. But doing this has shown me that
it's something to do with the partial key on the 'email' column in the
'user' table. If you remove it,
Hi mysql-community!
I have a problem with mysql 3.23.49a:
If I try to use the statement 'LOAD DATA LOCAL INFILE
'/storage/hosting/uxclients/www.xxx.ch/transfer/golfclub.csv' INTO TABLE
test'
mysql replys: 'The used command is not allowed with this MySQL version'.
Why this error-message?
Hi.
Try to upgrade to the latest release
(use official binaries from MySQL).
Kristina Clair [EMAIL PROTECTED] wrote:
Hello,
I am having a problem with a mysql (myisam) table that I've never had
before, and I'm completely stumped!
I am using mysql version 4.0.13.
myisamchk -e
Hi.
See
http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html
Martin Rytz [EMAIL PROTECTED] wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __
Hi.
Try to upgrade to the latest version
(use official binaries from MySQL).
Unreal HSHH [EMAIL PROTECTED] wrote:
Sometimes, mysql client got this error,
mysql error: Record has changed since last read in table 'table'
And I checked from mysql error log,
041023 8:28:06 Got error 123 when
Hi All,
we are using mysql and tomcat ...
when i try to access the other system's data the programs throw
javax.servlet.ServletException: Server configuration denies access to
data source exceptionwhere as when i access the databse on the
same system(ie., localhost) then it does not throw
hi,
I have some question about indexes more...
in this example we have table just like this:
table_tbl
tableid int [primary key]
tablefield1
tablefield2
...
tablefieldx
tablefieldsort1 int
tablefieldsort2 varchar(32)
there are lots of questions containing order by clause
like:
select t.*
from
Hi.
I was wondering how you can edit/change tables and data inside a table with
mysql query browser. I run mysql 5.0.0 on windows xp sp2. It says in the
help that you can edit/change tables and data inside tables if there is
enough identifiable information inside the table. What does that mean
Hi.
MySQL Query Browser is a graphical tool designed to help constructing and executing
queries.
Andy B [EMAIL PROTECTED] wrote:
Hi.
I was wondering how you can edit/change tables and data inside a table with
mysql query browser. I run mysql 5.0.0 on windows xp sp2. It says in the
Egor Egorov [EMAIL PROTECTED] wrote:
Stefan Gnann [EMAIL PROTECTED] wrote:
I have a mysql database 4.0.15 on a suse linux 9.x system running.
First, upgrade to .20 version officially built by MySQL AB (http://dev.mysql.com/).
RPM version is easy to install and run.
Oops, of
Hi.
Sounds OK, but don't forget to make a backup.
J S [EMAIL PROTECTED] wrote:
Thanks for your reply Gleb. I tried running with --safe-recover instead of
-qr but that caused some other processes running on the box to hang and
coredump so I had to kill it off.
I'll try running:
Hi,
I have two tables:
TABLE_1
===
- id
- name
TABLE_2
===
- id
- table1_id
- name
How could I make a select on table_1 that returns me only the
rows that don´t have any reference in table_2?
Any help would be appreciated.
Thank´s,
Ronan
--
MySQL General Mailing List
For list
SELECT `TABLE_1`.* FROM `TABLE_1` JOIN `TABLE_2` USING (`id`) WHERE
`TABLE_2`.`id` IS NULL
Asuming that the reference is the id field...
Regards, Jigal.
- Original Message -
From: Ronan Lucio [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 3:12 PM
Subject: Help
hi again,
I have question like that:
SELECT /*! SQL_BUFFER_RESULT */
DISTINCT branza.branzaid, branza.branzanazwa
FROM branza, klientbranza, klientwojewodztwo
WHERE
branza.branzaid = klientbranza.branzaid
AND klientbranza.klientid = klientwojewodztwo.klientid
AND wojewodztwoid =9
ORDER BY bsort
Dear MySQL Support List:
Way back in early 2003 two questions and answers appeared on
this list and bug list RE: DECIMAL precision. See both at
http://lists.mysql.com/mysql/141268 and
http://bugs.mysql.com/bug.php?id=559
1) Did anyone else notice that the 'INSERT INTO' value DID
NOT MATCH the
Yes, good keys are crucial but I try to avoid them when demonstrating temp
tables (I think it blurs the issue). All you need to do to have keys on a
temp table is to either add the KEY() definitions to your CREATE TEMPORARY
TABLE statements like this:
CREATE TEMPORARY TABLE
This is a very FAQ:
SELECT t1.*
FROM TABLE_1 t1
LEFT JOIN TABLE_2 t2
ON t1.id = t2.table1_id
WHERE t2.id is null
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Ronan Lucio [EMAIL PROTECTED] wrote on 10/27/2004 10:12:42 AM:
Hi,
I have two tables:
TABLE_1
Shawn,
Thank you very for your answer.
Actually, I thought that a main SELECT couldn´t be filtered
by the WHERE clause refered to a field in a LEFT JOIN.
Now, looking better in the JOIN documentation I see this
issue.
Thank´s,
Ronan
This is a very FAQ:
SELECT t1.*
FROM TABLE_1 t1
Lawrence K. Hixson wrote:
4) This has been fixed in MySQL server 4.1, but why wasn't
this caveat explicitly WELL DOCUMENTED in the documentation
so developers could avoid this land mine along with the
additional gotcha under Windows? Could someone please
revise the documentation to make
I really hate to do this to you but if I tried to answer your questions I
would be copying from the book anyway. There is a section in the manual
that deals specifically with query optimization. It covers index creation
and usage, when an order by will and won't use and index and a bunch of
I'm really sorry wasting your time but...
but - at first I read all materials I found [including this chapter you
suggested]
I can't correct interpret these explains I described - I've tried to change the
order in where clause, making different indexes but see no changes and no
correction
so I
Is there any plan to release a 32-bit binary 4.1.7 MySQL max for Solaris 9 and
Solaris 8? I see all the other binaries for Solaris for everything - any reason
to exclude the 32 bit?
Thx,
R
Greetings
After installing the new release of MySQL ( i.e. MySQL 4.1), I know get
the following error from phpMyAdmin when using any of the auth types:
Error
#1251 - Client does not support authentication protocol requested by
server; consider upgrading MySQL client.
I get this whether I am
1. The manual says there is and it gives an example, but I haven't been
able to get it to work and neither have other people on this list.
If you look at the planned improvements of MySQL, a few of the major
items have to do with full text searching.
On Oct 26, 2004, at 7:39 PM, Jalil Feghhi
You need to get caught up on your reading. The password hash changed as of
4.1 and this behavior is well documented. Start here:
http://dev.mysql.com/doc/mysql/en/Problems.html
and if you have more questions read this
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
What it boils down
If the query is applied to a duplicates free set of data and making nolinks
0, it does indeed deliver the expected results. Since the counters are not
reused, they can even be used textually in the HAVING clause which doesn't
add any extra columns to the final result set.
Two things through.
Just put the href into the database.
When you output it to html in PHP wrap it wth the rest.
$href=$sql-data['href'];
echo a href=\ . $href . \The Link/a\n;
leegold wrote:
I have to put html links inside varchar and text fields. They have to be
(somehow) fulltext searchable (of course a
I have mysql master and mysql slave on same machine running separately.
I have master and slave setup.
I was able to do the LOAD DATA FROM MASTER;
to get the data but the data does not replicate after that.
Looking at the info below can you tell why replication is not taking place.
Can I
Hi.
When you output field data inside html pages,
browser can interpret the tags inside fields (hackers usually use
such things).
Try to use htmlentities() and htmlspecialchars() to escape all '' and '' chars in
data.
Regards.
leegold [EMAIL PROTECTED] wrote:
I have to put html
Op woensdag 27 oktober 2004 16:52, schreef [EMAIL PROTECTED]:
I had the same problem on my Linux suse 9.1 box. I was using a mysql
client/server that came with my distro. Got the same error as you trying to
connect with phpmyadmin, while I was sure to have installed the proper client
(4.1) via
Hi.
Thank you for the message, I've sent your report
to docs team.
5) I'm sucking data from Oracle into MySQL using Perl and
would like to propose a behavior change for DECIMAL
...
7) The article
http://www.ixora.com.au/notes/number_representation.htm?number=3.14159265358987354
Hi.
See:
http://www.phpmyadmin.net/documentation/#faqmysqlversions
Regards.
Schalk Neethling [EMAIL PROTECTED] wrote:
Greetings
After installing the new release of MySQL ( i.e. MySQL 4.1), I know get
the following error from phpMyAdmin when using any of the auth types:
Anybody?
Jeff Burgoon [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Sorry, I forgot to mention I am using version 4.0.20a (no subqueries
supported)
Jeff Burgoon [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I have a simple problem and I'm just wondering the BEST
What type I should use in MySQL 3.23.58 to store large data file?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Randy Johnson [EMAIL PROTECTED] wrote:
I have mysql master and mysql slave on same machine running separately.
I have master and slave setup.
I was able to do the LOAD DATA FROM MASTER;
to get the data but the data does not replicate after that. =20
Looking at the info below can
Here is what is in the error log: looks awful How do I determine if
slave is running correctly. I though show Slave status \G did this...
041026 0:19:44 Slave I/O thread killed while reading event
041026 0:19:44 Slave I/O thread exiting, read up to log 'www-bin.001',
position 5685
[snip]
Anybody?
I have a simple problem and I'm just wondering the BEST query to
solve
it.
I want to return all the rows of a table whose foreign key value
exists
more
than once in that table. IE...
MyTable
Region(foreign key)City
EastBaltimore
Does this table say that mysql 3.23.33 and up is not compatible to replicate
to a mysql 5.0 slave?
Thanks!
Randy
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 12:21 PM
To: [EMAIL PROTECTED]
Subject: Re: Replication Issue
Randy
Here is the url sorry:
http://dev.mysql.com/doc/mysql/en/Replication_Compatibility.html
-Original Message-
From: Randy Johnson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 2:07 PM
To: [EMAIL PROTECTED]
Subject: RE: Replication Issue
Does this table say that mysql
What about
select distinct a.region, a.city
from mytable a , mytable b
where a.region=b.region and a.city b.city
Jay Blanchard wrote:
[snip]
Anybody?
I have a simple problem and I'm just wondering the BEST query to
solve
it.
I want to return all the rows of a table whose foreign key
[snip]
What about
select distinct a.region, a.city
from mytable a , mytable b
where a.region=b.region and a.city b.city
[/snip]
Crud! Standing too close to the forest and forgot about a self join...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Good one. I don't know how I missed this either!
Thanks!
gerald_clark [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
What about
select distinct a.region, a.city
from mytable a , mytable b
where a.region=b.region and a.city b.city
Jay Blanchard wrote:
[snip]
Anybody?
I
Randy Johnson wrote:
Here is the url sorry:
http://dev.mysql.com/doc/mysql/en/Replication_Compatibility.html
Does this table say that mysql 3.23.33 and up is not compatible to replicate
to a mysql 5.0 slave?
Yes
Friedhelm
--
MySQL General Mailing List
For list archives:
Sorry, I don't think I was very clear. I'm asking a more generic
question about control flow expressions. I want to run a sql statement
but only if a certain condition is met, namely if a particular record
exists in a table. I want to do it all in a single mysql statement, like
so:
If ([record
Thanks, but I tried that and it doesn't seem to work any better than an
if statement. Have you tried it? Maybe I am doing something wrong. If
you could post some working code that would be awesome.
-Original Message-
From: sol beach [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27,
Nearly all of the T-SQL style procedural statements (IF... BEGIN... END,
WHILE...WEND, cursors, etc.) are not currently available in MySQL.
Procedural scripts , like the one you propose, will be available in Stored
Procedures (new to MySQL 5.0+). I haven't tested that version yet, so I
can't
Robert,
- Original Message -
From: Bagyinszki Rbert [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, October 26, 2004 12:46 PM
Subject: deadlock caused by odbc and transaction handling
--_=_NextPart_001_01C4BB40.B000D6DB
Content-Type: text/plain;
Latest realease is 4.1.7 in 4.1.x but I am looking for 4.1.5 source
download.
Pointers will be helpful.
Thanks
Aman
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Josh,
You cannot do this in mysql, as there is no such construct.
Perhaps you've been misled by the title of section 13.2, Control Flow
Functions http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html.
Despite the name, mysql has no control flow functions. What it has are
functions
Running MySQL 4.0.12-NT on a Windows 2k Pro Server.
When I attempt to execute mysqldump.exe, I get the following error:
mysqldump: ERROR: unknown variable 'local-infile=1'
I tried using --force and it didn't help.
Showing the variables, I get local-infile to be TRUE. I looked in my.ini
and found
Thanks a ton !
Aman Raheja
Nate Blanchard wrote:
http://downloads.mysql.com/archives.php
-Original Message-
From: Aman Raheja [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 3:47 PM
To: mysql
Subject: mysql 4.1.5 source
Latest realease is 4.1.7 in 4.1.x but I am looking for
Thanks Shawn. Basically, our deployment mechanism involves applying sql
change scripts as part of the build process. I created this simple shell
script:
host=$1
user=$2
pwd=$3
mysql -u$user -p$pwd -h$host -f sinu_com _EOF_
#Put the scripts to execute here:
\. z_worklog_alter.sql
You are right about your PRIMARY KEY and UNIQUE keys being able to protect
most of your data. MySQL has an optional switch for INSERT, UPDATE, and
ALTER TABLE statements just for some of the situations you described. It's
IGNORE and I can vouch that it works well.
Have you considered doing what you want to do in Ant? I haven't done exactly
what you want to do but Ant supports properties and conditions. I could
imagine an Ant task that determines if the desired record exists, then
another task that does an insert is executed only if the record doesn't
exist.
Thanks for all of the advice everybody. I'm actually a lot more
comfortable with perl than ANT so I think I'll use that. ANT does seem
pretty cool though, I'll need to buckle down and learn it at some point.
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Wednesday,
At 15:47 -0400 10/27/04, Michael Ragsdale wrote:
Running MySQL 4.0.12-NT on a Windows 2k Pro Server.
When I attempt to execute mysqldump.exe, I get the following error:
mysqldump: ERROR: unknown variable 'local-infile=1'
I tried using --force and it didn't help.
Showing the variables, I get
Hi,
I'm trying to do the following:
SELECT
IF((ProductStatus IS NOT NULL), Available, Not Available) as ProductStatus
FROM
tb_Product
WHERE
ProductName = MyProduct;
It works fine if the ProductName MyProduct works, and returns
Available. However, if the product name doesn't work the query
At 22:58 +0200 10/27/04, Luke Venediger wrote:
Hi,
I'm trying to do the following:
SELECT
IF((ProductStatus IS NOT NULL), Available, Not Available) as
ProductStatus
FROM
tb_Product
WHERE
ProductName = MyProduct;
It works fine if the ProductName MyProduct works, and returns
Available.
One of my slaves stopped running due to a corrupted relay log. The error
file shows:
Error writing file 'dbs2.log' (errno: 28)
Error in Log_event::read_log_event(): 'read error', data_len: 160,
event_type: 2
Error reading relay log event: slave SQL thread aborted because of I/O error
Slave: Could
- Original Message -
From: Luke Venediger [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 4:58 PM
Subject: Select with an IF statements
Hi,
I'm trying to do the following:
SELECT
IF((ProductStatus IS NOT NULL), Available, Not Available) as
Hi.
Use LONGBLOB.
Jerry Swanson [EMAIL PROTECTED] wrote:
What type I should use in MySQL 3.23.58 to store large data file?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___
Hi.
See
http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html
and upgrade to the latest stable release.
Michael Ragsdale [EMAIL PROTECTED] wrote:
Running MySQL 4.0.12-NT on a Windows 2k Pro Server.
When I attempt to execute mysqldump.exe, I get the following error:
Hi.
Look at
http://downloads.mysql.com/archives.php?p=mysql-4.1v=4.1.5
Aman Raheja [EMAIL PROTECTED] wrote:
Latest realease is 4.1.7 in 4.1.x but I am looking for 4.1.5 source
download.
Pointers will be helpful.
Thanks
Aman
--
For technical support contracts, goto
Thanks Paul!
Luke Venediger.
On Wed, 27 Oct 2004 16:17:51 -0500, Paul DuBois [EMAIL PROTECTED] wrote:
At 22:58 +0200 10/27/04, Luke Venediger wrote:
Hi,
I'm trying to do the following:
SELECT
IF((ProductStatus IS NOT NULL), Available, Not Available) as
ProductStatus
FROM
Hi Rhino,
I don't think that answer solves the problem. I do use a programming
language, and doing a query like this means I can make use of the
database engine and not add overhead to my application.
Cheers,
Luke Venediger.
On Wed, 27 Oct 2004 17:26:56 -0400, Rhino [EMAIL PROTECTED] wrote:
Hi,
I have this query which used to work really fast but now it just seems to
lock up the tables. I tried running it with EXPLAIN but it just hangs at the
command prompt. I also tried adding the USE INDEX directives but still no
luck. I've run myisamchk -m on both tables involved and no errors
Hey have you checked thi
shttp://www.geocities.com/jahan.geo/mysql_c_by_example.html?
Matthew Boehm wrote:
What is the best way to access a specific field in C? Its really easy in
PHP...
PHP
---
$res = mysql_real_query($mysql,SELECT col1, col2 FROM table);
while($row = mysql_fetch_row($res))
Hello Listpeople,
I need to output headline and link information from an 'articles' table.
Each article belongs to one and only one 'section'. I will probably need a
different number of articles from each section. I'm wondering about
performance, in very general terms, of a few different
That's up to you of course. Personally, I think some things are better
handled by the database and some are better handled by the programming
language. Things like conditional logic tend to be best handled by the
programming language in my view. Your mileage may vary ;-)
After all, just because
Can I execute this query in a single JOIN statement?
select * from hist
where date_h = '20041027'
and tel not in
(select distinct tel from hist where date_h '20041027')
I know I could do it using a temporary table, but I wonder if there's a way to do it
directly.
Thanks!
Hector
--
MySQL
Like so many other people..
No one puts any collective thought into what they are doing..
Instead of moving on and trying to finish the rest yourself, you rely
on someone else to finish it for you.
-Original Message-
From: Eve Atley [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25,
Hi!
Can someone point me in the right direction?
I have this that works in v.4x:
$sql = LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE `members`
FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED BY
'' LINES TERMINATED BY '\\r\\n';
When I try it using 3.23.55 I get the
Well that wasn't a very nice thing to say.
On Mon, 2004-10-25 at 11:56, none none wrote:
Like so many other people..
No one puts any collective thought into what they are doing..
Instead of moving on and trying to finish the rest yourself, you rely
on someone else to finish it for you.
Hi Richard,
Try looking at mysqlimport instead. I'm only taking a punt that it works
with that version but the manual doesn't say anything about it being
since a certain version. It works as at 3.23.58 so hopefully it may do
for .55
Regards
David Logan
Database Administrator
HP Managed
Hi all,
I'm designing a small database, it's essentially a tree-structure. I'm
probably going to use a Modified Preorder Tree Traversal (On a side
note, how is it different than an Unmodified Preorder Tree Traversal?).
Each node will have children etc, and those will have children, etc.
But
dear All Master of Mysql,
I'm new in Mysql, and I'd just move to mysql Linux version..!and i have problem to
activate the service. I have installed Mysql linux ver. with this Command
tar-zxvf mysql-standard-4.0.21-pc-linux-i686.tar
when i try to Configure ./configure ,there is a note that i
Richard Whitney wrote:
Hi!
Can someone point me in the right direction?
I have this that works in v.4x:
$sql = LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE `members`
FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED BY
'' LINES TERMINATED BY '\\r\\n';
When I try it using
Hello,
MySQL has released 4.1.7
http://lists.mysql.com/announce/226
As you can see there have been some bugfixes in
libmysqlclient. I am using libmysql.dll provided with
4.1.1 in my app.
Do I need to upgrade it to the one provided with
4.1.7?
Regards,
Karam
81 matches
Mail list logo