't trivial to set up.
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.
--
Ar
ho wants to build on it or improve it, and said it
> > > plans to add more to open source systems in the future.
> > >
> > > Redwood Shores-based Oracle (NASDAQ: ORCL) said it plans to negotiate to
> > > extend the deal between Innobase and MySQL when it needs to b
e to open source systems in the future.
>
> Redwood 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
or
instance).
Regards,
Arjen.
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL Users Conference 2006 (Santa Clara CA, 24-27 April)
Call for Papers deadline 7 Nov 2005: http://www.mysqluc.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
to
http://www.mysql.com/news-and-events/users-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 Mail
ist companies where using
GPL-licensed software runs into policy problems, etc.
We do also sell non-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.
Regard
some time though.
Would a special 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)
Onl
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
me specific cases, but this was fixed ages ago in a 4.0 release.
If I'm not mistaken, ALL combinations are now tested in the standard
test suite so any bug would block a release going out.
> I would like to have a comment on this as well... or rather: I wonder if
> anyone agrees with me
s regardless of their experience or configuration choices.
In addition, we are working on a set of proactive services to help alert
you to bugs, security issues and new features.
Naturally we will also continue to educate our users about security (strong
passwords and firewalls) on all platfor
SERT privs and
any other privileges you want controlled).
Depending on the cron job frequency that's slightly rougher in terms 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 Confe
nce itself, see:
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
source code and
> compiling it on our systems?
The general compile process is documented in the manual at
www.mysql.com/doc/, 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'
These threads do need some memory of course. The
connection-specific 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):
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,
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 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,
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 freezer
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 whe
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 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:
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 20
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-10
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;
>
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 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
>
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:
>
> @fi
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 port
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...
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
> b
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-) tr
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
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 th
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
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 symli
Hi,
On Fri, 2002-03-08 at 17:07, Pramod_Chakravarthy wrote:
> I am looking out some information on the features My SQL freeware version
> and the Enterprise version. So I would be very happy if you could put on a
> table with the comparison of Mysql freeware version vs Mysql enterprise
> version.
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 col
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,
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 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 so
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 m
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 sele
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 t
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
> combi
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 i
Hi Wilbur,
On Fri, 2002-03-01 at 13:28, Wilbur Streett wrote:
> I'm working on indexing words in web pages, and I'm finding a significant
> issue with the performance of MyODBC, even when I resort to using batch
> mode inserts..
>
> I'm currently using the older version of MyODBC, and basically
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,
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 Dos,Lin
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...
>
>
>
>
>
>
> I am then using PHP to insert the info
Hi,
On Thu, 2002-02-28 at 04:43, Oscar Colino wrote:
> I read your thread discussion Jan and it is certainly very interesting to
> me.
> There are though a couple of areas where I would (oh shit you wrote this
> email in 1999, I hope you are still there anyway ..) be rather skeptical,
> and th
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
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 TEM
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 kn
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 statemen
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
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 func
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 t
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 |
> | 2
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)
> );
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,
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 basicall
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 conv
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 exte
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 DS
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' tell
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 bein
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,
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 mySQ
Hi,
On Mon, 2002-02-18 at 18:56, Craig Vincent wrote:
>
> 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 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 wi
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 y
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 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 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 alread
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
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 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-in
79 matches
Mail list logo
