At 21:47 + 7/9/03, Gustavo A. Baratto wrote:
Greetings,
What happens if I use the command below when innodb engine is running?
set global have_innodb=0;
You can easily find out by trying it. (Go ahead, nothing bad will
happen.)
I want to stop innodb engine without stopping the whole server
Hello Adam,
Wednesday, July 09, 2003, 4:46:40 PM, you wrote:
AG> I am writing an attendance system in php for my school. We have a
AG> little less then 1000 students. For every day of the school year one
AG> record will be entered into a table for each student representing their
AG> attendance
I have a database that is getting too big for the drive it's on. How do change my.ini
to make it see everything after I move the mysql/data folder?? or is there more to it
than that?? BTW - I'm running on Windows NT 4.0 SP6 w/ gig of ram...
Robin E. Kopetzky
Black Mesa Computers/Internet Service
Can't use REPLACE. The table contains a little more data than what's
supplied in the bi-weekly logfile. The REPLACE command will delete the
old record before inserting its replacement, which in this case would
lose the data in the other fields.
p
On Wed, Jul 09, 2003 at 03:50:42PM +0200, Rudy
At 2:30 -0600 7/9/03, P Srinivasulu wrote:
When Mysql runs on machine with multiple NIC's. Mysql server takes the
IP Address that we specify in the configuration file. This IP Address
may or may not be a primary IP Address of that machine. So we specify
secondary IP Address for the Mysql server. I
Greetings,
What happens if I use the command below when innodb engine is running?
set global have_innodb=0;
I want to stop innodb engine without stopping the whole server for
backup (most tables are myisam).
Any ideas on how to do that?
Thank all
--
MySQL General Mailing List
For list arc
At 14:14 +0700 7/9/03, Dominicus Donny wrote:
Sorry, my mistake. It's "reindexing" then.
Once i should add 2 key indexes on a huge table.
But instead of alter the table in 1 single query,
I build each index 1 by 1.
Generally, it is faster to build all your indexes with a single
ALTER TABLE statemen
At 8:19 +0200 7/9/03, mixo wrote:
The size is already set to 2000M, and I may be wrong, but the
autoextend feature is not support
in mysql version earlier that 4.
3.23.50, actually.
Nils Valentin wrote:
Hi Mixo,
Do you have the autoextend feature enabled for the innodb table ?
It can be set f.
Hi!
Starting from version 4.0.13, InnoDB supports
ALTER TABLE ... DROP FOREIGN KEY internally_generated_foreign_key_id
You have to use SHOW CREATE TABLE to look the internally generated foreign
key id when you want to drop a foreign key.
Version 4.0.13 came in May, but 4.1.0-alpha was released
At 22:01 -0700 7/8/03, cmars wrote:
Paul,
I have used the ODBC interface as a rough test to experiment with
application compatibility with MySQL. I would not consider using
ODBC at all to load in a production environment.
I want to develop a loading method that is as fast as possible. If
I we
At 9:26 -0500 7/9/03, azamka wrote:
Hi I am trying to make mysqld max so i can create innodb tables but I am
getting the following error when i run mysqld
No Variable Match for: -0 'innodb_buffer_pool_size = 40M'
./mysqld version 3.23.56 for pc-linux on i686
I am unable to figure out what to do. Th
At 22:23 -0500 7/9/03, mos wrote:
I don't know why, but if I have a CSV file with missing field values
like: "ABC",
I thought the missing values following the "ABC" should put NULL's
in the table columns.
But instead it is putting in 0's for numeric values.
The table is defined to allow NUL
I am using MySQL 3.23.54. I have the following table structure.
FORMS
form_id (PK)
form_name
STAFF ASSIGNMENTS
staff_assignment_id (PK)
form_id (FK)
staff_id (FK)
STAFF
staff_id (PK)
first_name
last_name
For each record in FORMS there may be zero, one or multiple records in STAFF
ASSIGNMENTS. I
I don't know why, but if I have a CSV file with missing field values
like: "ABC",
I thought the missing values following the "ABC" should put NULL's in the
table columns.
But instead it is putting in 0's for numeric values.
The table is defined to allow NULL's for these columns, and the def
I am familiar with regex in general, but here is what I want to do...
I have a field that contains 6 actual data items separated by the | symbol.
Like this...
a|b|c|d|e
What I need to do is build a list of distinct values between each pipe, so
that I get 5 arrays of values, one array for each
The order of the WHERE clause does make a difference.
The same is true of table joins. I don't think that
the order of tables in the FROM clause makes a
difference.
olinux
--- [EMAIL PROTECTED] wrote:
> As we're on this topic in another thread right now:
>
> Say I have a SELECT query from more
Hi Kevin,
In this case the error log file (hostname.err) in f.e /var/lib/mysql should
give you an idea whats going on.
Perhaps the settings inside the my.cnf from the newer version are very
different then from the older version.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 10日 木曜日 11:
This is probably a dead horse but let me post a followup to let everyone
know what I did and what has happened since. Maybe I should list it
under some other error number.
Before Paul posted his message I uninstalled (using rpm -e) version
4.0.13. I then got the RedHat installation CDs and re
Hi All,
I success ./configure my "mysql-3.23.51", after type make I got this
error
-
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
libmy
Say I have column A with 1 distinct values column B and C with 2
distinct values and for simplicity sake the column type is an int.
If I wanted a composite key why should I make the order of the key
A,B,C
I read someplace that faster lookups happen with the leftmost index,
being an index wit
On Wednesday 09 July 2003 17:49, Cory Lamle wrote:
> Contents are Direct Alliance Corporation CONFIDENTIAL
> -
>
> Duane,
> Does mysql actually start back up? Or just get hung on step(4)?
Yes, mysql starts back up ok. I do a /etc/init.d/mysql start and the daemon
starts just as it should.
Hello Heikki,
Thanks for your response. Hmmm... When I run 'show processlist', I get something
like the following:
++--++--+-+-+---+--+
| Id | User | Host | db | Command
> > Further to this, I should point out everything works fine in mysql-front
> > or at the mysql console.
> >
> > The problem shows up when using mysql++, a BadQuery exception is thrown.
> >
> > query.reset();
> > query << "CREATE TEMPORARY TABLE " << sTemporary << " TYPE=HEAP
> >
James B. Wetterau Jr. wrote:
I'm trying to upgrade the glibc on some machines that do not yet have
glibc2
in order to support > 1000 threads. It seems that some of the
instructions
concerning setting a pthread maximum for older glibc's are no longer
pertinent.
I wonder if the glibc 2.3.2 is kn
I'm trying to upgrade the glibc on some machines that do not yet have glibc2
in order to support > 1000 threads. It seems that some of the instructions
concerning setting a pthread maximum for older glibc's are no longer
pertinent.
I wonder if the glibc 2.3.2 is known to be compatible with MySQL
On 9 Jul 2003 at 23:14, Andrew Braithwaite wrote:
> I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline
> burst, with a wd 512MB HD and I want to store George Bush in our MySQL
> database.
>
> As far as table definitions are concerned, should I use a BLOB or
> should I store him o
Hi,
Can anyone help?
I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline burst,
with a wd 512MB HD and I want to store George Bush in our MySQL database.
As far as table definitions are concerned, should I use a BLOB or should I
store him on disk and make a reference to the physi
Hi,
If you send a table def (mysqldump would be good) I will be able to
experiment and come up with an answer...
Cheers,
Andrew
-Original Message-
From: Patrick Shoaf [mailto:[EMAIL PROTECTED]
Sent: Wednesday 09 July 2003 20:30
To: [EMAIL PROTECTED]
Subject: Select not producing desire
Mike Brum wrote:
I've been preparing some notes for my students on how to do this (using
PHP/MySQL), if you're
interested have a look at
http://www.scit.wlv.ac.uk/~jphb/sst/php/extra/images1.html - I've
only just put these notes together so if you can see any errors please
let me know before I
thanks a lot!!!
cheers
christian
You'd want to use a BLOB (binary large object) if that's what your goal
is.
But if you're using this for a web application I'd highly suggest that
you instead save images to a directory and make a reference to the path
in the database. If you have many BLOB inse
Contents are Direct Alliance Corporation CONFIDENTIAL
-
Duane,
Does mysql actually start back up? Or just get hung on step(4)?
I know I have had problems running scripts over ssh because the sudo
environment user wasn't being executed as root. (where a cron_tab was
actually execu
You are going to have to give us more information on what those functions do
If at all possible capture the query itself and let us know more about the
details
Also what type of connection to the Database ODBC, JDBC are you
implementing.
Regards,
Martin
--
MySQL General Mailing List
For list ar
Hi every one :
i'm trying to make a db program using Mysql & cbuilder6 .
on my table a have fields named " patient_Id " .
its an auto_increment value but i got problem .
the problem is when i try to get the value of that fields i got nothing just
" 0 " although i execute the commands
SQLClient
Yep, that was it, along with what Mark said.
On Wednesday, Jul 9, 2003, at 15:10 US/Central, gerald_clark wrote:
Nick Boudreau wrote:
Trying to start mysqld for the first time after a reinstall on Mac OS
X gives me this error:
030709 12:53:26 mysqld started
030709 12:53:27 InnoDB: Operatin
Never mind. I've solved my problem. My create statement had an unquoted
date in the select part. It works correctly now.
On Wed, Jul 09, 2003 at 03:29:11PM -0400, Rick Pasotto wrote:
> Is it possible to issue multiple sql statements in a single php request?
> (Probably not since I get a syntax err
You'd want to use a BLOB (binary large object) if that's what your goal
is.
But if you're using this for a web application I'd highly suggest that
you instead save images to a directory and make a reference to the path
in the database. If you have many BLOB inserts or selects on a site,
your datab
Glad I can help. The home page for the product is www.bytefx.com, however
you can post bugs/patches/suggestions at
www.sourceforge.net/projects/mysqlnet until I get those features implemented
at my site.
Reggie
> -Original Message-
> From: Kimberly Clark [mailto:[EMAIL PROTECTED]
> Sent:
hello,
i'm just changing from openbase SQL to MySQL, so i'm new here.
in openbase i had images stored in a database. the 'type' was set to
'object'.
i can't find something like that here and also not in the manual.
what should i use?
thanx for advance
cheers
christian
--
MySQL General Maili
Thanks, worked perfectly!
At 04:17 PM 7/9/2003, gerald_clark wrote:
fsttik has dashes in it and your having does not.
Either add dashes to your having or change the alias to min(datein+0) as
fsttik.
Patrick Shoaf wrote:
I am trying to get a SELECT working and not having any luck, can someone
fsttik has dashes in it and your having does not.
Either add dashes to your having or change the alias to min(datein+0)
as fsttik.
Patrick Shoaf wrote:
I am trying to get a SELECT working and not having any luck, can
someone please help?
SELECT
strref,acc.acctno,acc.namelast,acc.namefirst,ph
Nick Boudreau wrote:
Trying to start mysqld for the first time after a reinstall on Mac OS
X gives me this error:
030709 12:53:26 mysqld started
030709 12:53:27 InnoDB: Operating system error number 13 in a file
operation.
mysql doesn't have permissions for this file.
It is probably owned
Is it possible to issue multiple sql statements in a single php request?
(Probably not since I get a syntax error. mysql 4.0.13).
For example:
$result = mysql_query("drop table if exists tmptab;
create temporary table tmptab select * from othertab;
select * from tmptab where ");
I am trying to get a SELECT working and not having any luck, can someone
please help?
SELECT
strref,acc.acctno,acc.namelast,acc.namefirst,phone1,adddate,min(datein) as
fsttik, sum(amt) as sales,store FROM acc,sdtik WHERE
acc.acctno=sdtik.acctno and voidreason=0 and store>=40 and store<=59 GROU
If you are looking for ways to retrieve and store hierarchical data
(employees and managers, for instance)
I'll also recommend looking at the Nested Set hierarchy. Search news
groups for it, and look into Joe Celko's book _SQL For Smarties_, which
describes the technique. You can store a complete
hi mike
you suggested the following
> If you are referring to recovering some auto_increment values that were previously
> used by no rows now use > them, it is better to avoid this.
how can you prevent this?
best regards
benny
See http://www.mysql.com/doc/en/TODO_future.html
"Oracle-like CONNECT BY PRIOR ... to search tree-like (hierarchical)
structures."
Whatever their definition of "The Near Future" is... I'd guess v5
J
- Original Message -
From: "Bernhard Schmidt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
Hello all -
I'm having a small problem with the mysql startup script that ships with
MySQL-3.23.56-1.
I'm running on RedHat Linux.
It works fine, but I have a backup server that runs a script that passes
these commands remotely through ssh:
(1) ssh dbsys-dc "sudo /etc/init.d/mysql stop" (2) ssh
Hello Nick,
You and I are just about on the same page here.
However, I just turned the page you are now baffling over.
Let me ask, Did you removed the old "Macintosh
HD/Library/Receipts/mysql-standard-4.0.13.pkg" file
before you did the new install.
If I am not mistaken, this is what cinched it
Why are you looking to reset it? If you mean resetting when there is no data in a
table, a truncate table should start the auto_increment over again. If you are
referring to recovering some auto_increment values that were previously used by no
rows now use them, it is better to avoid this. That
Miguel:
Wednesday, July 9, 2003, 3:07:33 PM, você escreveu:
---[inicio]--
MP> Hi everyone:
MP> Does anyone know how to reset the auto_increment value of certain table.
MP> Any ideas or sugestions
MP> Greetings in advance
MP> __
Hi everyone:
Does anyone know how to reset the auto_increment value of certain table.
Any ideas or sugestions
Greetings in advance
_
Únete al mayor servicio mundial de correo electrónico:
http://www.hotmail.com
--
MySQL General
Trying to start mysqld for the first time after a reinstall on Mac OS X
gives me this error:
030709 12:53:26 mysqld started
030709 12:53:27 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: The error means
On 9 Jul 2003 at 19:07, Peter Engström wrote:
> I want to search for an e-mail address but I don't get any matches. I
> assume characters like @ . are ignored (stop words).
A "stop word" is a *word* that is ignored in indexing -- usually
things like "the" and "and". What you're talking about is
>> Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)?
>> Is there something I should check when next I notice the high CPU usage?
>>
>
>I used to see the same kind of behavior a while back with a MySQL
>installation I did for a client. It turned out that what was happening
>was
>> load). Is there a known issue (running on FreeBSD 4.8,
>> MySQL 3.23.55 MyISAM)?
>
>its been a known issue for quite a long time
>use linuxthreaded version and it should work fine.
>
>although much of work has been done on threads implementation,
>there are still such problems with mysql. it ha
Hi!
I'm running MySQL 4.0.13 and have problem with fulltext search.
I have a column of type 'text' which I fulltext index.
I want to search for an e-mail address but I don't get any matches.
I assume characters like @ . are ignored (stop words).
How can I create an index which contains e-mail ad
"Dathan Vance Pattishall" <[EMAIL PROTECTED]> writes:
> #use for when mysql is doing a check or repair
> set-variable= myisam_sort_buffer_size=64M
>
> to a higher value will make the index happen faster on the fly.
Oops. I only adjusted the key_buffer value. Probably I should set
myisam_sor
Maybe increasing
#use for when mysql is doing a check or repair
set-variable= myisam_sort_buffer_size=64M
to a higher value will make the index happen faster on the fly.
But, for a 100 million row table doing a dump and adding that dump back
to the db might be your fastest method. Building t
As we're on this topic in another thread right now:
Say I have a SELECT query from more than one table and with some conditions, does it
matter in what order I enter the tables in the FROM clause and in what order the WHERE
conditions appear in my query? Or does it make any difference if I use W
Mike,
#2 is not 100% correct. Only the columns in the "lookup" table (table2) need to be
indexed. Why? The optimizer first gets a limited set of table1 and then checks if it
can join this subset with a key from table2. So for the join condition only table2
needs to be indexed.
However, you are
I have four tables I need to query for information;
acc,accmemo,aard,sdtik where
acc contains basic information about a customer (1 rec per acctno)
accmemo contains multiple Account Memo messages (0 or more recs per acctno)
aard contains credit card(s) information (0 or more recs per acctn
MySQL allows only ONE primary key per table, so you can only use one. However, you can
also define UNIQUE INDEXES. The major difference here is that primary key columns may
not contain NULL values, however UNIQUE KEY columns may contain NULL values.
If your question now is: Is it better to use a
Use LOAD DATA INFILE if you want to import it from the filesystem or use
INSERT/UPDATE if you do it from an application (e.g. perl, php). Make
sure that the column which stores them is defined as BLOB and not as
TEXT. Look up the BLOB definition for size limitation and variations on
BLOBs.
For get
Rudy, Egor, Victoria,
Thank you for keeping an eye on me. I ended up doing a reinstall of
MySQL and have successfully connected.
I feel I have broken through a wall only to find an infinite number of
walls yet to break through.
Such is the adventure I have chosen.
Be at peace,
Mark Depenbrock
Why using int for date? Better suited would be DATE or DATETIME (or even TIMESTAMP,
depending how you want to use it).
For studentid, SMALLINT or MEDIUMINT would maybe suffice, esp when you make them
UNSIGNED.
For status I would choose CHAR(1), you can put a lot of information into that, which
a
Yes it is. If you are using VB look at
www.vbmysql.com/articles/blobaccessvb.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Dan Anderson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 09, 2003 8:49 AM
> To: [EMAIL PROTECTED]
> Subject: Is it possible to dump
Well that all depends. The real reason for a primary key is to prevent duplicates,
therefore, if a combination of fields needs to be unique, then a multiple primary key
makes sense, especially if other tables will reference the field combination (for
example, detail items on an invoice where the
If you got the error message during creation of the innoDB files (e.g.
during install) you HAVE TO DELETE all files and restart the
installation. There is no way around this!
However, if the file got corrupted after installation (e.g. you already
used it for days) you can repair it (maybe someone
On Wed, 2003-07-09 at 10:31, Dave [Hawk-Systems] wrote:
> Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)?
> Is there something I should check when next I notice the high CPU usage?
>
I used to see the same kind of behavior a while back with a MySQL
installation I did for a
take a look at:
http://www.php4.com/forums/viewtopic.php?t=6
or search the mailing list archive.. there are plenty of threads talking
about this:
For list archives: http://lists.mysql.com/mysql
On Wed, 9 Jul 2003, Dan Anderson wrote:
> Can anyone point me to a reference on how to insert ima
Is it better to set multiple primary keys or to set one key and index
the other columns? If I have a primary key as a field in another table
should it also be set as a key?
Adam
On Wednesday, July 9, 2003, at 10:41 AM, <[EMAIL PROTECTED]> wrote:
i think this should be no problem...
i'd thin
Please note that InnoDB is included as from MySQL 4.0 in the "standard"
release. So the easiest way to use InnoDB would be to grab a RPM or
binary distribution and install it on your system. No need to compile
one yourself then.
However, if for some reasons you must have 3.x or are on a not suppor
Adam,
Mysql will easily handle this. This certainly doesn't constitute a large
database.
Correctly indexing the database should see you doing speedy queries on years
worth of data.
Sounds like you've used access in the past :-)
Andy
> -Original Message-
> From: Adam Gerson [mailto:[EM
Can anyone point me to a reference on how to insert images into a column
in a mySQL database -- or is that not possible?
Thanks in advance,
Dan Anderson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi,
> load). Is there a known issue (running on FreeBSD 4.8,
> MySQL 3.23.55 MyISAM)?
its been a known issue for quite a long time
use linuxthreaded version and it should work fine.
although much of work has been done on threads implementation,
there are still such problems with mysql. it happe
i think this should be no problem...
i'd think of some table layout like this:
date int PRIMARY
student_id int PRIMARY
status int
extra_data what-you-want
then you should get about 360,000 records per year.
i saw people on this list reporting about millions of records
Rick Pasotto wrote:
One of these days I will maybe understand...
A "left join" (t1 LEFT JOIN t2 ON ) is defined as follows.
For each row in t1, find all matching rows in t2 and return the
combination of t1 and t2 found. If there are no t2s for a t1, leave the
t2 values NULL in the result.
Try
Hello Egor,
You give me hope but...
I attempted to set up permissions but it appears that I need to start
up MySQL in order to do that.
That brings me right back to my original problem of not being able to
connect.
I am thinking of reinstalling MySQL to see if I missed something in the
origina
Occasionally in checking one of the servers, I noticed that mysql shows 85% + of
cpu usage essentially leaving the server at 0% idle. After monitoring it for a
few hours, the status did not change. After a stop and start of mysql, things
progessed normally. Checking back a few days later I notic
Hi I am trying to make mysqld max so i can create innodb tables but I am
getting the following error when i run mysqld
No Variable Match for: -0 'innodb_buffer_pool_size = 40M'
./mysqld version 3.23.56 for pc-linux on i686
I am unable to figure out what to do. This shows that it reads the my.cnf
One of these days I will maybe understand...
Using MYSQL 4.0.13, debian linux
create table members (
id unsigned int autoincrement,
name
)
create table activity (
id unsigned int autoincrement,
description
)
create table history (
id unsigned in autoincre
Everything from month to years. Might even be tomorrow...
/rudy
-Original Message-
From: Bernhard Schmidt [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 16:07
To: [EMAIL PROTECTED]
Subject: Re: recursive sql statement
hi victoria
sorry for this mysql newbie question, but what mea
hi victoria
sorry for this mysql newbie question, but what means "planned for the near future"?
ist this weeks, months or years away?
best regards
benny
Paul,
Did you try using REPLACE instead of UPDATE/INSERT? Could give you some
more speed enhancement.
Cheers
/rudy
-Original Message-
From: Paul Chvostek [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 15:21
To: cmars
Cc: [EMAIL PROTECTED]
Subject: Re: Bulk loading data
On Tue, Ju
I am writing an attendance system in php for my school. We have a
little less then 1000 students. For every day of the school year one
record will be entered into a table for each student representing their
attendance status (present, absent, late, etc...). I also have several
other supporting
"Bernhard Schmidt" <[EMAIL PROTECTED]> wrote:
>
> for me a recursive sql statement is when the result of a query can be used for a
> following query. the statement has start and stop condition. such kind of queries is
> useful for tree traversal. sql is based on relational algebra that does not
Mark Depenbrock <[EMAIL PROTECTED]> wrote:
>
> Can not make mysql connection -
>
> error log:
> 030708 08:53:48 mysqld started
> 030708 8:53:49 InnoDB: Operating system error number 13 in a file
> operation.
> InnoDB: See http://www.innodb.com/ibman.html for installation help.
> InnoDB: The e
On Tue, Jul 08, 2003 at 09:36:11PM -0700, cmars wrote:
>
> I want to insert massive amounts of data in near real-time into a MySQL database.
> The data is in a structured binary format, and I have code that parses the data into
> logical data structures.
...
> How can I load data directly into
Hi Benny,
Thank you for the explanation, but I believe thats out of my reach to give any
advice here ;-)
Best regards
2003年 7月 9日 水曜日 21:30、Bernhard Schmidt さんは書きました:
> for me a recursive sql statement is when the result of a query can be used
> for a following query. the statement has start a
Hello MySQL programmers,
suppose we have an Enhanced ER diagram,
with entities as classes/ subclasses connected through
some IS-A relationship.
How can this be Coded in MySQL Please?
My prerequisites are the basic database texts from
http://www-db.stanford.edu/~ullman/dscb.html
http://w
On Wed, Jul 09, 2003 at 04:20:52AM -0700, David Thompson wrote:
>
> Looking for a book to help me develop a philosophy for building
> databases (particularly on MySQL). And then taking them from concept to
> construction.
>
> Something like Start by asking which queries you will be performing,
David,
If you want to learn about Databases and normalization and Relational
Algebra, a really good book is:
Fundamentals of Database Systems, by Elmasri and Navathe
and
Understanding Relational Database Query Languages by SW Dietrich
I have studied the first book, cover to cover, and I still us
for me a recursive sql statement is when the result of a query can be used for a
following query. the statement has start and stop condition. such kind of queries is
useful for tree traversal. sql is based on relational algebra that does not allow to
write such expressions. but as mentioned by r
Hi jvilla,
I know that MySQL supports some simple nested queries from 3.23 -xx, and even
includes subselects from 4.1.
However I am not clear if any of the 2 queries will work straight away in 4.1
(once its stable).
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 21:00、Jonathan Villa
Dear mysql users,
in the tutorial of the documentation I found an interesting
example of a complicated non trivial sql query:
URL:
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#
example-Maximum-column-group-row
3.7 Queries from Twin Project
3.7.1 Find all Non-distribu
I have a shopping cart which creates temporary tables in the format of
zorder_;
These tables are used to hold a customers order while they shop and
after checking out, it is dropped. The values of the shopping cart are
put together in an HTML table and stored as their history.
What I want to
Hi Benny,
May I guess that you are talking about nested queries or subseects ?
If yes than they are supported from Version 4.1. If no, than I have no clue
what you are talking about ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 20:26、Gerald R. Jensen さんは書きました:
> Benny:
>
> What d
Further to this, I should point out everything works fine in mysql-front or
at the mysql console.
The problem shows up when using mysql++, a BadQuery exception is thrown.
query.reset();
query << "CREATE TEMPORARY TABLE " << sTemporary << " TYPE=HEAP
MAX_ROWS=1 " << subselect
As a way of getting around the lack of subselect (I'm aware this is coming
soon) we're parsing sql queries, running subselects and storing their
results in a temporary table and replacing the subselect in the sql with the
temporary table name.
This has been working fine, but on upgrading to v4.0.1
Benny:
What do you mean by 'recursive sql statements'?
If you are talking about triggers and stored procedures, the answer is no.
Gerald Jensen
- Original Message -
From: "Bernhard Schmidt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 2:58 AM
Subject: recu
1 - 100 of 116 matches
Mail list logo
