On Wednesday 11 July 2007 00:34, Anders Karlsson wrote:
UNION will only return distinct rows. This is according to spec and to
the SQL Standard.
And of course, to no one's surprise, this also matches the mathematical
definition of union:
j
--
Joshua Kugler
Lead
On Monday 29 January 2007 12:57, Ed Reed wrote:
I just didn't enjoy the location. When it was in Orlando a few years ago,
it was great. There were plenty of things to do and see; different places
to eat every night. I had a really good time. Then the following year I
went to Santa Clara and
On Sunday 21 January 2007 16:41, Nuno Vaz Oliveira wrote:
Just FYI: you can get the Express version of the VB.Net portion of
Visual Studio for free:
http://msdn.microsoft.com/vstudio/express/default.aspx That way,
you're much more likely to have a fully supported app. I've not tried
On Sunday 21 January 2007 08:17, Nuno Vaz Oliveira wrote:
Hello Miles,
At 04:39 PM 1/19/2007, Nuno Vaz Oliveira wrote:
Why VB6? This isn't an anti-Microsoft position, but that language has
been left to die on the vine. So I'd think about .NET, or RealBASIC,
or ... or You will have
On Friday 12 January 2007 12:51, C.R.Vegelin wrote:
Dear List,
I have a MySQL database (V5.0.x) and I need to make graphs.
Does anyone know about good utilities to make graphs ?
I would appreciate your expertise or links.
If you're using Python, matplotlib is an excellent package. If you
On Wednesday 15 November 2006 18:14, Renish wrote:
Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
php.exe and nothing seems to happen.
I have intalled
1) webserver-Apache2
2) MySql-41.1
Please read the documentation before asking questions such as these. Thanks.
On Sunday 29 October 2006 17:43, David Thole wrote:
On Oct 22, 2006, at 11:37 AM, João Cândido de Souza Neto wrote:
Hi everyone.
I´m using mysql workbench to design my database and am heaving a snag.
How can i rename my object? It always gets the name test and i
did not
found where
On Wednesday 18 October 2006 20:44, Dan Nelson wrote:
In the last episode (Oct 18), Danny Swarzman said:
I'm developing an Apache module that uses mySQL. It needs to be able
to talk to a remote host.
I'm doing this in a Mac.
I have a simple program in C that calls
[I searched the bug database...please let me know if I missed an already filed
or fixed bug.]
I am trying to dump a database from MySQL 4.0.24 using the client tools from
5.0. Debian server, Ubutnu 6.06 client.
I use this command line (watch for wrap):
mysqldump -u jkugler -p -h
dbserver
On Tuesday 11 July 2006 19:26, mos wrote:
SCSI drives are also designed to run 24/7 whereas IDE drives are more
likely to fail if used on a busy server.
This used to be the case. But there are SATA drives out there now being made
for enterprise class, 100% duty cycle operations. See, for
California mirror (H.E. in San Diego), but
they might be willing to take on another.
j- k-
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and
under the earth, that Jesus Christ is LORD -- Count on it!
--
MySQL
feature whereby when you press L while
reading a message it replies to list. I use that all the time.
j- k-
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and
under the earth, that Jesus Christ is LORD
. Pascal Francq
Université libre de Bruxelles
CAD/CAM Department
Avenue F.D. Roosevelt, 50
CP 165/14
B-1050 Brussels
BELGIUM
Tel. +32-2-650 47 65
Fax +32-2-650 47 24
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth
. So what I want
to do is move the sync app to the CE Device and connect to MYSQL
directly from the mobile device.
Hope this gives you a better idea of the problem.
Regards
Hough
Joshua J. Kugler [EMAIL PROTECTED] 03/02/05 9:07 AM
On Wednesday 23 February 2005 03:47, Hough Van Wyk said
a
standard ethernet connection, there is no difference than if you were
plugged into a wall.
What exactly are you looking for in your search?
j- k-
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and
under
will
resolve all the dependencies for you.
Hope that gets you started a little. If you need more detail, feel free
to ask.
j- k-
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and
under the earth
not
be able to do that.
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count on it!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
to the mysql db.
j- k-
On Saturday 08 January 2005 05:55, Gleb Paharenko said something like:
Hello.
As said at:
http://dev.mysql.com/doc/mysql/en/SET_PASSWORD.html
Only clients with access to mysql database can set passwords for
other accounts.
Joshua J. Kugler [EMAIL PROTECTED
that have a FK pointer.
Any ideas?
Thanks!
-Andy
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count on it!
--
MySQL General Mailing List
For list archives: http
in question, worked and created the user, albeit with no
password.
Is there a way for a user with GRANT privs to create a user *with* a password?
j- k-
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
incompatiblities between the two versions, or any gotchas to the
upgrade?
--
A. Clausen
[EMAIL PROTECTED]
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count
in fact, but the
dir where MySQL resides /var/lib/mysql is
consuming about 10Gb of my hard drive.
What can be going wrong here?
I am running 4.0.20-Max-log
Thanks,
C.F.
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count on it!
--
MySQL General Mailing List
For list archives: http
tell me what can i do. Should i use MYSQL Clusters or any
other thing ... i'll be so gratefull
regards,
s.ahmad
Lahore, Pakistan
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ
+ Reservation stations in the country. Where multiple
operators are sitting and reserving seats. Indexes are being used in
the DB. as i am related to hosting company, i havent seen if they are
taking advantage of indexes.
regards,
s.ahmad
On Mon, 12 Jul 2004 22:36:10 -0800, Joshua J. Kugler
find
out whether mysql has that or not.
If not, are there any alternatives anyone can suggest?
Thanks
Alex
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count
? Any helpful insights?
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count on it!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
. I don't know if I can even implement those classes.
SNIP
LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable
FIELDS TERMINATED BY ',' ENCLOSED BY ''
LINES TERMINATED BY '\n';
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven
is in that field in the Excel file? What kind of numbers?
j- k-
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count on it!
--
MySQL General Mailing List
For list
or more of the columns as the row to be
inserted? That is, without using a method outside SQL?
Thanks,
John
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count
be very welcome!
For what it is worth, I am a Mac OSX.3 user.
Thanks,
John
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count on it!
--
MySQL General
in the db if necessary, and use your middleware to display the
images. Its faster, easier to maintain, and easier to backup. IMO,
storing images in the db just bloats the file and complicates all the
backup issues.
-- greg willits
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every
sec)
However, when I run this from my PHP script, I get a value of 0.
Any clues as to how to resolve this?
Thanks!
-Erich-
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ
Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
There is no reason anyone would want a computer in their home.
--Ken Olson, president, chairman and founder of Digital Equipment
Corporation, 1977
(Then why do I have 8? Somebody help me!)
--
Joshua J. Kugler -- Fairbanks
E-mail: [EMAIL PROTECTED]
Web: www.bpenet.net
BPEnet Offices in ~ Sussex, London Dublin
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count on it!
--
MySQL
OK...thanks for the clarification. It helps. And it's good to know that what
I'm doing won't break anything.
j- k-
On Thursday 29 April 2004 07:16 pm, Sasha Pachev said something like:
Joshua J. Kugler wrote:
I have a program that is using (via a front end library) libmysql. If I
- k-
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count on it!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
libmysql,
my signal handler works fine.
What does libmysql do to the signal handlers when it initializes? I don't
have the source for it in front of my, or I would probably go digging my
self. Running up against a deadline as it is. :)
Thanks!
j- k-
--
Joshua J. Kugler
Fairbanks
in there, and see what error it gives me.
As in 'You have an error near' type messages.
j- k-
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue
columns are duplicated in at least one other row in any of the
tables? Essentially, a command to find duplicate entries in the database .
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
, etc. However, I need it to match columns on
all of the tables in the database (of which there are many), rather than
just two.
Any ideas?
Thanks,
John
on 4/21/04 12:57 AM, Joshua J. Kugler at [EMAIL PROTECTED] wrote:
Yes, there is a way. It's called joins. :) I don't remember
T. Caskey
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count
and by your name with no luck. If
you don't feel like going into detail, could you point out some good
links to learn more about the subject.
Regards,
Justin Palmer
-Original Message-
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 3:27 PM
concurrently
on the box. Each one of them allocates 512M for the
buffer pool and the box grinds to a halt, completely
out of RAM to do anything!
I've included a snippet of the top command display (I
hope that you can read it easily).
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant
to upgrade to the latest 4.0x if it
can solve this problem.
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
postulantes ALL /NULL/ /NULL/ /NULL/ /NULL/ 4499
Thanks for your help, im still confused :(
Joshua J. Kugler wrote:
MySQL is very stable on large databases...I would suspect inefficient
indexes. What does your query look like? What is the output when you put
EXPLAIN in front of your
migrated data base, ... it just
don't display anything. Any ideas ? Is there any issue problem when
migrating MSSQL image column types to MYSQL ?
Thanks in advance, cheers from Argentina,
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
pm, Rodrigo Galindez said something like:
Im using SQLYog to display results. It lets me to display blob data
types. By the way, i was trying to do some queries with phpmyadmin ...
but, it hungs ... hmmm ... inestability with large databases in mysql
maybe ? :S
Joshua J. Kugler wrote:
You
;)
What I did was trying to use something like this which to my knowledge
doesnt work on MySQL servers.
$dbh-commit();
$dbh-rollback();
/Jonas
- Original Message -
From: Joshua J. Kugler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 31, 2004 9:02 AM
Subject
('BEGIN');
.
.
.
.
$dbh-do('COMMIT');
What does your code look like?
j- k-
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess
I've been needing high-resolution timestamps
(year/month/day/hour/minute/seconds/microseconds) in MySQL (to store
network packets, mmm). Is this a planned feature for MySQL in the
future?
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
(for example address change) and
add transactions to the transaction table. What I do not want to happen is
that customer A is able to modify customer B's record.
In short how would you restrict customer a to see transactions that pertain
to him/her.
Many thanks.
--
Joshua J. Kugler
Fairbanks, Alaska
time for other applications.
What I am looking for are phpmyadmin specific instructions as to how to
configure phpmyadmin to use mod_ssl and
and DISALLOW http logins and only allow https logins and use of phpmyadmin.
Thanks anyone.
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant
be
implemented in MySQL? Could somebody please at least
give me a hint how to implement this?
Many thanks in advance.
Regards
Sagara
__
Do you Yahoo!?
Yahoo! Search - Find what youre looking for faster
http://search.yahoo.com
--
Joshua J. Kugler
Fairbanks
seconds
2004/03/09 06:45:00OK, 77526 bytes26 seconds
2004/03/09 06:50:01OK, 77526 bytes29 seconds
2004/03/09 06:55:00OK, 77526 bytes28 seconds
2004/03/09 07:00:00OK, 77532 bytes28 seconds
2004/03/09 07:05:00OK, 77526 bytes1 seconds
--
Joshua J. Kugler
details,
etc) in say abc database what will I have to do to make sure when customer
A logs in to the database can only see his/her account, orders, order
details without getting access to other customer accounts.
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 5:34 PM
To: Mulugeta Maru; MySQL
Subject: Re: Security
Only being able to see certain rows is not a function of MySQL, it is a
function of the application you write for the user to access the database.
If a user has
a perl interafce. Is this at all
possible???
And would it be possible to then read that file from a c++ interface?
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow
on queries and
I've been searching and reading through messages without success yet.
I suspect a big part of the problem is I'm fairly new to sql queries
and am not exactly sure what terms to search for.
Tim
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
the protocol and the operations
possible via the protocol?
Best regards
Søren
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven
import such a file.
How do you want to import this file? Do you want to load the whole file
into specific field?
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow
announcement or
the 4.0.17 documentation? Is there a way to get sub-second resolution in
4.0.17, or must I rely on my application?
Thanks!
j- k-
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED
on Windows, Mac, or *nix
can talk to a MySQL server on a Windows, Mac, or *nix server, and will never
know the difference. All it knows it that it is connecting to port 3306 and
it's talking to a MySQL server. There is no difference among operating
systems.
j- k-
--
Joshua J. Kugler
(changing row status from
'waiting' to 'processing'), how do I prevent another process
from grabbing the same row?
Thanks for any help or advice
-TO
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED
.
Example : table customer with field customer_id, address, DOB, Services
I need to know that customer data in my table have more than 1 record for 1
customer. So he/she has more then 1 customer_id.
I need to query the double record, not the DISTINCT one.
~Elle~
--
Joshua J. Kugler
Fairbanks
.
~Elle~
-Original Message-
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 11:08 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: FW: query
Oh, so what you're looking for a a find duplicates query (as MS Access
calls
it). That's something
On Wednesday 03 March 2004 08:04 pm, Sasha Pachev wrote:
Joshua J. Kugler wrote:
In the manual that came with MySQL 4.0.17 (at least in the Mandrake
packages of such) it says I can use %f to get the microseconds in a
DATE_FORMAT call. This does not work, however, and searching the archives
a look at the paragraph that follows the table that lists
the formatting specifiers.
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess
this be placed.
Any help would be great!
Thanks,
James
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
hardware to run our MySQL server.
The 64-bit architecture is something we would like to take advantage of.
Is this good, bad, otherwise? Any comments would be appreciated.
Thanks
TOM
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
'*F65E684A09D85F1DD4574279566B9E738DD597E7' WITH GRANT OPTION
+
+
1 row in set (0.00 sec)
I need a help,
thanks in advance
Rafael
--
Joshua J
table_name as t1, table_name as t2 where
t1.rownumber = t2.rownumber+1
and
(
(t1.col1='strt' and t1.col2='word')
OR (t1.col2='strt' and t1.col3='word')
OR (t1.col3='strt' and t1.col4='word')
OR (t1.col4='strt' and t2.col1='word')
)
Good luck.
Eric
Joshua J. Kugler [EMAIL PROTECTED
if 'word' is in col1 on the
next row (via another query)?
Ideas? Tips? Suggestions?
Thanks much!
j- k-
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow
A request such as this make me think the database is not properly normalized.
If there is one value that can be in several columns, it is very likely
those columns need to be broken into their own table, so that they can be
queried with a SELECT statement that has only one column in its WHERE
You need quotes around $username in your SQL query, unless you've already run
$username thorough $dbh-quote();
j- k-
On Tuesday 04 March 2003 13:11, Jianping Zhu wrote:
I am writing a simple login system by using perl( this is almost my first
program in perl), After user pick a
Daniel -
This might be a long shot, but since I've actually run into this problem
before, here goes:
Check your partitions. I had a server on which this very thing happened, and
it turned out there were overlapping partitions. This was all fine and dandy
until data was written to those
Your INT in your table is a signed INT, which is going to have a maximum
value of 2^31, thus your IP address is causing the field to roll over. You
need to change your IP column to UNSIGNED INT. That should solve your
problem.
j- k-
On Tuesday 18 February 2003 12:33, Aaron Conaway
How much work do you want done for you? Perl and Python are great apps for
writing MySQL reports, and you can output all the report to a text file,
which would be great for a reader. But as report applications, can't help
you there.
Sorry.
j- k-
On Tuesday 04 February 2003 09:10,
I got that as well., and like the case below, MySQL is up and running just
fine. I tried looking in safe_mysqld for a spurious '5' but couldn't find
anything. Does anyone know what's up with the most recent safe_mysqld?
j-- k-
On Thursday 12 December 2002 17:16, Gabriele Carioli
INSERT INTO $tablename
(sender, recipient, whenread, whensent, subject,
messagetext, folder, priority, condition)
VALUES
('$directorid', '$SendTo', '00', NOW(), '$SetSubject',
'$MessageText', 'Inbox', '$SetPriority', 'TO')
Easy as that!
j- k-
mysql, sql
--
Joshua
This looks like the same problem I have with MS Access. It seems MS Access
uses the SELECT id FROM table_name WHERE is IS NULL, and this syntax clears
the last insert ID field. My solution is here:
--- One Line URL, might wrap ---
The correct behavior is the number starting at the last number used. If you
are using MyISAM tables, you should see this behavior. If you are using the
old style ISAM tables, it will restart at 1 every time.
j- k-
On Monday 11 November 2002 11:41, Jessee Parker wrote:
I have a
MySQL is multithreaded, so your OS will send separate threads to different
processors. So, yes, MySQL will automatically take advantage of multiple
processors, no need to tell it explicitly.
j- k-
On Monday 14 October 2002 08:49, Dyego Souza do Carmo wrote:
Hello all...
I´m
There has been such a project for quite a while. Take a look at
http://no.spam.ee/~tonu/ and find the link about SQLFS.
j- k-
On Thursday 10 October 2002 02:58, Alex Polite wrote:
Is there any way I could display a MySQL database as a filesystem
under Linux?
alex
--
Joshua
I agree completely with Egor! You should not be killing your processes to
solve load problems. If there is a load problem 1) You need to write your
applications better, 2) you need to have a better database structure, 3) you
need to analyze where indexes would help you, or 4) you need a more
On Monday 30 September 2002 10:13, Drulli B wrote:
Hi,
I have a grand total of two very important but possibly humiliatingly daft
questions, that I hope some kind soul will patiently solve:
1. Can I run a mySQL server on a Linux computer, and query it through
myODBC running on a Windows
Tom -
I'll address what I can
I had the same problem with fields being truncated on direct connections (the
problem does not manifest on ODBC table attaches in Access).
IIRC, the way to solve this problem is to make sure the optimize columns
widths (option 1) in the ODBC properties.
If you are running Linix, at the prompt type:
md5sum filename
I'm sure you can get md5sum for other Unices as well.
j- k-
On Thursday 20 June 2002 13:00, Kiss Dániel wrote:
Hi everyone,
Can anyone tell me how to create an MD5 checksum on a file.
I tried to do this by using the
It's not illogical at all. You often want (sometimes need) that field to
make sure a record has not changed when you go back to update the row. MS
Access (and others) uses this so as not to overwrite changes made since the
record was retrieved. You can't always rely on the client to set
To all: This is in response to a request for more information. I thought
others may find it useful.
Thanks so much for your reply. It's good news to hear that
someone is relying on MyODBC for an important purpose, much of the
usage I've seen seemed rather small.
Like I said, we
Oh. OK. Didn't know that. Thanks.
j- k-
On Saturday 16 February 2002 22:26, Jeremy Zawodny wrote:
On Sat, Feb 16, 2002 at 03:56:42PM -0900, Joshua J.Kugler wrote:
In that case, i would highly recommend using mysqldump to backup
your databases. Simply compressing the actual DB's
In that case, i would highly recommend using mysqldump to backup your
databases. Simply compressing the actual DB's could give you tables in
inconsistent states, UNLESS you first shut down your DB server, then run the
backup.
Something to think about.
j- k-
On Saturday 16 February
Using Perl/CGI and DBI::MySQL would work for forms. You could take the input
from the browser, and print the results back to the browser. Would that work?
j- k-
On Monday 11 February 2002 05:20, Jim Hatridge wrote:
Hi all...
First of all, I think that MySQL is really great. The
Umm, I take it you haven't read the documentation? MySQL fully supports
LIKE. Can you tell us the error you are getting? Along with the full query?
j- k-
On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote:
MySQL doesn't support LIKE does it? I got an error when I tried.
--
Umm, I take it you haven't read the documentation? MySQL fully supports
LIKE. Can you tell us the error you are getting? Along with the full query?
j- k-
On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote:
MySQL doesn't support LIKE does it? I got an error when I tried.
--
You can try...but, an i686 binary may use machine code instructions that are
not present in the i586 chip. Thus, the program will crash with an illegal
instruction message.
j- k-
On Friday 01 February 2002 16:11, Steve wrote:
I'm wanting to install mysql on an older i586 machine
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
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
On the MySQL download page, there is a warning for GCC 2.96/x86/Linux that
reads thus: Several of our users have reported random crashes and table
corruption with MySQL binaries compiled with gcc 2.96 on the x86 Linux
platform.
I was wondering what kind of crashes users had experienced.
Umm, why not just install a copy locally? You can get a binary for just
about any OS. And a local copy would be much faster than working over the
internet.
j- k-
On Thursday 27 December 2001 06:31, David Ayliffe wrote:
I am writing a conversion tool for MySQL and I could do with
1 - 100 of 147 matches
Mail list logo