t;
rand() seems using primary key of your table.
mine works in both old and new versions.
- Original Message -
From: "Webmaster" <[EMAIL PROTECTED]>
To: "Tony Shiu" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 12
i think it is more suitable to do it in programming level in mysql, though I
know there is a function is M$sql server.
if your table schema has a unique id field, before submit a query to DB,
1) select count(*) from it
2) from the above resultset, program to draw whatever number of records you
wa
in UNIX derivatives,
vi a text file, and write your create/other sql into it then save and close
it.
cat your_file | ./bin/mysql -uyour_username -p your_database
you will be prompted to enter a password for your username.
then enter your password.
- Original Message -
From: <[EMAIL PR
try
insert into pictures
values ('c:\\pictures\\computer.gif);
single \ is for escape special characters in MySQL.
-Original Message-
From: Roy Wasse [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 4:42 PM
To: [EMAIL PROTECTED]
Subject:Link to pictures outsi
Hi
I have not used EJB app server with MySQL w/ BDB support. Indeed I used Jrun
with Sybase for feasibility test.
But for setting AutoCommit,
I suggest u'd check MySQL JDBC whether it supports to disable auto commit.
If it can, try to run your JDBC code to disable instead of running in
.setEnti
One more suggestion is, using LIKE to search (whatever your column is
indexed or not) is definitely slow than using "=". I try it in 0.38 M
records before.
-Original Message-
From: Tony Shiu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 11:21 AM
To: [EMAIL
Hi Hannes
Several approaches to achieve your work. One is upgrade your resource i.e.
CPU, memory... I do not take this. Another is check all columns used inside
WHERE clause whether they are indexed. If not, pls create indexes for them.
it will definitely smooth better.
Programmatically, I sugg
: Wednesday, January 31, 2001 12:49 PM
To: Tony Shiu
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject:RE: Mysqld eats up RAM and CPU
on my server which runs an online game the values are all in the
megabytes
On Wed, 31 Jan 2001, Tony Shiu wrote:
> I wonder the normalization
I wonder the normalization and indexing of tables, Awa the complexity of
queries submitted to server. For those variables you mentioned I use in
production without significantly slow-down in peak time.
-Original Message-
From: Matis, Jan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, J