.
Would a special forum for this purpose perhaps be a good intermediate
solution? Routines could be posted there, it's searchable...
Forum = list?
I think it would be a good start, if only to discuss things like this :)
forums.mysql.com
Regards,
Arjen.
--
Arjen Lentz, Community Relations
world means that
not everything is always public.
I do appreciate that you have questions beyond the answers given so far.
At this precise moment in time, I hope you can run on the trust you have
given MySQL and its developers upto now?
Thanks.
Regards,
Arjen.
On 10/7/05, Arjen Lentz [EMAIL
Shores-based Oracle (NASDAQ: ORCL) said it plans to negotiate to
extend the deal between Innobase and MySQL when it needs to be renewed
next year.
http://www.bizjournals.com/sanjose/stories/2005/10/03/daily52.html?hbx=e_du
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
-conference/
For more information about O'Reilly conferences, visit:
http://conferences.oreilly.com/ .
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL related blogs @ http://www.planetmysql.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html
The only thing you need to mind is to also download and install the
-shared-compat RPM, which contains the 3.23 libraries as well as the 4.0
libs, to keep some apps on FC3 happy which use 3.23 (Python for
instance).
Regards,
Arjen.
--
Arjen
-GPL licenses separately from MySQL Network, to
OEM/embedded customers.
I hope this clarifies the situation to your satisfaction.
If you have any further questions, please feel free to ask me.
Regards,
Arjen.
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL related
forum for this purpose perhaps be a good intermediate
solution? Routines could be posted there, it's searchable...
Regards,
Arjen.
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL Users Conference (Santa Clara CA, 18-21 April 2005)
Only 8 days until the event! http
under the
GPL license.
If you have any feedback or questions, please feel to ask on the
dedicated forum: http://forums.mysql.com/list.php?95
Regards,
Arjen.
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL Users Conference (Santa Clara CA, 18-21 April 2005)
Early
in this
context (MySQL documentation, description of logical operator OR), or if
I am just overthinking again... :)
You are right. NULL is not a non-zero value. NULL is not a value at all.
Regards,
Arjen.
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL Users Conference (Santa
features.
Naturally we will also continue to educate our users about security (strong
passwords and firewalls) on all platforms.
9. Where can I report my observations?
Please report all security issues to [EMAIL PROTECTED]
Regards,
Arjen.
--
Arjen Lentz, Community Relations Manager
MySQL AB
of
disk space use, but the handling could be much cleaner.
Regards,
Arjen.
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL User Conference (Santa Clara CA, 18-21 April 2005)
Early registration now open: www.mysqluc.com
--
MySQL General Mailing List
For list archives
:
http://www.mysqluc.com/
Regards, Arjen.
(Program Chair)
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL ComCon Europe (November) www.mysqlcomconeurope.com
MySQL User Conference (April) www.mysqluc.com
--
MySQL General Mailing List
For list archives: http
/, with specifics for various platforms. I won't
speculate what the specific issues for this new environment might be.
When the build engineers have the details, we'll update the manual
accordingly.
Regards,
Arjen.
--
Arjen Lentz, Technical Writer, Trainer
Brisbane, QLD Australia
MySQL AB
variables can be adjusted.
You can also set the maximum # of connections the server will allow.
Regards,
Arjen.
--
Arjen Lentz, Technical Writer, Trainer
Brisbane, QLD Australia
MySQL AB, www.mysql.com
Melbourne 1 December (5 days): Using Managing MySQL Training
Training,Support,Licenses,T
Hi,
On Thu, 2002-10-10 at 10:57, kayamboo wrote:
1. Is there anyway to know the string value of the password using the
encrypted value , from the mysql.user table ?
No. It's scrambled with a one-way (lossy) algorithm.
2. How can I know the most recently entered record, that does not
Hi Scott,
On Thu, 2002-10-10 at 03:28, Scott Pippin wrote:
I am trying to set up two data files in case the first one fills up. I
tried to use the following in my.cnf but it says there is an error. If
I take out the reference to the second data file everything works
AIX 4.3.3
MySQL
Hi David, Adam,
On Wed, 2002-09-25 at 10:37, David Lloyd wrote:
Obviously MySQL would have advantages if I intended to use it as a server
database with concurrent users. But is it faster than Access in the
single-user environment, when dealing with large databases?
I'd think so, yes.
Hi Peter,
On Fri, 2002-09-20 at 08:03, Peter M. Flor wrote:
I have been beating my head against a wall to try and get this to work.
Apparently in version 2.22 a bug preventing ORDER BY in a SELECT statement
from working was fixed in 2.23. Well I think that this bug also exists in
2.23 when
Hi,
On Fri, 2002-09-20 at 08:30, Csaba Kiss wrote:
this is my first mail to the mailing last, since I am new to the mysql
world. I would like to create a cell-bank mysql database. We freeze
down cells in small tubes. These tubes are stored in boxes and the
boxes are in big freezers.
Hi Benjamin, Vivian,
On Wed, 2002-07-24 at 05:23, Benjamin Pflugmann wrote:
On Tue 2002-07-23 at 14:58:16 -0400, [EMAIL PROTECTED] wrote:
I have 14 fields are chars (like char(8), char(9)), and one field is int(4).
All char fields are mixed with upper case letters, numbers(0-9) and
Hi Andy,
On Thu, 2002-06-13 at 05:02, Andy Sy wrote:
I want to use an auto-incrementing value that works
across multiple tables. For example I have 3 tables
forumA, forumB, forumC, each of which has a primary
key field called 'msgnum'. However, if I declare
'msgnum' auto_increment,
Hi,
On Thu, 2002-05-23 at 13:29, [EMAIL PROTECTED] wrote:
Anybody has tried installing MySQL on CygWin?
Not to evade your question, but... why would you want this, since there
are native Windows binaries? Faster and more reliable.
Regards,
Arjen.
--
MySQL Training in Australia: 9-13 Sep
Hi Steve,
On Fri, 2002-05-24 at 09:56, Orr, Steve wrote:
I changed my.cnf to add an autoextending datafile but I get errors on
startup.
Here's the my.cnf syntax:
innodb_data_file_path = hat/hatdata1:64M;hat/hatdata2:64M:autoextend
Here's the error output from mysqld:
InnoDB: syntax
Hi Jeff,
On Tue, 2002-05-21 at 11:15, Jeff Field wrote:
I think I understand how to set up replication but have a couple unanswered
questions. I'm hoping the list can help.
I have two servers with MySQL. Each server currently has completely
different databases, except for the standard
Hi Erik,
On Thu, 2002-05-16 at 07:50, Erik Fears wrote:
I'm looking for a solution to a database problem I'm having. The
current implementation is a file based database of roughly 57
million entries. I'm wondering if anyone has had any experience running
a mysql based database with 50-100
Hi Michael,
On Fri, 2002-05-10 at 02:27, Michael Davis wrote:
I'm trying to allow an attribute to hold multiple value. I know you can use
varray in oracle but I cant find anything in mysql. I found SET but you
must set the possible choices from the beginning. This is not good for what
I'm
At 16:30 -0400 5/9/02, Andrew Kuebler wrote:
I want to select say 100 of 1,000 records and get the highest value for
id in that query, however the MAX command always gives me the MAX for
the whole table, not just my query.
Here's my expression:
SELECT MAX(id) FROM table WHERE DATE =
Hi Tim,
On Fri, 2002-05-10 at 11:53, Tim Johnson wrote:
I'm not usually this lucky, but it seems that the trick is
to let mysql do more of the work, and I'm happy to go
along with that:
What I needed is
CREATE TABLE EurCount SELECT DISTINCT Country FROM EUR;
Hi,
On Fri, 2002-05-03 at 02:43, Andrew Kuebler wrote:
I use Perl/DBI with MySQL and I'm trying to find a way to sort email
addresses by domain. I would assume there is probably an option in MySQL
to strip off the text after the '@' sign that will allow me to sort on.
In Perl:
@fields =
Hi,
On Thu, 2002-03-21 at 16:58, [EMAIL PROTECTED] wrote:
I am using the MySQL server version 3.23.44 running on Windows 98 machine, I
just found out that as you view the task manage...mysqld is not alone...I
mean, about 6 of them...I am confuse whos running...so, all I want to know
is...is
Hi,
(please reply to the mailing list, no to me directly.)
On Thu, 2002-03-21 at 19:17, Leecher wrote:
Thanks,
Yes, I logged in as Administrator.
Just a question, why would running it as a service do any good, if I can't
even manually start the daemon? The daemon insists that all ports
Hi Lance,
On Thu, 2002-03-21 at 03:18, Lance Prais wrote:
Can someone look at this at see what I am doing wrong:
The following SQL returns to records:
50
333
select SC_USER_ID as parmSecurename from CP_USER_COMMENT where SC_ID =
107793;
If I include it in the following loop the result
Hi,
On Thu, 2002-03-21 at 01:03, Leecher wrote:
I installed mysql-3.23.49-win on Windows 2000 to drive D: (the installer
lets one choose the location). After reading the docs, I can see that I need
to start the daemon like this:
mysqld --basedir d:\mysql
However, when I do it I get this:
On Wed, 2002-03-20 at 12:56, Paul DuBois wrote:
With Story_Content, we're happy to use the stricter MATCH selects. So is
it possible to do something like Select * from stories where
MATCH(Story_Content) against ('param1') AND Writer LIKE param2% or am I
barking up the wrong (b-) tree?
If
Hi Kim,
On Thu, 2002-03-21 at 09:15, Kim Kohen wrote:
G'day Arjen
Indeed, hi fellow Aussie ;-)
FULLTEXT search generally uses an index (the FULLTEXT index), so the
server will not use an index on Writer.
So is an index on Writers worthless in this circumstance? My concern would
be if
Hi,
On Tue, 2002-03-19 at 11:41, Campbell McLeay wrote:
I wish to upgrade mysql server from 3.22 to 3.23 running on Linux and
had a few basic questions which I am hoping someone can help me with.
My plan is simply to download and unpack the binary distribution, stop
mysqld, move the symlink
Hi,
On Tue, 2002-03-19 at 16:24, Chuck PUP Payne wrote:
Ok, but that still doesn't any why MySQL is filling the delete slot, I
understand that I can do any SQL statement to put into the order I want. I
guess what I am trying to wonder how it place a record into the table, does
MySQL see that
Hi, Kenneth,
On Fri, 2002-03-08 at 08:48, Kenneth Hylton wrote:
I've posted this twice before - third time might be the charmer...
Can anybody help me?
I am using the C API and am returning a result set from a table with a BLOB
type item in it.
When I populate the BLOB fields initially
Hi Joseph,
On Fri, 2002-03-08 at 08:33, [EMAIL PROTECTED] wrote:
Access can do it, I have queries in access that need to be able to read
the data I imported into Mysql from access.
Can it be done, if so how
(hello fellow Australian ;-)
Well, you can stuff pretty much anything into a column
Hi,
On Thu, 2002-03-07 at 08:20, bin cai wrote:
I am encountering one problem. I am using mysql as the
dabase for my application.
I create a table like takeexam as following:create
table takelabexam( sid varchar(10) not null,
cid varchar(20) not null,
Hi,
On Wed, 2002-03-06 at 11:12, Shankar Unni wrote:
(Using mysql 3.23.38 - commercial version)
I have a table that has two indexes: one on just creationTime
(iv_alert_creation_ix), and one on (state, creationTime) (iv_alert_state_ix).
When I issue this query:
explain select uuid
Hi,
On Tue, 2002-03-05 at 23:55, Petre Agenbag wrote:
I have recently had some problems with web forms not updating the
website ( use PHP and the insert page should first enter the form data
into a table and then update the status field in a second table
correlating to the entry just
Hi Richard,
On Wed, 2002-03-06 at 13:02, Richard S. Huntrods wrote:
Interestingly enough, pulling records without a sort was rather
random (rather, influence by the last sort) - but once I placed a primary
key on the table, the order of unsorted records is always constant, even
after a sort
Hi,
On Tue, 2002-03-05 at 10:53, destr0 wrote:
Is it faster for mysql to return all of the rows in a table, or to return a
set of rows picked out with a call like LIMIT 20, 40
Well, the server has to first create the whole result set in the proper
order etc, before it can do the limit. But
Hi,
On Tue, 2002-03-05 at 08:42, destr0 wrote:
whigh one is faster?
REGEXP or LIKE?
LIKE is an SQL language construct, REGEXP is a function.
LIKE only uses two simple wildcards (_ and *). Provided your LIKE
pattern does not start with a wildcard, the server will be able to use
an index for
Hi Rebecca,
On Mon, 2002-03-04 at 05:19, Rebecca Hall wrote:
I was recently assigned to finish a project started by a previous employee.
The objective is to collect data from numerous geographic locations, and
then analyze the data at the central office. The goal is to look for
combined
Hi,
On Thu, 2002-02-28 at 18:10, cherian wrote:
I'd like to know few information regarding the MySql Platforms.Since I'm
quite new to MySql I'd expect a reasonably informative reply from all.
Can MySql run on Dos platform?
I'm thinking of writing an application that will run on
Hi,
On Fri, 2002-03-01 at 06:49, Scalper wrote:
I am curious about the geographical usage of MySQL. Judging from the users
on this list it seems like it is used more heavily in Europe than in Asia
and the Americas. To date, has there been any formal studies or polls taken?
It's really
Hi Chris,
On Thu, 2002-02-28 at 10:26, Chris Herold wrote:
Problem:
Having trouble inserting text files longer than a few lines into MySQL
although short ones go in fine.
I'm using a form in HTML to get a value for $abstract...
form method=POST action=abstract_submit.php
textarea
Hi,
On Wed, 2002-02-27 at 02:55, JW wrote:
Hello,
We're been running a pretty large MySQLd with InnoDB support, last night it
crashed on us in the middle of the night. I have never sent in a bug report
like this before so please give me a little slack. I do not have any clue as
to what
Hi Peter,
On Tue, 2002-02-26 at 12:21, Peter Jennings wrote:
We have been trying to solve a replication issue related to TEMPORARY
tables.
Here's the issue
Every three hours we run a processX (C++ compiled program) on the Master
mysql that goes something like this:
CREATE TEMPORARY
Hi Anthony,
On Fri, 2002-02-22 at 23:43, Anthony W. Marino wrote:
On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote:
Is there a timeline/status for 4.x functionality available?
I would like to use MySQL 4.x, however, I'm looking for some of the
highly requested functionality
Hi,
On Sun, 2002-02-24 at 07:06, Steve Rapaport wrote:
I'm just trying to draw attention to a possible software
malfunction in the commentary section of the online docs.
[...] etc., etc.
All valuable and appropriate comments, no doubt. FOR SOME OTHER
PART OF THE MANUAL. I hope some tech
Hi Tim,
On Sat, 2002-02-23 at 02:46, Tim Allwine wrote:
So it appears there is a maximum of 32 keys (indexes) that can be
created on a table. Is there any way to increase this? If so how?
I think it is very important to ask the WHY question here can you
post your table CREATE statement,
Hi,
On Sat, 2002-02-23 at 01:14, Tod Harter wrote:
This is an example of a class of problem that crops up in a lot of
applications, like GIS systems all the time.
Unfortunately B-Tree type indexes, like RDBMS systems generally use are just
not well adapted to this type of query. I know
Hi Alec,
On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote:
Is there a timeline/status for 4.x functionality available?
I would like to use MySQL 4.x, however, I'm looking for some of the
highly requested functionality (ie; subselects, SP's, triggers and Views)
and would like to know
Hi Byron,
On Fri, 2002-02-22 at 03:23, Byron Scott wrote:
I have the following table:
CREATE TABLE phpSP_users (
primary_key mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
[...]
PRIMARY KEY (primary_key),
KEY user (user),
KEY primary_key (primary_key)
);
You
Hi,
On Fri, 2002-02-22 at 11:29, [EMAIL PROTECTED] wrote:
Have u encountered this kind of query?
mysql select edate from traffic where year(edate)='2001' group by
month(edate);
++
| edate |
++
| 2001-04-29 |
| 2001-05-01 |
| 2001-06-01 |
| 2001-07-01 |
Hi,
On Wed, 2002-02-20 at 14:44, SplitSlim wrote:
I need some help, this is a mission critical server and it has
CRASHED!
Details:FreeBSD on INTEL, MySQL v3.23.36 (FreeBSD Port)
020219 22:52:01 mysqld restarted
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you
Hi Andre,
On Wed, 2002-02-20 at 19:04, Andre Konopka wrote:
mmh, maybe it's not a mysql-problem...
Indeed, doesn't look like it.
Yes, I read through the numerous threads about this topic but I can't
solve my problem
After compiling php-4.1.1 with mysql support (mysql-3.23.47) as a DSO
Hi Neil,
On Wed, 2002-02-20 at 20:51, Neil Freeman wrote:
I am using MySQL v3.23.40 on Windows NT. When creating various MyISAM
tables the files saved are of the form *.frm *.MYD and *.MYI. So far so
good. When I copy these files over to a Linux box though some of the
*.MYD and *.MYI
Hi Neil,
On Thu, 2002-02-21 at 08:26, Neil Silvester wrote:
Just a trivial question.
How does dual locations work?
I am based in our Brisbane Australia office and am using MySQL as a backend
for a company Intranet. Our parent company is based in Hayward, California
and has recently
Hi,
On Thu, 2002-02-21 at 03:11, subodh kumar wrote:
I am finding Problem with connecting JSP and mysql,
it gives no error as well as exception,no output is coming out.
please help me in this problem
anticipating quick response
I don't mean to be negative, but considering you're basically
Hi Nilesh,
On Thu, 2002-02-21 at 15:14, Nilesh Deshpande wrote:
I am using MySQL database
I just wanted to use transaction.so as per manual i
have to make table type as Innodb.
Then i had set Innodb startup options as follows
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
Hi Noel,
On Tue, 2002-02-19 at 13:40, [EMAIL PROTECTED] wrote:
I'm wondering about row level privilages - being able to restrict what
people see and can update etc on a row level as well as a column/table
level.
As others mentioned, having VIEWs wouldn't necessarily be of any help,
since
Hi Michael,
On Wed, 2002-02-20 at 13:29, Michael Mitchell wrote:
We are considering using MySQL in an application involving recording and
processing analog signal inputs from various electric powerplant
instrumentation.
Interesting application!
It is always nice to hear where MySQL is being
Hi,
On Mon, 2002-02-18 at 18:56, Craig Vincent wrote:
snip
I am using MySql server in my application.
My application needs MySql server to be running for 24 hours and needs to
make connection with server at any time.
I have heared that by default MySql server will close the connection after
Hi,
On Tue, 2002-02-19 at 16:25, S Aravind wrote:
My company has developed a project using Java and
Oracle. The client for whom the project has been
developed wants mySQL. As a member of the team, I've
been asked to find out the basic differences between
Oracle SQL queries and your mySQL
Hi,
On Mon, 2002-02-18 at 00:40, [EMAIL PROTECTED] wrote:
I want to do substraction between tables in mysql,
MINUS not yet implemented in mysql
and this not work :
select a.* from table_a a where a in (select * from table_b)
Please post the structure of both tables. Then we can post you a
Hi,
On Mon, 2002-02-18 at 08:40, The Majestic Moined Mogul wrote:
I am still looking for a method of reading XML documents into mySQL database
and also to retrieve data from the mySQL database into an XML document
I found something on how to do it with PERL but would like to stick with
Hi Andreas,
On Sat, 2002-02-16 at 08:52, Andreas Frøsting wrote:
Why does MySQL have this strange behavoir, treating unique indexes
case-insensitive?
Can anyone explain MySQL's behaviour and how I do a workaround making
unique indexes and primary keys case sensitive?
I've been over the
Hi John,
On Sat, 2002-02-16 at 06:52, John D Siirola wrote:
I am having trouble with Mysqld unexpectedly crashing.
How-To-Repeat:
Unfortunately, I do not know how to consistently cause the
crash to repeat.
Yeah, that's always a bit tricky; and can make it very hard for the
Hi Steve,
On Thu, 2002-01-31 at 06:35, Steve Rapaport wrote:
I'd buy it!
That is possible too:
- MySQL Training (http://www.mysql.com/training/)
- MySQL Support (http://www.mysql.com/support/)
- MySQL Consulting (http://www.mysql.com/consulting/)
See, the manual and sample cnf files
Hi,
On Wed, 2002-01-30 at 00:06, Chetan Lavti wrote:
thanks for your quick reply !!
that's fine !! I have done the max.RPM installation part.
but what is fix up the startup scripts so that
binary will be the one started.
When I am trying show variables like have_%;
Hi,
On Wed, 2002-01-30 at 15:19, Chetan Lavti wrote:
It seems, you suggesting that after setting changes in the configuration
file the Show variable. will list out the 'YES' in front of
'have_innodb' (in table below). right ??
Indeed.
The second thing is that, how do I test for the
Hi,
On Tue, 2002-01-29 at 14:10, Chetan Lavti wrote:
I have downloaded and installed MySQL ( rpm's). Now, I want to configure
it with InnoDB option, as given in the manual,
but can't see the below configure file anywhere.
// cd /path/to/source/of/mysql-3.23.37
./configure --with-innodb
76 matches
Mail list logo
