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 >>>>
>>
x27;),('About','main-column','some text
... ... more text ...');
/*!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
Quoting Daevid Vincent :
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...
D
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 t
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
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
>
>
>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
-> f
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
p1.player_name,g.score1,g.tim
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
dropping
the entire data 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 arch
the word "group" 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
rting both 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
start/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 rel
> 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 mys
using S 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
any advice.
--
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 l
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
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/
>
>
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 safe_
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 ../storage/feder
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:http://lists.mysql.com/mysq
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 foug
error
"# - 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.
error
"# - 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.
es. I 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 Ge
ything else I can do to get a clean install of MySQL running
again?
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nfuse 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]
b
E: Sub-process /usr/bin/dpkg returned an error code (1)
So now what am I 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]
ysqld.pid --skip-external-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 exper
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
een '2008-05-01' and
'2008-05-30';
+---+
| count(id) |
+---+
| 85232 |
+---+
1 row 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: DOMDocument::__construct
ing trouble importing a mysql dump using 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
est practice for preserving my database as is when
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 and
our 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,
Dav
be a good use of the MySQL Proxy http://forge.mysql.com/wiki/MySQL_Proxy >.
This doesn't look like it will work 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
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
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.
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;
+
ta | mediumblob | YES | | NULL|
|
++--+--+-+-++
6 rows 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 Ge
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 d
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>
>
D payload_time
> 11808.74704 AND payload_time < 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,
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;
++-
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 Mailin
t;
> - michael
>
>
> On 6/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 lik
ll 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]
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
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 cro
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 particila
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 [ERRO
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
0
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, Apa
ite, and if there are
new tables or columns, then add them.
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
F
ppealing.
Any advice 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*"
> ./mysql-5.1.11
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 f
and the does this once every 5 seconds.
>
> I don't know 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
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?
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
&g
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: http://lists.mysql.com/m
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: http://li
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:
> Sent: Wednesday, August 23, 2006 10:15 PM
> Subject:
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:h
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 t
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?
>
>
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: http://lists.mysql.com/mysq
sqld/mysqld.pid
socket = /var/run/mysqld/mysql.sock
- - - - - - - - -
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]
5 and uthe
application update 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
QL MySQL 4.1.15
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]
lto:[EMAIL 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 ex
ansactions.
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, 20
n 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
Su
y
the same 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
n't going to work when I tried it, but I 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 Mail
hat's 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.co
r, 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://lists.m
the PHP pages that seek to get any data from 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
hasn't been an issue in any other 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/Analyst"
) 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
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: ht
est way 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]
tName 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),
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]
What 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:
what 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.
ot sure which I
want to be using, and how.
Any assistance 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]
INSERT
takes a bunch of parameters which are specified within brackets. I
thought SELECT worked the same way.
The MySQL manual, while very helpful, did not, in this case, make clear
to me that INSERT and SELECT behaved differently.
Dave
--
MySQL General Mailing List
For list
Have you tried removing the brackets ( ) from around the fields in the
SELECT part of the query?
I did as you suggested and ran the query without brackets, and it worked
perfectly.
Thank you for the speedy and helpful advice!
Dave
--
MySQL General Mailing List
For list archives: http
1 - 100 of 452 matches
Mail list logo