>Description:
It seems that that the use of LEFT JOIN when the joined table
uses multiple primary key conditions fails to include rows which
are clearly matching on those conditions.
>How-To-Repeat:
mysql> create table foo (fooID smallint unsigned auto_increment, p
Hello,
I've been struggling with this all night. Can someone give me a push? I
have a csv file named Sheet1.txt, here's an example of its contents:
"P1002565",
"P1002566",
"P1002638",
I want to put the contents of Sheet1.txt in a table named 'passcodes'. The
passcodes table has 2 fields: 'id'
Umm does this mean there is no way to do what I need? Is it inappropiate
to ask if it'd be difficult for such a function to be added into MySQL if
it is the case that this is an impossible thing to do (or even just very
challenging)? A median is a very common function to need in accounting I
think
Hi all,
We are currently using MySQL for our database driven website. Currently,
we have about 100,000 users. In January, we will be getting 2 million new
registered users on our website.
We're buying a $50,000 Sun box to run the database server on. We're
deciding whether we should switch to Ora
Jorge del Conde wrote:
>
> Hi,
>
> As always, the best version of MySQL to work with is the latest stable
> release 3.23.46 :)
Hello,
MySQL 3.23.46 is good for work with Red Hat 6.2 system ?
I need to run apache 1.3.20, php 4.0.6 with my system...
So, I want to know which version of MySQL is b
Brian French wrote:
>
> running
> pentium 80
> 64mb ram
> 30 gig HD
> Redhat Linux 7.1
> perl 5.06
> Mysql
> |_ previously 3.23.39 after this went to 3.23.45
>
> php 4.0.4
> |_ w/ ZendOptimizer
>
> how i got to this problem:
> was running php/mysql (versions above)
> php was installed
Support wrote:
>
> Hi
>
> i have php4.0.6
> Can't see why i should change apache as i don't see that as the problem.
> is it a know issue in MySQL that 3.23.45 fixes? if not i don't upgrade
> everytime there is a new release.
> The server has been up since april this year and this is first time
OK, so I'm on a slightly older version for this experiment (3.23.36)..
I tried restarting mysqld with the line
set=lower_case_table_names=1
in my my.cnf (on RedHat 7.1), and have a table called "ipaddr" in my
database (the files are ipaddr.frm, ipaddr.MYD and ipaddr.MYI). (I have
verified
trying to compile mysql-3.23.46, getting this error. Can't find any
reference to it anywhere.
Please help;
kgcc -O3 -DDBUG_OFF -O9 -rdynamic -o isamchk isamchk.o sort.o libnisam.a
../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread
-lz -lcrypt -lnsl -lm -lpthread
../mysys/li
DBD::mysql::st execute failed: The table 'ip_src' is full at
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Mysql.pm line 172.
I get this error when running a query on my database. According to the
documentation, in later versions of mysql this problem should be bypassed
due to the automatic d
Try giving a range in the where clause, I have the latest source
(from bit keeper and it seems to alway use the index here) there is
lots of good things coming in 4.0.1.
Here I've provide some examples from my test system. Using a date
field. Forcing both a sorted response and an unsorted res
Ken Menzel wrote:
>
>Actually it MySQL 4 does. There is a small bug in it right now where
> it won't use the descending index witout a range in the where clause,
> but this is supposed to be fixed in 4.0.2.
Thanks, I am using MySQL 4. I actually want this for "order by". When
I do "create
Hi Franklin,
Actually it MySQL 4 does. I am not sure why this could not be put
in 3.23, but I assume it has something to do with the extended table
and index formats in 4.0. There is a small bug in it right now where
it won't use the descending index witout a range in the where clause,
but t
Check out urSQL from http://www.urbanresearch.com/ursql
On Fri, 30 Nov 2001, Won Lee wrote:
> Anyone know a good ERD program that will also interact with MySQL to write
> the CREATE scripts? As usual open source would be nice, also running on a
> win2k workstation.
>
> I used to use PowerDesign
Hi,
As always, the best version of MySQL to work with is the latest stable
release 3.23.46 :)
Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_
In the last episode (Nov 30), Steve Osborne said:
> I created the file with ver 3.23.43, tried to recreate database on
> 3.22.32. I administer 2 other databases the same commands and they
> work fine. I looked at the difference in the sql files, and those
> ones don't contain the PACK_KEYS statem
allrighty, for you perl/mysql folks here is the trouble I'm having.
I'm tyring to do a transaction in mysql/innodb in perl with the following
basic flow
eval{
Insert my first record
get the insert_id
(using $sth->{mysql_insert_id})
now perform other insert
Why doesn't MySQL support descending keys in indexes?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMA
Hi
While tuning the system to minimize locking, I added SQL_BUFFER_RESULT to
some
of my select statements. Since then have been seeing a lot of
created_tmp_disk_tables
e.g. below is what I see after restarting the system for less than an hour.
| Created_tmp_disk_tables | 515 |
| Created_t
I created the file with ver 3.23.43, tried to recreate database on 3.22.32.
I administer 2 other databases the same commands and they work fine. I
looked at the difference in the sql files, and those ones don't contain the
PACK_KEYS statement...just TYPE=myISAM. The command used to create the sq
"Steve Osborne" <[EMAIL PROTECTED]> wrote:
> I am receiving the following error when I try to restore a database backup
> from an .sql file:
> ERROR 1064 at line 12: You have an error in your SQL syntax near
> 'PACK_KEYS=1' at line 11
> ) TYPE=ISAM PACK_KEYS=1;
>
> Cmd used to create sql:
> mysq
Please show us your Perl code and then we can have a look and try to find
what is wrong,
Cheers Karl.
- Original Message -
From: "Ken Kinder" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 10:25 PM
Subject: Running queries while queries are still running
> I
On Fri, 30 Nov 2001 15:25:18 -0700, Ken Kinder <[EMAIL PROTECTED]> wrote:
>>I have a query. It (should) return one row. It normally does, except when I
>>do something like this:
>>
>>(query)
>>(loop through results)
>> (update table that was in the first query)
>>
>>When I do this logic in P
I have a query. It (should) return one row. It normally does, except when I
do something like this:
(query)
(loop through results)
(update table that was in the first query)
When I do this logic in Perl/DBI, it seems to restart the loop, returning the
same row, over and over again. Can this
Thanks Peter,
I have already addressed the issue with sales/webmaster, and they are
updating the page. Now, that's a Kompany.
-Original Message-
From: Peter Harvey [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 3:25 PM
To: john; Won Lee; mysqlList
Subject: Re: ERD
> ye
Hi!
> "Michael" == Michael Stassen <[EMAIL PROTECTED]> writes:
Michael> * everyone who has reported this was using the precompiled binary of gcc
Michael> (either 2.95.2 or 2.95.3) from Sunfreeware to build MySQL for Solaris 8
Michael> sparc.
Michael> * No one has spoken up to rep
database,sql,query,table
> yeah, but the http://www.thekompany.com/products/dataarchitect/ link to
> buy the dl version just shows that you have nothing in your cart, and
> doesn't give you dl options. I recommend not using that site.
I have forwarded your comments to the CEO of theKompany. I am
> the problem John is experiencing is because he didn't actually select a
> product to purchase. It is hard to add nothing to your shopping cart,
> so that is exactly what we do. There are two purchase options, one is
> CD and one is Download, and you must choose one before you add it to
> y
"Harlan Feinstein" <[EMAIL PROTECTED]> wrote:
> I've joined them an SQL statement that looks like this:
>
> select val, status
> from A
> left outer join B on val=id;
>
> What I'd LIKE is a 90-row result set, with the "status" field from table B
> when there was data available. What I'm getting i
On Saturday 01 December 2001 01:49, Heikki Tuuri wrote:
> Ady,
>
> what version of MySQL you are running? In 3.23.44 there was a bug which
> could cause an assertion failure in trx0trx.c, line 178.
I use MySQL 3.23.44, i try to download mysql 3.23.45 from Mysql.com but it
always fail, any mirror
Hi,
I've got a *BIG* problem here...
I have a mysql database with some big tables (50,000 - 80,000 records and
above)
running on a netbsd machine.
Users run queries from their windoze machines through a delphi program via
myodbc. I didn't write that application so I can only guess the queries t
Are there anyone from Auckland , New Zealand that can tell me where I can
get a good book on mysql?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (
I knew it. Nobody bothered to read my post.
The original problem involved running a lightweight version of mysqldump in
a simulated nanokernel environment with reduced power resources. The
ultimate result, we hope, is to use it to record Quidditch matches being
played in Afghanistan.
Thanks,
--
I'm having difficulty doing a LEFT OUTER JOIN, and was hoping someone could
shed a little light on what I'm doing:
Table A has one column, "val", that's an integer. There are 90 records, with
values of "val" from 1-90.
Looks like this:
val
---
1
2
.
.
.
90
Table B is more sparse, with 2 colum
yeah, but the http://www.thekompany.com/products/dataarchitect/ link to buy
the dl version just shows that you have nothing in your cart, and doesn't
give you dl options. I recommend not using that site.
I wonder how many more errors are in their software, if they cannot even
make an html link wo
OK I managed to get passed the cross compiler error. Thanks for the links Ravi and
Alan. I included /usr/local/lib in my
LD_LIBRARY_PATH and that seemed to do the trick and allowed configure to finish
however I am still concerned about certain
things not being found among others:
checking for
Jens,
That is great news! You've made my day -- that means that the rest of
my tables should work with JOIN queries, as I am building them along the
same model -- using ID numbers instead of actual names to connect to the
main "files" table. Thanks for clearing that up for me.
And also for
Heikki Tuuri wrote:
>
> Chris,
>
> what is your my.cnf or my.ini like? Do you have a big enough
> innodb_buffer_pool_size?
set-variable = innodb_buffer_pool_size=300M
big enough?
Chris
database, sql, query, table (just to keep the stoopid list software from
whinging..)
-
Sorry for the repost of this problem, but I can't find the answer anywhere,
and I'm stuck here until I solve this.
I am receiving the following error when I try to restore a database backup
from an .sql file:
ERROR 1064 at line 12: You have an error in your SQL syntax near
'PACK_KEYS=1' at line 1
> Anyone know a good ERD program that will also interact with MySQL to write
> the CREATE scripts? As usual open source would be nice, also running on a
> win2k workstation.
>
> I used to use PowerDesigner. Nice software but too expensive.
>
I have used PowerDesigner for years and have found it
Chris,
what is your my.cnf or my.ini like? Do you have a big enough
innodb_buffer_pool_size?
Regards,
Heikki
http://www.innodb.com
--
Order commercial MySQL/InnoDB support at https://order.mysql.com/
[EMAIL PROTECTED] wrote:
>
> Your message cannot be posted because it appears to be either s
Hi Erik,
> In the "files" table, each row corresponds to a separate file. There's
> all sorts of additional criteria, but the only one that matters to my
> question is the column called "div_id". That's right, the number in
That's exactly what I would recommend you to do. As you wrote, you can
Ady,
what version of MySQL you are running? In 3.23.44 there was a bug which
could cause an assertion failure in trx0trx.c, line 178.
Please test with 3.23.45 or .46.
Regards,
Heikki
http://www.innodb.com
--
Order commercial MySQL/InnoDB support at https://order.mysql.com/
>After having exper
I've not used it yet, but I saw this on freshmeat:
Data Architect from the Kompany
http://www.thekompany.com/products/dataarchitect/
Won Lee wrote:
>
> Anyone know a good ERD program that will also interact with MySQL to write
> the CREATE scripts? As usual open source would be nice, also run
On Fri, Nov 30, 2001 at 12:15:26PM -0500, Won Lee wrote:
> Anyone know a good ERD program that will also interact with MySQL to write
> the CREATE scripts? As usual open source would be nice, also running on a
> win2k workstation.
>
> I used to use PowerDesigner. Nice software but too expensive
Well, this changes things (in my mind, anyway). Now that we know it can
be done, the likely explanation is that something is wrong with the gcc
installation for people who report this. It's strange though, since a few
people who've reported this have claimed to be able to successfully build
oth
http://www.datanamic.com/dezign/
it was posted today in another thread, I checked it a little.
You create your table with complete definition (type, indexes, etc)
and you can create the .sql to implement it into mySQL
Etienne
Won Lee wrote:
>
> Anyone know a good ERD program that will also i
Anyone know a good ERD program that will also interact with MySQL to write
the CREATE scripts? As usual open source would be nice, also running on a
win2k workstation.
I used to use PowerDesigner. Nice software but too expensive.
Won
=
Not being a materialist in the U.S. i
I appreciate all the help that you all have provided I've got another
one for you all.
I am receiving the following error when I try to restore a database backup
from an .sql file:
ERROR 1064 at line 12: You have an error in your SQL syntax near
'PACK_KEYS=1' at line 11
Code used:
DROP TABLE
On Friday 30 Nov 2001 16:33, Jason Burfield wrote:
First of all, the idea of data loss because one disk has gone bad on RAID-5
is not possible. RAID-5 specifically allows you to loose up to 1 disk at any
one time, and stay active.
The reason why RAID-5 is not recommended for MySQL is speed. RA
I don't think the manual page at http://www.mysql.com/doc/S/o/Solaris.html
is much help here. It mentions setting
ac_cv_sys_restartable_syscalls=${ac_cv_sys_restartable_syscalls='no'}
in your config.cache in case of a particular error, not the one reported
here. I think I remember reading so
Hi,
I have been working with mySQL and Apache for years on linux servers. But
recently I purchased Solaris machine, and I am have problems compiling
mySQL on it.
I have
- SunOS machine1 5.8 Generic_108528-10 sun4u sparc SUNW,Sun-Blade-100
- with gcc 2.95.3 20010315
And I am getting the following
Hi,
I am planning an authentication system that is structured much like the
system Windows uses:
I have "users" and "groups". Groups can either contain users directly or can
contain other groups (which can again contain groups etc).
Now I am thinking on how to store and efficiently read those de
Hello,
I'm designing a database, and of course I have no formal training in
this area (I'm learning from DuBois's book). It's designed to keep
track of files. In my organization, we have a small design studio, and
the designers save their image files to CD-ROMs. As you can imagine,
the sta
> make fails with mksh: Fatal error in reader: = missing from replacement
> macro reference
>Current working directory
> /opt/perlModules/MyODBC-2.50.37
>
> I have ODBC working for SQL Server.
>
> If I do a make -V is leads me to a bad set of lines in Makefile:
>
> DEPS_MA
On Fri, Nov 30, 2001 at 11:56:05AM -0500, Michael Stassen wrote:
:
: This keeps coming up. So far (in my reading of this list since spring,
: and searches on Google),
:
: * everyone who has reported this was using the precompiled binary of gcc
: (either 2.95.2 or 2.95.3) from Sunfreeware t
This keeps coming up. So far (in my reading of this list since spring,
and searches on Google),
* everyone who has reported this was using the precompiled binary of gcc
(either 2.95.2 or 2.95.3) from Sunfreeware to build MySQL for Solaris 8
sparc.
* No one has spoken up to report succ
I use visio professional...
But it's home made, not auto made like with an access DB.
Plus since there are not a lot of types from visio, I prefered to make
my own drawing, using cool functions like the snapping (so when I move
tables they stay linked). Plus the relationship from visio are prett
Roxen 2.1 uses pike
-Original Message-
From: sherzodR <[EMAIL PROTECTED]>
To: "B.J.Rumsey" <[EMAIL PROTECTED]>
Date: Fri, 30 Nov 2001 10:36:47 -0600 (CST)
Subject: Re: Title counter
> B: querys the database and returns the stories to a new page. How
> do I set
> B: up a counter t
We use this:
http://www.datanamic.com/dezign/
Try the demo before buying it, it's not quite as good as it looks
(unfortunately).
Along with the "ImportER MySQL" you can just set it loose on your DDLs and
it will generate a semi-complete ER diagram of your database.
It helps if your foreign keys a
It has a command prompt, and is virtually identical to Linux or any
POSIX-compliant Unix system (from a user's point of view), but the big
difference (from a user's point of view) is that instead of using text
files such as /etc/passwd (and numerous other configuration files), this
information
Also, although the standard "groupadd" command doesn't work for adding
groups, you can use NetInfo Manager to add a group. This gives you a
GUI interface to managing your groups and users. If you don't like GUI,
use the command line tool "niutil", which has its own man page.
You would probab
B: querys the database and returns the stories to a new page. How do I set
B: up a counter to record how many times that story has been read.All
B: stories are loaded into the database and the new page is the results of
B: the query.
B:
First off, what programming API are u us
David,
I currently run a system with Raid 5. I have had one disk drop, however,
no data was lost. That is one of the beauties of RAID 5, you have a
spare disk that takes over.
I too had heard originally that running MySQL on a RAID 5 was a bad idea
(this, after I already had it running...), howe
Is there a utility that will allow me to view a mysql database that is
similar to an Access 2000 relationship diagram?
Steve Osborne
Database Programmer
Chinook Multimedia Inc.
-
Before posting, please check:
http://www.mysq
I'm using roxen 2.1 as my web server and have set up a form page which
querys the database and returns the stories to a new page. How do I set
up a counter to record how many times that story has been read.All
stories are loaded into the database and the new page is the results of
the query.
If the MySQL server is unable to create the mysql.log log file, then the
server hangs in an undeterminate state. No children are forked, and clients
can connect, however are not serviced at all.
I know there is an error in the log , or when mysqld is ran with STDERR
logging, however in my humble
Hi Johnathon,
There are several problems with threads and the C++ compiler on
FreeBSD 4.2. If you can please update to FreeBSD 4.4, or for
performance enhancements go to 4.4-stable. If you have to stay on
4.2 I can send you a patch that should work on 4.2, but you will have
to recompile MySQ
Hi
i have php4.0.6
Can't see why i should change apache as i don't see that as the problem.
is it a know issue in MySQL that 3.23.45 fixes? if not i don't upgrade
everytime there is a new release.
The server has been up since april this year and this is first time the
error has happened.
It is pr
running
pentium 80
64mb ram
30 gig HD
Redhat Linux 7.1
perl 5.06
Mysql
|_ previously 3.23.39 after this went to 3.23.45
php 4.0.4
|_ w/ ZendOptimizer
how i got to this problem:
was running php/mysql (versions above)
php was installed via the standard .tar
the MySQL server skrewed up a
"Brian P. Austin" wrote:
>
> If you are using the MySQL RPMS for RedHat, They install in the /usr directory.
> (Redhat dows things differently)
> So it would be
> ./configure --with-mysql=/usr for PHP compilation.
>
> as far as upgrading... I have used RedHat for a long time, and have found th
[EMAIL PROTECTED] wrote:
>
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query,table
>
> If you just reply to this message, and incl
On 30-Nov-01, Ravi Raman said something totally profound about RE: compile problems on
Solaris8 that made me ponder...
RR> It's been a while since I tried to compile mysql on a Solaris box, but
RR> that error most like likely indicates a compiler-related issue...I don't
RR> know how much help I
I'm using a table joiner tabel with a auto-incrementing key field, and I
would like to empty the table, and start fresh from key 1 (as compared to
the next auto-incremented key). Can anyone tell me how to do this (in mysql
or in php)?
Steve Osborne
Database Programmer
Chinook Multimedia Inc.
-
Support wrote:
>
> MySQL 3.23.39
> RH6.2
> Apache 1.3.12
>
> 2 weeks ago mysql stopped with the following example error.(repeated on
> other sites that use mysql on my server)
>
> Warning: Host 'localhost' is blocked because of many connection errors.
> Unblock with 'mysqladmin flush-hosts' in
If you are using the MySQL RPMS for RedHat, They install in the /usr directory.
(Redhat dows things differently)
So it would be
./configure --with-mysql=/usr for PHP compilation.
as far as upgrading... I have used RedHat for a long time, and have found that in
their newest distos, it is extreme
Hi.
>This didn't seem to make it to the list the first time so let's try
again. BTW is anybody else
>receiving each mail twice from the list?
It did, it's just that no one answered it. :]
Not me, the last time I thought that was happening, it had to do with my
mail sorting rules in Outlook.
I'm running MySQL on Windows2k. The service is installed and I can start it
with the WinMySQLAdmin Tool, but I have trouble to shutdown the server on a
DOScommand window with 'mysqladmin shutdown'. I also can't connect to the
server at localhost, and I can't start MySQL as a service with 'mysqld -
MySQL 3.23.39
RH6.2
Apache 1.3.12
2 weeks ago mysql stopped with the following example error.(repeated on
other sites that use mysql on my server)
Warning: Host 'localhost' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts' in
/home/domain/domain42/web/drwho/php/
Hello,
I have 2 application running in a master/slave mode.
- Application A linked to a database D
- Application A' linked to a database D'
While A is master, A' is in standby mode and D' replicates D.
If a problem occurs on A, A' becomes master and D must replicate D'.
1) Is it possible for a
Hi!
I'll be happy if I know that when "Stable version 4.0" will be released.
Thanks!
Homepage = http://www.nnr.or.kr/inos/
ICQ # = 123534385
Member of DSN(database.sarang.net), NNR(nnr.or.kr)
--MIME Multi-part separator--
--
Mweb,
Set your ODBCINI environment variable (and others) as per the HOWTO at
www.iodbc.org.
This HOWTO is for iODBC, but the concepts are the same for this error
condition.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Acc
Hello,
I've got a bunch of tables from MS Excel that I've exported to tab delimited
files that I'm trying to load into mySQL. I'm having problems getting the
data in properly though.
For instance, I have set up the ids so that they are incremented
automatically. I have the initial records in m
Joe Ellis wrote:
>
> Just For My Info: does it take long for one insert. if so, what does
> the insert statement look like. the reason i ask is becuase i use
> InnoDB and inserted a few records and it was pretty quick. but maybe
> thats becuase my statement was:
> insert into table (user,email
This didn't seem to make it to the list the first time so let's try again. BTW is
anybody else receiving each mail twice from
the list?
I am getting the same error message "configure: error: cannot run test program while
cross compiling". I think this a simple
PATH issue where basic functions
At 15.40 29/11/01 -0500, Raymond Abel wrote:
>At 16:44 2001-11-29 +, you wrote:
>>On Thursday 29 Nov 2001 16:18, Fabien R. wrote:
>>
>> > > I saw somewhere that this comparaison existed but I can't remember
>> > > where.
>> > > Does it talk to anyone ?
i used interbase to develop an applicat
Just For My Info: does it take long for one insert. if so, what does
the insert statement look like. the reason i ask is becuase i use
InnoDB and inserted a few records and it was pretty quick. but maybe
thats becuase my statement was:
insert into table (user,email,firstname,lastname) values
A good book is JSP, Servlets, and mySQL by David Harms.
-- original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 6:47 PM
To: MySQL (E-mail); '[EMAIL PROTECTED]'
Subject: Solaris, JDBC and MySQL
Hi,
Can anyone point me, a humble C programmer,
It won't work this way.
SELECT min(my_column) as MINIMAL_VALUE
will give you ONE record only. Therefore, an additional condition (which
you can get with HAVING, not WHERE) will be meaningless.
e.g:
SELECT min(my_column) as MINIMAL_VALUE
FROM mytable
HAVING MINIMAL_VALUE > 10
will return an
Norman Khine wrote:
>
> Welcome to the MySQL list;^) good to see you here...
*grinz* It's weird being a newbie again :-P
> "In inserts InnoDB uses the insert buffer to merge secondary index records
> to indexes in batches. That saves a lot of disk i/o. In rollback no such
> mechanism is used, a
Try to use HAVING instead of WHERE. I hope that will help.
Julio Faerman wrote:
JF: Hi ... I am need the following query to work :
JF: SELECT
JF: min(my_colum) as MINIMAL_VALUE
JF: WHERE
JF: MINIMAL_VALUE > 10
JF:
JF: The query is not EXACTLY as this one,
Hi try http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/page1.html
for good tutorials on PHP and MySQL, although biased toward Unix, I suppose
it should work in a similar way on IIS. Maybe wrong?!
snip
";
}
?>
-Original Message-
From: anandakkum
A quick search on Google gives some places here is the search URL:
http://www.google.com/search?hl=en&q=libodbcinst.so.1&spell=1
HTH
At 01:46 PM 11/30/2001 +1300, Quentin Bennett wrote:
>Hi,
>
>Can anyone point me, a humble C programmer, to a tutorial for setting up and
>using JDBC and MySQL.
Hi Chris,
Welcome to the MySQL list;^) good to see you here...
Any way I found a link which might explain why your InnoDB inserts take
longer, perhaps this may be the reason...
http://www.mysql.com/doc/S/E/SEC418.html
"In inserts InnoDB uses the insert buffer to merge secondary index records
to
Hi ... I am need the following query to work :
SELECT
min(my_colum) as MINIMAL_VALUE
WHERE
MINIMAL_VALUE > 10
The query is not EXACTLY as this one, but i think it is enough to get you
the idea of my problem...
Thnx for any help !
[]~S
julio
Hi!
> "Chang-Ping" == Chang-Ping Hsiao <[EMAIL PROTECTED]> writes:
>> The problem with gcc 3.0.x, as I have understood it, is that for this
>> to work you must also have libstdc++v3 installed.
>>
>> I have now updated our documentation about this.
Chang-Ping> According to the web page
Okay, second time of asking, does anyone know why InnoDB inserts are an order of
magnitude slower than BDB inserts?
Is this true only for me? If so, what am I doing wrong?
Is it a FAQ? If so, where can I find the answer?
Are InnoDB tables supposed to behave like this? If so, why?
I know I'm n
Can someone perhaps tell me why the following pseudo-code blocks at time 4,
when transaction isolation is set to READ_COMMITTED. Table A is a BDB table,
records 1 and 400 both exist. To me it seems that both updates don't have
anything to do with eachother. Does this perhaps has anything to do wit
I am not quite sure, but the only I could think of is the table locking.
Just lock those two tables at the time of transaction, and release the lock
as soon as you're done. I am sure people out here might have more
sophisticated solutions... in which case i'd like to be aware of that too
( I beli
Hi everybody:
Can anybody tellme how can y get the id asigned to a record in the moment i
insert data in the database?
I need to storage transaction requests, the mysql database assigns an unique
id (auto increment) to that record, and i need it to continue saving data in
another table.
Is ther
1 - 100 of 118 matches
Mail list logo
