> I'm implementing a bridge between MySQL and Lotus Domino.
> In our application we realy need stored procedures (triggers).
> I saw that MySQL does not yet support stored procedures. (This will be
> one of the features of version 4.1). Is it worth to wait for version 4.1
> or should we switch t
Errata:
> We could use MySQL and imlement stored procedures outselves. (Using some
> scriptlanguages like perl or python).
A stored procedure is by definition a collection of SQL statement
stored and executed in the RDBMS, not an external script, etc.
//Anders - sql, query
---
> CREATE TABLE places (
> idp INT(8) NOT NULL,
Contex: SQL, database
Just curious, but is this a 8-bit (smalint maybe?) or approximate 8-byte integer?
-
Before posting, please check:
http://www.mysql.com/manual.php
Since I been working implementing some triggers in my system
recently this suggestion first came into my mind:
create a delete trigger for the user table. Every time a user it deleted,
the trigger fires and could for example moves this information to a history
table, with date of deletion, etc. T
Why do you want to restrict the names to be unique?
//Anders - SQL, QUERY
-Original Message-
From: Shaun Bramley
To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
Sent: 3-5-02 20:16
Subject: Re: Simple Question relating to Indexing
I'd like to first thank Carl and Anders for
> Hello all being relatively new on the SQL scene I must say some of the
> concepts are a little new and strange to me. My really big question is what
> is the difference between an index and a key? are the synonamous with each
> other?
A key will identifying a row or several rows. Just like yo
> I have a Where clause like:
> select count(*) from table where LIMIT 100
> Unfortunately the Count(*) ignores the LIMIT clause entirely. Why?
The answer is: Because the SQL query with COUNT(*) only returns one row...
-
sql,query
> "Salada, Duncan" a ecrit :
> >
> > Is anyone else getting auto-replies from [EMAIL PROTECTED] when they post
> > to the list?
All the f*cking time. I sent mail to "security" and postmaster and asked them
to please remove this user from the mailing list - no reaction so far.
> This question I am posting for a friend Below is post to another list...
>
As always the answer is: "It depends on!" ;)
> How does one create a self-join in MySQL tables? I've only played a little
> with SQL selects so far, some inner joins, and now I have to create a
> many-to-many rela
limit number of
connections/jobs on the machine, and then assume the
worst case scenario from this.
> -Original Message-
> From: Gelu
> Sent: Wednesday, May 01, 2002 6:12 PM
> To: Svensson, B.A.T. (HKG); Shaun Bramley
> Cc: Jason Yates; [EMAIL PROTECTED]
> Subject: Re: mysql sp
An webserver uses mostly CPU resources while a DB uses I/O, or?
Separation between the webserver and the RDBMS also suggest increased
delays with IPC. I think one needs to find a balance somewhere in between,
and I guess the only way to tell is to actually measure the performance of
the system t
> I'm not a suitable person to compare MySQL against other databases but MySQL
> will cope with this size of database if the tables are properly indexed and
> your queries optomised. Here our main database has over 90 tables and several
> of our tablse hold about the amount of data your'll acrue
JP> Is there any ability to put tables dynamic in a query?
JP> I have to do a select * for many tables and it would be cool if I
just do
JP> something like this
JP> select * from (select t from mytables).
JP> Thanks a lot,
>You can't do this with MySQL only. Using external programming - yes, sure
> Don't you think you should use
>
> select * from test WHERE a=0 ;
>
> not
>
> select * from test where 0;
>
> Isn't the correct usage of WHERE
Well, usually my queries could look like this:
insert into #report (Line)
select isnull(a.Object, '') + char(9)
+ isnull(c.ClusterId, '
oes not generates a syntax error here, this might
be a source of introducing faults in the system. That's why it is important
to know exactly how the system behaves. No I know this, but is there other
surprises that I would like to know about?
> On Tuesday 16 April 2002 11:21 am, Svensso
uates to true.
Also it seams like this is not ISO SQL, so it could be a bit tricky
to predict the outcome without actually having some specification of
the behavior.
//Anders
> -Original Message-
> From: Christopher Thompson
> Sent: Tuesday, April 16, 2002 6:24 PM
> T
Is this a documented behavior of MySQL(?):
mysql> create table test (a int);
Query OK, 0 rows affected (0.03 sec)
mysql> insert into test values(0);
Query OK, 1 row affected (0.00 sec)
mysql> insert into test values(0);
Query OK, 1 row affected (0.00 sec)
mysql> insert into test values(1);
Que
> You've already stated your lack of belief in the reliability of deadlines,
> so what did you expect? If someone had responded with "4.1 will be done on
> 5/1/2002" you'd respond that the only way that would happen would be if it
> were horribly buggy or lacked "critical" features -- if you hold
> > But I did ask for a release date of version 4.1.
>
> When it's ready.
That's a tautological answer.
> > A nice thing with a stored procedure is that you can lower the load
> > impact made by heavy queries on the database by using cursors to soften
> > the performance hit they are likely to
Did I ask for optimization tips?
Nope. ;)
But I did ask for a release date of version 4.1.
> -Original Message-
> From: Land, Christopher
> Sent: Friday, April 12, 2002 11:18 PM
> To: Jon Frisby; Mysql List
> Subject: RE: MySQL and stored procedures -> v4.1 :(
>
>
> 5.2.12 Other Opti
> > Checked my own version and found it to be "Ver 11.16 Distrib 3.23.49".
> >
> > He, version 11??? Quit confused, but after a sanity check with reality
> > I realized I must be using version 3.23. Anyhow, check the status of
> > next version and found out that version 4.0 is in alpha mode...
>
> Hello Everyone,
> I've only just started trying to use MySQL so please forgive my
> ignorance if this sounds like a really basic question!
> I am trying to search a text field within a table that contains
> several keywords; for example the column might be called
> "computer_descr
Installed MySQL and about the first thing I tried to create was a stored
procedure - failed.
Found out fairly quickly with a text search in the manual that stored
procedures is not to be introduced until version 4.1.
Checked my own version and found it to be "Ver 11.16 Distrib 3.23.49".
He, ver
23 matches
Mail list logo