...');
/*!4 ALTER TABLE `text_for_pages` ENABLE KEYS */;
The value created in the database is just 'some text ... '
Cheers, Dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Thanks for the reply, and I apologize because I expect I've broken
threading. The list isn't mailing the posts to me, so I've nothing to
reply to. I've had to cut and paste from the web archive...
2014/01/06 12:18 +, Dave Howorth
Everything appears to work except that text fields
Quoting Daevid Vincent dae...@daevid.com:
HA! No $hit! Well isn't that clever. I didn't know that you can highlight a
table like that, and paste it into Excel. That darn Microsoft -- they think
of everything! :)
Hell, don't give them ideas! They'll be trying to patent cut and paste...
Dave
Is there a halfway house between a single database and a full master-slave
setup?
I have a database with one piggish table, and I'd like to direct queries that
search the pig to a duplicate database, where it won't affect all the routine
traffic.
I could definitely do this by setting up a
At 12:43 AM 8/30/2011, mysql-plain-digest-h...@lists.mysql.com wrote:
Not useful to add an index for that. I also wonder why the value is null
(meaning: unknown, not certain) for almost all records.
It depends on if you want the forest or the trees. A frequently executed
query asks for just
The innocuous change was to add an index for is_robot which is true
for 6 out of 20,000 records and null for the rest.
My complaint/question/observation is not how to optimize the query
that went awry, but to be alarmed that a venerable and perfectly
serviceable query, written years ago and
Why would using UNION cause the subqueries to be de-optimized?
explain
(SELECT count(gamename) as gname ,variation from zertz_gamerecord
where (gmtdate date_sub(current_timestamp(),interval 90 day)) and
(player1='13213' or player2='13213' ) group by variation limit 3)
shows using index on
This is a cautionary tale - adding indexes is not always helpful or harmless.
I recently added an index to the players table to optimize a common query,
and as a consequence this other query flipped from innocuous to something that
takes infinite time.
select
Can you post the EXPLAIN EXTENDED output for your before and after queries?
also, have you recently run an ANALYZE TABLE on the tables?
// before
mysql explain extended select
p1.player_name,g.score1,g.time1,g.color1,p2.player_name,g.score2,g.time2,g.color2,g.gamename,gmtdate
- from
BTW, the query on the database with the added index doesn't take
forever, it takes a mere 51 minutes (vs. instantaneous).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
BTW, the query on the database with the added index doesn't take
forever, it takes a mere 51 minutes (vs. instantaneous).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
base and recreating? If I did that, would the mysqldump
of the remaining tables allow me to restore most content?
--
Dave Close
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Aveek, Simcha, Johan,
Thanks for explaining the situation. I knew there were some reserved
words, but I hadn't realized there were so many.
Anyway, now that I know I can protect my column names with backticks,
I'm good to go.
--
Dave M G
--
MySQL General Mailing List
For list archives: http
for column names? Seems a little
silly. Is there a way to protect column names to that there is no confusion?
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
/running
~$ ps -ef | grep mysql
dave 23043 22341 0 23:57 pts/000:00:00 grep mysql
If I understand these outputs, it says MySQL is running when I start it up,
but, after that, if I look for the process, it doesn't show up as
running.
When I run any of my local web sites that rely on MySQL
Apparmour and MySQL
solved the problem.
Thank you for setting me in the right direction.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
We have a PSE05 Master and PSE06 Slave (PRODUCTION servers) both
are
Ubuntu 32-bit.
We have a third slave PSE07 which is Ubuntu 64-bit. This is our 'live
backup' so to speak. We take mysqld down daily on there and tarball the
/var/lib/mysql and /var/log/mysql as snapshots (since mysqldump
servers:
Q-S
if S:binpos M:binpos
then
Q-S // Slave has executed master bin pos and can be queried.
Else
Q-M // fallback
fi
Thanks!
--Dave
David W. Juntgen
Medical Informatics Engineering Inc.
6302 Constitution Drive
Fort Wayne, IN 46804
Phone: 260.459.6270
Fax: 260.459.6271
.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Trying the latest phpMYAdmin on Mac OS X.
Everything is set up correct but I get
#2002 - The server is not responding (or the local MySQL server's socket is not
correctly configured)
And I am telling config.php where the mysql.sock file is located.
Help.
--
MySQL General Mailing List
For
Hello, we are trying to move a Joomla Site
and the administrator does nowrk.
Using MySQL 5.1.36 on MAC OS X Server.
How can I fix this?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Thu, Jun 04, 2009 at 01:27:34PM -0600, Timothy Smith wrote:
Dear MySQL users,
MySQL Community Server 5.1.35, a new version of the popular Open
Source Database Management System, has been released. MySQL 5.1.35 is
recommended for use on production systems.
For an overview of what's new
On Wed, May 20, 2009 at 10:27:51AM +0200, Webmaster Studio Informatica wrote:
Hi,
I need to upgrade Mysql 4 to Mysql 5 on Linux.
I will uninstall version 4 and install version 5.
With uninstallation usually database files remain in /var/lib/mysql/
I
make all-am
Making all in mysql-test
Making all in lib/My/SafeProcess
g++ -DHAVE_CONFIG_H -I. -I../../../../include -O3
-fno-implicit-templates -fno-exceptions -fno-rtti -MT safe_process.o -MD -MP
-MF .deps/safe_process.Tpo -c -o safe_process.o safe_process.cc
In file included from
I mean MySQL 5.1
I compile MySQL 5.1.32 and on tests I got
gmake -k test
cd unittest gmake test
gmake[1]: Entering directory `/usr/src/contrib/mysql/mysql-5.1.32/unittest'
perl unit.pl run mytap mysys ../storage/archive ../storage/blackhole
../storage/csv ../storage/example
Does anyone know if Conficker is suppose to affect MySQL?
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
. Will read directions if
necessary
Dave
* Your server must have the following MySQL grant privileges (for
tables): SELECT, INSERT, UPDATE, DELETE, DROP, ALTER, CREATE
* Your MySQL server must not be running in Strict mode.
--
Canada must refuse to be entangled in any more wars fought
# - Invalid use of group function
I also tried
SELECT ID_number, count( CU_number ) AS CC
FROM MyTable
GROUP BY ID_number
WHERE CC = max( CC );
But this also causes an error, anyone able to offer some pointers am I able
to use sub queries ?
Thanks Dave.
# - Invalid use of group function
I also tried
SELECT ID_number, count( CU_number ) AS CC
FROM MyTable
GROUP BY ID_number
WHERE CC = max( CC );
But this also causes an error, anyone able to offer some pointers ?
Thanks Dave.
went into
/etc/mysql and edited both my.cnf and debian.cnf so that the socket =
/tmp/mysql.sock
Then I reinstalled MySQL server:
$ sudo apt-get install mysql-server mysql-server-5.0
Seems to be running now.
Thanks everyone for helping me get things sorted out.
--
Dave M G
--
MySQL General
supposed to do? It won't let me start it, stop it,
remove it, or anything.
Any advice would be much appreciated.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the situation.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
?
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-locking
--port=3306 --socket=/var/run/mysqld/mysqld.sock
root 11291 0.0 0.0 2920 736 ?S20:36 0:00 logger
-p daemon.err -t mysqld_safe -i -t mysqld
dave 11309 0.0 0.0 3004 764 pts/0R+ 20:37 0:00 grep mysql
I'm obviously no expert (closer to babe-in-the-woods
Hi,
Thanks for the help; that makes sense I think you guys are right. Is it
worth tuning such a thing? It seems to me like it would be much faster to
use the index?
Thanks again
Dave
Dave schrieb:
Hi all,
I've been trying to optimize some of our queries against a large
database
and come
in set (0.97 sec)
Does anyone know what could be the cause of this or where to look next?
Thanks
Dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Customer has tested his site in Mysql 5.1 and we are running Mysql 4.1 .
His test works but over here we get:
Warning: DOMDocument::__construct() [function.DOMDocument---construct]:
Malloc(88) in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 5
Warning:
phpMyAdmin, it might be simpler not to use it, and use mysqldump instead.
I suppose I'll have to if I can't get phpMyAdmin to behave. It's too
bad, though, as phpMyAdmin is so convenient otherwise.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
backing up and restoring?
Thanks for any advice.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hey folks,
As with many lessons in linux world it takes a big oop for a big lesson.
system:
gentoo OS
webmin/virtualmin frontend
I was trying to apply permissions to usetrs so they can only access
certain DB's. This involved removing the associated user permissions
from the permissions list
best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.
You may contact me via reply e-mail or at my phone: 801-733-5333, where
I am available 8:00 a.m. - 11:00 p.m. daily.
Thank you,
Dave L. Hunt
just yet
http://forge.mysql.com/wiki/MySQL_Proxy_FAQ#In_load_balancing.2C_how_can_I_separate_reads_from_writes.3F
Which is a real shame because I can't see that sqlrelay can do this either
http://sqlrelay.sourceforge.net/sqlrelay/loadbalfailover.html
Dave
--
MySQL General Mailing List
For list
Hello all,
I'm trying to do some processing on the front end to optimize my query on
the backend. I would like to generate a list of id's for this query like
so:
SELECT REPLACE('3,4,5,6,7,8,9',',',' OR element_id=') INTO @tmp;
Then use it like:
mysql select @tmp;
Thank you Baron, I'll give that a shot, and thanks for the IN() list tip
... much appreciated.
Dave
Hi Dave,
Dave G wrote:
Hello all,
I'm trying to do some processing on the front end to optimize my query
on
the backend. I would like to generate a list of id's for this query
like
so
Prepared Statements with the IN function worked beautifully. Performance
is slightly degraded, but I get the functionality I want and can live with
the slight performance hit.
Thanks again.
Dave
Hi Dave,
Dave G wrote:
Hello all,
I'm trying to do some processing on the front end
I asked a question yesterday that was quite onerous, so I have been
working out some of the details today, and would like to re-post my
question under a different light.
I have a table called data__ProcessedDataFrames that can grow to be
gigantic, and I need to speed up the query for pulling the
in set (0.00 sec)
mysql
This table can get quite large so I'm trying not to query on it twice to
get the MAX(payload_time) ptime. Obviously what I have is not the
group-wise maximum I was hoping for.
Dave G.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I have a table in my database (currently) that grows to be huge (and I
need to keep the data). I'm in a redesign phase and I'm trying to do it
right. So here are the relevant details:
The table has several keys involved:
mysql desc data__ProcessedDataFrames;
1180564096.24967;
What I'm concerned about is with how much data I will eventually have,
even scanning over the KEYS will take a long time.
Thanks
Dave G.
BTW: heres the giant query that I use.
SELECT
E.product_id,
product_name,
D.top_level_product_name,
processed_id
I do, but I don't see any way around that with the data I have.
Dave G.
Good Afternoon David
sounds as if you have a number of non-unique indices (even possibly FTS!)
slowing down queries..this should help you concentrate on the slower
indices
mysql
select TABLE_NAME,COLUMN_NAME
REcently my mysql server has been overload with a lot
of connections; in fact losing the mysql.user table and
one whole database.
How can this be prevented?
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General
will be appreciated. I searched on google and only found where
another person had the same problem, but no solution.
Dave G.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/5/07, Dave G [EMAIL PROTECTED] wrote:
I'm getting what appears to be a java reference back from values I
return
from a UDF. The values appear find using php, and in the mysql client.
The result looks something like:
[EMAIL PROTECTED]
The result should be a string (some representing floats
I'll defer to you.
At 01:00 PM 5/28/2007, Baron Schwartz wrote:
Dave Dyer wrote:
Thanks, it turns out you are exactly right. I rewrote
the query to keep the on immediately following the left join
and it now works as I wish.
I'll have to read up on cross join, but if there
is a mysql bug here
Thanks, it turns out you are exactly right. I rewrote
the query to keep the on immediately following the left join
and it now works as I wish.
I'll have to read up on cross join, but if there
is a mysql bug here, it is that the parser that what I
wrote as left join was turned into a cross
I'm trying to construct a join, but the effect I want seems
to be impossible to achieve. In this schema, the uid
field is unique in the players table, but not in the ranking
table (one player per uid, multiple rankings per player)
I want to select player names and rankings for a particilar
I am suddenly seeing this in my error log:
070418 08:43:57 mysqld started
070418 8:43:57 [ERROR] /usr/contrib/libexec/mysqld: Can't create/write to file
'/usr/contrib/var/doctor.nl2k.ab.ca.pid' (Errcode: 13)
070418 8:43:57 [ERROR] Can't start server: can't create PID file: Undefined
error: 0
On Wed, Apr 18, 2007 at 12:42:56PM -0500, Gerald L. Clark wrote:
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
I am suddenly seeing this in my error log:
070418 08:43:57 mysqld started
070418 8:43:57 [ERROR] /usr/contrib/libexec/mysqld: Can't create
Janek,
Thanks for responding.
I was really hoping to not have to go to any third parties and start a
whole new learning curve.
Is what I'm after really not possible with MySQL?
--
Dave M G
Ubuntu 6.10 Edgy Eft
Kernel 2.6.20-5-generic
Pentium D Dual Core Processor
PHP 5, MySQL 5, Apache 2
.
Is this possible without third party commercial software?
Thank you for any advice.
--
Dave M G
Ubuntu 6.10 Edgy Eft
Kernel 2.6.20-5-generic
Pentium D Dual Core Processor
PHP 5, MySQL 5, Apache 2
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
or information would be much appreciated.
--
Dave M G
Ubuntu 6.10 Edgy Eft
Kernel 2.6.17.7
Pentium D Dual Core Processor
PHP 5, MySQL 5, Apache 2
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Mon, Oct 23, 2006 at 01:49:14PM +0100, Ben Clewett wrote:
MySQL,
I am trying to upgrade from 4.1 to 5.1.
Your manual states I should run mysql_upgrade.
But there is no such program in our pre-compiled binary, only a man page!
$ find . -name mysql_upgrade*
Thanks for pointing that out, I'll go with James solution.
David Godsey
David Godsey wrote:
I am looking for a way to write a client program that will wake up when
there is new data in the database, much like replication.
So instead of my client pulling the database on some fixed
if there is a built-in solution for mysql but this gets the
job done for me.
Let me know if you find a better way to do this.
Thanks,
James
Dave at Mysql wrote:
I am looking for a way to write a client program that will wake up when
there is new data in the database, much like replication.
So
I am looking for a way to write a client program that will wake up when
there is new data in the database, much like replication.
So instead of my client pulling the database on some fixed interval, I
would like the mysql daemon to push the data to my client when there is
new data. I assume this
I am not able to install Mysql on my 2003 server at home.
error 1045!!
I get an accesd denied for user [EMAIL PROTECTED]
I need the full error, but have some questions:
1. Are you sure that you set a root password?
2. Are you using the command line client or some other administrative tool?
Has anyone heard of drupal breaking under a minor upgrade from
Mysql 4.1.1X to 4.1.2X ?
I have a weird one.
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives:
On Thu, Aug 31, 2006 at 09:52:37AM +1000, Colin Charles wrote:
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
Has anyone heard of drupal breaking under a minor upgrade from
Mysql 4.1.1X to 4.1.2X ?
MySQL 4.1.18 to 4.1.21
No, upgrading between versions
Question, I specify with openssl is with --wth-openssl=/usr/contrib
and the config script chokes. What is this happening?
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives:
On Thu, Aug 24, 2006 at 12:43:56AM -0400, Rhino wrote:
- Original Message -
From: Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, August 23, 2006 10:15 PM
Subject: Chemistry search
Has
Has anyone come up with searching a chemicals based database using
mols or smilies?
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Tue, Aug 22, 2006 at 10:42:52AM +, Neil Tompkins wrote:
On my website I'm looking to add a search box.
I have a number of different database fields. Does anyone have any
recommendations about how I can perform a search engine type search including
the text fields.
Have you
On Mon, Aug 14, 2006 at 02:29:41PM +1000, Chris wrote:
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
On Mon, Aug 14, 2006 at 10:42:50AM +1000, Chris wrote:
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
I use SELECT
On Mon, Aug 14, 2006 at 10:42:50AM +1000, Chris wrote:
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
I use SELECT all from * ... and one row is a gif.
How do I get that gif to appear as a gif and not text?
In your connecting programming language
I use SELECT all from * ... and one row is a gif.
How do I get that gif to appear as a gif and not text?
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives:
- - - - - - - - -
I am unsure where to look to diagnose this problem further.
Any advice would be much appreciated.
Thank you.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
manager doesn't update it to 5.0.
So if 5.0 is the current version of MySQL, why does it seem to me that
it's not widely adopted?
Would it be problematic now or later if I upgraded to 5.0?
Would I have to soon upgrade to 5.0 if I upgraded to 4.15 now?
Thank you for any advice.
--
Dave M G
phpMyAdmin 2.7
PHP 4.4.2
Any help would be much appreciated.
Thank you.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello all,
I am looking for a way to view the max values that have been used by all
threads or a signal thread for read_buffer, read_rnd_buffer,
sort_buffer, and net_buffer. I want to know these values so that I can
turn them appropriately.
Regards,
--Dave
David W. Juntgen
Medical
,
--Dave
David W. Juntgen
Medical Informatics Engineering Inc.
Phone: 260.459.6270
Fax: 260.459.6271
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
For me, MySQL 5 on 2.4 seems to be less unstable than on 2.6, although I'm
getting TomCat hangs on 2.4, but that's another story and may be hiding
MySQL instability.
Dave
-Original Message-
From: Ady Wicaksono [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 11:38 PM
To: Dave
PROTECTED]
Sent: Wednesday, March 08, 2006 11:10 PM
To: Dave Pullin
Cc: mysql@lists.mysql.com
Subject: Re: Aggregate functions in ORDER BY
Many thanks for that Dave.
Do you know whether it's possible for MySQL to return fully qualified
column names by default?
For example, I'd like
application.
It seems unlikely to be a hardware problem because its on 3 machines at
once. It looks like a MySQL V5 problem but I can't pin it down to anything
specific enough to report a bug.
Anyone had similar experiences with MySQL V5?
Dave
--
MySQL General Mailing List
For list archives: http
in the results, make your
select a subselect.
select a,b,c from (
select a,b,c, COUNT(pets.pet_id) as count
from etc
order by count
) as subtable
Dave
-Original Message-
From: Yasir Assam [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 9:10 PM
To: mysql@lists.mysql.com
Subject
the only
encoding I ever work in, and I want to make my system as consistent as
possible.
What commands do I run to permanently fix all of these collation and
character set variables to utf8?
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
thought
I'd dive in anyway.
Is it possible I can get a slighly more newbie-friendly set of
instructions on how I can either reconfigure my MySQL server, or at
least permanently alter the system variables?
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
to be clear, all Japanese characters and all database
data display correctly when viewed from the hosting service.
I hope someone can shed some light on this.
Thank you.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
the
database return this error:
Warning: mysql_data_seek(): Offset 0 is invalid for MySQL result index
11 (or the query data is unbuffered) in
/home/dave/web_sites/tokyocomedy.com/site_files/show.php on line 51
Because the pages work flawlessly on my hosting service, I have to
assume
programs and my suspicion is that I'm
clobbering memory somewhere else (but if it's as simple as me needing to
allocate space for the returned pointer, then I'd like to know!)
Thanks.
--
Dave Weingart, Sr. Programmer/AnalystI can call modules from the vasty
RNA Private Label Services
MySQL server version for the right syntax to use
near 'group int(11) NOT NULL default '0',
event int(11) NOT NULL de
(the error message cuts abruptly, as shown here)
Any advice would be much appreciated.
--
Dave M G
--
MySQL General Mailing List
For list archives: http
) I am looking at compiling MySQL myself for an Intel Xeon EM64T
box using pgcc, any insight on compiler options to get the best
performance?
Thank you all for you help!
Regards,
--Dave
David W. Juntgen
Medical Informatics Engineering Inc.
Phone: 260.459.6270
Fax: 260.459.6271
to preserve text encoding methods
when copying a database from one machine to another?
Any advice is much appreciated.
Thank you.
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
varchar(30)
email varchar(75)
campus varchar(75)
year varchar(4)
When the user enters search criteria I want all records where there is
an identical match within any portion of the field.
i.e.
Searching for 'ave' returns all firstName's (dave), lastName's
(Shaverson), email's ([EMAIL PROTECTED
Windows XP
phpMyAdmin 2.7.0-rc1
MySQL 5.0.16-nt running on localhost as [EMAIL PROTECTED]
The DELIMITER statement works in the command line, but not in phpmyadmin
(see error below)
mysql DELIMITER //
mysql use mysql //
Database changed
mysql
PHPmyadmin ===
DELIMITER //
.
Thank you. That answer is very concise and helpful.
Dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
applications are used for management of this list? I like the
way it is handled, and I have always been interested in having a mailing
list manager that uses MySQL to keep track of members.
Dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
is much appreciated. Thank you.
Dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the data was set to. But of course
that's not the case. One specifies what to get, and then separately
specifies what to set.
Thank you for clearing that up.
Dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
using the wrong statement? How do I take a value from one field,
such as the date, and make it into a different format for inserting into
another field if the INSERT command won't accept those modifications?
Dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
, and in all cases the collation is marked as being utf8_general_ci.
Where could this latin1_swedish_ci collation be coming from?
Dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 431 matches
Mail list logo
