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 t
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 Yo
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 yo
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
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 mysql_re
[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 --a
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
ady has a Southern 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 L
in existence? Or is there some great reason
> why the mysql lists are different than everyone else's lists?
KMail has a handy little 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 --
to the network, but I do not what. Anyone an
> idea? --
>
>
> Prof. 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. Kug
C with a USB cable and then sync the 2 DBs. 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. Kugl
? If it's 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
andrake or Fedora, their installer tools 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 heav
gt;
> If you don't have privs to the mysql.user table you definitely should 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
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.
>
&
RT, UPDATE, DELETE, CREATE ON rubric.* TO 'user'@'localhost'
run as the user 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, Al
hen we get connectivity. But I
> don't have a handle on how to update the sub tables 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, an
there
> any 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
physical size of
> each table. They do not correspond to 10Gb, much less 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.
>
> can
>
> > accomplish this task or an alternative solution?
> >
> > Thank You
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/[EMAIL PROTE
e here who works with mySQL on a MAC? 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:
alled linking, but I couldn't 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,
a blank serevr was also choked by the usage. This started
> > > happening bcz. DB is growing day by day and is quite big in size. Can
> > > any body tell me what can i do. Should i use MYSQL Clusters or any
> > > other thing ... i'll be so gratefull
> > >
> &
t; happening bcz. DB is growing day by day and is quite big in size. Can
> any body 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#:1370629
is too large for the field, and MySQL
is rolling it over. What is the type of your key? Int? Big int? And what
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
ams in applescript, a little
> obj-C, and SQL. I don't know if I can even implement those classes.
> >>> LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable
> >>> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
> >>> LINES TERM
(or .xls file for that
> > matter) and place it in a table in a MySQL database. Is this something
> > that I can do with the server side MySQL application, or do I need to
> > figure out a way to do it on the client side? Any description of the
> > method would be very
for one 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 Jes
ve ever come across for this type of
> application is that there's no advantage to keeping the image in the db
> itself. Just keep them as files on the server, store a filename &/or
> location in the db if necessary, and use your middleware to display the
> images. Its faster
t; | LastID |
>
> ++
>
> | 3575 |
>
> ++
> 1 row in set (0.00 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#:1
ut a hiccup.
>
> thanks for the help,
> --
> Chip Wiegand
> Computer 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 Equipm
ost came across the list that is answered in the
archives or the docs, a message could be bounced back saying so. It would
probably cut list traffic by half.
j- k-
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in
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 en
ar All
>
> I am using ASP. Can anyone give me the connection code to connect to a
> MySQL database without using ODBC DSN?
>
> Thanks
>
> Michael Johnson
> Director
>
> BPEnet EMEA
> Sun iForce Premier Solution, Sales, Change Management & Development
> Partner
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
Fair
d paste the SQL 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
Ever
rk--it should specify:
> table1.column1=table2.column1, 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
every row whose
> first 3 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
.--- --- ... ..- .--.- ..- --.
ed the archives by the title 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. Kugle
you think? Also, how long would
> it take me to learn the necessary information? Lastly, how long would
> it take to develop such a system?
>
> I appreciate your time and information!
> Thanks,
> Mike T. Caskey
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems
everal instances of mysql server running 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 re
y may escape backslashes in the
> MySQL way and switching the whole server to ANSI mode would break them.
>
> I'm using MySQL 3.23 but I'm willing to upgrade to the latest 4.0x if it
> can solve this problem.
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Sys
_keys key key_len ref rowsExtra
> 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
> > in
day 05 April 2004 05:41 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
es (blob data
> types now) but I can't in the MYSQL 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,
--
Joshu
y nonses ;)
>
> 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
#Begins the transaction
$dbh->do('BEGIN');
.
.
.
.
$dbh->do('COMMIT');
What does your code look like?
j- k-
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAI
wrote:
> Hello,
>
> Recently 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
r a long 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
Fairb
abase
> so that they can update the customer table (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
> -Original Message-----
> From: 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 applic
customer order 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
onds
> 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
Fairbanks, Alaska
Computer Consultant
_
> Do you Yahoo!?
> Yahoo! Search - Find what youre looking for faster
> http://search.yahoo.com
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL PROTECTED]
ICQ#:13706295
Every knee shall bow, a
se the file. I am using 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
; each of the sensors and have it sorted it by the sensor ID?
>
> This isn't obvious to me from reading the documentation 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 t
gt; columns or the details about the db file.How can i 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
.--- --- ... ..- .--.- ..- --. .-..
nt I would like to try.
>
> So where do I get information about the protocol and the operations
> possible via the protocol?
>
> Best regards
> Søren
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .--.- ..- --. .-.. . .-.
[EMAIL
.html
>
> Hint: Take 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 e
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, howev
our example is using 2 table.
>
> ~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 loo
same
> value for several fields.
> 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 DISTINC
sing
> to be done now.
>
> For speed, I'd now like several processes to grab work from the table.
>
> I am not sure how mysql handles locking.
>
> While a process is seizing a row (changing row status from
> 'waiting' to
tical. A client 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-----
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
--
>
> ------------+
> 1 row in set (0.00 sec)
>
>
> I need a help,
>thanks in advance
> Rafael
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .
king of purchasing some new 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
Fairban
; MySQL:
>
> Auth_MySQL_Info hostname user password
>
> Is this right? Where in the httpd.conf should this be placed.
>
> Any help would be great!
>
> Thanks,
>
> James
--
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... ..- .-
next_row='word')
> >
> > Is this even possible? I'd hate to issue hundreds of queries to check if
> > "strt word" is split across rows.
> >
> > Should I investigate setting variables equal to the col4, and on a failed
> > search, use that
the "old col4" pairs
with anything in col1?
Or am I better off searching for the good case, and on failure, go and look
for 'strt' in col4, then when I get a row, see if 'word' is in col1 on the
next row (via another query)?
Ideas? Tips? Suggestions?
Thanks mu
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 c
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 user
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 overl
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 wrote
> 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
--
Jo
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 ---
http://groups.google.com/groups?hl=en&safe=off&threadm=9ehc8i%2
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 scrip
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 comp
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 Ku
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 Wind
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
field=N
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 h
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
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 2
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 r
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 cons
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 appli
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. Cra
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 so
1 - 100 of 151 matches
Mail list logo