Hi
I have developed a software wherein the frontend is in visual basic and
the backend is mysql 4.1. Now when I am installing the software in
various machines do i have to install the odbc connector for mysql in
every machine. The database is going to be a centralised database.
Thanks in adv
Here is a config diff that made mysql usable again. As the database
grew in size, buffer sizes in the config were increased to try to boost
mysql performance.
Unfortunately it didn't work as expected. As the config was tweaked,
mysql slowed down even more. Removing all settings from the my.
is there a way to make ORDER BY RAND() at bit more spontaneous ?
I am using it in a php statement:
$sql = "SELECT media.id,
artist.name as artist,
artist.spanish as bio,
artist.purchaseLink,
artist.picture,
media.spa
On Fri, 30 Sep 2005 13:08:31 -0700
Jacek Becla <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I had asked similar question few days ago, and then checked with
> the developers as no one was able to answer on this mailing list.
> I was told it is very likely we'll get it in 5.2.
Thanks - now that 5.0 is re
Sound advice, I have no done as suggested and my application handles the
Nulls's
Thanks
John B
-Original Message-
From: Sujay Koduri [mailto:[EMAIL PROTECTED]
Sent: 30 September 2005 14:26
To: Scott Noyes; [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: Global Replace
Yes, I
Hi,
I had asked similar question few days ago, and then checked with
the developers as no one was able to answer on this mailing list.
I was told it is very likely we'll get it in 5.2.
Jacek
Sujay Koduri wrote:
does anyone have an idea when mysql guys are going to include foreign key
support
Hi,
Does anyone know how to execute SQL statements from a text file
such that the summaries "X rows in set (X.YZ sec)" are printed
for each query?
Neither of these do it:
mysql < batch-file
mysql -e 'source batch-file'
'source batch-file' run inside mysql command-line does it,
but then I n
Hi all,
It's not a big deal, but I can't seem to find how to sort or order my
connection entries in "Options->Connections" view tree in MySQL Query
Browser. (See attached screenshot.)
Any ideas?
Thanks!
Mihail
--
Mihail Manolov
Government Liquidation, LLC
Special Projects Leader
202 558
I meant 600k not 6meg. Sorry
>>> "Ed Reed" <[EMAIL PROTECTED]> 9/30/05 9:46:32 AM >>>
That's not true.
Group_Concat can already return more than 6meg. It's set by
group_concat_max_len variable. The fact is that I've been told there are
security issues corrected in the 4.1.14a update and I can'
I think Control Center is a much better tool then the combination of Query
Browser and Administrator. I still use Control Center for my day to day stuff
and only check out Query Browser when new versions come out to see if they've
solved the major problems.
I think they've gone completely in t
That's not true.
Group_Concat can already return more than 6meg. It's set by
group_concat_max_len variable. The fact is that I've been told there are
security issues corrected in the 4.1.14a update and I can't apply them because
it will break my already existing apps.
Is there a fix?
- Th
2005/9/30, Sujay Koduri <[EMAIL PROTECTED]>:
>
> I am not saying MysQL Query Browser is anyway bad or inferior, but as for my
> experience sqlyog is very good. There is a free version which you can use
> for executing SQL queries, ofcourse you will be stripped of some advanced
> features.
>
> You c
Wolfram Stebel wrote:
Am 30.09.2005 16:29 Uhr schrieb "Nuno Pereira" unter
<[EMAIL PROTECTED]>:
in Users/user/Library/Logs/CrashReporter/java.crash.log
one mile of traces
Regards
Wolfram
**
Host Name: Erde
Date/Time: 2005-09-30 15:13:52.351 +0200
OS Version: 10.4.2 (Buil
Hello.
Probably some web-development mailing list of forum is a better
place for your letter, than MySQL list. From MySQL side I can
advice you not to store images in the MySQL DB, usually it is
better to have them in the file system and to store links to the
images in the database.
John
Mysql_store_result stores all the results in a single buffer. But at one
time you can only access one row. It is like a array of structures, where
each structure has one row info. And the call to mysql_fetch advances this
rowcount by one. And coming to storing all the results in one char*, it is a
I am not saying MysQL Query Browser is anyway bad or inferior, but as for my
experience sqlyog is very good. There is a free version which you can use
for executing SQL queries, ofcourse you will be stripped of some advanced
features.
You can run multiple queries at once using shift+F5. I sugges
Hi,
Is there an easy way to access directly the results after a SELECT and a
mysql_store_result() into a single dimentional char *array[], given that
I already know the (fields * rows) value? Are the total results stored
in a single buffer or is it done on a per row basis? How does it work?
Thnx
"Rob Agar" <[EMAIL PROTECTED]> wrote on 09/29/2005 08:27:37 PM:
> hi Scott
>
> > How do I run more than 1 queries in MySQL Query Browser?
>
> The only way I've found is to put the queries in a .sql file and load it
> via File > Open Script. It doesn't accept multiple typed in queries,
> even if
"John Berman" <[EMAIL PROTECTED]> wrote on 09/29/2005 06:05:42 PM:
> Hi
>
> We have a database on MySql 4 and it contains many tables. In each field
in
> the table in the past were there was no data to display we simply left
the
> field blank, we now want to replace a null entry with No Data
>
Yes, I don't think you have to do lot of changes to your application to
achieve this. As scott mentioned, always try to keep minimum(whatever is
really useful) data in the DB, either for more performance or for using less
disk space.
sujay
-Original Message-
From: Scott Noyes [mailto:[EM
> We have a database on MySql 4 and it contains many tables. In each field in
> the table in the past were there was no data to display we simply left the
> field blank, we now want to replace a null entry with No Data
I advise you to reconsider. You are reducing the flexibility and
usefullness
In article <[EMAIL PROTECTED]>,
Jonas Geiregat <[EMAIL PROTECTED]> writes:
mysql> create table foo (id int NOT NULL comment 'test foo en bar');
This is a comment on a column which apparently gets displayed by SHOW
CREATE TABLE only by later versions, e.g. 4.1.14. Table comments go
after the clos
Gleb Paharenko wrote:
>Hello.
>
> > = 77591546 K
>
>
>Really - something is wrong with your memory settings - MySQL is using
>about 77G of memory
>
Unfortunately getting the daemon to not go above the theoretical limit
has tanked performance. In reality I never see the daemon go above 45%
RAM us
23 matches
Mail list logo
