- Original Message -
From: kalin mintchev [EMAIL PROTECTED]
To: Adam [EMAIL PROTECTED]
Cc: MySQL General [EMAIL PROTECTED]
Sent: Sunday, November 14, 2004 11:33 PM
Subject: Re: syntax question..
Kalin,
Kalin thanks to all... yes, Rhino - i'm new. my first
Kalin post. the
Dear ladies and gentlemen,
Upscene Productions is happy to announce a new version of
the database developer tool:
Advanced Data Generator (version 1.2.5)
A fast test-data generator tool that comes with a library
of real-life data, presets and much more.
This new release consists of four
Hello.
The INSERT ... VALUES and INSERT ... SET forms of the statement insert rows
based on explicitly specified values. So you can't use select in the value
clause.
Instead you should use insert ... select. By the way: don't forget to
escape single quotes in text which you insert.
See:
Hello.
It looks like you don't have g++ in you path.
Check if you have installed g++, or may be you have something like g++-3.xx
and there are no symlink to g++.
You may specify your compiler by CXX environment variable( for more details
see output of ./configure --help).
And, it's
Hello, Rafal.
At first, sorry for my query, it probably should look like this:
select convert_tz(cast(from_unixtime(( cast(t as binary) div 1000)) as
datetime),'+00:00','-07:00') from tvar;
Because you use milliseconds, not seconds.
(cast(s2u.value))
Second... I think
Hello.
Looks like it returns as much as:
select count(distinct id) from sale where user_id=1;
I've found it in comments at:
http://dev.mysql.com/doc/mysql/en/Counting_rows.html
Jerry Swanson [EMAIL PROTECTED] wrote:
This is my query
select id, status from sale where user_id =
Hi,
I get this:
You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near
'(cast(from_unixtime(cast(s2u.value as binary) div 1000 ) as dat
I think, the problem is here:
select
s2u.value as binary
from
users u,
MySQL 4.0.14
Need help please with the folowing:
On starting mysqld-nt using
mysqld-nt --console
we the get the follwing output
041115 10:31:59 InnoDB: Database was not shut down
normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB:
Hi Rafal,
binary is a reserved word, you need to quote it with back-ticks ` if
you want to use it:
SELECT s2u.valus as `binary`
FROM ...
/Johan
Rafal Kedziorski wrote:
Hi,
I get this:
You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the
hi,
At 18:50 12.11.2004, Gleb Paharenko wrote:
Hello, Rafal.
At first, sorry for my query, it probably should look like this:
select convert_tz(cast(from_unixtime(( cast(t as binary) div 1000)) as
datetime),'+00:00','-07:00') from tvar;
I have to user / instead of div, which maker problems. thx.
Hi all
we are having a strange problem at the web site I work for (it's an Italian
registar).
Sometimes (that means: every 15/20 days) our db (MySQL) just hangs with a Too many
connections error. The strange thing is that the DB server is stuck untill we restart it
(actually, we always had to
I want to set some variables once and for all. How should i do it ?
I need following vars to be set :
character_set_client=latin2
character_set_connection=latin2
character_set_database=latin2
character_set_results=latin2
character_set_server=latin2
character_set_system=latin2
I think you need to do something like this:
select t1.data
from table1 t1 inner join table2 t2 on t1.zip = t2.zip
where t2.chain like '%carmike%';
i tried this one... it seams to work. i'll read a bit more about joins ..
thank you... appreciate it...
You're welcome!
Rhino
--
Hello.
What version of MySQL do you use? If it's older than 4.0.2, then
use set-variable = var_name=value.
See:
http://dev.mysql.com/doc/mysql/en/Option_files.html
Hariett Jones [EMAIL PROTECTED] wrote:
I want to set some variables once and for all. How should i do it ?
I need
Hello, Silvio.
I guess you are using MySQL as shipped in Fedora distibution. See:
http://dev.mysql.com/doc/mysql/en/Linux.html
You may find that sometimes with non-official binaries happens little problems.
So my advice for you in this situtation - upgrade to the latest release and use
Hello.
I didn't found any bug in bug database, which was similar to your's.
Also I haven't ever heard about that thing: count of open files exceeded
OS limit in Windows. So for the beginning take a look at:
http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html
And, if it won't
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 14, 2004 11:30 AM
To: [EMAIL PROTECTED]
Subject: Conditonal where
?php
$sql .= SELECT PostStart, JobTitle, Industry,
LocationState, VendorID FROM VendorJobs;
if ($s_Ind){
$sql
I know that having a fulltext index on a table slows inserts and updates
down (or I think I do...might have miss read something)
I have a large table that uses fulltext which I plan to update nearly
90% of the rows (400,00+) and add new ones.
It currently takes around 35 minutes to remove the
Using the request :
SELECT DISTINCT journal
FROM reference
WHERE TYPE = 'article' AND etat = 'published' AND journal = 'Physical Review
Letters'
I get two type of answers
One with 'Physical Review Letters'
(WHERE `journal` = 'Physical Review Letters' )
the other with 'Physical Review
--- Adams, Pat 006
[EMAIL PROTECTED] wrote:
You could add a where condition that's always true
to the main part of
the SQL statement so that you can just tack on more
clauses
conditionally.
$sql .= SELECT PostStart, JobTitle, Industry,
LocationState, VendorID
. FROM VendorJobs
when I go to both 2.10 Upgrading MySQL
(http://dev.mysql.com/doc/mysql/en/Upgrade.html) and 2.10.2 Upgrading
from Version 4.0 to 4.1
(http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html) it does
not tell me how to upgrade it only tells me about important changes
and recomendation. I am
Best Regards,
Boyd E. Hemphill
MySQL Certified Professional
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O: (512) 248-2278
M: (713) 252-4688
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 14, 2004 11:32 AM
To: Boyd E. Hemphill
Cc: [EMAIL
Hello,
First, I tried searching the mysql list archives, but the archive search
function on mysql.com does not seem to be working.
Second, I'm using the PHP fsockopen() function on port 3306 to test if a
database is up and responsive. If the socket opens, I'm assuming the database
is up, and
Hi,
I am using the Create table select * into ... query to create a table
using two exsisting tables
But the table is created with only 1000 rows, which should not be the
case.Is there a config setting which defaults the rowcount to 1000?
I am using the MySQL control center.
thanks,
r
--
Stuart Felenstein wrote:
--- Adams, Pat 006
[EMAIL PROTECTED] wrote:
You could add a where condition that's always true
to the main part of
the SQL statement so that you can just tack on more
clauses
conditionally.
$sql .= SELECT PostStart, JobTitle, Industry,
LocationState, VendorID
.
Could it be that you have put your variables into the wrong section of
your configuration file? I haven't been able to look it up to verify my
information but I thought the section that starts with [mysql] contained
settings for the command line client while the section that starts with
Do you mean this page http://dev.mysql.com/doc/mysql/en/Option_files.html?
Michael
[EMAIL PROTECTED] wrote:
Could it be that you have put your variables into the wrong section of
your configuration file? I haven't been able to look it up to verify my
information but I thought the section that
Hi!
On Nov 15, John Smith wrote:
I know that having a fulltext index on a table slows inserts and updates
down (or I think I do...might have miss read something)
I have a large table that uses fulltext which I plan to update nearly
90% of the rows (400,00+) and add new ones.
It currently
rahul pathak wrote:
Hi,
I am using the Create table select * into ... query to create a
table using two exsisting tables
Do you mean CREATE TABLE ... SELECT... or INSERT INTO table SELECT ...?
But the table is created with only 1000 rows, which should not be the
case.Is there a config setting
Hello,
I am running mysql version 4.1.7 on SuSE professional 9.1.
I have a MyISAM table which I use for syslog messages. This table gets
about 40-70 inserts a second with peaks of over 400 inserts a second. I am
using INSERT DELAYED for all inserts, and only one thread of my application
has
How do I avoid insert locks?
We updated from mysql 4.0.18 to 4.1.7
now all my inserts lock tables, I had 500 asp timeouts within 30 minutes
after installing 4.1.7
I also had over 400 connections to the database, as all the threads were
locked waiting, asp timeout is set to 30 seconds, the
I am missing my *-relay-bin file on my slave so I got an error on my
show slave status; . The slave is stopped, now I want to resync but
whenever I do a change master_log_pos and master_log_file it outputs a
ERROR 1105 (HY000): Failed purging old relay logs: Failed during log reset
what should I
Does 4.1.8 address any of the issues I am reading about in 4.1.7? Are all
of these issues valid or are you finding that its Lazy coding?
Thanks
Donny Lairson
President
http://www.gunmuse.com
469 228 2183
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
It doesn't get any simpler than this. :)
The Select statement takes way too long to complete.
select rcd_id, company_name from company where company_name like fra%
12357 rows fetched (86.08 seconds)
However if it returns just the column value from the index, it is quite fast:
select company_name
At 02:12 PM 11/15/2004, you wrote:
How do I avoid insert locks?
We updated from mysql 4.0.18 to 4.1.7
now all my inserts lock tables, I had 500 asp timeouts within 30 minutes
after installing 4.1.7
I also had over 400 connections to the database, as all the threads were
locked waiting, asp
I think a lot of it has to do with the fact that 4.1 is now production and a
lot more people are now using it then before. So you are bound to have new
bugs crop up, or in some cases people think they are bugs and they just
haven't read the manual. You can see what's already been fixed for 4.1.8
I think I found the problem
all our input files are prepped in a separate table
then insert delayed select * from temptable into production
4.0.18-19 removed this!
I dont know why they would allow insert delayed values, or load data
infile concurrent
but not on a select into table!?
Sucks,
Howdy all,
We have a set of tables in a database that maintain
session information of users of a website. Each user's
session is identified by a GUID that we generate when
they login. As the users perform various operations
records are inserted/updated/deleted from these
session tables. Some of
Hello all,
I'm having a very peculiar and nerve racking experience with MySQL 4.1.7
running on Fedora Core 2.
On the master the query executes just fine, however on the slave I get:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='' on query.
The reality we have to live in is that decisions about software for
large projects are made several years prior to turning the system on
line, so inevitably many guesses have to be made based on what is known
today. Although (obviously) no one knows how the database world will
look like in
In the last episode (Nov 15), matt_lists said:
I think I found the problem all our input files are prepped in a
separate table then insert delayed select * from temptable into
production
4.0.18-19 removed this!
I dont know why they would allow insert delayed values, or load data
infile
Michael,
Normally I would let a fellow domain registrar fend for themselves, but I'm
feeling nice today. :)
Do a show create table contacts and see what the charset is set too.
I bet the character set on the slave is different. Are you running this
from the command line?
Or are you
On Monday 15 November 2004 11:30 am, [EMAIL PROTECTED] wrote:
I am running mysql version 4.1.7 on SuSE professional 9.1.
I run 4.0.22
I have a MyISAM table which I use for syslog messages. This table gets
about 40-70 inserts a second with peaks of over 400 inserts a second. I am
using
Mos,
Personally, I never use like for anything. I would add a fulltext index
myself and call it a day. But that's me.
Donny
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Monday, November 15, 2004 2:40 PM
To: [EMAIL PROTECTED]
Subject: Poor Select speed on simple 1
G'Day All,
Can anyone recommend an application that will read/probe a MySQL
database on a Linux server and generate a graphical output of
thedatabase/table structure? FlowChart type?
Thanks
On Monday 15 November 2004 03:25 pm, Jeff Smelser wrote:
insert delayed is a myth.. Least in the 4.1 version. 4.1.18 it was taken
out.
Course thats 4.0.18.
pgpBoy3BGuPlh.pgp
Description: PGP signature
Hi ,
I need to do the following:
Given a certain variable for example @var I want to include the
contents of that variable as part of the name of a result column.
I'll try to explain myself a bit more with this example
Set @var = 'October_' ;
Select
Tot as
Donny,
I certainly appreciate your help.
"show create table contacts" shows the same output on both the master
and the slave ('latin1').
This is being run by the slave's SQL thread, and the Error is shown in
the "Last error" line of
"show slave status" and the error log.
Thanks again,
At 03:32 PM 11/15/2004, Donny Simonton wrote:
Mos,
Personally, I never use like for anything. I would add a fulltext index
myself and call it a day. But that's me.
Donny
Donny,
Unfortunately I can't. The query must return all rows that *start*
with a certain phrase. It's similar to
You could always add an index on company_name + rcd_id. That technically
shouldn't help, but I've seen crazier things before.
Donny
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Monday, November 15, 2004 4:23 PM
To: [EMAIL PROTECTED]
Subject: RE: Poor Select speed on
Got me stumped on this one, I've been using 4.1 for over a year now and I
haven't run into this problem except somebody was using phpmyadmin or
something. Maybe somebody else can help with this one, sorry.
Donny
_
From: Michael Grubb [mailto:[EMAIL PROTECTED]
Sent: Monday,
I've been googling for 1/2 hr w/o any answers. sorry if I've missed the
obvious.
Problem. Fresh install of mysql 4.7.1, AS perl 5.8
DBI and DBD-Mysql via ppm.
Client does not support authnticaiton protocol
DBI connect('cjuhsdinfo','{username}',...) failed: Client does not support
authentication
Is this accurate? My understanding from the changelog in 4.0.18 was
that DELAYED is only ignored when using:
INSERT DELAYED ... SELECT ...
But not otherwise. So unless he's doing that, that portion shouldn't
be an issue. If you have alternative information, please let me know.
Thanks!
On
William R. Mussatto wrote:
I've been googling for 1/2 hr w/o any answers. sorry if I've missed the
obvious.
Problem. Fresh install of mysql 4.7.1, AS perl 5.8
DBI and DBD-Mysql via ppm.
Client does not support authnticaiton protocol
What version of MySQL were you using previously? If it was
I see the expected behavior from INSERT DELAYED, the server returns right
away and a new delayed thread gets created. I have noticed that my
application's internal queue flushes significantly faster with INSERT
DELAYED than it did with just INSERT, as expected.
Andrew
I've installed ver 4.1.7 on a brand new Fedora Core 3 server but cannot
connect remotely from a Mac OSX machine running Navicat or a Win XP machine
running MySQL Admin. I can ping the machine with no problem and have opened
the firewall for the 3306 port.
The error I receive is:
Could not
Keith Ivey said:
William R. Mussatto wrote:
I've been googling for 1/2 hr w/o any answers. sorry if I've missed
the obvious.
Problem. Fresh install of mysql 4.7.1, AS perl 5.8
DBI and DBD-Mysql via ppm.
Client does not support authnticaiton protocol
What version of MySQL were you using
Quoting Kevin Barry [EMAIL PROTECTED]:
I've installed ver 4.1.7 on a brand new Fedora Core 3 server but cannot
connect remotely from a Mac OSX machine running Navicat or a Win XP machine
running MySQL Admin. I can ping the machine with no problem and have opened
the firewall for the 3306
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
Keith Ivey said:
William R. Mussatto wrote:
I've been googling for 1/2 hr w/o any answers. sorry if I've missed
the obvious.
Problem. Fresh install of mysql 4.7.1, AS perl 5.8
DBI and DBD-Mysql via ppm.
Client does not
Mark Matthews said:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
Keith Ivey said:
William R. Mussatto wrote:
I've been googling for 1/2 hr w/o any answers. sorry if I've missed
the obvious.
Problem. Fresh install of mysql 4.7.1, AS perl 5.8
DBI and DBD-Mysql
Kevin,
Could be a few things causing problems. Lets look at the most obvious.
First, make sure you can login locally as root.
Second, MySQL authenticates based on user, password, and host. If you have a
know user with the right password coming from an unknown host MySQL will
bounce you.
Michael,
There are a bunch. I'll assume you have a Win32 client to use these tools
on. Take a look at:
- Erwin (http://www3.ca.com/Solutions/Product.asp?ID=260)
- MicroLap Database Designer (http://www.microolap.com/dba/mysql/designer/)
- ER/Studio
Adam,
Thanks much. Best wishes. Cheers.
-Original Message-
From: Adam [mailto:[EMAIL PROTECTED]
Sent: Monday, November 15, 2004 8:47 PM
To: Ferguson, Michael; MySQL General
Subject: Re: Database/Table Structure
Michael,
There are a bunch. I'll assume you have a Win32 client to use
Hi, I am using MySQL 4.1.1 and all databases, columns are set to UTF-8 encoding
I have try both MySQL cc and Query browser and try to enter some
Chinese character, but when I print out the HEX value of the
character. It isn't in Unicode that I expected, but i can't see those
Chinese character
Description:
A UNION B reports the A results faithfully, but 0s and NULLs
in B's results aren't making it to the result set intact.
How-To-Repeat:
SELECT 1 AS a, NULL AS b
UNION
SELECT NULL AS a, 1 AS b;
+---+--+
| a | b|
+---+--+
| 1 | NULL |
Have you tried my MySQL C API Site ?
I have posted some C API examples here.
http://www.geocities.com/jahan.geo
Aftab Jahan Subear
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
North Jatrabari
Dhaka 1204
Bangladesh
http://www.DhakaStockExchangeGame.com
Tel: +880-2-7519050
/*
Get customized
At 13:10 +0900 11/16/04, Eric Prud'hommeaux wrote:
Description:
A UNION B reports the A results faithfully, but 0s and NULLs
in B's results aren't making it to the result set intact.
How-To-Repeat:
SELECT 1 AS a, NULL AS b
UNION
SELECT NULL AS a, 1 AS b;
Hi,
I have installed MySQL-4.0.5-0 version on my RH Linux-7.1 box. I am using the
innodb database with tables (.frm, .MYD .MYI ). My system's memory is around
3 GB ( 3798748K ). But I am facing problem of memory utilization. The top
output is as below ;
Mem: 3798748K av, 2378268K used,
Patrick Galbraith said:
William,
What was the error that you had specifically? Did you use a precompiled
version of DBD::mysql like a RPM, or did you build it yourself? I don't
know if this is a DBD version issue that you are experiencing, because
nothing was changed in authentication
I suddenly have lost the ability to connect to the MySQL server from my
remote host and can not figure out what is wrong. I have searched for
the last couple of days and cannot figure out why.
I am running MySql 5.0.0 on Linux Suse 9.1
I normally connect to MySQL from Windows XP Pro using
distribution)
This is a problem that's fixed in MySQL 4.1. (4.1.2, I believe)
I can confirm this (sorry I didn't test before submitting):
after a make install:
unagi:/usr/local/src/mysql-4.1.8-nightly-20041115$
LD_LIBRARY_PATH=/usr/local/lib/mysql /usr/local/bin/mysqld_safe
Starting mysqld daemon
71 matches
Mail list logo