Well, what a mess. It is regretable that this legal issue
needs to be aired so publically that was certainly not my
preference. I also will not get into a flame war, it is
not in the best interest of mysql. I appreciate all the
email I've received with advice and/or support - thanks.
It is impo
> IT is actually more of a security risk, because it is sending passwords in
> the clear.
You should not send a password at all. Put your password in a
file at a safe location on your server (you can always protect it
with .htaccess), then let your program read this password and
send it to MySQL.
There are courses, but there is no certification as yet, AFAIK.
See http://mysql.com/training/
Sie schrieben am Samstag, 14. Juli 2001, 04:26:16:
> Is there some sort of mySQL certification course?
sql
--
Herzlich
Werner Stuerenburg
_
I've just tested the timestamp method and you are perfectly correct. It
works a treat.
Thank you for your help, it was becoming a headache as I thoughy I started
this project only to fail because the usual, "Oh, M$ has another bug or
another bad ODBC/SQL standard". Then having to explain this t
Hi
when i am trying to insert the following value into the text field, the
value is changing and the new one is inserting in the table.
I tried both preparedStatement and Statement object for insertion..
Input:
This is giving in textarea of html code
main()
{
fprintf("hi")
}
when i
Hi,
I've problem with sorting table rows, thats why i need to get mysql
work with my character set.
can you explain better about ctype array when defining character set.
I really did not understand about elements in this array. The rest
ones to_lower, to_upper, sort it's simple just simbol codes
Colin Faber wrote:
> Michael, Interesting idea but I think it would problematic over all,
> The mysql manual changes almost everyday (anyone that syncs the bk
> tree's knows) I would suggest a better solution would be to provide the
> manual as a localized application (possibly even ported to
Here comes my 2 cents...
The 'advantage' of installing a package such as MySQL on your system as
"root", is that the "root" user would be the only one able to 'modify'
permissions on the installed files. You'd still create a "mysql" user and
"mysql" group, which would be assigned to the "var"
On 14-Jul-01 [EMAIL PROTECTED] wrote:
>>Descritpion:
> Hello,
>
> I've got MySQL installed on a P-III 1ghz machine running RedHat 7. I
am
> havign the same error, over and over again when I attempt to delete anything
> from any table. I've tried this delete from being ROOT to being a peo
>Descritpion:
Hello,
I've got MySQL installed on a P-III 1ghz machine running RedHat 7. I am
havign the same error, over and over again when I attempt to delete anything from any
table. I've tried this delete from being ROOT to being a peon user.
Heres my query:
DELETE FROM topicexc
This is a very common problem and can be found in the archives of this list
as well as the mysql documentation.
- Original Message -
From: "Robert Sochor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 14, 2001 2:42
Subject: Help Requested
> Dear XYZ
>
> I am running b
At 9:15 PM -0600 7/13/01, Colin Faber wrote:
>Michael, Interesting idea but I think it would problematic over all,
>The mysql manual changes almost everyday (anyone that syncs the bk
>tree's knows) I would suggest a better solution would be to provide the
> manual as a localized application (poss
Ugh, I couldn't find the mailing list archives until I looked at the
bottom of my own message that got mailed back to me! I searched, found
out about the temporary table workaround for no unions, sorry for
bothering you all with a question that had been answered before. I'm
still eager for MySql t
Hi. I just finished a database that will be supporting another system,
and right now it is running on Postgres, but I was unhappy with that for
various reasons. I converted my data to mysql, and most things look
good: in the ways I care about, performance is much better, EXCEPT for
one issue which
How can I write a query that answers the following question: Which stores
have not entered soups in the collection_schedule for the current day? I
just want to get a list that shows the stores.code, stores.name,
stores.phone of all the stores that failed to update the soups for the day.
collect
Michael, Interesting idea but I think it would problematic over all,
The mysql manual changes almost everyday (anyone that syncs the bk
tree's knows) I would suggest a better solution would be to provide the
manual as a localized application (possibly even ported to
PalmOS/WindowsCE), Anyone?
This has been discussed to death on the freebsd mailing lists, The over
all feeling was to add such a system would `break' most of the clients
that subscribe and would eliminate the open mailing list we have now,
Most list subscribers know that about 10/20 questions a month that come
to this l
At 8:09 PM -0400 7/13/01, Mark A. Chalkley wrote:
>I, for one, was
>considering purchase of their distribution just to get the printed
>manuals, but wouldn't have one from them now if they were giving them
>away.
BTW, why doesn't MySQL AB print the manual and sell it? I would
gladly pay US $ 30-
Is there some sort of mySQL certification course?
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-
Before posting, please check
>Description:
MySQL Daemon crashes when a user with the necessary privileges issue a query
"show logs"
>How-To-Repeat:
Start your daemon with the option --skip-bdb:
your-shell> safe_mysqld --skip-bdb
Then, issue a "show logs" using mysql utility, for instance.
>Fi
At 16:17 Uhr +0300 13.7.2001, Sinisa Milivojevic wrote:
>Support for transactions in replication will come in MySQL 4.0 that is
>scheduled for this Autumn.
Hi!
We have been planning to use mysql/innodb with replication soon
(mid/end of august). http://www.mysql.com/doc/B/i/Binary_log.html
sug
It sounds like you ISP doesn't know what they're talking about. All access
to the server is VIA TCP/IP, even when you are connecting with ODBC. Unless
they mean, set up an ODBC client on the server, then you connect to that,
somehow. I don't know if you can do that.
They might say that for
I would imagine that they just don't want to...possilbly for security
reasons or for manpower/support reasons.
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
- Orig
Paul,
OK, I think it make sense now. Appreciate you clearing this up in my head
atleast.
THX's...
>>>thanks for the info. So if I'm ready this correctly, I would log
>>>into the server
>>>under my UNIX account, not as root, do the install of the server/client Mysql,
>>>create the new user/gro
At 7:21 PM -0500 7/13/01, MikeBlezien wrote:
>Paul,
>
>thanks for the info. So if I'm ready this correctly, I would log
>into the server
>under my UNIX account, not as root, do the install of the server/client Mysql,
>create the new user/group, which would make me part of the new
>user/group, th
Paul,
thanks for the info. So if I'm ready this correctly, I would log into the server
under my UNIX account, not as root, do the install of the server/client Mysql,
create the new user/group, which would make me part of the new user/group, then
start the server under this user/group. Is this cor
Hi,
I would like to be able to create some tables in a database on an SQL server
at my web provider, then access those tables via a client application
running on my PC over the Internet (dial-up connection). My understanding is
that the client application accesses the SQL server via TCP/IP and no
At 6:32 PM -0500 7/13/01, MikeBlezien wrote:
>Hello all,
>
>I'm a bit confused on this issue of installing MySQL and creating a separate
>user/group ownership. Now I've read thru many resources, and it recommends not
>installing MySQL as root, or is this incorrect??
That's correct, you don't want
On Friday, July 13, 2001, 8:02:16 PM, you wrote:
MW> MySQL is GPL, so it's ok to sell derivate works. The problem is
MW> however that NuSphere has been selling derivate work but not complied
MW> to the GPL license, which is NOT ok.
MW> By using mysql.org they are also violating our trademark;
database,sql,query,table
>
> Now most of us in/using Open Source probably do not _really_
> understand the meaning and ramifications of the GPL. We _think_
> we know, and we certainly have a "feeling" about what the GPL
> "means".
Oh Bull
Making a derived work from a GPL produc
At 3:45 PM -0700 7/13/01, Cindy wrote:
>I'm curious -- is there an interface from expect to mysql? I suppose
>I could just write a small perl script and exec it from expect, but it
>would be kind of need if I could do the requisite commands directly.
Your question is vague. Interface to *do wha
At 7:04 PM -0400 7/13/01, <[EMAIL PROTECTED]> wrote:
>Ok, I've been writing SQL for a few years now, but only recenlty started
>using Mysql. I have a website hosted at a third party that uses mysql
>3.23.36
>
>I keep getting errors when I try to run fairly straight forward queries with
>the IN cl
Hello all,
I'm a bit confused on this issue of installing MySQL and creating a separate
user/group ownership. Now I've read thru many resources, and it recommends not
installing MySQL as root, or is this incorrect??
Is it better to create the new user/groups, then install MySQL under these
user/
Bill,
I think you want to use mysqldump. Check here for documentation on it;
http://www.mysql.com/doc/m/y/mysqldump.html
cheers,
Glenn
Glenn Tillema [EMAIL PROTECTED]
ADC Telecommunications, Inc.
PO Box 1101, MS 508
Minneapolis, MN 55440-1101
Learn about ADC - The Broadb
Hi,
I'm administrating a machine which has just badly crashed, and a MYI file has
disappeared for one table.
Is this possible to repair this table ?
BTW, REPAIR TABLE in mysql report a wrong message :
mysql> REPAIR TABLE threadhardwarefr1;
+--++--+---
Ok, I've been writing SQL for a few years now, but only recenlty started
using Mysql. I have a website hosted at a third party that uses mysql
3.23.36
I keep getting errors when I try to run fairly straight forward queries with
the IN clause like:
select var1 from table1 where var1 not in (sele
I'm curious -- is there an interface from expect to mysql? I suppose
I could just write a small perl script and exec it from expect, but it
would be kind of need if I could do the requisite commands directly.
--Cindy
--
[EMAIL PROTECTED]
--
In the last episode (Jul 13), Kevin Smith said:
> Yes, each record has a primary key, but not a timestamp. Does this
> make any difference?
>
> This also happens with my Unix machine which has MySQL installed on
> it. I have had the problem for about a year, but now that I'm
> starting to use M
I'm not sure if that was a problem or not. I am actually very interested in
the second part of my query regarding replication. An earlier post
mentioned that if I am using A -> B -> A replication behind a
load-balancer, that I may lose performance. I am only slightly concerned
with update perf
"Michael Widenius" <[EMAIL PROTECTED]> wrote:
> By using mysql.org they are also violating our trademark; If we are
> not defending our trademark we may loose it.
I'm sure you and your attorneys have considered this, but for the benefit of
others on the list I'll mention that the Uniform Domain-
Glyndower;
I just joined the PHP mailing list. It appears to be fairly active and
knowledgable. Your question seems to be MORE PHP related than MySQL.
I know, I hate joining half a dozen lists to get answers, and the MySQL
list has been most helpful with database questions, but this sounds lik
That would explain why I get the #DELETE in the fields.
I would actually be very interested to know why you need a timestamp
field an auto_increment field I can totally understand.
Many thanks,
Kevin
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[E
I know this sounds bizarre, but I believe that error means the your SQL
statement did not return any rows and you don't have any error checking in
place to cater for this. I know this, because I did the same thing. ;)
Regards,
Kevin
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[
Andy De Paoli <[EMAIL PROTECTED]> writes:
> I wanted to thank all the helpful e-mails I got ragrding problems with
> MySQL bundled with RedHat 7.1.
>
> it was pointed out that the main problems were due to the following:
> this release apparently installs the mysql files with root
> permissi
I have followed two very simple rules and it has always fixed this
problem for me. First, every table must have an auto_increment field
as the primary key. I always name use the first field and I name it
Serial. Second, every table must have a timestamp field. I use the
second field and I
Yes, each record has a primary key, but not a timestamp. Does this make any
difference?
This also happens with my Unix machine which has MySQL installed on it. I
have had the problem for about a year, but now that I'm starting to use
MySQL in real-time applications I'm developing at work, this
This may be a silly question, but since you didn't state it in your e-mail:
does each record have a primary key AND a timestamp field?
j- k-
On Friday 13 July 2001 01:24, Kevin Smith wrote:
> Hi All,
>
> I've installed MySQL 3.23.39 on my Windows 2000 Pro Server and I am
> currently dev
-- Original Message --
From: [EMAIL PROTECTED]
Date: Fri, 13 Jul 2001 12:36:08 -0700
>
>I am far from a legal expert on this... but is it all that bad that
>NuSphere wishes to sell a derivative work of MySQL? Other than it competes
>with MySQL AB's busines
At 9:54 PM +0100 7/13/01, Sara wrote:
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Sara" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Friday, July 13, 2001 9:20 PM
>Subject: Re: Using Scripts with MySQL - NEWBIE
>
>
>> At 9:13 PM +0100 7/13/01, Sara wrote:
>> >
[EMAIL PROTECTED] writes:
> I am far from a legal expert on this... but is it all that bad that
> NuSphere wishes to sell a derivative work of MySQL? Other than it competes
> with MySQL AB's business of selling their own commercial deployments of the
> package? And by that I can somewhat see wh
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Sara" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 9:20 PM
Subject: Re: Using Scripts with MySQL - NEWBIE
> At 9:13 PM +0100 7/13/01, Sara wrote:
> >Hi Paul
> >
> >Thanks for replying, however, som
>Description:
When performing a left join with a table including a non-null
datetime column, saying "where a.non_null_datetime is null" always
returns the empty set. It works if the column is either not non-null
or not datetime. This used to work (on 3.22.32).
>How-To-Repeat:
cre
I wanted to thank all the helpful e-mails I got ragrding problems with
MySQL bundled with RedHat 7.1.
it was pointed out that the main problems were due to the following:
this release apparently installs the mysql files with root
permission which the mysqld does give mysql processes and a wor
"Ravi Raman" <[EMAIL PROTECTED]> writes:
> hi.
> i have a question (or 2)...
> since this email doesn't contain the words "sql", "table", "database" or
> "query", is the reason it got through because of the "mysql" in the
> header/footer?
> that doesn't really make sense, because then everything
At 9:13 PM +0100 7/13/01, Sara wrote:
>Hi Paul
>
>Thanks for replying, however, something which I know should be easy is
>eluding me right now.
>
>The samp_db directory is created as a subdirectory of the mysql1 directory.
>
>This is what I tried to do following your instructions and this is the
I have next setup: two servers each serving completely independent web
projects. Each webserver has its own mysqld and programs on web server
use only local mysqld.
To minimize possible downtimes in case of any problems with one of
servers (hardware failure, serious misconfiguration and so on) I
Hi Paul
Thanks for replying, however, something which I know should be easy is
eluding me right now.
The samp_db directory is created as a subdirectory of the mysql1 directory.
This is what I tried to do following your instructions and this is the error
message I got, I guess I am missing some
Hi!
> "btjones" == btjones <[EMAIL PROTECTED]> writes:
btjones> I am far from a legal expert on this... but is it all that bad that
btjones> NuSphere wishes to sell a derivative work of MySQL? Other than it competes
btjones> with MySQL AB's business of selling their own commercial deploym
UPDATE --- The YOU_are_FAT!.TXT.pif is a VIRUS!
The W95/MTX@M Virus to be exact.
See this
Update - September 19, 2000:
McAfee AVERT has raised the ARA for this virus from Low to Medium based on customer
samples received to date.
Removal of this virus requires 4095 DAT files. This virus was di
Hello,
We are installing a new server, and I'm having to transfer the databases in
MySQL from the old server to the new one. However, I know _very_ little
(almost nothing) about MySQL. Could someone please offer me any
help/suggestions/advice on how I could do this?
--
Regards,
Bill Omer
Di
I recently upgraded from MySQL 3.23.36 to 3.23.39 and now the following
query fails.
> SELECT DISTINCT Ring.*, Question.DefaultRingID, COUNT(RingMember.UserID)
AS MemberCount FROM Ring, Question, QuestionXQuestionCategory,
BrandXQuestionCategory LEFT JOIN RingMember ON (Ring.RingID =
RingMember.R
I am far from a legal expert on this... but is it all that bad that
NuSphere wishes to sell a derivative work of MySQL? Other than it competes
with MySQL AB's business of selling their own commercial deployments of the
package? And by that I can somewhat see why NuSphere is using the phrase
"un
hi.
i have a question (or 2)...
since this email doesn't contain the words "sql", "table", "database" or
"query", is the reason it got through because of the "mysql" in the
header/footer?
that doesn't really make sense, because then everything would get
through...maybe because of the word "profita
The patch below syncs AC_SYS_LARGEFILE with the version shipping with
autoconf 2.50. This is against MySQL 3.23.39.
--
albert chin ([EMAIL PROTECTED])
-- snip snip
--- acinclude.m4.orig Sun Jul 1 12:51:18 2001
+++ acinclude.m4Sun Jul 1 12:58:47 2001
@@ -1035,122 +1241,85 @@
dnl Wri
You don't supply enough information to even guess what the problem is.
What hardware/software are you running?
What is the MySQL version?
Was this a binary package, or did you compile it?
What compiler did you use?
What are you using to do the update?
How do you know it failed?
Did you check the l
> Well. I need to create a window that maintains the postal codes and I need
> Cod Descr, and Country fields for that. The Window simple have a few
> buttons(First, Previous, Next, Last, New, Delete...etc.) That needs The
> complete big recordset or the simple little recordset with a limit clause.
Dear XYZ
I am running bsdi 4.2 commercial. My problem is as follows:
% mysql
ERROR 2002: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)
Any help is greatly appreciated
--
Rob Sochor
IS Manager
[EMAIL PROTECTED]
Ie Solutions - RAPS
The Recruiting and Applicant Process
I don't believe NFS locking is reliable enough to allow two
servers to serve the same databases.
Shon Stephens wrote:
> I recently started experimenting with a way to setup MySQL to be
> load-balanced. I installed 2 servers with MySQL, NFS mounted the
> /mysql/var directory, then moved the gra
LIMIT X,Y
Skips X rows and gives you the next Y.
Just increment and decrement X as necessary
between selects to scroll through table.
David Tomas Fargas wrote:
> Well, sorry about my worst explanation :)
>
> The table is a Spain Postal Codes Table.
> It has fields: Cod(5),Descr(100),Country(3
Ok, figured hout hot do generate the update logs, and to rotate the
logs, but, cant seem to upload the logs.
>From mysql/bin:
The statment:
mysql -u root -p --one-database < update.1
generates the error that it cannot find the update file. How do I tell
mysql where the update log is.
Currently i
On 13-Jul-01 David Tomas Fargas wrote:
> Well, sorry about my worst explanation :)
>
> The table is a Spain Postal Codes Table.
> It has fields: Cod(5),Descr(100),Country(3),IND(13),ORD(3).
> All are varchars.
> Because there are possible to have the same Postal Codes and diferent
> description
hi, maybe you can try d/l the mm.mysql driver from the jdbc link at
www.mysql.com.
the details of programming can be retrived from the webpage where you will
get the mm.mysql driver under documentation.
after you've downloaded the documentation "mm.doc.tar", you can view the
book1.html file and fi
Hi,
got the same problem too after i rebooted my linux RH7.
i solved it by restarting the server :
bin/safe_mysqld --user=mysqladm &
I got the command from Paul Dubois book on MySQL
hope it helps
-Original Message-
From: Roberto Carlos Sánchez Barroso [mailto:[EMAIL PROTECTED]]
Sent: Wed
i've written a java file to connect to the database in a linux rh7 os. the
file runs fine on a win2000 os so i think that there is no problem with the
code. I've set my class path to the dir where i've downloaded the
mm.mysql.jar file and the path set to my jdk1.3.1/bin and jdk1.3.1/lib
directorie
> Hi!
>
>
>
> Sander> I do not deny their claim on the trademark OR domain,
> but I am
> Sander> somewhat unpleasantly surprised by the means they try
> to resolve
> Sander> this matter, and the fact that nobody in a what I
> assume is an
> Sander> internet-aware company like MySQL even
I AM AS CONSERVATIVE AS IT GETS
THIS REALLY WORKS.
YOU WILL BE DEBT FREE FOR 2002...PLEASE READ BEFORE
DELETING...THIS IS
NOT A SPAM...YOU WILL BE DEBT FREE...YOU HAVE NOTHING TO LOSE BUT
EVERYTHING TO GAIN
All our mailings are sent complying to the proposed United States
Federal
requiremen
Jesús Gómez wrote:
> I have a problem with the update querys.
>
> When i do a update in a table,it fails.
> If i do this query two or three times it works fine.
> There isn´t a table problem because this error happens in every tables.
>
> The select and insert querys work fine.
>
> Anybody kno
Well.
It should be an interesting Open Source convention in
San Diego later this month...
database,sql,query,table
--
Paul DuBois, [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (
The following CREATE TABLE statements seem straight forward but they all
fail. Can someone explain why they fail and what I can do to get rid of the
"Duplicate column name" errors?
mysql> CREATE TEMPORARY TABLE User2 (UserID int(11)) SELECT UserID FROM
User;
ERROR 1060: Duplicate column name 'Us
Hi!
I am just filling in some missing facts here.
> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> On Fri, Jul 13, 2001 at 01:03:19AM +0200, Sander Pilon wrote:
>>
>> Rule number one on the internet: If you have a trademark, GET THE
>> .COM, .NET, .ORG, .CC and .CX ASAP!!!
Hi!
Sander> I do not deny their claim on the trademark OR domain, but I am somewhat
Sander> unpleasantly surprised by the means they try to resolve this matter, and
Sander> the fact that nobody in a what I assume is an internet-aware company
Sander> like MySQL even considered getting the .org
Hi!
> "Tim" == Tim Endres <[EMAIL PROTECTED]> writes:
>> If anyone has any comments about how we at MySQL AB work as an open
>> source company, please write to our CEO Marten Mickos via
>> [EMAIL PROTECTED] and we will welcome your suggestions. We are
>> totally dependent on the trust of ou
Well, sorry about my worst explanation :)
The table is a Spain Postal Codes Table.
It has fields: Cod(5),Descr(100),Country(3),IND(13),ORD(3).
All are varchars.
Because there are possible to have the same Postal Codes and diferent
description or different country, The Primary Index is IND that it
Dear Mysql
How can lock and unlock a single record into mysql table?
Thank you very much.
On Thu, Jul 12, 2001 at 03:49:12PM -0700, Jeff Philapy wrote:
> It is hard to say where I am confused because the
> HOWTO requires me to try and follow it as I setup
> replication. So let me try and follow the
> documentation and if I see anything that can make it
> more clear then I will let you
They give away the previous version free
(i.e if they are on 1.9 you can download 1.8
and use it free)
-Original Message-
From: Chris Lott [mailto:[EMAIL PROTECTED]]
Sent: 13 July 2001 14:30
To: '[EMAIL PROTECTED]'
Cc: MySQL List (E-mail)
Subject: RE: MASON GUI for Windows is it good?
Remember Win 3.1, you had to create PIF files for DOS programs, I think it was DOS, to
run in the Win enviroment.
The odd thing is that it sure sounds like some kind of new virus with that kind of
text comment.
Cheers
M;)
-Original Message-
FROM: Don Read
TO: Chris Bolt
CC: [EMAIL P
Yes Of course.The table have a primary key and indexes and the field
used in the order by are indexed (this isn't the primary field, but it's
indexed)
-Mensaje original-
De: Huntress Gary B NPRI [mailto:[EMAIL PROTECTED]]
Enviado el: viernes, 13 de julio de 2001 18:10
Para: 'David To
On 13-Jul-01 David Tomàs Fargas wrote:
> I Have a large table with 59.000 records and if i execute a simple select
> since "Select * from table order by cod" it takes 4 seconds to process
> query!
> and if table will have 590.000 then... well, you see it.
>
> It's possible to accelerate it, with
Kim White wrote:
> Could anybody tell me how to get rid of the following error on a php3
> request. "Warning: MySQL Connection Failed: Host 'hostname.co.za' is not
> allowed to connect to this MySQL server in /var/local/irm/irm.inc on line
> 83".
> ---
Hi,
Newbie to MySQL here. I am trying to export tables from SQL Server to MySQL
set up on a virtual server and manage to create the tables when the fields
contained within them are purely text, but the table creation fails when
fields are type integer or type datetime. The error message is a
On 13-Jul-01 David Bouw wrote:
>
> Something that I noticed was that you could also add an option to say if a
> Int was unsigned ot signed..
>
> Does it have any sence to use a signed int on a autoincrement table..?
> E.g. When using a auto-increment correctly you will never need a negative
did everyone on the list get those spam emails? I got 6 too, within 15
minutes, at 5am my local time. And I don't remember sending anything at
that time, I was sleeping :)
Sinisa Milivojevic wrote:
>
> Justin Farnsworth writes:
> > [EMAIL PROTECTED] wrote:
> > >
> > > Your message cannot be post
Hi Kevin
Can you please send us the ODBC trace generated by MyODBC as well as ODBC DM
?
Thank you
Venu Anuganti
- Original Message -
From: "Kevin Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 2:24 AM
Subject: MyODBC 2.50.37 and Access 2000
> Hi All,
>
>
Hi,
I didn't get a reply to this, so I guess no one knows, or, it's on the wrong
forum.
Can any set me straight on this?
Cheers,
Kevin
- Original Message -
From: "Kevin Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 10:24 AM
Subject: MyODBC 2.50.37 and
I Have a large table with 59.000 records and if i execute a simple select
since "Select * from table order by cod" it takes 4 seconds to process
query!
and if table will have 590.000 then... well, you see it.
It's possible to accelerate it, without where and limit clausules?
I think no, and in m
I created a database with MySql (version 3.23.39-nt) that has a table named
Report. How can I open the database and insert values in this table from a
servlet?
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
-
I have a problem with the update querys.
When i do a update in a table,it fails.
If i do this query two or three times it works fine.
There isn´t a table problem because this error happens in every tables.
The select and insert querys work fine.
Anybody knows what could be the problem?
I recently started experimenting with a way to setup MySQL to be
load-balanced. I installed 2 servers with MySQL, NFS mounted the /mysql/var
directory, then moved the grant tables to /mysql/grant, and created a
symbolic link from /mysql/var/mysql to /mysql/grant. This appeared to work
correctl
Hello,
I need help with a select statement on my database. (I am still on L Plates
with Mysql)
My Tables
Clients - Holds clients infomation
Targets - Holds Target infomation
Clients_Targets - Holds Clients Id and Targets Id
How do I find clients that are in muti
1 - 100 of 176 matches
Mail list logo
