Stuart
Could this be something as simple as the fact that you have a field with a
space in its name ('Contact Email'), which is sometimes called as 'Contact
Email' and sometimes as 'Contact_Email'?
I'm not even sure if a blank space is actually allowed in field names
Cheers
Terry Riley
Hi
I'm having problems with a union and group by...
My query looks like this...
(select count(*) as numberOfC,Customer.country,Customer.creationdate
FROM Customer,VIP where Customer.id=VIP.customer and VIP.brand=2 and
Customer.creationdate '1999-31-01' group by country)
union
(select count(*)
Hi,
I'm noticing this error in various script of ours that run on the cron:
DBI connect('general:10.1.1.80:3306;mysql_connect_timeout=3','root',...)
failed: Can't connect to MySQL server on '10.1.1.80' (115) at
/usr/local/apache/cgi-bin/Shared/DBStuff.pm line 214
This happens on a number of our
I have no idea if this will actually work but I believe that if we use the
documented behavior of anonymous views to encapsulate the UNION query,
we may be able to build a single two-stage query that could resolve your
issue. Please let the list know if this works or not. I do know of another
Rather than going through a loop to convert characters, would it be
useful to you to see the string escaped as HEX values?
(http://dev.mysql.com/doc/mysql/en/Hexadecimal_values.html)
Other than that I think you would have to search using one of the string
comparison functions and escaped
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday, Aug 18, 2004, at 13:59 US/Eastern, Steve Edberg wrote:
At 08:37 AM 8/18/04, leegold wrote:
Question I have wondered about: Is it a good practice to put html in a
text field, then (eg. via php) when the marked-up text renders in a
user's
We am having constant index corruption problems since moving
from 4.0.17 to 4.1.3. All tables are InnoDB and we're using
the file-per-table setting on Solaris9.
Every couple days another few tables will show up corrupt
and queries start missing things. The database has never
gone down, there
Hi all. Just a quick question (I hope).
Im looking to buy a MySQL license and noticed
an array of different options on their website.
The MySQL Box sounds promising as all I want to do is
host some web applications locally for our internal use.
Any thoughts?
Michael Mason
Dear sirs.
I'm implementing Fulltext feature on 4.1.3-beta-standard-log, on tables
containing data in TEXT utf8 myisam.
Attached with this email a file with stop word in arabic language Plus words
in english. this file was typed in windows and saved in utf8 encoding.
My testing on the Fulltext
The MySQL GNU (GPL) license is free so long as you are not shipping MySQL
with your products.
There are 2 license options available.
http://www.mysql.com/products/licensing/
Hope that helps.
Kind Regards,
Christian Biggins
Web Developer
Web: http://www.fusiononline.com.au
Just so you know I am pretty new to all this.
I recently installed MySQL 4 on my PC. My friend gave me mysqlgui.exe to help
configure stuff. So I made several databases using it. Now I know these
databases are there, because I am running IPB on one of them, and they show up
under the data
Has the ODBC user been removed? Have you logged into mysql, mysql -uuser -p
and done show databases?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/19/04 9:44 AM
Subject: Databases not showing in cmd and mysqladmin?
Just so you know I am pretty new to all this.
all I want to do is host some web applications locally for our internal use.
Why, specificaly do you need a commerical license then?
-Daved
The information contained in this communication is confidential and
may be legally privileged. It is intended solely for the use of the
individual or
Sounds like a permissions problem. Make sure the login you are using has
the rights to see the databases in question.
(http://dev.mysql.com/doc/mysql/en/SHOW_GRANTS.html)
You may need to GRANT yourself additional privileges.
(http://dev.mysql.com/doc/mysql/en/GRANT.html)
Respecfully,
Shawn
Hi List,
Today I got a surprise when I tried to restore a dump file did yesterday. I
did not work. I don't know if because is too big, I don't think so (just
3 lines). However, when I remove one table AuditTrail that tracks
changes in the database, it worked.
I am using MySQL 4.0.18-standard
Are you getting any error messages?
-Original Message-
From: Andre Mato
To: [EMAIL PROTECTED]
Sent: 8/19/04 9:59 AM
Subject: Restoring dump file problem
Hi List,
Today I got a surprise when I tried to restore a dump file did
yesterday. I
did not work. I don't know if because is too big,
Hello Community,
I still needs help.
My problem system is a mysql server with two databases intern und extern.
I have two other different servers which are data collectors we say server1
and server2. They load their data to the mysqlserver hourly.
Server1 writes in intern and server2 writes in
Andre:
If you are using enforcing FK constraints it may be that the tables are in
the wrong order.
Try inserting the line
SET foreign_key_checks = 0;
at the front of the file and
SET foreign_key_checks = 1;
at the end, then try again.
Hope this helps.
Best Regards,
Boyd E.
Because he's a good sport and really wants to support the MySQL
development effort?
Either that or he hadn't heard of the GPL'd option, but I prefer to
believe the former. :-)
Cheers,
--V
Daved Daly wrote:
all I want to do is host some web applications locally for our internal use.
Why,
Hey Folks,
I have a query where it pulls random data and display's it.
SELECT route_photo, route, route_count, area FROM routes WHERE
ORDER BY RAND() LIMIT 1
The query works fine, however, the route_photo field is partially
populated. This results in just a route name appearing but no
Greetings,
I am stumped. I have a very busy MySQL db that we've run for
about 3 years with no problems. A couple of months ago we upgraded
the system to RH-3AS with RedHat's distro mysql-server 3.23.58-1.9.
Recently I've started getting zombie processes ([mysql defunct]).
I've checked/tested
hi,
a boolean mode full text search doesn't sort automaticly as stated in
the docs, but it also isn't possible to select the match value (the
score) any more. (is is always 1)
consider this query;
SELECT id, titel, MATCH (titel) AGAINST ('mozart') AS score FROM
cmp_composities WHERE MATCH
I think oracle parallel query is calling me
110,832,565 stat records
77,269,086 on weekly update, I get small daily files, but daily sql's
dont work very well, and miss records, in this case it missed 563 records.
mysql update stat_in set ctasc='321ST';
Query OK, 77269086 rows affected (24 min
Michael Stassen said:
-lz means to link with libz (the zlib library
http://www.gzip.org/zlib/),
but the error is that it couldn't be found. Do you have zlib? I'd expect
yes, or configure should have complained.
Yes, I have zlib.
$ find /lib -user zlib | xargs ls -l
lrwxrwxrwx1 zlib
I guess I must be a dinosaur because I don't use either mysqladmin or
mysqlgui. So I don't know how else to help. Could it be logging in as
something else and THAT account is the one without access to the other
tables?
What do you get when you do a SHOW DATABASES from each client program?
You
I'm guessing that you have indexes on the 321st_stat table? If this is the
case, try dropping them before you do the insert, then rebuilding them.
MySQL is known to be slow at doing bulk inserts on indexed tables. Also,
updates are much faster than inserts since with inserts there are much more
In the last episode (Aug 19), matt ryan said:
I think oracle parallel query is calling me
110,832,565 stat records
77,269,086 on weekly update, I get small daily files, but daily sql's
dont work very well, and miss records, in this case it missed 563 records.
mysql update stat_in set
One alternative, since you know you don't have many records to insert,
is to pull the IDs of the missing records and insert just those. Do an
outer join on the two tables (joining on the primary key), get a list
of the IDs of records in stat_in but not in 321st_stat, and add a
WHERE id IN
- Original Message -
From: matt ryan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 19, 2004 12:06 PM
Subject: 1 day 28 min insert
I think oracle parallel query is calling me
110,832,565 stat records
77,269,086 on weekly update, I get small daily files, but daily
Andrew Pattison wrote:
I'm guessing that you have indexes on the 321st_stat table? If this is
the case, try dropping them before you do the insert, then rebuilding
them. MySQL is known to be slow at doing bulk inserts on indexed
tables. Also, updates are much faster than inserts since with
In the last episode (Aug 19), matt ryan said:
One alternative, since you know you don't have many records to insert,
is to pull the IDs of the missing records and insert just those. Do an
outer join on the two tables (joining on the primary key), get a list
of the IDs of records in stat_in
I think this can be done, but tried a few times with
no success. I want a column in a table that sets a
timestamp.
Instead of passing a value from the form though is
there a way mySql would automagically stamp the
records as they are inserted ?
and as a side note - would table type make any
It could save you lots of processing time to pre-collect a list of the
records you are actually going to add to the table. I know it sounds
counter-intuitive but this has saved me OODLES of time on several
occasions (of course it can't work for all situations but in your case
where you are
You are DEFINITELY not going to win any races with INSERT REPLACE.
Minimizing the number of records you need to process will improve your
times significantly, especially since you need less than .002% of your
source data added to your destination table.
Shawn Green
Database Administrator
I thought about this method before. But since there
are 6 sets of rows I want to update in one table and
they are common at some level, I am wondering whether
there is more efficient way to do it.
Thanks,
--- Michael Stassen [EMAIL PROTECTED]
wrote:
Assuming that column Q3F in your example is
Hi
you try setting the column type to TIMESTAMP :)
http://dev.mysql.com/doc/mysql/en/DATETIME.html
Peter
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
Sent: 19 August 2004 17:50
To: [EMAIL PROTECTED]
Subject: Fairly lame question
I think this can be
MySQL provides a number of functions for handling dates and times:
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Cheers,
--V
Stuart Felenstein wrote:
I think this can be done, but tried a few times with
no success. I want a column in a table that sets a
timestamp.
Instead of
Stuart,
If the field is the only (or first) timestamp-type field in the table
columns, then the record will automatically have the current date/time
inserted when it is added. The only (or first) timestamp field will *also*
be updated every time you update the record.
View the timestamp
see topic.
Ex: mysqlgui.exe, phpmyadmin, etc.
I can't get phpmyadmin to work...but that's a different topic.
Whoa, I ran SHOW DATABASES and everything came up!
Now I just have to figure out how to do that with mysqladmin
(c:/mysql/bin/mysqadmin - or that is how windows default goes anyway for MySQL 4)
Sorry, thanks for the tip. I'm new to mailing lists in general...
Hi,
Ex: mysqlgui.exe, phpmyadmin, etc.
I can't get phpmyadmin to work...but that's a different topic.
What is best - tastes differ when it comes to GUI,
note everyone likes the same features ...
So, what is best?
With regards,
Martijn Tonies
Database Workbench - developer tool for
Same problem when trying to compile 4.0 instead of 4.1:
gcc -O3 -DDBUG_OFF -O3 -mcpu=i686 -felide-constructors -fno-rtti
-fno-exceptions -fno-implicit-templates -fno-exceptions -fno-rtti
-DUSE_MYSYS_NEW -DDEFINE_CXA_PURE_VIRTUAL -rdynamic -o mysqld sql_lex.o
sql_handler.o item.o item_sum.o
In the last episode (Aug 19), Casey Allen Shobe said:
Same problem when trying to compile 4.0 instead of 4.1:
gcc -O3 -DDBUG_OFF -O3 -mcpu=i686 -felide-constructors -fno-rtti
mini_client_errors.o stacktrace.o repl_failsafe.o sql_olap.o -static
^^^ Note the -static flag here
Umlets see.
I suppose the best means easiest to use, making it simple to create and
manage databases, tables, and the like, for newbies like me.
^_^
Umlets see.
I suppose the best means easiest to use, making it simple to create and
manage databases, tables, and the like, for newbies like me.
And what OS do you need to run it on?
Either way, make sure to give Database Workbench a
try as well - www.upscene.com
With regards,
Matt:
You would be very well served to give the table a unique physical key.
Alternate or primary, you could then join to this single column. I am not
sure how big the table to get, however, so you will definitely want to use a
bigint unsigned if you plan to test this theory.
Benefits:
- You
The table is 9 gig, and the index is 8 gig
unfortunately the primary unique key is almost every column, if I were
to make it one using concat, it would be huge.
I tried making those fields a hash, but it did not work, I had duplicate
hashes for non duplicate records!!
Matt
--
MySQL General
On Wed, Aug 18, 2004 at 08:03:36AM +0400, Mike Blazer wrote:
Mike Blazer wrote:
In addition to my previous posting - on this machine I have glibc.2.3.2
which was installed using the Gentoo emerge native installer. Dunno, the
mysql manual says a lot about various bugs and patches for glibc
Hi, just an odd query.
Background: I'm trying to calculate the Next Thursday and Next Friday
dates from today (whenever that is), and return today's date if it's
already a Thursday or a Friday.
As a bit of a traditionalist, I've been used to modulo arithmetic
always giving a positive answer,
I have two tables that should be related by a customer
id (established in the customer table). The second
table is going to have documents in a text column.
I want the ability (at least I think) to have full
text search for this second table. Hence I chose a
myIsam table type.
So a few
Richard Dyce wrote:
mod(3-weekday(curdate()),7);
But MySQL doesn't seems happy to give back negative numbers:
What about changing it to MOD( 10 - WEEKDAY( CURDATE(), 7 ) )
to avoid the negative numbers?
--
Keith Ivey [EMAIL PROTECTED]
Washington, DC
--
MySQL General Mailing List
For list
Dan Nelson said:
^^^ Note the -static flag here
But you don't have a static libz (libz.a). You've only got a dynamic
one. Redhat usually puts the static libraries in a separate -dev
rpm.
Aha, yes. This is a custom-built linux installation where I have built
zlib dynamically-only,
In the last episode (Aug 19), Casey Allen Shobe said:
Dan Nelson said:
^^^ Note the -static flag here
But you don't have a static libz (libz.a). You've only got a dynamic
one. Redhat usually puts the static libraries in a separate -dev
rpm.
Aha, yes. This is a custom-built linux
I have two tables that should be related by a customer
id (established in the customer table). The second
table is going to have documents in a text column.
I want the ability (at least I think) to have full
text search for this second table. Hence I chose a
myIsam table type.
So a
I don't know yet but transactional activity could get
quite large.
I read a bit in the manual (well a page or two)
So I created a sql statement
relating t1-id = t2-id .
I'm imaging that could work ,maybe i'm wrong.
Thank you,
Stuart
--- Jeremy March [EMAIL PROTECTED] wrote:
I have two
I have been using SQLyog at http://www.webyog.com for
quite some time.
Karam
--- [EMAIL PROTECTED] wrote:
see topic.
Ex: mysqlgui.exe, phpmyadmin, etc.
I can't get phpmyadmin to work...but that's a
different topic.
___
Do you Yahoo!?
Win
Programming a new site that will be launched in a month.
We'd like to use MySQL 4.1 but aren't sure how production-ready it is.
Anyone heard how the development is coming along, or when it will be
officially released?
--
MySQL General Mailing List
For list archives:
I'm having the same problem that's described here:
http://bugs.mysql.com/bug.php?id=4120
The recommendation by Mr. Barnett is to download and compile the newest
version of ByteFX.Data / Connector/NET / MySQL.Data.MySQLClient (I've
seen it referred to by a number of different names) from source.
Thanks Keith!
About 5 minutes after I posted it, I had a personal email from someone
suggesting exactly(!) the same thing. For the record, my reply:
On 19 Aug 2004, at 21:39, Richard Dyce wrote:
Thanks!
I'd got to go with:
if(weekday(d)4,3-weekday(d),10-weekday(d)) day)
which is I suppose the
59 matches
Mail list logo