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 to
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
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
tables,
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
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
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
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
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
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
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
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
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
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.
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
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
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
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 relate
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.
Aftab
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
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]
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
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 putting
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
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 NULL
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
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. :-)
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
-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
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 deletes
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 data
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 message
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
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
33 matches
Mail list logo