en modified earlier in
the statement failed to find the existing column. (Bug #34972,
Bug #11748057)
* For FEDERATED tables, loss of connection to the remote table
during some insert operations could cause a server crash. (Bug
#34660, Bug #11747970)
* For some
bugs.mysql.com/37044)
* mysqladmin --wait ping crashed on Windows systems.
(Bug#35132: http://bugs.mysql.com/35132)
--
Jonathan Perkin, Release Engineering, MySQL
Database Technology Group, Sun Microsystems
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
.com/27439)
* If InnoDB reached its limit on the number of concurrent
transactions (1023), it wrote a descriptive message to
the error log but returned a misleading error message to
the client, or an assertion failure occurred.
(Bug#18828: http://bugs.mysql.com/
4: http://bugs.mysql.com/27884)
* mysql_convert_table_format did not prevent converting
tables to MEMORY or BLACKHOLE tables, which could result
in data loss. (Bug#27149: http://bugs.mysql.com/27149)
--
Jonathan Perkin, Release Engineering, MySQL
Database Technology Group
lated, incompatible and important bugs fixes since
the previous version of MySQL 6.0. The full changelog including many
other changes can be viewed online at
http://dev.mysql.com/doc/refman/6.0/en/news-6-0-11.html
Enjoy!
Jonathan Perkin
The MySQL Build Team, Sun Microsy
see the errata
list at
http://dev.mysql.com/doc/refman/5.1/en/open-bugs.html
The following section lists the changes in the MySQL source code since
the previous released version of MySQL 5.1. It may also be viewed
online at
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-34.html
Enjoy!
//dev.mysql.com/doc/refman/5.1/en/news-5-1-33.html
Enjoy!
Jonathan Perkin
The MySQL build team at Sun Microsystems
===
Functionality added or changed:
* mysql-test-run.pl now supports an --experimental=file_name
option. It
urity-related, incompatible and important bugs fixes since
the previous version of MySQL 6.0. The full changelog including many
other changes can be viewed online at
http://dev.mysql.com/doc/refman/6.0/en/news-6-0-10.html
Enjoy!
Jonathan Perkin
The MySQL Build Team, Sun Microsy
ciate your feedback, bug reports, bug fixes, and
patches at
http://forge.mysql.com/wiki/Contributing
The following section lists changes since the previous version of MySQL
6.0. The full changelog can also be viewed online at
http://dev.mysql.com/doc/refman/6.0/en/news-6-0-9.html
Enjoy!
Jonat
Bug#34705: http://bugs.mysql.com/34705,
Bug#34706: http://bugs.mysql.com/34706)
Enjoy!
--
Jonathan Perkin, Product Engineering, MySQL
Database Technology Group, Sun Microsystems
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
I have this query:
SELECT DISTINCT t1.string FROM t1
LEFT JOIN t2 ON t1.string=t2.string
LEFT JOIN t3 ON t1.int_a=t3.int_a
LEFT JOIN t4 ON t1.int_b=t4.int_b
WHERE
t1.string != '' AND
t2.string IS NULL AND
t3.int_a =
ORDER BY
t1.string ASC
which includes this fix.
(Bug#26489: http://bugs.mysql.com/26489)
Enjoy!
--
Jonathan Perkin, Product Engineering, MySQL
Database Technology Group, Sun Microsystems
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
as the Internet. If you experience
reliability issues and see many You have an error in your SQL
syntax errors on replication slaves, we strongly recommend
that you upgrade to a MySQL version which includes this fix.
(Bug#26489: http://bugs.mysql.com/26489)
Enjoy!
--
Jonathan
Sorry to return to this topic, I haven't found a lot to explain
what's happening.
I'm trying to total certain nutrients consumed on a given date
(though I've removed date temporarily).
You'll see I have three items (in two meals) in itemized,
and two meal totals in simple.
mysql> select id, ite
Hi,
Here's the basic query I'm trying. It's supposed to return
the totals of each nutrient (carb, in this case) by date.
The data totals 218.31, but I get 190.80.
select itemized.day_date as day_date,
round(sum(my_menu.carb * units) + simple.carb,2)
from itemized inner join simple using (uid) in
- Original Message -
From: "Jake Peavy" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc:
Sent: Saturday, April 05, 2008 11:59 AM
Subject: Re: Incorrect results from sum
On 4/5/08, Jonathan Mangin <[EMAIL PROTECTED]> wrote:
I&
I'm getting incorrect results from a sum and wonder if
anyone sees something obviously wrong. (Won't surprise
me.) Leaving 'simple' out of the equation (or adding
'simple' values manually) gets me the correct number.
$menu is a personalized table of meal/recipe ingredients.
itemized is a list of
just develop one...
Thanks
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Baron Schwartz
Sent: Sunday, January 27, 2008 9:48 AM
To: Jonathan Sion
Cc: mysql@lists.mysql.com
Subject: Re: comapring schemas
Hi,
On Jan 27, 2008 12:56 AM, Jonathan Sion
,
say, development and production environment) SQL Server and other databases
got tons of such tools. could it be that no one has developed one for MySQL?
And if so, how do developers usually do it?
Thanks
Jonathan
he moment and I don't link
this message "concern(ed) the MySQL software on Microsoft operating systems"
Regards,
- Jonathan Lampe
- Standard Networks, Inc.
- http://www.standardnetworks.com
- [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Monday 13 August 2007 10:43:33 Gary Josack wrote:
> Jonathan Horne wrote:
> > i finally have a real need that i need to sit down and learn the basics
> > of databases. i need to learn to create a database that i can use to
> > track assets at my company, and have it be re
book that i might learn this from? ill be starting
from total db-novice.
thanks in advance,
--
Jonathan Horne
http://dfwlpiki.dfwlp.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am pleased to announce the creation of a MySQL software appliance built using
rPath's rBuilder tools. The appliance includes mysql server, the latest
community edition. Give it a try, and leave feedback!
Currently, there are install images for x86/x86_64, xen domU images for
x86/x86_64, and imag
?) or, is really the only viable way to migrate or restore a
database, is to create the blank database, and then reload the dump?
thanks,
jonathan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: Jonathan Trahair
To: MySQL General
Sent: Monday, March 19, 2007 11:10 AM
Subject: Error message "Row cannot be located for updating"
Hi Everyone
I am using VB6 and MySQL, recently installed. I have a FlexGrid of items. I
save them, and in a l
erverName & ";" & " DATABASE=" & mstrThisDatabase & ";" & "UID=root;PWD="
& mstrThisPassword & "; OPTION=3"
mconn.Open
mconn.CursorLocation = adUseClient
grsOrderItems.Open mstrSQL, mconn, adOpenStatic, adLockOptimistic
Jonathan
t for different orders it will not be the same item, colour or
row number as other orders.
I've been onto Google and found some stuff about Option=2 but that didn't make
any difference.
Can anyone shed light on this dark area?
Thanks in advance.
Jonathan Trahair
conn.CursorLocation = adUseServer shouldn't the data be processed
without sending it to the client, or am I missing something?
PS, what is Option = 3 in mconn.ConnectionString?
Thanks in advance
Jonathan Trahair
3. Is this the right list for such questions?
Thanks in advance.
Jonathan Trahair
File downloads are enabled in IE but refuse to work.
Does anyone know where I can FTP the latest version
of mod_auth_mysql?
Thanks,
Jon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I concede to the MySQL engineer :-)
-Original Message-
From: Shawn Green [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 10, 2007 3:30 PM
To: Jonathan Langevin
Cc: Chris White; Richard Reina; mysql@lists.mysql.com
Subject: Re: Does Update allow for aliases?
Hi all,
Multi-table
View the documentation here:
http://dev.mysql.com/doc/refman/5.0/en/join.html
You could write your statement as
SELECT
Field1, field2
FROM
Table1
LEFT JOIN Table2
LEFT JOIN Table3
OR
SELECT
Field1, field2
FROM
(Table1, Table2)
LEFT JOIN Ta
The proper syntax would need to be:
UPDATE maindb.orders o, altdb.orders ao SET o.price=ao.price WHERE
o.ID=a.ID;
The only problem is the existence of the "from".
That being said, an UPDATE ... JOIN likely doesn't work under MySQL 3
-Original Message-
From: Chris White [mailto:[EMAIL PR
total time used for a SELECT lock)
-Original Message-
From: Jonathan Langevin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 03, 2007 4:49 PM
To: Jerry Schwartz; mysql@lists.mysql.com
Subject: RE: Question regarding Update ... LEFT JOIN
That would be fine with me, but then conversely
That would be fine with me, but then conversely it means multiple tables
would be locked by one query, which is bad in our environment (high
transaction)
-Original Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 03, 2007 4:24 PM
To: Jonathan Langevin
ld
determine whether I'll continue to use this update structure.
Many thanks!
RED VENTURES
Jonathan Langevin
PHP Developer (Home Services Corp)
14120 Ballantyne Corporate Place
Suite 200
Charlotte, NC 28277
Tel: 704-971-4373
Fax: 704-971-2303
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
- Original Message -
From: "Daniel da Veiga" <[EMAIL PROTECTED]>
To:
Sent: Thursday, December 07, 2006 9:48 AM
Subject: Re: Renaming the root user - problems.
> On 12/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > my question refers to the user "root" in MySQL 5.
Hi,
I'm using DBI and a dsn with 'mysql_client_found_rows=0' appended.
A normal update returns 0E0 if no data has changed.
The update part of insert...on duplicate key update always returns
2, whether data has changed or otherwise, plus the timestamp
column is not automatically updated.
Is there
Section 3.6.2 of the 4.1 manual has this example
using a subselect:
SELECT article, dealer, price
FROM shop
WHERE price=(SELECT MAX(price) FROM shop);
I use this basic syntax with max(date) alot.
- Original Message -
From: "João Cândido de Souza Neto" <[EMAIL PROTECTED]>
To:
Sent:
- Original Message -
From: "George Law" <[EMAIL PROTECTED]>
To: "MYSQL General List"
Sent: Wednesday, August 09, 2006 3:40 PM
Subject: forcing leading 0 for numeric fields
Hello All,
I have what is probably a simple question.
I have a table of phone numbers, broken into npa,nxx,stati
by 'value', you mean variable, right? is it a filepath?
On Jun 1, 2006, at 9:17 AM, Cory wrote:
Ed Curtis wrote:
I have a column in a table I need to replace a value of certain
records
in. The current value is /realtors/Value/. I need to change them to
/realtors/This_Value/. Is there an easy
are you using it with MySQL 5.*?
On Jun 1, 2006, at 8:42 AM, David Griffiths wrote:
Embarcadero, who in my humble opinion make the best database tools
around, have added MySQL to some of their tools.
Their tools (DBArtisan for database management, and ER Studio for
diagramming and chang
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 16, 2006 3:08 PM
Subject: Re: Converting varchar field into primary key
> Jonathan Mangin wrote:
>
> >>>
> > I'm creating a new MySQL database from an existing Filemaker db.
> >
> > My problem is that some of the existing 'numbers' in one column (it
> > was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
> > 001234. I need to maintain these numbers 'as is' - complete with
> > zeros
- Original Message -
From: "Ferindo Middleton Jr" <[EMAIL PROTECTED]>
To: "Ferindo Middleton Jr" <[EMAIL PROTECTED]>
Cc: "Hank" <[EMAIL PROTECTED]>;
Sent: Friday, March 31, 2006 7:30 PM
Subject: Re: TIMESTAMP field not automatically updating last_updated field
> Ferindo Middleton Jr wr
are you having two timestamp fields in a table (ie a created and a
last_updated)?
-j
On Mar 30, 2006, at 5:17 PM, Ferindo Middleton Jr wrote:
I think I've seen this complaint posted before but I ignored but
now I realize that in some of my db tables' last_updated field the
value is automat
I've looked around the web and found very diffreing ideas about how
this should be handled.
Basically, I want to have a content row that has two times, the time
that an insert was done and the time that it was last updated if any.
I keep getting an error when I try to create a table with t
based upon that.
-jonathan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: "Douglas S. Davis" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 21, 2006 3:58 PM
Subject: Creating a Web Database Search Application
> Hello,
>
> I commonly create webpages that need to search through a MySQL
> database and then display the results to the
- Original Message -
From: "Douglas S. Davis" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 21, 2006 3:58 PM
Subject: Creating a Web Database Search Application
> Hello,
>
> I commonly create webpages that need to search through a MySQL
> database and then display the results to the
- Original Message -
From: "bob pilly" <[EMAIL PROTECTED]>
To:
Sent: Sunday, February 12, 2006 12:44 AM
Subject: Returning values from an INSERT
> Hi everyone, im new to SQL and have a question that someone can hopefully
answer
>
> If i am inserting a new record into a table that has
I'm trying to change a couple of replace statements to
insert...on duplicate key update (using Perl/DBI).
foreach my $key (keys %e_items) {
my $sql = "insert table1
(id, date, time, uid, type, seq, value)
values
(?, ?, ?, ?, ?, ?, ?)
on du
I got exactly that error message last night when doing a
numeric comparison on a varchar column. Oops.
Kind of misleading, though.
- Original Message -
From: "David Godsey" <[EMAIL PROTECTED]>
To: "George Law" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, January 24, 2006 4:43 PM
Subject: RE:
RE: Calendar table workaround>
>A table of dates to which to join other tables,
>ensuring reports that reflect days for which no
>data is available.
I forget the query but I know it can be done. But can't you just have a table
(called calendar?) with each entry having it's own row with a date co
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Sent: Wednesday, January 04, 2006 1:25 PM
Subject: Re: Calendar table workaround
>
> - Original Message -
> From: "Jonathan Mangin
I created a calendar table (date only), but all
where clauses include a uid. Is the following a
sane workaround to get a usable calendar table?
Anything else I can do?
my $sth = $dbh->prepare("
create table $temp_tbl
(date date,
uid varchar(14))
select date,
? as uid
from calendar
where date betw
1/06, Alex <[EMAIL PROTECTED]> wrote:
> the table type whether it is myisam or innodb. create table statements are
> preferred when you have slow query issues.
>
> --Alex
>
>
> On Wed, 04 Jan 2006 15:57:06 +0530, Jonathan Chong <[EMAIL PROTECTED]>
> wrote:
>
>
Please provide details like what tables are you using, the entire my.cnf
> and the information from the mysqld.err when the crashes occurred.
>
>
> --Alex
--
Jonathan Chong
http://www.arsenal-now.com/
http://www.arsenal-mania.com/
http://www.ashburrn.com/
http://www.jonathan-chong.com/
--
information from the mysqld.err when the crashes occurred.
>
>
> --Alex
>
>
> On Wed, 04 Jan 2006 06:11:24 +0530, Jonathan Chong <[EMAIL PROTECTED]>
> wrote:
>
> > Hi everyone
> >
> > I run a relatively popular forum that gets overloaded on match days.
any ideas I can try
out, I'd appreciate it if you could please let me know.
I can provide more stats if necessary!
Thanks in advance.
--
Jonathan Chong
http://www.arsenal-now.com/
http://www.arsenal-mania.com/
http://www.ashburrn.com/
http://www.jonathan-chong.com/
--
MySQL General Mailing
tables during I/O access.
I'm running an AMD64 3000+ with 1GB of memory.
--
Jonathan Chong
http://www.arsenal-now.com/
http://www.arsenal-mania.com/
http://www.ashburrn.com/
http://www.jonathan-chong.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
ite a parse script to do this for me?
Another option would be to have a snapshot_id column in every table,
but is slightly more messy from my point of view.
Please let me know your thoughts, thanks.
--
Jonathan Chong
http://www.arsenal-now.com/
http://www.arsenal-mania.com/
http://www.ashburrn.com/
This should be working.
You can respond directly to me with schema and SQL that you are using and I
can try to reproduce in-house.
Thanks,
Jonathan Miller
Austin, Texas USA
Senior Quality Assurance Developer
MySQL AB www.mysql.com
I'm trying to correct a situation I've created after
combining separate date/time columns into a datetime column.
Here are skeletons of new table definitions.
CREATE TABLE products
(id mediumint unsigned primary key not null auto_increment,
item varchar(40) not null,
priceA decimal(6,3),
(I used to have separate date/time cols. in all tables
but changed them to datetime and buggered up some stuff.
Now I'm trying to find the best way to fix this.)
If I have an indexed datetime column (`date`), and say:
select date,
from table1
where date between '2005-08-01' and '200
- Original Message -
From: "Jonathan Mangin" <[EMAIL PROTECTED]>
To:
Sent: Monday, November 21, 2005 8:48 AM
Subject: Index of JOINed table?
I have a simple query, (part of a union).
calendar is a table of only dates, `date` as PK.
sales has a multi-col ind
I have a simple query, (part of a union).
calendar is a table of only dates, `date` as PK.
sales has a multi-col index on (date, uid).
(select calendar.date as date,
time_format(time(sales.date),'%H:%i') as time,
from calendar
left join sales
on date(sales.date) = calendar.d
Stupid question. units is no different from item1 at this point.
- Original Message -
From: "Jonathan Mangin" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 15, 2005 2:36 PM
Subject: Missing column in select??
I thought I'd found a mistake...
$sql
I thought I'd found a mistake...
$sql = "(select date(date) as date,
time_format(time(date),'%H:%i') as time,
units, # I forgot to include this
round(sum(item1 * units),2),
but all the numbers are correct. Does mysql know to multiply b
I have a Windows 2000 host with 3.5 G of ram. I have configured MySQL
4.1.14 with innodb_buffer_pool = 1024M, when I start mysqld I get the
following error:
051013 16:46:00 InnoDB: Error: cannot allocate 1073758208 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB
Hi,
I have mysql 4.1.14 on solaris 9 and have just switched to using the
innodb_file_per_table option. Previously I was using MyISAM tables and
created about 700 tables.
The rlim_fd_cur and rlim_fd_max kernel paramteres are set to 256.
I'm getting an error from innodb that it is running out
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, October 07, 2005 2:09 PM
Subject: Re: Joining tables, duplicating none
"Jonathan Mangin" <[EMAIL PROTECTED]> wrote on 10/07/2005 02:57:28
I have two tables with date and uid cols. in common.
Table 1 has one row per date, Table 2 has a maximum
of 7 rows per date.
select t1.date, t1.val, t2.val from t1
right join t2 on t1.date = t2.date
where t1.date between '2005-08-01' and '2005-08-14'
and t1.uid = 'me';
+-
w variables like 'tx_isolation';
to find out the transaction isolation level. See:
http://dev.mysql.com/doc/mysql/en/InnoDB_Monitor.html
http://dev.mysql.com/doc/mysql/en/show-processlist.html
"Jonathan Stockley" <[EMAIL PROTECTED]> wrote:
>Hi,
>
Hi,
We're having a problem with "lock wait timeout exceeded" errors. We are
exclusively using innodb tables apart from the mysql database. The
problem seems to be with the way we are simulating sequences.
There is a table called SEQUENCES defined as follows:
CREATE TABLE IF NOT EXISTS Sequ
- Original Message -
From: "Jonathan Mangin" <[EMAIL PROTECTED]>
To:
Sent: Saturday, September 24, 2005 2:18 PM
Subject: Using ifnull in a subquery
Hello all,
This works if t2 is populated:
select t1.item_no, t1.value1 *
(select weight from t2 where
item_no
Hello all,
This works if t2 is populated:
select t1.item_no, t1.value1 *
(select weight from t2 where
item_no = t1.item_no and
descrip = 'dime bag')
from t1
where t1.descrip = 'marigold seeds'
If t1.item_no and/or 'dime bag' don't exist in t2 I'd
like to multiply by a different value (5):
sele
I see these really need to be int or time types.
Is there no way they can default to NULL or blank?
Hi,
I think I'd like to store these values as strings
instead of [?]int or time types.
mysql> select '3' - '1';
+---+
| '3' - '1' |
+---+
| 2 |
+---+
1 row in se
Hi,
I think I'd like to store these values as strings
instead of [?]int or time types.
Is this string arithmetic? Can/should I do this?
(I see the second one won't work without single-quotes.)
mysql> select '3' - '1';
+---+
| '3' - '1' |
+---+
| 2 |
+---+
1 row
Jonathan Mangin wrote:
Hello all,
I'm storing data from a series of tests throughout each
24-hour period. I thought to create a table for each test.
(There are six tests, lots more cols per test, and many
users performing each test.)
But each test is performed no more than once per d
Hello all,
I'm storing data from a series of tests throughout each
24-hour period. I thought to create a table for each test.
(There are six tests, lots more cols per test, and many
users performing each test.)
select test1.date, test1.time, test2.date, test2.time from
test1 left join test2 on
- Original Message -
From: "Juan Pedro Reyes Molina" <[EMAIL PROTECTED]>
To: "Hassan Schroeder" <[EMAIL PROTECTED]>
Cc: "mysql general list"
Sent: Saturday, June 25, 2005 2:08 PM
Subject: Re: starting mysql 4.1.12 on Ubuntu Linux
hello, Hassan
which mysql gives me /usr/bin/mysql. e
Thanks, that works (I'll have to read a bit to learn why)
except for one thing I didn't mention. (Everybody Lies :)
How ugly is this?
$sql = "INSERT into $table2"; # dynamic name with $user_id as root
$sql .= sprintf <<'EOF', join(',', @array);
I see.
I suppose this produced quite a few grins.
Ha
- Original Message -
From: "Eamon Daly" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, May 19, 2005 1:17 PM
Subject: Re: Efficient select/insert
my $sql = sprintf <<'EOF', join(',', @array);
> This would be even faster if you could concatenate all of the elements
of
> @array into a single list then you could say:
>
> #My PERL skills are non existent so you need to write this part.
> #I am assuming that @array is holding a list of string values.
>
> foreach my $element (@array) {
> @ar
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, April 26, 2005 3:20 PM
Subject: Re: Efficient select/insert
"Jonathan Mangin" <[EMAIL PROTECTED]> wrote on 04/26/2005 12:26:20
PM:
I woul
- Original Message -
From: "Jonathan Mangin" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 26, 2005 11:26 AM
Subject: Efficient select/insert
I would like to select several rows from one table
and insert them into another nearly identical table
using Perl/DBI:
my @a
I would like to select several rows from one table
and insert them into another nearly identical table
using Perl/DBI:
my @array = $q->param(); # HTML checkboxes
foreach my $element (@array) {
my $sql = "select col2, col3, col4 from table1
where col1 = ?";
my $sth = $dbh->prepare(
7;
in order to work. Otherwise set
$cfg['PmaAbsoluteUri_DisableWarning'] = TRUE;
In order to disable the warnings.
--
Jonathan Wright
Life has no meaning unless we can enjoy what we've been given
--
Running on Gentoo Linux
(2.6.10-gentoo-r7-djnauk-b03 i686 AMD Athlon(tm) XP 2100+ GNU
y but according to the
manual, a multi-row INSERT is faster.
I think you're looking for something like
INSERT INTO table [ (x, y, z) ] VALUES (a, b, c),
(d, e, f),
(h, i, j);
--
Jonathan Wright
Life has no meaning
man pkgadd
-J
- Original Message -
From: "Joerg Bruehe" <[EMAIL PROTECTED]>
To:
Cc: "Jonathan Stockley" <[EMAIL PROTECTED]>
Sent: Thursday, March 17, 2005 9:16 AM
Subject: Re: 4.1.10a packaging for Solaris
Hi Jonathan, all!
Am Mi, den 16.03.2005 schri
I just downloaded the 4.1.10a release for Solaris 8 and 9 (32bit). It
seems that it is no longer in a tar archive. Was this change
intentional?
I cant find any mention of it on the web site. How do I unpack the new
format into a given directory?
Thanks,
Jo
Hello,
Does this mean a key is not being used?
mysql> explain select vl_ts from view_log where vl_uid='bb';
+--+--+---+--+-+--+--++
| table| type | possible_keys | key | key_len | ref | rows | Extra
|
+--+--+
udied), and I'm
interested to know how the query is optimized given a multiple column
searches and possible multiple indexes. :)
--
Jonathan Wright
Life has no meaning unless we can enjoy what we've been given
--
Running on Gentoo Linux
(2.6.10-gentoo-r7-djnauk-b03 i686 AMD At
es MySQL (currently 4.0.14, although it'll be
running on 3.23.53 eventually) allow the searching of multiple indexes,
or is it better to specify multiple indexes with similar columns to
maximize performance?
Thanks,
--
jonathan wright
// mail at djnauk.co.uk // running on gentoo linux
// life has n
Hi,
I have a change request.
Could you add the +z (or +Z) flag to the compile flags of the standard
static mysql client library (libmysqlclient.a) on HPUX.
I am building a shared library in my application and it links with
libmysqlclient.a. However, on HPUX I have to build my own version of
l
Friends,
I goofed up when creating my table - I established my column in reverse order.
How can I move them all back around?
Regards,
Jonathan
I have an installation of 4.1 and 5 running on the same test server... I
want to start using 5 for testing but still want to use the same test data
I had before... Is it possible to simply point MySQL 5 to the old 4 data
dir?
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
Never mind, it was a query optimization issue. Upon the third
interogation of the other admin, he remembered one small setting that he
changed, which just so happened to increase the number of queries
exponentially.
Thanks,
Jonathan Duncan
On Mon, 6 Dec 2004, Jonathan Duncan wrote:
Background
admin said he only edited an e-mail address on someone's account.
Help?
Thank you very much for your time,
Jonathan Duncan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 312 matches
Mail list logo
