At 21:08 2003-08-10, you wrote:
On Sun, Aug 10, 2003 at 05:25:05PM -0700, James Johnson wrote:
>
> I have a MySQL database for books. The ISBN field is set as varchar(15) and
> I've put a test ISBN number in of 1--111-11.
Note that ISBN numbers are a maximum of 13 characters, not 15. Ten
digit
At 08:15 PM 8/10/2003, you wrote:
I have a table I'm using for logging purposes with a schema like:
create table results (
user varchar(255)
);
Where user is not a unique field and I want to find out how many unique
users there are in the table.
I want to do something like:
select co
this is a Perl script, not shell ...
#!/usr/bin/perl
use strict;
use DBI;
# change the next four to match your network
my $SLAVE_IP= '0.0.0.0';
my $MASTER_IP = '0.0.0.0';
my $USER= 'user';
my $PASSWORD= 'password';
my ( $dbh, $sth, @masterResult, @slaveResult, $i );
$dbh
I'd cross post to the mysql-java/jdbc mailing list... Most likely you
need to modify mysql config to allow larger packet sizes.. search the
list archive/website for max_allowed_packet info..
On Fri, 8 Aug 2003, Ma Mei wrote:
> Dear administrator,
> Now I have a quesion and want to get your help
adrian GREEMAN wrote:
> I have also read the manual section on this {as I should have
> done] to try and understand it
> and how to enable reading a local file - the discussion section
> seems confusing and confused.
>
> I tried following what others have done and
> modified the ini file with set-v
Perhaps just something trivial but both numbers are differing:
> SELECT * FROM book_details WHERE ISBN = '1---1'
and
>and I've put a test ISBN number in of 1--111-11
In any case I have ran a test on my servers with mysql V 4.0.13 and things
work accordingly.
Thanks,
Aaron Holmes
[
I have a table I'm using for logging purposes with a schema like:
create table results (
user varchar(255)
);
Where user is not a unique field and I want to find out how many unique
users there are in the table.
I want to do something like:
select count(count(*)) from results group b
Hi,
I have a MySQL database for books. The ISBN field is set as varchar(15) and
I've put a test ISBN number in of 1--111-11. Can someone tell me why
this SQL query isn't working?
$ISBN = $_GET['isbn'];
$query = "SELECT * FROM book_details WHERE ISBN = '$ISBN'";
Since the field is a varchar,
>
>
> > Ok, I know it WAS there because we have two similar tables
> that should
> > contain sister records. One table has a record the other
> doesn't so
> > it had to have been deleted. I need to find out WHEN it
> was deleted.
> >
> > How do I create a log of record deletes?
> >
>
>
Does it restart or just shut down? Do you have to start it up in the
morning? And is there a specific time at which this happens? If you don't
have logging on, you should consider turning it on for debugging purposes.
After it happens again, check your error log (should be in your data
directory -
David,
Firstly, to answer your question I don't know of a MySQL function that
may allow you to sort indirectly by the contents of a field - there are
many many functions and some of them are very specialised, and if you
ever move to another db all those great little functions may not be
there. Howe
I have a table with a column "date" that contains dates in SQL format,
i.e. 2003-08-10
I need to query the table and return all the rows from the current date
thru the next 6 days. (i.e. today 2003-08-10 thru Saturday 2003-08-16).
I have tried the following query which returns all of the desired
Andreas wrote:
Bill Hernandez wrote:
I followed the install instructions at http://entropy.ch , and was
able to
get mySql & php installed on my G4 -> (OSX 10.2.6) last night. I
downloaded
Navicat and setup a password for the mysql user. I created a connection
called myDatabase_connection to a
Hi,
I've been writing software on the mac since 1987, but am brand new at
unix/php/mysql, and that's where I'm headed so I'm reading everything I can
get my hands on, but like anything else there's going to be a learning
curve, that having been said...
I followed the install instructions at http:
Hi!
On Aug 05, Justin Hopper wrote:
> On Tue, 2003-08-05 at 10:57, Paul DuBois wrote:
> > At 10:30 -0700 8/5/03, Justin Hopper wrote:
> > >
> > >I have a table with a FULLTEXT index on a column of type 'text'.
> > >Searches on this table using MATCH() AGAINST() work fine for most
> > >words. Howe
Unfortunatly, I'm stuck using mysqld version 3.23.54 :(
Original Message Follows
From: Victoria Reznichenko <[EMAIL PROTECTED]>
Date: Fri, 08 Aug 2003 18:29:45 +0300
"Paul Mahon" <[EMAIL PROTECTED]> wrote:
> Hello, I recently managed to corrupt a table pretty badly. I read the
> sections i
On Thu, Aug 07, 2003 at 01:41:57PM -0700, Jennifer Goodie wrote:
> I have a stand alone database server. It is a RAID5 running mySQL 3.23.55
> on FreeBSD 4.1 and has 768MB of RAM, I'm not sure on the processor speed,
> but I think it's a P3 1GHz. It has several tables with 20-40 million rows
> an
Todd and Guys,
Your advice helped me too. I think either Apple screwed up when set up
/tmp directory to be writeable by root only or since MySQL package has bug
or shall be installed ONLY as root user.
- Nicos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On Wed, Aug 06, 2003 at 11:39:26AM -0400, walt wrote:
> On Wednesday 06 August 2003 11:26 am, Andy Smith wrote:
> > > Andy,
> > > I just noticed that you have
> > > a mix of port numbers. Can you try
> > > `netstat -an | grep 3306`
> > > from the command line and see if the master is indeed listeni
At 07:00 PM 8/6/2003, you wrote:
Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm considering
moving to a P4 2 Ghz with the same amount of RAM. I have a few specific
tables with several million rows of data, and it takes quite a long time to
process that data on my current server. D
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Sat, 26 Jul 2003, Zenon Panoussis wrote:
> > Can I safely comment out everything after %install on
> > that line, or will something else break?
>
> The %install section finished successfully that way, but then
> the next problem popped up:
>
>
I'm writing a function for Perl module I'm writing that will allow you to do
$query = "SELECT".DBIallexcept($dbh,'fred','wilma')."FROM monkey";
If that will help. Let em know and I'll notify you when it's done.
Thanks
Dan
>>
> As Victoria says, you can't. However I agree that this syntax
>
On Wed, Jul 30, 2003 at 12:34:54PM +0800, unplug wrote:
> I use rpm to update the previous version. I can use innodb in redhat 9
> with version 2.23.56. But it failed in redhat 7.2. I wonder it is the
> kernel problem.
Why would you suspect the kernel? How did it fail?
> BTW, I want to ask
Jennifer Goodie wrote:
I have a stand alone database server. It is a RAID5 running mySQL 3.23.55
on FreeBSD 4.1 and has 768MB of RAM, I'm not sure on the processor speed,
but I think it's a P3 1GHz. It has several tables with 20-40 million rows
and a ton of smaller tables with less than 1 millio
I'm baffled by reaching a limit of between 1456 and 1458 connections, at
which
point I can no longer make new connections. I've tried compiling my own
MySQL and using the stock MySql RPM's. I've experimented with ulimits,
values in my.cnf, and kernel parameters, and all the permutations of the
The fact that you have "several millions of rows" may indicate that you
have an I/O problem, not CPU.. do some benchmarking. and perhaps the
solution is going to (if not already) SCSI drives, or some kind of raid
configuration (recommend raid 0+1)
Or if you want to keep costs low.. perhaps using
Hi all,
I think you misunderstood me. :-) I try to be more detailed, and I will
also give an example.
So, I have these two tables:
CREATE TABLE main (
ID int not null,
Value int,
primary key (ID)) Type = InnoDB;
CREATE TABLE sub (
MainID int not
you can create/alter the particular column with 'zerofill' attribute set. i.e.:
create table books (isbn bigint(16) unsigned zerofill, somemore varchar(100));
-yves
-Ursprüngliche Nachricht-
Von: "Eben Goodman" <[EMAIL PROTECTED]>
An: <[EMAIL PROTECTED]>
Gesendet: Dienstag, 5. August
28 matches
Mail list logo
