Same Here! Bryan! Do let me know if you find one.
- Original Message -
From: Aravind N V Gorthy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 11, 2002 12:59 PM
Subject: Java Related Sites for MySQL
Hi
Are there any JAVA based Forum sites which are using
MySQL as the
At 07:16 2002-01-11, Michael T. Babcock wrote:
On Thu, Jan 10, 2002 at 08:55:35PM +0100, Marjolein Katsma wrote:
That proves it's a REAL problem for subscribers to this list.
No, it proves that some subscribers (like yourself) have real problems.
Your E-mails will all be blacklisted at my
Hello all,
www.infinitehost.com
Kind regards
Emmanuel
Same Here! Bryan! Do let me know if you find one.
- Original Message -
From: Aravind N V Gorthy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 11, 2002 12:59 PM
Subject: Java Related Sites for MySQL
Thursday, January 10, 2002, 8:43:04 PM, you wrote:
Maybe the list mom/dad doesn't care where you go.
Maybe MySQL provides this list for free and doesn't
care what you think. If you don't like it, get off
the boat. A free list, which puts people in direct
contact with the developers, is a
Tip: try the myvars module (for example: moodss myvars --host myhost),
and optimize your server configuration very efficiently, by simply
comparing each variable value with its corresponding documentation
(only a mouse move away thanks to the balloon help on the variable
name). Take a similar
Hi there,
I wonder if anyone can help?
How would I go through a whole table changing the values:
StuartD to stuartd
thanks a mil,
Stuart Otway.
MoveAssist International Ltd
Ickleford Manor
Turnpike Lane
Ickleford, Hitchin
Herts SG5 3XE
United
Friday, January 11, 2002, 12:26:00 PM, you wrote:
Hi there,
I wonder if anyone can help?
How would I go through a whole table changing the values:
StuartD to stuartd
UPDATE users SET username = 'stuartd' WHERE username = 'StuartD';
--
Pål Sollie - [EMAIL PROTECTED]
Change is good most
Alex,
Further to Anvar's suggestions:
- in addition to time_to_sec() recommend you look at sec_to_time() - which saves the
repeated division to
produce 'elapsed time'
- alternatively take a look at unix_timestamp() and from_unixtime() which would allow
the recording of all times
to the
Hi,
I am new to test case design in Database.
I wants to know Basically how to calculate the Maximum Database.
When we have to take backup.?
What are steps to be flow please tell me.
Thanks in advance.
Manish Mehta
E-mail: [EMAIL PROTECTED]
Hello.
I have tried using the latest MyCC on
Windows NT 4.0 (SP 6a) Server to connect to
a MySQL database on a FreeBSD box.
Everything's fine until I connect :-6
Upon connection I get a message that
'The instruction at 0x10006bf5 referenced
memory at 0x0014. The memory could not
be read.'
HI guys!
I am having a problem with Redhat 7.2. After
installation mysql does not talk to php on the apache
server. Any time i try to access a page I get a warning
message which says path is not included in php.ini.
I have not done any modification to the php.ini file.
Any help?
NB: phpinfo()
Thanks for the info Heikki, but life has not got any better. I have bought
the mySQL book (Paul DuBois) and I am still baffled. Maybe I am having a
blonde week (I am blonde). From the screen shots I have seen of myCC it
looks similar to SQL Server. That is what I am looking for. My understanding
At 11:57 11/01/02 +, Andrew Aragi wrote:
Hi!
Thanks for the info Heikki, but life has not got any better. I have bought
the mySQL book (Paul DuBois) and I am still baffled. Maybe I am having a
blonde week (I am blonde). From the screen shots I have seen of myCC it
looks similar to SQL Server.
What is the correct way of having 1 user connect from only 2 hosts to
the same database? Since user,host, and db fields are all primary keys
in the all of the user, host, db tables. I can't enter a user twice with
diffrent hosts as I had planned on doing it. I'd prefer to explicitly
state the
Hi Miguel.
I am not using any software to rename the boot HD. Concerning the path
C:\mysql\bin mysqld-max --standalone this is out of the pdf manual. What
would be the correct path then?
Thanks
-
Before posting, please
it seems not possible.
however, you may solve with a little trick in Linux systems...
For example:
If you have a Linux Machine with MySQL. and
the computers which will connect to the database has IP numbers
212.45.64.20 and 212.45.64.21
One step at a time.
Your first problem is user authentication?
A few options:
1. Directory access (as you mentioned in your message)
The user must be authenticated to run the scripts / view the web pages
2. DBMS built-in security
Not supported (properly) by MS-Access but can easily be
One more thing...
Are you sure that user/host and db fields are primary keys such
that they does not accept double/triple entrance?
My User Table is something like this.
Host
User
=
localhost
At 12:40 11/01/02 +, Andrew Aragi wrote:
Hi,
Hi Miguel.
I am not using any software to rename the boot HD. Concerning the path
C:\mysql\bin mysqld-max --standalone this is out of the pdf manual. What
would be the correct path then?
If you had installed with the default path:
you are correct, my assumption was wrong, you can add the same user to
the user table twice, I'm assuming as long as the host-user combination
is unique.
On Fri, 2002-01-11 at 07:50, Sait Karalar wrote:
One more thing...
Are you sure that user/host and db fields are primary keys such that
Becky McElroy writes:
Thank you for your response and the info.
Actually I was using 4.0.1 which I downloaded a couple of days ago:
[beckymcelroy@indigo bhm]$ rpm -qa | grep SQL
MySQL-Max-4.0.1-2
MySQL-client-4.0.1-2
MySQL-4.0.1-2
[beckymcelroy@indigo bhm]$
[skip]
--
Becky
Dr. Frank Ullrich wrote:
Steve,
what did explain tell you in either case?
Good question Dr. Ullrich.
mysql explain select rec_no,phone_no from White where phone_no=0636941;
+---+--+---+--+-+--+--++
| table | type | possible_keys |
Hi Miguel.. still in the dark.
I installed mySQL into the c:\mysql directory.
So pardon my ignorance but what is the difference
between besides the symbol? What does the
do. When I use the latter it say that this
cmd is not recognized.
c:\mysql\bin\mysqld-max --standalone
What operating system are you using?
The path vars etc are found in your mysqld_safe or safe_mysqld script, at
least in *NIX systems
-Original Message-
From: Roman Eisner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 6:06 PM
To: [EMAIL PROTECTED]
Subject: Path Variables
- Original Message -
From: Andrew Aragi [EMAIL PROTECTED]
Sent: Friday, January 11, 2002 8:30 AM
Subject: Re: Installation of mySQL on a Win2000 Pro machine
So pardon my ignorance but what is the difference
between besides the symbol? What does the
do. When I use the latter it say
Hi
The that you see in the command prompt is only for decoration you can
easy change the look on you command prompt to show you something else. The
proper way to start your program is:
c:\mysql\bin\mysqld-max --standalone not the otherway.
Regards
Jonas Arvidsson
PS.
The look and apperance
Sir,
I have install Mysql 3.23.41 in my redhat 7.2. For
some reason the logic partition of /var is so small,
now I want to change the mysql's default directory to
another bigger partition. How can I do that?
Of course, I do not want to uninstall and reinstall
mysql if there is another
Hi,
I'm in desperate need of help.
MySQL keeps dying and I just can't figure out why...
Here goes:
Clients connect from Windows machines via VB and Delphi apps
through myodbc doing queries on databases with *big* tables containing over
1.6 million records
Often they're losing connection
You might want to increase your max_connections using :
-O max_connections=1000
as an option in mysqld_safe. See
http://www.mysql.com/doc/S/e/Server_parameters.html
for more information.
-Original Message-
From: Müller, Markus [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002
Anvar Hussain K.M. writes:
Hi,
Since the equality test is for a number, the phone_no field of every row of
the table
is converted into a number first and tested for the equality. This makes it
impossible
to use the character index and so forces the full table scan.
If it were using the
Quick Newbie question:
Can I use MySQL with Coldfusion server? If yes, are there any limitations or
provisos I should know about?
Thanks as always
Mark
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Quick Newbie question:
Can I use MySQL with Coldfusion server? If yes, are there any limitations or
provisos I should know about?
Thanks as always
Mark
-
Before posting, please check:
http://www.mysql.com/manual.php
Dnia(at) pi? 11. stycze¨½ 2002 14:56, willinger netcactus napisa?(said):
| Sir,
|
|I have install Mysql 3.23.41 in my redhat 7.2. For
| some reason the logic partition of /var is so small,
| now I want to change the mysql's default directory to
| another bigger partition. How can I do that?
|
* Steve Rapaport
Regarding integer/string conversions:
select rec_no,phone_no from White where phone_no=0636941;
versus
select rec_no,phone_no from White where phone_no='0636941';
Seems naive to me, since the datatype of the field is known, why
not convert the constant instead? Then
Trond Eivind Glomsrød writes:
Is there a clean way to administrate mysqld without a password by
root?
I'm looking for ways to make it flush logs, reload my.cnf and shut
down cleanly, in an automated way - i.e, no password, but by root.
(similar to pg_ctl for postgresql or `kill -HUP`
Are you sure the password for root is christ1 ?
Did you try it without the -p ?
Kory Wheatley wrote:
I have MYSQL installed on a hpux 11.0 unix system
I installed the binary and everything started up correctly
using /opt/mysql/bin/safe_mysqld
but when I try to connect as an user
Use the buil-in replication.
On the slave machine, insert a record in the database on the master.
Then check for that record in the slave database.
Jochen Kaechelin wrote:
Is there a tool - a php script would be prefered -
to compare a local and a remote database for synchronisation?
Our aim
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 include the entire text of it in the
reply,
Thanks, Paul. ;)
~rob
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 8:22 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: DATES Optimization
At 9:02 -0600 1/9/02, Robert L. Yelvington wrote:
Two quick qux for the
ColdFusion server on Unix/Linux platform, then yes. The ColdFusion server for
Linux/Unix comes complete with the MySQL drivers necessary. I have successfully
created CF-MySQL pages without any problem.
When I have installed ColdFusion on Windows platforms, it has NOT come with the
MySQL drivers.
On Thursday 10 January 2002 17:22, Matthew Walker wrote:
Where I work, we're at the point of needing to maintain two database
servers, one inhouse, and the other at another physical location. We
need to replicate between the servers, to keep them both up to date, as
both will be getting
While I don't like the idea of limiting messages to subscribers (I hate
signing up for things, especially when I'm only going to post a few
messages), I think it's still very important. Like any other problem,
ignoring it will only send a message of passive acceptance and the amount of
spam WILL
I currently use MySQL along with CF v5 on a Win2k box. After installing
MySQL, install the myODBC drivers (also available at MySQL.com), setup your
DSN on your win box, then attach them in CF and you are ready to rock.
While my install is still new (a few months), I could not be happier after
Any suggestions on loging tools I cna run to try to find out more
information? The machine is coloced about 3 hours for me, so I would
hate to have to drive there and install FreeBSD on it, when it was just
something I could have fixed.
Gavin
Blestan Tabakov wrote:
hi!
i'm running mysql on
database,sql,query,table
Hi Stephen
Good to hear your very postive notes on Win2K/Coldfusion/MySQL. I'm just
setting up, and wondering about some notes in the MySQL documentation:
In the following circumstances you will need to use the MySQL
configuration file:
1.The install/data directories
Hey,
I would file a bug via mysql_bug but for my fear of emacs, so i am going to
attempt to provide as much info here in the hope you don't request a
./mysql_bug report. :)
I am trying to install mysql on a client's box, it's latest stable version
(mysql-3.23.47), and installed to
Hi, I just read the message that Mark posted concerning ColdFusion. It would
be much appreciated if Stephen S Zappardo could email me concerning his
installation of mySQL on Win2k box as I have been having endless problems
doing it. I am going to be doing developing in Coldfusion and wanting to
We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47.
Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5.
After being up for a few days, the system completely froze. No ssh, no
console, nothing. Had to hard reset the server.
Yes, we compiled MySQL: we have to. Our
Hello everyone,
I guess I have the similar question, that has been brought up.
I have 36 InnoDB tables, and I have allocated two 2GB partitions for my data.
Provided I have very big hard drive, how many partitions at 2GB each could I allocate?
As many as my hard drive can handle?
I also
Could be the 2.4.17 kernel..
I run a Dual RH 7.1 machine:
mysql status;
--
--snip--
Uptime: 57 days 11 hours 57 min 28 sec
#uptime
11:36am up 57 days, 13:28, 1 user, load average: 0.00, 0.00, 0.00
#uname -a
Linux [hidden] 2.4.8 #3 SMP Tue Aug 14 09:47:47 CDT
i don't have any problem with this config :
slackware 7.1, kernel 2.2.18, MySQL 3.23.41
Dual PIII-800, 256MB RAM, SCSI Ultra-160
maybe it's kernel 2.4 fault.
HTH
(sorry for the duplicated message Joshua, forgot to send to the ML)
At 18:26 11/01/2002, you wrote:
We are having the same
Joshua J.Kugler writes:
We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47.
Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5.
After being up for a few days, the system completely froze. No ssh, no
console, nothing. Had to hard reset the server.
Yes, we
Forgot to say I was running MySQL v 3.23.39
Also, I read in one of the other messages on this thread
that the problem might be RedHat. I don't relly belive this
because a kernel is a kernel.
RedHat = Every other Distro when it comes to issues with
the kernel (memory,diskaccess,etc). In my
Yes, this had occured to me. I am thinking about downgrading to kernel
2.4.8, or such. Not sure I really want to do that, but I'd rather do that
than face system lock ups.
j- k-
On Friday 11 January 2002 08:55, Sinisa Milivojevic wrote:
If nothing works as you said, no ssh, no
Mark --
We've been running Cold Fusion with MySQL on the Solaris platform for
almost two years now and have had such terrible problems with Cold
Fusion errors that we have begun the process of migrating to PHP. Our
average load has been about 30,000 .cfm pages (linked to MySQL backend)
served
I'm running ok on my Dual PII machine, if this helps anyone.
Redhat 7.1, 2.4.2-SGI_XFS kernel, MySQL 3.23.43.
[root@willyjr /root]# uptime
1:07pm up 95 days, 4:08, 1 user, load average: 0.08, 0.04, 0.01
[root@willyjr /root]# cat /etc/redhat-release
Red Hat Linux release 7.1 (Seawolf)
database,sql,query,table
Hi Andy
Wow! Well, that's made me take a double take! Sorry to hear of your woes, as
I know having to deal with that sort of thing (especially for so long!) is
no joke.
Seems strange that there are such diverging reports on coldfusion today, but
your experience and
Hello,
I am new to mysql. I know, in Oracle, when you spool file, then spool off, this will
create a file on your server. What is the equivalent command for Mysql.
For example:
sqlplus Spool C:\temp\table_names
sqlplus select table_name from user_tables;
sqlplus spool off;
This will create
Check out select into outfile.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL
ECT
Ryan
- Original Message -
From: Cindy Yu [EMAIL PROTECTED]
I am new to mysql. I know, in Oracle, when you spool file, then spool off,
this will create a file on your
I have three tables, each with a single column, data.
I'd like to form a query that will combine the table columns into a
common result column.
When I use the query: SELECT * from tab1, tab2, tab3 I get:
+-++---+
| data| data | data |
Hello,
I've just recently discovered a problem that I'm having a bit of difficulty
solving. I have a MySQL server running (3.23.47) on a Debian machine and
everything seemed to be working fine until I tried to connect to the SQL
through tcp/ip sockets. It works fine through Unix sockets,
hi all,
in debian, the /etc/init.d/mysql script waits for the appearance of
/var/run/mysqld/mysqld.pid to conclude that the server has started. since
the red hat init script does not do that, my program's own installer has to.
however we have had a report that waiting for the pidfile is not
On Thu, 10 Jan 2002, Dan Nelson wrote:
In the last episode (Jan 11), Manish Mehta said:
As we know that MySql support maximum of 4 GB data per table.
Actually, http://www.mysql.com/doc/T/a/Table_size.html says that only
Mysql 3.22 had a 4gb table size. With 3.23, the real limit is how
Yes and no. With 3.23, the MyISAM format will, by default, have a 4GB
limit (32 bits). You can set flags on the table to allow a 64-bit table,
and you'll generally hit an OS or physical limitation long before you
run out of space. The downside of the 64-bit version is it's considerably
Hello,
I am new to MYSQL
platform: Sun Solaris 2.6
mysql version: 3.22.32
I upgrade the hard drive from 4G to 18G as database
was increasing and causing problem now space problem
is solved and got in to another problem.
Database is not getting updated through
C programs and perl scripts(
* Cindy Yu
I am new to mysql. I know, in Oracle, when you spool file, then
spool off, this will create a file on your server. What is the
equivalent command for Mysql.
For example:
sqlplus Spool C:\temp\table_names
sqlplus select table_name from user_tables;
sqlplus spool off;
This
a quick fix would be to see if the default port is open or not...something
like:
netstat -an | grep 3306
you could put that in a shell script and do all sorts of tests against it.
-OR-
you could use mysqladmin and whatever flag used to check status.
hope this helps.
~rob
-Original
This is speculation:
They're slower because many operations have to be done using 64 bit
values rather than 32 bit values. You set the flag by setting the max
data size when creating the table. You can also alter this after the
table is created with ALTER TABLE. The doc suggests you're
ummm. you go ahead with that and noone will stay on the list.
again, now with my stupid reply, there has been more posts about spam
than actual spam.
let's do the list a favor and put this thread to bed.
jOda
-Original Message-
From: Patrick Crowley [mailto:[EMAIL PROTECTED]]
Sent:
Below code does not print contents of the select sql
statement to file ??
When I run a select on the table i get results in the
dos shell.
All the code below does is print column names and
nothing more ??
code:
open(file,C:/perl/bin/mysql.txt) or warn did not
open file\n;
undef $sql;
$sql =
A little higher barrier to entry, even for non-spam posts might not be
a bad thing. The list is already pretty well spammed with questions
that are either in the manual, or result from a lack of programming
experience in general.
Making it harder to post might make it a little easier to stay
Solaris 8
GCC 3.03
Ok, first I got an error about iso/math_iso.h not being there so I commented
it out of the math.h file. This got me past that error, now I get this
error.
gcc -O3 -DUNDEF_THREADS_HACK -I./../include
-I../include -I./.. -I..-I..-O
-Original Message-
From: Andy Ingham [mailto:[EMAIL PROTECTED]]
We've been running Cold Fusion with MySQL on the Solaris platform for
almost two years now and have had such terrible problems with Cold
Fusion errors that we have begun the process of migrating to
PHP. Our
average
i don't consider questions resulting from a lack of programming experience
spam. the list SHOULD aid and embrace novice users. i know heikki and sinisa
have both helped me with my basic questions, although i took some time to
look in the archives and man before i posted. this IS the general list,
Hi,
We have a transaction table that has a field called userid.
Each time a user makes a purchase, this table get populated.
I am using the following query to get the no of transactions per user:
select userId, count(*) from transactions group by userid
I am using the following query to get a
I would imagine floor() would be defined in math_iso.h..
Since floor() is a math function..
along with ceiling() (sp?)
You need math_iso.h..
Maybe it wasn't in the tar?
Can't imagine why it wouldn't be.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
Interesting story. We run Windows 200 servers, and we axed MSSQL and CF/ASP.
i would (and do) run php even on a windows box. i guess the only problem it
brings is no stored procedures, and people freak out if they don't have that
enterprise interface. oh well. mySQL runs better even on a win32
I wasn't trying to say that the simple questions are spam, only that if
it took a little more effort to post, some people might check with the
manual and archives first. Posting to the list would always still be an
option if those failed.
Maybe the lists could be divided into: 1. mysql
* Eric Mayers
I have three tables, each with a single column, data.
I'd like to form a query that will combine the table columns into a
common result column.
When I use the query: SELECT * from tab1, tab2, tab3 I get:
+-++---+
| data| data |
If it's not too much trouble this is slightly urgent.
~Travis
I have the database files, now how do I put them back into mysql?
Restore table doesn't seem to work.
Thanks in advance,
~Travis
_
Send and receive Hotmail on your
This is going to be a very basic question, so please excuse me.
I have a MySQL server running, but when I added users I inadvertently
gave them all permissions to everything. They can all access every one
else's databases and make what ever changes they want and even delete.
How do I lock it
Just wanted to know if anyone has compiled MySQL under QNX, and if they
did, how they did it. Any help would be appreciated.
Therrel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
You need to take a look at the database called mysql.
In it you have:
culumns_priv
db
func
host
tables_priv
user
as tables.
Use the GRANT command to set the USERS, or you can also do an insert
statement like so:
insert into mysql.tables_priv VALUES
On Fri, Jan 11, 2002 at 11:54:26AM -0500, [EMAIL PROTECTED] wrote:
Any suggestions on loging tools I cna run to try to find out more
information? The machine is coloced about 3 hours for me, so I would
hate to have to drive there and install FreeBSD on it, when it was
just something I could
Do have the files actual files? Or do you have text files which were create
from MYSQLDUMP?
-Original Message-
From: Travis Farmer [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 3:04 PM
To: [EMAIL PROTECTED]
Subject: Restoring database from hotcopy
If it's not too much
Hi,
Is it possible to update a field with the result of a select. For example:
UPDATE ordr_order SET balance = ('SELECT ordr_order.total_cost -
sum(ordr_payment.amount) FROM ordr_order LEFT JOIN ordr_payment on
ordr_payment.ordr_order_id = ordr_order.id WHERE ordr_order.id = 1') WHERE
id = 1
Is it possible to update a field with the result of a select.
For example:
Try:
SELECT @newbalance := ordr_order.total_cost - sum(ordr_payment.amount) FROM
ordr_order LEFT JOIN ordr_payment on ordr_payment.ordr_order_id =
ordr_order.id WHERE ordr_order.id = 1;
UPDATE ordr_order SET balance =
My system tends to generate large result sets, with the first page of
results being used and the rest thrown away. I expect this is typical in
other systems as well. I've noticed the JDBC driver retrieves the entire
result set before letting the application iterate over any results. I'm not
sure
Just making sure my post got processed. I replied to the join confirmation
after sending my first post. Sorry for the potential redundancy.
Bret
-Original Message-
From: Bret Ewin [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 5:47 PM
To: [EMAIL PROTECTED]
Subject: returning
If all you want is the first page, then simply use SELECT ... LIMIT n,
which will only return the first n rows of the set. To page through
data, use LIMIT offset, n, which will return n rows starting at offset
rows into the dataset. Note that doing this on a changing table will
give results
In your select statement, use the LIMIT option
SELECT * FROM table limit 10;
will return the first ten rows, or
SELECT * FROM table limit 100,10
will return rows 101-110
-Original Message-
From: Bret Ewin [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 4:47 PM
To: [EMAIL
Sinisa Milivojevic [EMAIL PROTECTED] writes:
Trond Eivind Glomsrød writes:
Is there a clean way to administrate mysqld without a password by
root?
I'm looking for ways to make it flush logs, reload my.cnf and shut
down cleanly, in an automated way - i.e, no password, but by root.
On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote:
Benjamin,
can you also grow MyISAM tables to such sizes?
You can.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up
Thank you! I can use the LIMIT option several places in the system. However,
in places where a changing result set is not acceptable I must read the
whole result set (or at least as many as I allow pagination across) in the
initial query. I tried Statement.setFetchSize() but that doesn't appear
Well, as long as you don't mind the overhead, you could simply prevent
the table from changing as you page by locking the table while you're
paging through it:
LOCK TABLE table READ;
SELECT ... LIMIT o,n;
...
UNLOCK TABLES;
as long as the paging process doesn't take too long and/or the update
I am an experienced programmed and have worked on Unix and with Oracle and
Informix for many years.
I personally am struggling to get my head around Mysql (getting there now
though) I think part of the reason I am posting simple questions is.
1.) I find the manual quite combersome for
I've got the following query executing in my php code:
$query = INSERT INTO table1(created,updated,ses)
values(now(),now(),'$this-PNPSES-ses');
MYSQL_QUERY($query);
query executes fine, but when I look at the ses column in inserted row it says
Object-ses instead of a value.
Any ideas
Hai,
I am doing sthing about store the image inside the mysql database using blob
datatype, programm be Visual Basic 6.0. It is fine when i store it image in, however i
unable to retieve the image. I have test my program in Ms Access and it work fine.
Another thing i found
THis is more of a PHP issue, but:
When PHP evaluates variables in a double-quoted string, it sees your $this
(the object reference) and immediately evaluates it (just returning its
type - Object). If you want to tell PHP to dereference $this-PNPSES-ses
properly, do
$query = INSERT
On Fri, Jan 11, 2002 at 04:48:18PM +0530, Manish Mehta wrote:
Hi,
I am new to test case design in Database.
I wants to know Basically how to calculate the Maximum Database.
A database can consist of several tables. Each table is stored
(essentially) as a file. The size of a that file
1 - 100 of 101 matches
Mail list logo