I get this error:Fatal error: Cannot redeclare class
mysql in /home/public_html/n/config.php on line 6
I have two processes running on one page and do not
know how to declare class for both with out getting
this error. I have one or the other working no problem
but never both. arghhh
Someone pl
I am trying to make a script that has an admin and
search area. The admin area let's the user upload 10
photos and a discription for a property, then select
from drop down menus for bedrooms,bathrooms,price for
rental, golfing or not comunity,comunity name and code
number"each has it's own for fast
How do I disable showing ALL the databases on the server for a normal user
that only has access to a single database? So that when a user runs show
databases, they only get a list of ones they can access. I've seen this done
before.
Sorry if it's a newb question.
John
--
MyS
pointing me in the right direction,
John
-Original Message-
From: Stephen Edberg [mailto:sbedb...@ucdavis.edu]
Sent: Sunday, February 15, 2009 7:07 PM
To: John
Cc: mysql@lists.mysql.com
Subject: Re: Show Databases issue
On Sun, 15 Feb 2009, John wrote:
> How do I disable showing ALL the d
Can you show us the output of SHOW CREATE TABLE for the tables in your
query? Looks like you just need some indexing!
Regards
John
John Daisley
MySQL & Cognos Contractor
Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer
Telephone
on queries.
John Daisley
MySQL & Cognos Contractor
Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer
Telephone +44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
From: Arthur Fuller [mailto:fuller.art...@gm
quests for your network. Programs that need UDP
will still work.
It's also worth making regular visits to a site such as
http://staff.washington.edu/dittrich/misc/ddos/ to find out what's new in
DDOS. Being well informed is half the battle!
Regards
John Daisley
MySQL & Cognos Contr
try and load the files using MySQL client
and the LOAD DATA INFILE command? (See this link for details on how to use
LOAD DATA INFILE http://dev.mysql.com/doc/refman/5.1/en/load-data.html)
Regards
John Daisley
MySQL & Cognos Contractor
Certified MySQL 5 Database Administrator (CMDBA)
Certi
Patrice,
Can you post the output of SHOW CREATE TABLE for the table you are having
difficulty inserting into? Without knowing the table structure its very
difficult to work out why your data load is failing.
Regards
John Daisley
MySQL & Cognos Contractor
Certified MySQL 5 Data
What is the exact error you are getting?
John Daisley
MySQL & Cognos Contractor
Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer
Telephone +44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
a lot of
indexes. From memory you can create the indexes faster by turning them off
with 'ALTER TABLE tablename DISABLE KEYS' before the 'LOAD DATA INFILE'
command and then using 'ALTER TABLE tablename ENABLE KEYS' to re-create the
indexes after the LOAD DATA INFILE com
I am trying to help a friend with her website, which is on Yahoo. I went into
her phpMyAdmin, and got the message:
Your PHP MySQL library version 3.23.49 differs from your MySQL server version
4.1.14. This may cause unpredictable behavior.
Another message told me to run the script: mysql_fix_pri
I am getting this error when installing a db:
An error occurred while trying to build your MySQL
database tables. The errors were: 'Invalid default
value for 'AttachmentID'
Invalid default value for 'MapID'
Invalid default value for 'ServerSendID''. Click on
the "Try Again" button below to try aga
I get this error:
Warning: implode(): Bad arguments. in
/home/b/cl/TP2/admin/defaults.php on line 102
102-104 Code is:
{
$cat_array=explode(":",$_POST['cat_str']);
}
Ideas?
Mike Richardson and John Dean are pleased to announce the 2.0 release of
Rekall, a personal, programmable DBMS system for Linux and Windows. If you
want to distribute your Rekall application commercially then there is a
run-time version of Rekall V2.0.0 available too. There are also versions
Hi Group,
I am very much familier with the replication in 3.x version of mysql. Now I
am trying with the Innodb version of mysql 4.0.13. The show slave status of
this version is giving some new fieldswhat is actually Relay_Log_File.
what is the use of this...
regds,
--
MySQL General Mai
Hi group,
I have two mysql-Innodb server(4.0.13) with replication enabled in that.
server A > Server B
I have the database dump of server B. In server B, I have enabled the log-
bin, log-slave-update in server B.
In case of database crash, How can I restore the data from log file. I know
tha
I am using php/mysql for a program and everything
installed fine but when I try to open it up I get this
error:
Fatal Error : Couldn't find local config file.
File Name : /program/admin/index.php
Error Code : err01
Time :18 Oct 2004, 07:19:44 pm
PHP Fatal error: Call to undefined function:
m
I want to make a small simple database that searches
by state or zip code for jobs. I would enter just a
job description, job position and job id #. so 3
fields display. I want to enter in the information by
an admin area but not a big deal. How hard would this
be to create. Help please. Thanks
with a few users.
Any assistance would be greatly appreciated.
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Thursday, 15 July 2004 1:35 PM
To: 'John Nairn '; '[EMAIL PROTECTED] '
Subject: RE: Any select with a large result set locks all
I wanted to know if this is a good place to post
for a project I needed done, If not can someone direct
me to a better place to post it.
Thanks
___
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com
--
MySQL
HI All
I was wondering if anyone could tell me how to get around this problems
Error: could not connect to the database.
It's possible the database itself is just not working at the moment.
The admin should also check that the database details have been correctly
specified in config.php
Database
Hello,
do any body can help me, i have problem with mysql syntax may be.
Let's first explain. I have two servers that i store filename, size
... in records of video camera files.
I have one database with two tables:
Servers and Files;
Servers contain:
ServerID, ServerName, User, Password, LastConne
>John:
>
>A couple of suggestions. First, a better way to identify duplicate files
> in to
>use MD5 sum - MySQL can compute it with MD5(LOAD_FILE(fname)) if the file
> is
>residing on the server. It would be a good idea to store the md5 sum in
> the table.
>
>I th
I have been getting access denied and am stuck.
How do i change the password for root in mysql?
I am hosting on a third party site.
The allow me to use phpmyadmin.
Thanks
--- [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to
> be either spam or
> simply off topic to
using the regexp operator. This would go great with
the type of work I do.
Thanks,
John
X3 Scripts
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Please help with ignorance, I was in mysqld making some changes to a
database. I run a Linux 6 box with MySQL 3 on it. I was logged in as user
john, who has all access privelages to mysqld. John is not root, and I told
mysql to stop. Well, mysql will not start again. What can I do
Yeah, I wish it were that easy. I have attempted to do so, and here is a
transcription of my recent events to catch you up to me: ...and by the way
thanks, john
I was working in MySQL under user:john, which has direct privelages to all
features of MySQL. ...Anyway thinking I was root, I called
ysqld server running on port:
3306 ?
020404 17:00:28 Aborting
mysqld ended on Thu Apr 4 17:00:28 CST 2002
mysqld ended on Thu Apr 4 17:21:00 CST 2002
John
>From: Steven Hajducko [mailto:[EMAIL PROTECTED]]
>What do the contents of the ns1.acculock.com.err fil
catatrostrophy averted with kill -9 8374, and started up fine.
thx,
John
-Original Message-
From: John Parsons [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 5:18 PM
To: 'john'
Subject: RE: Help. I have truly blundered.
> -Original Message-
> Fr
You know this sounds like a good idea, and I know this is what the utilities
are for that come provided with mysql(d). (MYODBC and mysqlaccess)I would
like to inquire, what do you mean. I don't comprehend what you just said.
Please someone give more specific details...
thanks,
, try again". Heaven forbid you want to call a
memory stack in Oracle and puipe the results to the db, and if you do, you
had better have all of your ducks squared away, you can ever so easily
corrupt the database if you don't. Oracle doesn't have enough intuition
either.
John
-
then you need to fix your filters
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:55 AM
To: john
Subject: Re: Insert ?'s
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To b
>Description:
Unable to use dotted-quad IP address in bind-address in 4.0.2.
>How-To-Repeat:
$ cat /etc/my.cnf
[mysqld]
bind-address= 192.168.1.2
$ /etc/rc.d/init.d/mysq
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
Operating system: WinNT4
PHP version: 4.0.6
PHP Bug Type: MySQL related
Bug description: Insert queries add TWO records to database
All my insert queries seem to add two records to the database instead of
one.
I was using MS Access 2000 and did not have the problem. I am now using
MySQ
I'm not convinced as I have the same problem in Netscape.
More likely to be a PHP or MySQL configuration problem as the code is fine.
Or maybe IIS?
May try it on a different server.
Regards,
John Stoops
Software Engineer
_
Neutralize (*\*)
Indepe
"20".$year;
} else {
$year="19".$year;
}
}
$date=$year.'-'.$month.'-'.$day;
return $date;
} // dbDate
Maybe able to run a similar function?
John (*\*)
-Original Message-
From: Bernhard Doebler [mailto:[EMAIL PROTECTED]]
Sent: 05 Ju
Only if the date being converted is a standard length, i.e. not 2/4/99
All dates would have to be DD/MM/ or MM/DD/, eg. 02/04/1999
If so then yes it can be done in MySQL else u wouldn't know your /'s from
your dates
John (*\*)
-Original Message-
From: Bernhard Doebl
ears to just be an occupied port...
many thanks.
John
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EM
Anyone have any personal experiences with installing mysql on a ppc
machine running os x pb? if so, and you've got a bit to talk about
it, I've got some pretty pointed questions so far as my difficulties
getting it working...
much th
I find out
what's wrong?
Linux 6.0 (Hedwig)
Perl 5
MySQL 3.22.32
thx,
john
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
did not read your email properly.
use:
cat lefeber lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber
If I am incorrect, please advise.
Someone please help to rid the world of the underscore and it's many
mis-interpretations,
john
-Original Message-
From: Ben Ocean [m
an aneurysm.
-Original Message-
From: Michael Collins [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 1:59 PM
To: john; MySQL List
Subject: RE: Mac OS X and MySQL
At 1:49 PM -0600 11/26/01, john wrote:
>this is not meant to be demeaning, but your not seriousely runnin
my mistake, I copied the line and forgot to remove the first lefeber.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 2:36 PM
To: john
Cc: Ben Ocean; [EMAIL PROTECTED]
Subject: RE: HELP! Hosed Database!
On Mon, 26 Nov 2001, john
ose guys that always overload
the mailboxes of others, aint you the big man -- coward.
Shut up punk, I will speak only to Paul DuBois of my issues.
-Original Message-
From: Michael Collins [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 4:36 PM
To: john
Cc: [EMAIL PROTECTED]
Subje
ing Mac
OS'?
i apologize, sincerely, to the whole newsgroup... ...and hope not to have
another day like Monday.
-Original Message-
From: NDPTAL85 [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 5:20 PM
To: [EMAIL PROTECTED]
Subject: Re: Mac OS X and MySQL
John,
Mac O
Raju,
I want to be able to do an update from a text file I have placed in the
/tmp dir. I have searched the "Manual" and it does not state how to do this.
I have three book on this subject and non of them state explicitly how to
accomplish the task of "import non-existing lines from /tmp/my_fi
items?
When using the IGNORE switch, should I use the "|" between REPLACE | IGNORE
as you have done?
thanks for your confirmation.
-Original Message-
From: Thomas Spahni [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 2:40 AM
To: john
Cc: MySQL Lists
Subject: RE: Beg
cing the data is the
command does not know how to align itself with CUST_ID = '1'. Does this
sound correct?
john
-Original Message-
From: john [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 8:24 AM
To: Thomas Spahni; john
Cc: MySQL Lists
Subject: RE: Beginner - Upd
Ms./Mrs. Marcotte,
First, since you asked, I am not a smooth talker, I am an asshole through
and through. When things aren't right I'll be the first to let you know.
Have you ever seen the movie "The American President"? Well, in order to
make things work for non-pro's the pro's have to be rem
Mr. Winters,
They do have a very slow search engine built in to the site. Look at the
header.
-Original Message-
From: Johnny Withers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 1:09 PM
To: 'Etienne Marcotte'; 'raezor'
Cc: 'MySQL Lists'; [EMAIL PROTECTED]
Subject: RE
Thanks for the input
-Original Message-
From: Ravi Raman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 2:28 PM
To: john; Johnny Withers; 'Etienne Marcotte'
Cc: 'MySQL Lists'; [EMAIL PROTECTED]
Subject: RE: Please redo this horrible web page
Hi.
Not
underscore or a space, I ask again and again and again?
john
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 2:16 PM
To: john
Cc: MySQL Lists
Subject: Re: Please redo this horrible web page
On Wednesday, November 28, 2001, at 02:44
yes, the PN field is a part number and is intently unique. But this seems to
load into CUST_ID=NULL, instead of CUST_ID=1. What can I do to update only
for CUST_ID=1?
-Original Message-
From: Thomas Spahni [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 4:26 AM
To: john
Cc
ot;_".
For the http://www.codebydesign.com/DataArchitect link to work you will have
to scroll down the header if using ie5/6.
john
-Original Message-
From: Peter Harvey [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 1:01 PM
To: Won Lee; mysqlList
Subject: Re: ERD
> Anyone know
Thanks Peter,
I have already addressed the issue with sales/webmaster, and they are
updating the page. Now, that's a Kompany.
-Original Message-
From: Peter Harvey [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 3:25 PM
To: john; Won Lee; mysqlList
Subject: Re
remove your line termination and it will not look for this non-existing data
and run through the whole file.
john
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 10:11 PM
To: [EMAIL PROTECTED]
Subject: Load data infile
Be struggling
all of the information you people have given to me is great and useful,
however, I still have no comprehension as to how to make the conditional
"html" setup for the pages. my attempt is as thus:
#getdata.pl
globals:
$PageLimit = "0";
$PageNumber = "1";
open db:
$DSN = "DBI:my
nd with google. I bet I could
refine my search, but I dont know where to start.
Please help.
Thanks.
John
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
ll help.
Thanks so far!
John
Chek your my.cnf file and see where it points to for the mysql.sock file.it should be under the client portion of it.
if you don't have a my.cnf file hat's your prob right there. Copt one of the cnf files to /etc and yo
I tried this:
root@rock:/etc# mysqladmin create testDB
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
in /etc/group, I added root and my user john to the mysql group.. but
that did not help.
If
bug script!
#
>How-To-Repeat:
Install binary mysql package from
mysql-max-3.23.53a-pc-sco3.2v5.0.6-i686.tar
Follow instrutions in INSTALL-BINARY text file. Fails at running
mysql_install_db.
>Fix:
unknown
>Submitter-Id:
>Ori
phpMyAdmin is part of PHPTriad, which has MYSQL, PHP, and the apache
webserver. There is a windows binary avalible via download.com
- Original Message -
From: Alan Cox <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 9:38 PM
Subject: Re: gui
> I like webmin. htt
on of Apache, MySQL, PHP and Perl and is available
for Linux, Windows, OS X, and Solaris.
http://www.apachefriends.org/en/xampp.html
XAMPP-on-a-stick takes that a step further and installs it on a USB
drive. http://forum.textdrive.com/viewtopic.php?id=3081
Hope that helps.
--John
--
MySQL Ge
Hello
Trying to CONCAT several fields into one with carriage in a Dreamweaver/php
recordset
I found an example for MS SQL
SELECT recid, CoName, Drive, Del_Proj,
'Co: ' +CoName + CHAR(13) + 'Acct: ' + Acct + CHAR(13) +'Drive: ', Drive) AS
Info
FROM data
ORDER BY recid ASC
Desired Result:
Co:
(such as some files other than MySQL's
table files) that may be preventing the deletion of the directory.
(Check /etc/my.cnf for the location of your database directories. RedHat
usually puts them in /var/lib/mysql.)
Let us know if that was the problem.
--John
PS Remember to reply
specific?
Where do you want to store the count?
What do you mean by "if there was data on this day"? Does the design of
the table anticipate no more than one record per day? Does each record
correspond to a single day?
--John
--
MySQL General Mailing List
For list archives: http://lists
words? Thanks in
advance.
What version of MySQL are you running? The ability to specify the
minimum length for fulltext search was not always supported.
--John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
diff, tracks
WHERE access_diff.DiffLevel = 'varKoshi'
and accesses.Access_ID = access_diff.Access_ID
and tracks.Kvish_Access = 'varKvish'
and accesses.Track_ID = tracks.Track_ID
and sites.Site_ID = accesses.Site_ID
The problem is that not every time all the correct reco
words? Thanks in advance.
From: John Hicks [mailto:[EMAIL PROTECTED]
What version of MySQL are you running? The ability to specify the minimum
length for fulltext search was not always supported.
Taco Fleur wrote:
Hi, that would be version 5.0.18 - thanks
Then your version is not the pr
t TCP socket connection to a
common IP address:port (10.10.10.10:1234)
(If you want simultaneous connections, each TCP connection will be to a
different port.)
But rather than write a client and a server application from scratch,
why not just use HTTP POSTs?
"Keep It Simple, Stewart."
blg_article_art.id_art = blg_comment_com.idart_com
group by blg_article_art.id_art
Try it in the mysql console before you try to plug it into php.
(You can only learn so much at one time :)
--John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
-Patrick wrote:
John Hicks wrote:
-Patrick wrote:
Folks, I could really use your assistance.
Take a look here: http://pastebin.com/687889
How can I manipulate totalRows_numberComments so that I get the number
of blg_comment_com.idart_com PER blg_article_art.id_art? Right now, it
produces
What is the best way to create a coded field? I want to do something
similar to enumeration but I don't want to have to define the values at
table creation time because sometimes the end-users need to add or remove
the codes.
I've been using char binary fields in my database to this point fi
Bing Du wrote:
The following are Cold Fusion code. It's interesting that previously
defined queries can be used as 'tables' to pull data from.
===
SELECT db_entry_num, title
FROM account_info
SELECT projectID
At 01:41 PM 5/5/2006, sheeri kritzer wrote:
The best way to do it is NOT to make new codes. If they're giving you
codes, use theirs -- why make up a new system if you don't have to?
[...]
Well, I made up my own codes before I knew I had to import data from
somewhere else. I was quite happy with
Hello,
(linux novice: windows user migrating to linux)
Hoping someone can point me in the right direction. Install of
MySQL-server-standard-5.0.21-1.sles9.i586.rpm is failing
with following error msg: "mysqld got signal 11".
I have 2 Suse 9E systems and mysql installs fine on one but not the oth
tony yau wrote:
Hello,
I can get a select result like the following: (SELECT ID,Changes FROM
mytable WHERE somecondition;)
IDChanges
-
1 10.0
1 10.3
1 12.2
2 31.0
3 1.02
3 4.9
how can I get the above result sets into
tony yau wrote:
Hi John,
tried your suggestion but I can't get it to work. This is because I don't
know how to set conditions in the following clauses (because there isn't
any)
and Table1.[condition for Changes1]
and Table2.[condition for Changes2]
and Table3.[condition for C
[EMAIL PROTECTED] wrote:
Hi to all!
I have "products" table:
CREATE TABLE `products` (
`prod_id` int(8) unsigned NOT NULL auto_increment,
`prod_no` varchar(50) NOT NULL default '',
`prod_name` varchar(255) NOT NULL default '',
`prod_description` text,
`prod_colors` text,
`prod_inclu
[EMAIL PROTECTED] wrote:
Ok. Got it.
And, since the able is already created and with tons of products inside,
how can I change the FULTEXT index?
I'm using phpMyAdmin.
Just create a new index.
http://dev.mysql.com/doc/refman/4.1/en/create-index.html
--J
[EMAIL PROTECTED] wrote:
Hi to all!
Bedford Bob wrote:
I'd like to retrieve the total amount of time the articles have been in the
site from 2005-01-01 to 2005-01-31 and divide them by 365 (or 366 if leap
year).
if an article has been online from 2004-10-01 to null (meaning the article
hasn't been sold yet) then I may count 365 da
Steve wrote:
thank you for the clue of double quoting the html when inserting into the
database but I still get the error. the problem seems to be that I have
quotes INSIDE the html code as well (links and pix) so, i still get this
error.
"
Database Selected: candlecatalog
Query: insert in
Mark Sargent wrote:
Hi All,
I am looking at OSCommerce for design comparisons and wonder what others
think about the below table design,
CREATE TABLE `customers` (
`customers_id` int(11) NOT NULL auto_increment,
`customers_gender` char(1) NOT NULL,
`customers_firstname` varchar(32) NOT NUL
mos wrote:
At 10:10 AM 5/20/2006, Keith Roberts wrote:
http://www.phpmyadmin.net/home_page/index.php
I think phpmyadmin will allow you to make changes to
multiple columns at once.
Sorry, I should have mentioned I was looking for a MySQL Administrator
running on Windows. Going through PHP see
I need to write a query that essentially does both a left and right join. I
have a list of people and the rooms they occupy. Some rooms have no people.
Some people have no room assigned.
This gives me a list of rooms and how many people are in each room
including any rooms with nobody in th
Setup
TITLES:
TITLE_ID
AUTHORS:
AUTHOR_ID
TITLE_AUTHOR:
(TITLE_ID,AUTHOR_ID)
Problem:
Given a title, I need to find all the authors who aren't connected with
that particular book.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
Rhino wrote:
- Original Message - From: "John Meyer" <[EMAIL PROTECTED]>
To: "List: MySQL"
Sent: Tuesday, May 30, 2006 5:09 PM
Subject: Query problem
Setup
TITLES:
TITLE_ID
AUTHORS:
AUTHOR_ID
TITLE_AUTHOR:
(TITLE_ID,AUTHOR_ID)
Problem:
Given a tit
Chris Sansom wrote:
At 19:44 +1000 31/5/06, Logan, David (SST - Adelaide) wrote:
I would agree, I have found it useful as well. It does have a few
limitations (well the versions I've used)
BTW, what are the limits on OpenOffice's Base being used as a front end?
--
MySQL General Mailing List
F
tedd wrote:
Yes, I was wondering that myself considering the onslaught of "no-no's" one
gets by suggesting placing images into a dB. A PDf file is really not that much different
and probably better served via file system.
tedd
On the other hand, you get control of the images, as opposed to r
tomáz rezistänz wrote:
I wish I could uninstall mySQL and start over but I don't know how..
On 6/7/06, tomáz rezistänz <[EMAIL PROTECTED]> wrote:
Do you know how to dump your mySQL databases?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
on on something like this, or give me a nudge in the
right direction. TIA
--
John C. Nichel IV
Programmer/System Admin
Dot Com Holdings of Buffalo
716.856.9675
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Adrian Bruce wrote:
John
I think you are saying you want the "Mode"? if you are then the
following might work:
SELECT col2 as val, count(col2) AS cc
FROM my_table
GROUP BY val
ORDER BY cc DESC
LIMIT 1;
in your case this will retrun the value '2'
Regards
Ade
Than
t col2
from tbl
group by col2
having count(col2) >= 2
order by col2;
+--+
| col2 |
+--+
|1 |
| 2 |
+--+
2 rows in set (0.00 sec)
Dan
Thanks Dan, that's what I'm looking for
John Nichel wrote:
Running MySQL 4.0.20 on a RHEL3 box.
Hi,
I'm tryi
tchdog and system.logs show
nothing. I have culled the following panic.log - can anyone tell if
MySQL is the cause of such?
Has anyone seen MySQL 4 crash on an Xserve (G4 specifically)? I have
tried two totally different servers, and the problems continue.
- John
*
Mon Jun 12 06:
Nope, no backups happening at the time.
Anyone other ideas?
- John
At 11:42 AM -0500 6/12/06, Dan Buettner wrote:
Hi John -
Yes, at my former workplace, we had a couple of different instances
where we experienced severe crashing problems on G4-based machines.
Prior to using a G4
Is there any way with this tool, or some other tool, to monitor the
amount of data (in KBytes or the likes) returned by a particular
query?
- John
The first version of MyMonitor is now available in source form on
sourceforge and can be downloaded from:
http://sourceforge.net
Sounds great. Being able to track the amount of data from requests -
even having something like a slow query log but a "large query log"
or the likes - would make a BIG difference in tracking down
performance issues. Thanks!
- John
At 4:02 PM +0200 6/16/06, Anders Karl
1 - 100 of 1882 matches
Mail list logo
