HI, when I try to compile mysql, I get message.
c++ can not write output files.
What should I do?
Thanks.
__
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
---
Or the perl way:
my %row;
@row{'f_handle','a_handle'} = $sth->fetchrow_array();
$row{f_handle} or $row{a_handle}are now set properly.
( if you really want a reference, you can say 'my $row = {};
@{$row}{'f_handle. )
dpk
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED
Regarding error 127 from table handler...
I thought this may be helpful to anyone that is having this problem:
I tried to back up my database using mysqldump:
[pad@gamma dbbackup]$ mysqldump -u padadmin --password --verbose paddata |
gzip > /home/pad/dbbackup/20010908a.gz
Enter password:
# Conn
On Mon, Sep 03, 2001 at 04:06:20PM +0200, Oliver Krapp - etracker.de e.K. wrote:
> Hello MySql,
>
> I'm dealing with a large (think so) production mysql server. There
> are up to ~2500 small databases (each ~1-4 MB Data in 10
> Tables). The system is growing and the CPU gets more and more
> loade
Thanx dude. That helped. hey! Dont forget to check out my web site!! I'm
almost done with the source-code upload part.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAI
On Fri, Sep 07, 2001 at 12:56:14PM -0300, Pablo Fraga wrote:
>
> What´s the diference between The row storage format (Fixed, Dynamic,
> or Compressed) .
>
> I'am experiencing problems with update statements which goes against
> a table with the row_format property set to Fixed.
Fixed rows always
I thought this may be helpful to anyone that is having this problem.
I tried to back up my database using mysqldump:
[pad@gamma dbbackup]$ mysqldump -u padadmin --password --verbose paddata |
gzip > /home/pad/dbbackup/20010908a.gz
Enter password:
# Connecting to localhost...
# Retrieving table
On Fri, Sep 07, 2001 at 10:03:03PM -0700, Philip Mak wrote:
> Let's say I performed the following query using Perl DBI:
>
> $row = $dbh->selectrow_hashref(<<"~");
> SELECT fanfics.handle, authors.handle
> FROM fanfics, authors
> WHERE fanfics.aid = authors.aid
> ~
>
> I won't be able to access b
On Fri, Sep 07, 2001 at 10:33:07PM -0500, Deryck Henson wrote:
>
> That manual is confusing in some parts. Like, how to make an
> auto_increment column. how do I anyway? My database table needs
> it.
The manual isn't perfect, but users like us sometimes submit
corrections and enhancements to h
ASP question... not MySQL (if I understand correctly...)
But just do a replace...
variabletoinsert = replace(thevariablecomingin,"'","\'")
INSERT INTO ASP (title, description, code, user, email, date_created) VALUES
('title', 'description', '" & variabletoinsert & "', 'user', 'email', 'now')
Let's say I performed the following query using Perl DBI:
$row = $dbh->selectrow_hashref(<<"~");
SELECT fanfics.handle, authors.handle
FROM fanfics, authors
WHERE fanfics.aid = authors.aid
~
I won't be able to access both fanfics.handle and authors.handle this
way, because they're called "handle
Hi,
I'm relatively new to MySQL, but it's been working well for me with dozens
of Perl scripts. We use it as our database with our ISP. Our database size
is currently about 30MB, and the majority of that is in two tables which
each contain about 20,000 records. The database has not changed mu
Except the problem is, this is done through an Active Server Page (ASP).
The user does the inserting, I just use variables and insert them.
TRANSLATION:: I have no control over what goes in the database until it's
there. So how can it be changed in the connection or sending process?
- Deryck H
I installed Mysql using the Apachetoolbox. Everything installed correctly,
but when linux boots, mysqld starts, and stops immediately. I checked out
the docs, and tried using "./safe_mysqld --skip-grant-tables" which starts
to load mysql, but then hangs, causing me to reboot.
I ran "mysql_install
At 06:44 07.09.01, you wrote:
>here is my sql query
>
>SELECT COUNT(*) as count, hostname FROM host_list GROUP BY hostname ORDER BY
>count DESC
>
>
>what I would like to do is list say just the hosts that have greater then 10
>in the left column
use the HAVING statement as in:
SELECT COUNT(*) a
That manual is confusing in some parts. Like, how to make an auto_increment
column. how do I anyway? My database table needs it. Thanx
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
http://ww
I don't know how small the mysql distro can be made but I'm guessing pretty
small. I see that the mysqld on my box runs about 1.4mb. I have seen
linux setups that can boot entirely from a floppy (so less than 1.44MB) at
http://www2.linuxrouter.org:81/ , perhaps you may also be interested in t
Add a \ before the '
INSERT INTO ASP (title, description, code, user, email, date_created) VALUES
('title', 'description', '\'get file scripting object Set objFileScripting =
CreateObject("Scripting.F', 'user', 'email', 'now')
Cal
http://www.calevans.com
-Original Message-
From: Deryc
On Fri, Sep 07, 2001 at 07:34:03PM -0500, Deryck Henson wrote:
>
> I keep on hereing in the manual them talking about some MySQL 4.0.
> What is it and how do I get it? If it even exists (which I doubt)
It is the next major version of MySQL, currently in development.
Jeremy
--
Jeremy D. Zawodny
Riza-frasin...
---
Rodney Broom
Programmer: Desert.Net
> Your message cannot be posted because it appears to be either spam...
> database,sql,query,table
> From: Anthony E. <[EMAIL PROTECTED]>
>
> > Unknow column 'USER' in 'where clause'.
>
> D'oh! Fast fingers and too many thoughts.
>
>
Unknow column 'USER' in 'where clause'.
--- Rodney Broom <[EMAIL PROTECTED]> wrote:
> From: Anthony E. <[EMAIL PROTECTED]>
>
>
> > This comes up with more records than are in
> USER_TMP.
>
> Is the 'email' column unique in both tables?
>
> Heh, sorry about that. Try this:
>
> select count
From: Anthony E. <[EMAIL PROTECTED]>
> This comes up with more records than are in USER_TMP.
Is the 'email' column unique in both tables?
Heh, sorry about that. Try this:
select count(USER_TMP.email)
from USER_TMP, USER
where USER_TMP.email = USER.email
and USER;
---
Rodney Br
I keep on hereing in the manual them talking about some MySQL 4.0. What is
it and how do I get it? If it even exists (which I doubt)
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
http://www.my
On Wed, Jul 04, 2001 at 07:16:50PM -0500, [EMAIL PROTECTED] wrote:
> Ok, I know I submitted an earlier bug report about this, but I've
> actually had it happen from the mysql monitor. Essentially, UPDATE
> queries are executing, but not actually updating, unless I SELECT
> data from the table fir
At 4:40 PM -0700 9/7/01, Anthony E. wrote:
>I've tried to do a NOT IN statement, but still am
>getting SQL syntax error.
>
>
>SELECT COUNT(*) FROM USER_TMP WHERE USER_TMP.email NOT
>IN (SELECT USER.email FROM USER);
>
>I'm trying to produce a list of records from USER_TMP
Huh? COUNT(*) produces
Use:
mysqladmin -p
and it will ask you for the password. To execute without question,
specify password on command line, but it is not masked if you do this
(say your password is "allaccess"):
mysqladmin -pallaccess
and follow with the command on the same line (using the appropriat
I've tried to do a NOT IN statement, but still am
getting SQL syntax error.
SELECT COUNT(*) FROM USER_TMP WHERE USER_TMP.email NOT
IN (SELECT USER.email FROM USER);
I'm trying to produce a list of records from USER_TMP
table where the USER_TMP.email is NOT IN USER.email.
(in other words, i wan
I am trying to input some data into the database when all of a
suddenPOOF! This pops up!::
You have an error in your SQL syntax near 'get file scripting object Set
objFileScripting = CreateObject("Scripting.F' at line 1
Is there anything I can doabout this? The 'get file scripting object S
On Saturday 08 September 2001 00:10, Mysql List wrote:
> Thanks,
>
> I already tried that, and I am only trying to insert about a dozen fields.
>
> Thanks for the response, I will wait and see if anyone else has an idea.
The documentation:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
has the
On Fri, Sep 07, 2001 at 02:54:18PM -0700, [EMAIL PROTECTED] wrote:
>
> Just wondering, if I make changes to the master database table
> structures, will the changes be reflected in the slave databaase
> tables or do I need to manually re-copy master database snapshot to
> the slave?
They will be
Thanks,
I already tried that, and I am only trying to insert about a dozen fields.
Thanks for the response, I will wait and see if anyone else has an idea.
Chris
> MaybeI guessThere's either too many datatypes or try putting like
> this (again, probably wont work)
>
> Auto_Increment=10
UPDATE returns the number of rows that were actually changed.
How is the returned number of rows formatted for SQLFetch/SQLGet?
Thanks
Jeff Tanner
Seattle, WA
-
Before posting, please check:
http://www.mysql.com/manual.php
On Friday 07 September 2001 23:37, Anthony E. wrote:
> i have two tables with similar structure...
>
> i want to find the intersection of data between two
> tables that have the same email address.
>
>
> I tried the following with an error (Unknown table
> 'USER' in where clause) the USER table is
Just wondering, if I make changes to the master database table structures,
will the changes be reflected in the slave databaase tables or do I need to
manually re-copy master database snapshot to the slave?
Thanks,
Jeff
-
Bef
Seems like MySQL is not running. Check to make sure it's running by
executing:
ps -eaf | grep mysql (on a Unix platform). If no processes are running then
start MySQL.
Hope this helps you,
-Teresa
-Original Message-
From: Pablo Javier Gonzalez Mateos [mailto:[EMAIL PROTECTED]]
Sent
i have two tables with similar structure...
i want to find the intersection of data between two
tables that have the same email address.
I tried the following with an error (Unknown table
'USER' in where clause) the USER table is definitely
there though:
select count(email) from USER_TMP wher
MaybeI guessThere's either too many datatypes or try putting like
this (again, probably wont work)
Auto_Increment=1000, .
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Mysql List" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>
Cc: "mysql
That didn't work either.
The documentation seems to show that you have to use = 1000, but I can't
get it to work.
> Try putting it like this ::
>
> AUTO_INCREMENT(1000), .
>
> Not sure but that should work
>
> - Deryck H
> - http://www.comp-u-exchange.com
> - Original Message -
> Fro
Hi,
Why is mysql(ver 3.23.41) complaining about this:
CREATE TABLE mytable(ID INT NOT NULL AUTO_INCREMENT = 1000,PRIMARY KEY (ID),
I know it is not the entire statement, but mysql does not like the
AUTO_INCREMENT = 1000 part, how do I do that so it is acceptable?
Thanks,
Chris
---
Anyone can help me with this
What can i do
thanks a lot !
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
--
Pablo Javier Gonzalez Mateos, [EMAIL PROTECTED] on
07/09/2001
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Aaron Brick writes:
>> good day -
>>
>> i have found cases in which the daemon blocks waiting on a select() and
>> just plain refuses to process certain queries. since i am reading in a 60
>> meg file, meaning about 3
>Description:
Ok, I know I submitted an earlier bug report about this, but I've actually
had it happen from the mysql monitor. Essentially, UPDATE queries are
executing, but not actually updating, unless I SELECT data from the table
first.
>How-To-Repeat:
Simple as that. I have ye
Hi Claudio,
I think having the functionality of stored procedures would be a wonderful addition to
MySQL. Let me be the first to say a hearty 'Thank you!' for your very generous offer
to devote your vacation time to this task.
I like Oracle's PL/SQL. I've used it a fair amount, and it get's th
-- Original Message --
From: Jeremy Zawodny <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 7 Sep 2001 00:12:24 -0700
>On Wed, Sep 05, 2001 at 01:33:03PM -0700, A. Clausen wrote:
>
>PURGE LOGS:
>
> http://www.mysql.com/doc/R/e/Replication_SQL.ht
I am using ASP and MySQL and am very happy with the performance!
If you are on a Windows box, and have IIS5, there is no reason not to use
ASP and the MySQL/MyODBC set up... it really does work well... (you could,
of course, install PHP on your Windows box... (www.php.net)... I do like
PHP... and
Hi
Trying to create a database or reload the Grant tables using mysql/bin/
./mysqladmin I get an access denied message including a PASSWORD NO
message. Trying the troubleshoot docs for this I get Access Denied for the
suggestions made to deal with this. This is also causing a MERANT mySQL
driver
One last question : The Fulltext search only matches those rows who match
teh exact word, so if I search for "bank", the query wont find banking.
(this would work with "like '%bank%'", but that is much slower). So is there
anything you can to make it also match those ??
Lorang Jacques
sql is mysq
One last question : The Fulltext search only matches those rows who match
teh exact word, so if I search for "bank", the query wont find banking.
(this would work with "like '%bank%'", but that is much slower). So is there
anything you can to make it also match those ??
Lorang Jacques
-
Nuno,
what does
ulimit -a
say (assuming you are running on Unix)?
ulimit tells the limits set for the user.
I think there are also hard limits decided
at kernel compile time.
What does
free
say?
Regards,
Heikki
http://www.innodb.com
>Nuno Dias wrote:
>
>> I installed mysql with innodb su
Hi.
On Fri, Sep 07, 2001 at 07:12:47PM +0200, [EMAIL PROTECTED] wrote:
> Hello,
> How can I limit the query to those rows where "SUM(value) as Tot > 0".
> If I put it in an where clause it get an error.
That is to be expected, as in SQL the WHERE clause is evaluated before
the SELECT clause (i.e
Hi all, just thought I'd let people know. I recently
developed a way to pass protected config file data to
unprotected perl scripts (system user scripts/cgis).
The project can be found at
http://psc.sourceforge.net/
It is a C setuid wrapper that opens a protected file
and drops its privi
Add 'HAVING Tot>0' to your query.
dpk
- Original Message -
From: "Lorang Jacques" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 10:12 AM
Subject: Limit query to a value
> Hello,
> How can I limit the query to those rows where "SUM(value) as Tot > 0
From: Shaji Khan <[EMAIL PROTECTED]>
> Hi, I am a newbie to MySql and I am planning to use MySql and PHP to develop
> a shopping cart and other components of a full blown ecommerce site. Is this
> a good choice for this kind of work or do you guys think some thing like SQL
> Server and ASP is
Shaji Khan wrote:
> Hi, I am a newbie to MySql and I am planning to use MySql and PHP to develop
> a shopping cart and other components of a full blown ecommerce site. Is this
> a good choice for this kind of work or do you guys think some thing like SQL
> Server and ASP is a better choice.
>
> E
I've been mildly scolded for not announcing this somewhere,
so, on the "better late than never" principle, here goes. :-)
New Riders has published a new book called "MySQL and Perl for the Web"
(by me). It focuses on using MySQL together with the Perl DBI and CGI.pm
modules to perform various ki
Lorang Jacques wrote:
> Hello,
> How can I limit the query to those rows where "SUM(value) as Tot > 0". If I
> put it in an where clause it get an error. So how to do that
> SELECT id,url,title,description,top,keyword,SUM(value) as Tot FROM links
> LEFT JOIN keywords on links.id=keywords.LinkId G
Sorry if this e-mail is rather long but I want to give all code I am using
as to make sure that everyone has all the information they need.
Machine info:
MySQL for Win 2000
IIS5
The Table:
CREATE TABLE Players (
pid INT AUTO_INCREMENT NOT NULL,
RealFullName CHAR(70) NOT NULL,
RealAge INT NOT NU
At 23:07 -0700 2001/09/06, Chadrick Mahaffey wrote:
>I realize that I'm going to be in the minority here but I have to say it.
>Open source would go much farther if they had self explanatory GUIs and had
>basic pre-setup apps that were ready for the average user to use. I program
>in Java and I fe
>Claudio Cicali ([EMAIL PROTECTED]) writes:
> - where I work, we have a HUGE database-driven web-application. A lot of
>our businness logic is implemented via stored procedures, that
>act as black boxes for the web-designers.
>Think of enterprise java beans.
>They are not "nonsense
I installed mysql with innodb support on a machine with 2G of RAM.
The manual recommends that one should set innodb_buffer_pool_size in my.cnf to up to
80% of the physical memory available.
However, if I set a value above 50M!!! I get this error:
Innobase: Fatal error: cannot allocate memory!
Hi, I am a newbie to MySql and I am planning to use MySql and PHP to develop
a shopping cart and other components of a full blown ecommerce site. Is this
a good choice for this kind of work or do you guys think some thing like SQL
Server and ASP is a better choice.
Experienced users, please ad
Hello,
How can I limit the query to those rows where "SUM(value) as Tot > 0". If I
put it in an where clause it get an error. So how to do that
SELECT id,url,title,description,top,keyword,SUM(value) as Tot FROM links
LEFT JOIN keywords on links.id=keywords.LinkId Group by id order by tot desc
Lora
Hi,
> > On the other hand though, it gives me some comfort that the hardware
> > being used in my operation will meet any future needs. We have
> > similar spec servers (P3-1Ghz dual-cpu, 512Mb RAM, 3x36Gb SCSI
> > RAID5). Maybe I should try out mysql-super-smack and see what kind
> > of numbers
> Since the current version of MySQL is open source you could write stored
> procedures in the same language used in (until recently) DB2, i.e., C. I
Why reinvent the wheel? MySQL already has user-defined function capability
in C.
> Related question, what language or psuedo language would be us
SQL. Stored procedures are loosely analogous to shell scripts. No
additional language constructs, outside of what is defined in the ANSI-SQL
standard are necessary for them.
IMHO, C would be a bad thing.
My $.02 worth, (which is worth less, each time I post)
Cal
*
* Cal Evans
* Senior Internet D
Cal Evans wrote:
> Stored procedures allow you to pre-compile and re-use code easily. They also
> make transactions easier. (At least from one point of view) It's not like
> the XML argument. SPs are also part of the ANSI spec so to be compliant,
> MySQL will have to have them. XML is not part of
On Fri, 7 Sep 2001, Cal Evans wrote:
> Date: Fri, 7 Sep 2001 11:05:27 -0500
> From: Cal Evans <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], [EMAIL PROTECTED], Ed Carp <[EMAIL PROTECTED]>
> Subject: Re: Let's approach stored procedures
>
> Ed,
>
> Stored procedures allow you to pre-compile and re
ricardo bravo writes:
> Hi All,
>
> where do I specify the remote hosts that are allowed to access port 3306? I
> have made entries in the user table of the mysql db, but still cannot conect
> from a remote machine. Thanks,
Do the entries match the host you're connecting from? Did you add th
On Fri, Sep 07, 2001 at 11:10:46AM -0500, Ed Carp wrote:
> > Do the current limitations of 500 characters per index and limited (?)
> > number of columns per index pose problems? I want to use fulltext
> > on a database with 7 varchar(255) columns and several smaller varchar
> > columns but can't
Torgil Zechel writes:
> I would like to get the total number of records in tbl along with the 10
> first ones..
As far as I recall this is one of the things that will be added in
version 4. The question is just when that version will be stable
enough to be fully trusted (it might already be for
Let me clarify.
I'm in great favor of stored procedures in MySQL. It is my HO that all
interaction with the database should take place within stored procedures.
But the ANSI standard is sufficient for most interaction with the database.
My call to arms was to resist the urge that Oracle could no
No, they do not differ from the rest. The only thing is that they need
longer
time to process (between 1 and 4 seconds, normally the SAME query is
processed
in a few miliseconds). The only correlation i found is that all queries
in that
log query the merge table.
How does mysql handle locks on m
Not quite. We're not looking for a left join or natural left join.
I'm not sure MySQL or any database can even do this, it may have to be
done (rather unattractively) on the API side.
The data in the two tables aren't tied by ID, and shouldn't mix w/ each
other at all.
To do this, all we've bee
Ed Carp wrote:
>
> Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
>
> > Ed Carp writes:
> > > Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
> > >
> > >
> > > ODBC, or MyODBC?
> >
> > ODBC as an API.
> >
> > Then you install ODBC driver for RDBMS of your choice and configure
> > ODBC likewise.
>
At 11.03 07/09/2001 -0500, Ed Carp wrote:
> > - it's cool
>
>Not a valid business reason.
>
> > - where I work, we have a HUGE database-driven web-application. A lot of
> >our business logic is implemented via stored procedures, that
> >act as black boxes for the web-designers.
> >Thin
Pablo Fraga ([EMAIL PROTECTED]) writes:
> What´s the diference between The row storage format (Fixed, Dynamic, or
> Compressed) .
RTFM!
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
http://www.mysql.com/doc/D/y/Dynamic_format.html
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - htt
Cal Evans ([EMAIL PROTECTED]) writes:
> Stick with the ANSI standard. (ANSI99?) Do not try to implement either
> PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or any
> other procedural or OO language in stored procedures. Speaking form
> experience, all this does is blur
> Do the current limitations of 500 characters per index and limited (?)
> number of columns per index pose problems? I want to use fulltext
> on a database with 7 varchar(255) columns and several smaller varchar
> columns but can't build a fulltext index. Is there documentation on
> the limitat
Ed,
Stored procedures allow you to pre-compile and re-use code easily. They also
make transactions easier. (At least from one point of view) It's not like
the XML argument. SPs are also part of the ANSI spec so to be compliant,
MySQL will have to have them. XML is not part of the ANSI-SQL spec.
> - it's cool
Not a valid business reason.
> - where I work, we have a HUGE database-driven web-application. A lot of
>our business logic is implemented via stored procedures, that
>act as black boxes for the web-designers.
>Think of enterprise java beans.
>They are not "nonsense
What´s the diference between The row storage format (Fixed, Dynamic, or
Compressed) .
I'am experiencing problems with update statements which goes against a table
with the row_format property set to Fixed.
Thanks.
Pablo Fraga (MIS).
e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED]
icq: 113466029
This is a standard 1st quarter computer science topic.
You can't reliably test floating point numbers for equality.
0.1 has no exact floating point binary representation.
Perhaps you should use the DECIMAL type which is stored
internally as a string.
Guddack Thorsten ICM MP SCM SCCM PI wrote:
>
If you read thru more about the reasons for recommendation for
installing thru RPM, you'll understand. Since the folks who built RPMs
have definitely spent lot of time building the RPMs which is optimized
for performance. I do trust them and commend their efforts.
The source definitely gives you
My $.02,
Stick with the ANSI standard. (ANSI99?) Do not try to implement either
PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or any
other procedural or OO language in stored procedures. Speaking form
experience, all this does is blur the lines of that the database should
Hi All,
where do I specify the remote hosts that are allowed to access port 3306? I
have made entries in the user table of the mysql db, but still cannot conect
from a remote machine. Thanks,
Ric.
_
Get your FREE download of MSN
Jeremy Zawodny wrote:
< snip >
>
> Are subsequent inserts just as slow to replicate?
>
> Can you show us the output of SHOW SLAVE STATUS and maybe the my.cnf
> files of the master and a slow slave?
>
> Jeremy
>
Thanks for the response. Below is the info you requested. If there's
anything
On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote:
> Lorang Jacques ([EMAIL PROTECTED]) writes:
>
> > Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
> > tables. As it is quiet some work, I first want to ask you guys if this
> > is really going to make my queries f
At 10.44 07/09/2001 -0500, Ed Carp wrote:
>Claudio Cicali ([EMAIL PROTECTED]) writes:
>
> > At a first glance, I think Oracle PL/SQL is the best (afaik)
> > programming language for sp, but, in the case we implement
> > that language, should we go against some Oracle copytight
> > infringment ?
>
What´s the diference between The row storage format (Fixed, Dynamic, or
Compressed) .
I'am experiencing problems with update statements which goes against a table
with the row_format property set to Fixed.
Thanks.
Pablo Fraga (MIS).
e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED]
icq: 113466029
Claudio Cicali ([EMAIL PROTECTED]) writes:
> At a first glance, I think Oracle PL/SQL is the best (afaik)
> programming language for sp, but, in the case we implement
> that language, should we go against some Oracle copytight
> infringment ?
Why would you want to do such a thing? Isn't SQL good
- Original Message -
From: "Colm Brazel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 4:33 PM
Subject: Re: command line open source ARRRGG!!
> > Open source software is written by technical people. They do it because
> > they enjoy it. Most of t
Claudio Cicali wrote:
> I'm going to attend a long period of holidays (finally) so,
> I thought: why don't try to implement stored procedures
> in mysql ?
>
Someone did it with perl.
http://software.tangent.org/article.pl?sid=01/08/23/0817244&mode=thread&threshold=
> At a first glance, I think
Lorang Jacques ([EMAIL PROTECTED]) writes:
> Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
> tables. As it
> is quiet some work, I first want to ask you guys if this is really going to
> make my queries faster (much faster ?)
Yup. I've got the entire set of laws for th
On Friday 07 September 2001 06:11 am, you wrote:
> Giovanni Borri writes:
> > hi all,
> >
> > i have a question. i would like to know if mysql has a sql'x' standard.
> > my problem is that i would like to use UNION or MINUS or... but it seems
> > not to work, another problem is that i would li
Stefan Pinkert wrote:
> Examine that query with explain select... show that the indexes are not
> used. The keyfields are unsigned tiny int where every bit has a different
> meaning. Any clue how i can rewrite this query in a way where the indexes
> are
> used?
If MySQL thinks it will be faster
I think this is a little OT here, so after reading please
indicate me where to talk about this subject.
I'm a skilled programmer in C, C++ and others progr. lang.
I have also a solid background in SQL and some RDMS
(DB2, Oracle, SQLServer, and of course, Mysql).
I'm going to attend a long perio
Hello,
Actually I am programming an web directory (like yahoo). But my sql queries
need
ernormous cpu resources. So it is quiet slow. I can't use indexing because
my serach works with <>. (apparently then it dosen't
help).
Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
t
I wanted to put in my 2 cents. Access is not an RDBMS.. It is a single
user - small user, and frequent fix type system. I have never worked on a
real database system that does not have a command line interface. It seems
fearsome at first, but it's actually easy. SQL Server do doubt ha
On Friday 07 September 2001 15:37, Torgil Zechel wrote:
> Is it possible to get the total number of records when doing a select with
> LIMIT?
No. As least, not in MySQL, unless I am missing something.
> For example, if I do:
>
> SELECT * FROM tbl LIMIT 0,10
>
> I would like to get the to
Mark Papadakis wrote:
> We are using mySQL on over 6 servers here, we have been doing so for over 2 years,
>and we are constaly facing problems with corrupted tables, especially on two of our
>busiest servers.
> Tables seem to corrupt out of the blue and we have to shut them down ( the servers
1 - 100 of 160 matches
Mail list logo