I am looking for code that will take an SQL command and break it into it's parts. I
have found some attempts, but none that use the
code from an actual SQL engine, and big surprise, they don't work 100%.
I have a few goals:
1) developer tool: cut/paste the SQL command and get a pretty format di
On Thu, Nov 06, 2003 at 05:08:54PM -0700, Jeff Mathis wrote:
> our database is about 20 Gb and growing daily. so far, I still see
> nearly constant time query performance on tables with ~10M rows. I don't
> think mysql is limited by file size per se.
It is limited to the extent that your operating
On Thu, Nov 06, 2003 at 01:48:46PM -0600, Paul Fine wrote:
>
> Thanks. I tried that awhile back to no avail.
Hmm.
> Am I correct that I should be receiving only a single large e-mail
> each day? Thanks!
Unless something is misconfigured, I'd expect you to get one message
per day--unless the mess
On Tue, Nov 04, 2003 at 08:45:08PM -0500, Jonathan Terhorst wrote:
>
> I could have sworn I posted this once before, but apparently it got
> lost somewhere. Apologies if you're seeing this twice:
>
> I'm wondering what I can do with MySQL to optimize reads (SELECTs)
> on a read-only table where da
On Sat, Nov 08, 2003 at 10:40:25PM -0600, Michael Satterwhite wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> This has got to be a common question, but I'd really appreciate a little help.
>
> I recently reinstalled my Linux (SuSE 8.2). I *KNOW* I don't have a cron run
> that delete
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This has got to be a common question, but I'd really appreciate a little help.
I recently reinstalled my Linux (SuSE 8.2). I *KNOW* I don't have a cron run
that deletes this.
When I try to start mysql, I get the message
"Can't connect to local MySQ
atleast: d-dd-d
0-00-0
9-99-0
select count(*) from processes where
`in` regexp "[0-9]{1}-[0-9]{2}-[0-9]{1
}";
for:
00-00-0
99-99-0
select count(*) from processes where
`in` regexp "[[:space:]][0-9]{2}-[0-9]
{2}-[0-9]{1}";
for
00-00-0,
99-99-0,
select count(*) from processes where
At 8:50 -0800 11/7/03, Herb Rubin wrote:
Paul,
TINYBLOB does seem to hold the value properly.
I can't use a TINYBLOB in a primary key. Is this not allowed?
The ALTER statement complains that I am using a column without a length
specified.
Specify a length, then. :-)
http://www.mysql.com/doc/en/I
At 10:49 -0800 11/7/03, William R. Mussatto wrote:
Paul DuBois said:
At 15:29 -0800 11/6/03, Herb Rubin wrote:
Paul,
I did try VARCHAR(16) BINARY and it still failed to INSERT in a NOT
NULL column.
The encrypted string seems to be equivalent to the NULL value even
though it visually looks like
Hi William,
- Original Message -
From: "William R. Mussatto"
Sent: Friday, November 07, 2003 12:49 PM
Subject: Re: aes encryption bug
> Paul DuBois said:
> >
> > Okay, I investigated this further and I believe I know the cause of
the
> > problem. The solution is to use a TINYBLOB NOT N
Hi Herb,
You should be able to specify 255 as the PRI KEY length... I think.
CREATE TABLE table (
col TINYBLOB NOT NULL,
PRIMARY KEY (col(255))
);
Hope that helps.
Matt
- Original Message -
From: "Herb Rubin"
Sent: Friday, November 07, 2003 10:50 AM
Subject: Re: aes encrypti
On Fri, Nov 07, 2003 at 06:58:58PM -0500, karthikeyan wrote:
> how to rename a field name "IN" to something else..
> I could not use
>
> alter table tbl_name change IN NEW mediumtext;
>
I suppose this complains about a syntax error?
You can use any reserved word as fieldname (or tablename) by p
Sounds like there is a misunderstanding about what exactly a data type can
do. What you can't do is change the 'type' of a column with an UPDATE
command. You can do it with an ALTER TABLE command, but this would be a
_misuse_ of the command, given what you are trying to do.
You have one of 2 optio
because '-' is understood as "from" - "to" e.g a-z, 0-9, etc.,
Escape the '-' with a backslash: '\-'
JP
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have one query:
how to use regular expression to search
all digits of the pattern in MYSQL
X-XX-X
XX-XX-X
XXX-XX-X
-XX-X
X-XX-X
I tried
mysql> select * from database where field regexp
"(\d{2,5}-\d{2}-d{1}d{1})";
others:
*-*-*
??-??-?
???-??-?
(\d{2,5})?- etc, seems not working
Dear Lists & MySQL,
I have just released the site http://www.DhakaStockExchangeGame.com/
which uses MySQL database and CGICC heavily.
"I Like MySQL, cuz, I can twist,turn,roll and whatever I want with its
MySQL C API".
Thank you MySQL, you all are really good. Dont become sooo commercial.
Aft
if it just can't be done with a query please somebody
like Paul DuBois say so...
Colleen Dick wrote:
This stumped them in PHPbuilder...
I have a table lets call it moms
each row in the moms table can have many kids,
and some "kids" have >1 "mom". I have a kid table
and I have a mxk map table to re
At 10:38 -0500 11/8/03, karthikeyan wrote:
I have a table with about 100 column with different column name. It is
difficult to remember all the field
names. But I know the last few columns are very important for query and
used frequently.
You cannot perform comparisons on columns by using column po
Trying to solve a phpmysql array problem.
Let's say I have a table in mysql format
Column1 Column2
dog brown
cat white
cat black
cat mixed
pig black
pig brown
What kind of (query, array function, loop, etc...)
should I use to produce an html output
Hi all:
Trying to solve a phpmysql array problem.
Let's say I have a table in mysql format
Column1 Column2
dog brown
cat white
cat black
cat mixed
pig black
pig brown
What kind of (query, array function, loop, etc...)
should I use to p
For anyone else that stumbles over this problem, there were two
problems...
1. My firewall was blocking the remote mysql port (duh)
2. Unlike what I expected from reading the docs, I had to give my remote
user rights in the user table (Select_priv='Y', Insert_priv='Y', etc.)
to get a connection.
I have a table with about 100 column with different column name. It is
difficult to remember all the field
names. But I know the last few columns are very important for query and
used frequently.
For example:
Table with fields weight_42(double),width_43(double),height_44(double)
where the fields(4
OK thx to MATHAN's previous post.
Solution:
Executed the following commands..
# chown -R mysql /var/lib/mysql
# chmod 700 /var/lib/mysql
Then started the daemon.
Thx
-EKG
From: ekg1
To: [EMAIL PROTECTED]
Sent: Saturday, November 08, 2003 1:39 AM
Subject: Mysql daemon dies on startu
Hello
I have a table that gets appended to every night with the LOAD DATA command.
The column 'start' is a unix timestamp. So when the LOAD DATA is done I then
want to update the Column to be human readable.
I was thinking of the following:
UPDATE table SET start = UNIX_TIMESTAMP(start);
I issu
Hello!
My name is Vlad. I'm begginer with MySQL. And now I should like to know where can I
take good documentation, tutor or others about MySQL.
Thank you.
--
___
OperaMail free e-mail - http://www.operamail.com
OperaM
Sorry for the long post, but I'm using with difficulty the 2nd edition
of Welling/Thomson's PHP and MySQL Web Development as a textbook for
self-teaching.
After being pleased to work my way thru to Chapter 14, not memorizing
the earlier material, but having some success basically understanding
We add an auto_increment BIGINT to every table we create. This gives us the
essence and utility of ROWID (BTW we always name the first column in a new
table 'row_id').
Just my 2 cents
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW Florida's First ISP
825 SE 47th Terrace
Cape Coral, FL 33904
(23
Hi all,
I'm sorry, I know this is not the list, to ask this question, but I couldn't find the
right one.
I'm having trouble with BRU. I'm running it for quite a time but it has started
throwing errors. Main problem is, though there's plenty of free space on my tape
media, it says,
Insert vol
Hi Mark,
I understand that Dbvisualizer 4.0 has this function built in. There is a
trial version available at
www.minq.se
I hope that helps
Best regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql/
On Saturday 08 November 2003 16:37, Mark Horton wrote:
> I'm working on som
I have installed Redhat 9.0 and upgraded mysql thru RHN to
3.23.58-1.9
I executed the following commands:
[EMAIL PROTECTED] linux]# mysql_install_db
then
[EMAIL PROTECTED] linux]# /usr/bin/safe_mysqld &[1]
12018[EMAIL PROTECTED] linux]# Starting mysqld daemon with databases from
/var/li
In the last episode (Nov 07), Jeremy Zawodny said:
> > In Oracle for example, a ROWID is the unique address of a row in
> > the database. Every row, unique key or not has a unique address. Is
> > there such a thing in MySQL?
>
> No. If there was it'd be documented. But at least with MyISAM
> tab
I'm working on some software that will generate all sorts of statistics
on large volumes of data. I'm looking for data to experiment on. I'd
like 100 million - 1 billion records. These records can be anything
from log files to database records, or whatever. I just need tons of data.
If you
This stumped them in PHPbuilder...
I have a table lets call it moms
each row in the moms table can have many kids,
and some "kids" have >1 "mom". I have a kid table
and I have a mxk map table to relate them.
what I want to do is select all the moms and for each mom I want a
random one of its kids
33 matches
Mail list logo
