Zak Greant wrote:
Heh. There are still some gems like this in the manual.:)
I have let our documentation team know about the awkward wording.
Just use the term gender instead of sex and everyone will be happy :-)
(Esp. the people searching for 'animal sex' on Google ...)
--
Michael T.
bump?
The content of this email when sent is as full as practical. Due to the
settling of the words the contents might not appear as full as it was but
the weight remains the same. The contents is being sent by weight and not by
volume.
- Original Message -
From: pazenko [EMAIL PROTECTED]
At 9:24 -0600 2/5/03, Jaime Teng wrote:
I have a MySQL table:
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-++
| id
At 14:19 +1000 2/5/03, boclair wrote:
I notice some of my colleagues using SET in INSERT statements.
DuBois makes a short reference on p565, DoorStop1.
The reference is short because there isn't much to say about it. :-)
The SET clause consists of col_name=value assignments, separated
by
I can't think of a way to do this, any help is appreciated =)
Imagine the following tables
table usr (holds all users)
id (int) | name (varchar)
table clanlist (holds all clans)
id (int) | name (varchar)
table clanmembers (holds all members of all clans)
uid (int, points to a user in usr) |
You need to delimit them:
INSERT INTO table VALUES ('value','Don\'t know','');
If you're inserting via PHP, you need to add a backslash before
apostrophes or commas in the post data, as apostrophes and commas are
used by MySQL to delimit fields on INSERT statements.
It's also in the manual,
Hi,
I am new to SQL. I am attempting to create a database that was created in
MS SQL to MySQL. The below SQL statements works with MS SQL.
I am executing the following:
CREATE TABLE 'Accounting'(
'Username' VARCHAR(254) NULL,
'CallerID' VARCHAR(128) NULL,
'Addr'
In the last episode (Feb 05), [EMAIL PROTECTED] said:
create table if not exists CBI (date DATE not null, close DECIMAL(10,2), high
DECIMAL(10,2), low DECIMAL(10,2), volume MEDIUMINT, yest DECIMAL(10,2), PRIMARY KEY
date (date))
Query OK, 0 rows affected (0.00 sec)
insert ignore into CBI
HINT:
I have used PERL to generate random numbers and then do a SELECT on the
auto_increment field in the mysql table, thus generating random picks from
my tables;
I'll be glad to bet informed of better ways around, though :)
Thanks
Aman Raheja
AGF Inc.
- Original Message -
From: Tue
Version: Mysql 4.0.10-gamma
Description: Innodb fails to follow the foreign key rules after alter table.
This bug can be done in several ways.
How to repeat
These variations gives same errors.
1st bug example:
drop table if exists parent;
drop table if exists child;
CREATE TABLE parent(id
[±¤°í] ³¿»õ ¶§¹®¿¡ ºÒÆíÇÑ.???
¾ÇÃëÁ¦°Å. °õÆÎÀÌ±Õ ¹ß»ýÁ¦°Å. °¢Á¾ ¼¼±Õ ¾ïÁ¦. ½Å¼±µµ Áö¼ÓÀû À¯Áö. ÀÎü¿¡´Â ÀüÇô ¹«ÇØÇÑ
õ¿¬ Ç×±Õ ¾ÇÃë Á¦°ÅÁ¦.
1. ½Ç³» ´ã¹è ³¿»õ ¹× ¼ú ³¿»õ ±âŸ À½½Ä ¸ðµç³¿»õ.
2. ³ÃÀå°í ³¿»õÁ¦°Å ¹× ½ÄÇ° ½Å¼±µµ Áö¼Ó À¯Áö.
3. ¿ÊÀå ¼Ó¿¡ °õÆÎÀÌ ³¿»õ
I want to create reports that can be printed to a printer, select a font and
a size for each field, etc.
Perl and PHP can't do that.
Well, perl could do that if using a post script printer... but I don't have
such a printer and it is very hard to do it anyway.
Teddy,
Teddy's Center:
Yes I have a question regarding Crystal Reports, but ... I don't know if you
can help me.
I am blind and I would like to know if this program has an interface
accessible for a screen reader.
Thank you.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message
Scott,
I would like to declare this as a 'feature'. You should not define multiple
foreign key constraints on the same foreign key/referenced key pair.
I could, of course, add an error message if someone tries to do that.
The algorithm in ON UPDATE CASCADE and ON DELETE CASCADE is this: InnoDB
I'm not getting mail, so I'm seeing if I can send. If you get this,
plesae disregard.
Adam.
sql query
---
Adam Randall http://www.xaren.net/
[EMAIL PROTECTED]
Hi!
A rather serious bug was introduced to 4.0.10 in connection of another bug
fix.
If you have a composite key (col1, col2) in an InnoDB table, then a query of
type
SELECT ...
FROM ...
WHERE col1 = x ORDER BY col2 DESC;
may hang in an infinite loop.
The fix is in 4.0.11.
Best regards,
Hello!
I have a following system.
Server A : a master for server B. MySQL 4.0.9
Server B : a slave for server A, a master for server C. MySQL 4.0.10
Server C : a slave for server B. MySQL 4.0.10
and I wanna that if update occurs on A, it forwarded to B and B forward it to C
But I don't know how
Dear listers,
can anyone shine a light on this one...
I have some HTML page-titles which i'd like to put in a dropdown menu. Least
load for server is when just using a server-cursor. And going trough the
results just once.
So best thing is to order the titles in the right way when recieving
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: boclair [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, February 07, 2003 8:47 AM
Subject: Re: Using SET in the INSERT statement
: At 14:19 +1000 2/5/03, boclair wrote:
: I notice some of my colleagues using SET in INSERT
Jennifer,
It is the third alternative syntax.
or INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name
SET col_name=(expression | DEFAULT), ...
[ ON DUPLICATE KEY UPDATE col_name=expression, ... ]
Louise
- Original Message -
From: Jennifer Goodie [EMAIL
- Original Message -
From: Keith C. Ivey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 06, 2003 6:47 AM
Subject: Re: Using SET in the INSERT statement
: On 5 Feb 2003, at 14:19, boclair wrote:
:
: I notice some of my colleagues using SET in INSERT statements.
:
:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Richard --
...and then Richard Morton said...
%
% Hi,
Hi!
%
% I am sorry this is a bit off topic.
%
% I am looking for recommendations of MySQL / PHP / HTML / Javascript development
% companies.
What about independents and freelaners?
%
%
Description:
Running a particular query, a REPLACE into a very large table (~2Gb)
causes MySQL to crash with a segmentation fault. I don't know whether the
destination table is corrupt, but myisamchk doesn't think so.
The query is rather long, I'm afraid, so I've elided some fields (also in
the
I have an application that works just fine on a local MySQL database
when it is running on W2K or Windows XP Home. However, on Windows XP
Pro, the application has problems keeping its connection to the server.
Has anyone else seen this and is there a known cause or fix?
Weve tried this on
On Wed, Feb 05, 2003 at 09:24:22PM +1100, Dan Rossi wrote:
hi there i was wondering if mysql 4 will become production quality soon ? i
would like to convince work to start using it, so i can start using the
transactions, sub selects and query cache
We've been using various builds of 4.0.x in
Hi!
this is a beginner's question about MySQL. I have looked at the online MySQL
documentation and have not found an answer.
I am looking for suggestions to read a fixed-column format file into a
MySQL database with about 50,000 observations and 400 variables (fields).
Each
variable is in
I am about to upgrade mysql to version 4
My question is, is there a simple rollback method in case it fails,
I will be doing it on a production server via rpm's and I don't wish for
it
To be killed for a long period of time...
Any comments would be nice
Hi,
Can any of you give me links about Archiving and restoring the data in
MySQL database. Are there any utilities for the same?
Thanks in advance,
Ram
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hello,
If it's a documented feature which I've missed - please excuse, but after
upgrading from 4.0.2 to 4.0.7 the following sql statement started to
behave differently then before:
select Sections.ReportName, Creatives.Name,
from HourlyStats natural left join Sections
left join
On Tue, 4 Feb 2003, Kees Hoekzema wrote:
I had the same problem, it went on until I had 44G of InnoDB space, with only
4G free. After getting tired of having to increase the number of files every
week, I decided to dump all data with mysqldump, remove the files+ logs and
recreate them. After
yes i am aware that sub selects are in 4.1, i'm pretty sure i have it
running @ home, there are some large traffic sites i would like to lighten
up and make a bit faster code wise with query caching and sub selects, but i
havent been told what gamma means ?
-Original Message-
From: Josh
I am creating a java application and am using tomcat. I would like to be
able to use mySQL in embedded mode, is this possible? you mentioned in
this thread that it could be made linkable in a java application, can you
tell me what needs to be done to achieve this?
Regards
Lucia
Hello all,
My name is Vikram Vaswani, and I'm currently working on the outline for a
MySQL reference book. This is supposed to be a comprehensive reference to
MySQL 4, covering all aspects of the software, including the new
transaction/subquery features.
I have put together a draft table of
Ok, trying to create a table in a mysql database via php script.
heres the code:-
?
$user=username;
$password=password;
$database=database;
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( Unable to select database);
$query=CREATE TABLE contacts (id int(6) NOT NULL
Marg,
MB The start up looks good: when I use the Run function
MB C:\mysql\bin\mysqld-shareware.exe, the black DOS box comes and goes, but
MB I'm getting this error when using the MySQL test script (See below):
I didn't know MySQL was shareware, well ... The problem you describe
is caused by
Anirudha,
AK could anybody please send me some details showing the performance of the
AK mysql server usder varying loads as compared to db2 server
Take a look: http://www.mysql.com/doc/en/MySQL_Benchmarks.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Narciso,
NMR select nome from categorias where id_categoria in (select id_categoria
NMR from categoriamembro where id_membro=1807)
MySQL supports subselects starting with version 4.1. AFAIK there are
no binary distributions available for 4.1, so you either have to
compile it yourself or wait a
Hello,
If it's a documented feature which I've missed - please excuse, but after
upgrading from 4.0.2 to 4.0.7 the following sql statement started to
behave differently then before:
select Sections.ReportName, Creatives.Name,
from HourlyStats natural left join Sections
left join
Any ODBC compliant reporting tool should work with MySQL.
Have you tried using Crytal Reports???
Regards,
Shamit Verma
- Original Message -
From: Octavian Rasnita [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Tuesday, February 04, 2003 11:40 PM
Subject: Applications for creating
Hi All,
I had the same problem on MySql server 3.23.43 on
Solaris platform but, so far, I don't know how
to solve it. Can you help me?
Thanks in advance. Regards.
Stefano Bruno Grenci
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Stefano Bruno Grenci ([EMAIL PROTECTED])
Ion Trading System
I was using Mysql on win XP downloaded from www.mysql.com site. All was
working good. Hmmm from that error message I assume you don't have Mysql
running...did u start it? Hmm sorry i don't remember right exe file to
execute in windows to start mysql...i am working on linux mandrake now :(..
Dan,
DR this is exactly what i am asking , when u say new gamma development
DR release (use this for new development) what does it all mean , is it
DR stable for production use ? i would like to know to convince work to start
DR using it ?
This discussion is in the list archives a couple of
mysql:ÄúºÃ!
×ð¾´µÄÅóÓÑ,¹ýÄêºÃ!
Ê×Ïȱ±¶·Ðǹ¤×÷ÊÒÔÚ´ËÏòÄúÖ£ÖØÉùÃ÷£ºÈç¹ûÄúÊÇÒ»¸ö֤ȯͶ×ÊÕß,Õâ¸öÓʼþ¶ÔÄúÀ´½²¾ø²»ÊÇÀ¬»øÓʼþ¡£
ÓµÓÐÊ®Äêʵս¿´Å̾ÑéµÄְҵͶ×ÊÈË¿ª·¢µÄ¡¢Á¢×ãÓÚÖйú¹ÉÊÐʵսµÄ¡¶±±¶·Ðǹ¤×÷ÊÒ¡·ÍøÕ¾
http://www.21cnstock.com
If you have id_categoria in both tables why don't you use join?
Try this:
select nome from categorias inner join categoriamembro
on categorias.id_categoria=categoriamembro.id_categoria
where id_membro=1807
[]s
Anderson Pereira Ataides
Em Qui 06 Fev 2003 00:31, you wrote:
Is this possible
Hi,
I use it in queries like
SELECT * FROM table WHERE field REGEXP patern;
It is the same as using the LIKE operator wit more complex patterns
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com
- Original Message -
From: Darren Young [EMAIL PROTECTED]
To: [EMAIL
Hi,
Isn't there a way to reduce the number of rows that are scanned based on an
index - for example
the query
SELECT * FROM email WHERE id100 AND subject = 'RE: TEST EMAIL' ORDER BY
`id` DESC LIMIT 0,25;
will be significantly faster (it will scan less rows) and will most probably
return the
Martin Hudec wrote:
Hello,
I would like to know what are limitations for mysql in number of records, size
of records, size of tables etc.
Can anyone help me please?
You could see information about it on:
http://www.mysql.com/doc/en/Features.html
http://www.mysql.com/doc/en/Table_size.html
Are you running mysql or mysql-max? InnoDB is not supported in standard
mysql. If you are running max then are there any error messages?
Extranet
[EMAIL PROTECTED] - 05/02/2003 17:17
To:mysql
cc:
Subject:innodb
I have a small probleme with MySQL in 3.23.55.
I do not manage to
Sadly MySQL does not support sub-selects yet. Take a look at the manual for
suggestions of ways around it.
Keith
Extranet
[EMAIL PROTECTED] - 06/02/2003 02:31
To:mysql
cc:
Subject:Can mysql execute this ? how can i do this ?
Is this possible
select nome from categorias where
SQLyog v3.02 - The definitive Windows Front End for MySQL, has been
released. It is a superfast, compact and easy to use Front End for MySQL. A
must for MySQL developers. SQLyog is FREE!
Some of the new features added in SQLyog 3.02 are -
-- ODBC Import. The simplest and the most powerful tool
Hi,
I've seen there's a problem with the mysql binaries on linux, does anyone
know if this also affects FreeBSD?
I cannot get access to the database via jdbc. I am using the
mysql-connector-java-2.0.14-bin.jar, mysql version 3.29.49, on freebsd 4.5,
and get the following stacktrace:
http://www.mysql.com/doc/en/Table_size.html
More lightly to be file system than dB I think depending on the version.
Jerry
Apps-RD
Cable and Wireless
- Original Message -
From: Martin Hudec [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Oh yes thank you Jerry this is what i was looking for. Hmmm as far as for
maximum number of rows, it can be defined it seems by MAX_ROWS parameter
while CREATE TABLE :).
Thanks
On Fri February 7 2003 14:38, Jerry wrote:
http://www.mysql.com/doc/en/Table_size.html
More lightly to be file
Hello,
I'd like to practice my C application for using mysql.
Do you know where can I find some examples?
Which header files should I include in my code?
And which lib.a should I link to?
Many Thanks.
Qin
This E-Mail and any attachment is intended only for the person or entity for
which it
Hello,
I am using Version : 3.23.40 under Linux and 3.23.51-Max under Windows XP
I get the following error message while dumping my database. The
segmentation fault is caused by the -c option. (It also occurs under
Windows XP).
Pierre-Yves Saumont
Red Hat Linux release 6.2 (Zoot)
Kernel
Martin Hudec wrote:
I would like to know what are limitations for mysql in number of records, size
of records, size of tables etc.
Check the free online user-commented manual first, ask any questions you
still have afterward.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
Just out of comment ... couldn't (shouldn't?) MySQL's replication been
set up as a seperate process altogether from the server process?
Replication *could* be done in its present form (afaict) by running
something like:
tail --follow=name --retry -n0 query_log | grep -v SELECT | mysql
Below is a little PHP code snippet which works great(returns results quickly)
for single
queries. However when I put this code into a loop incrementing the order_index
and line,
my application can take as long as 2 minutes to return results. Is there any
other way
to execute this series of queries
I am using MySQL 4.0.10 on Windows. If I process SELECT @@whatever (where
whatever is not a valid global variable name), the connection is closed.
Is this by design? Then it should be documented. Otherwise it is probably a
bug.
Best wishes,
Michael Kofler
http://www.kofler.cc
59 matches
Mail list logo