We have aded an internal domain, its assigned the latest id ( 20433), we
have safeguards in our portal that stop domains with id less than 5 from
being deleted, the table doesnt show "3" so it is not used, but when I try
alter the table it fails:
update virtual_domains set id='3' where id='20433'
rk
> Am 06.03.2011 05:34, schrieb Edward avanti:
> > Hi, I am having all sorts of problem getting apache to accept its MD5
> > version, this is from a CRM using perl
> > I've tried concat $apr1$foo$ and md5(bar)
> > as best I can tell It doesnt like the md5 part
Hi, I am having all sorts of problem getting apache to accept its MD5
version, this is from a CRM using perl
I've tried concat $apr1$foo$ and md5(bar)
as best I can tell It doesnt like the md5 part
Is there anyway to get this to work? the only thing that does is encrypt,
and thats sad, with only
Jerry Schwartz wrote:
> From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
> Sent: Friday, January 15, 2010 8:03 AM
> To: Jerry Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
> performance
>
> Jerry Schwa
Jerry Schwartz wrote:
From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
Sent: Friday, January 15, 2010 8:03 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
performance
Jerry Schwartz wrote:
BTW, would you mind to
t;[JS] PHP 5.2.10, Apache 2.2.14 (Win32), MySQL 5.1.36-community
>
>
Dear Jerry,
Did you means :
php (32 Bit) + Apache (32 Bit) + MySQL (32 Bit) on Windows (64 Bit) OS ?
Thanks !
Edward.
Jerry Schwartz wrote:
From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
Sent: Tuesday, December 29, 2009 10:35 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
performance
Jerry Schwartz wrote:
Dear Jerry,
Sorry
Dear All,
If the OS is Windows 2003 64Bit (IIS)...
So, which php package must download and how to config it for running
with IIS ?
Due to I don't quite the online manual:
http://www.php.net/manual/en/install.windows.iis.php
Which installation mode is suitable of it ?
Thanks !
Edward.
--
Jerry Schwartz wrote:
From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
Sent: Tuesday, December 29, 2009 10:35 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
performance
Jerry Schwartz wrote:
Dear Jerry,
Sorry
Jerry,
Do you know which version of newer version of php which support the
short tags ( allowed ) ?
Or would you mind to tell me how to fix the problem of php source code
and connect with mysql db ?
Thanks !
Edward.
Jerry Schwartz wrote:
From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
Sent: Monday, December 28, 2009 9:25 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
performance
Jerry Schwartz wrote:
-Original Message
Jerry Schwartz wrote:
>>-Original Message-
>>From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
>>Sent: Thursday, December 17, 2009 7:25 AM
>>To: mysql@lists.mysql.com
>>Subject: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
>>performanc
Dear all,
Would you mind to give me the suggestion ?
I want to use 32bit php and mysql server on 64bit Windows 2003 Server...
So, is it possible ( good for work also ) ?
Thanks !
Edward.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
I had previously installed the 64-bit version of MySQL 5.1 server under
Windows Vista x64 and both the installation and configuration were
successful. Then for compatibility reasons with something on which I am
working I realized I needed to install the 32-bit version of MySQL 5.0
server. Since
I have a few questions about the parameters for SslOption/mysql_ssl_set
( C++/C ) and about SSL in general between the server and the client.
I do understand what a certificate, a private key, and a public key is
in general but I am having trouble understandng how they work in MySql.
1) Are the f
I have a few questions about the parameters for SslOption/mysql_ssl_set
( C++/C ) and about SSL in general between the server and the client.
I do understand what a certificate, a private key, and a public key is
in general but I am having trouble understandng how they work in MySql.
1) Are the
In the MySql manual section 5.5.7.2 it specifies how to build MySql on a
Unix/Linux platform with SSL by using 'configure'. I need to build MySql
for Windows with SSL support. In section 2.4.15.6.1 for building MySql
for Windows itr specifies the available options for using win/configure,
but S
Warren Young wrote:
> Edward Diener wrote:
>>
>> The source distributions listed at
>> http://dev.mysql.com/downloads/mysql/5.0.html#source do not specify
>> any as the Windows source distribution. I downloaded the .zip file,
>> thinking that might be the one, but
The MySql manual in section 2.4.15.6.2 mentions building MySql from the
Windows source distribution. I need to do this in order to add SSL
support to my MySql server on Windows.
From where do I download the Windows source distribution ?
The source distributions listed at
http://dev.mysql.com/
I signed up for the Server | General Discussion mailing list using an
e-mail address I created at my web host, and through which I have
received numerous e-mails without problem. The subscription went
correctly. I then attempted to send a message to the GMane newsgroups
which mirrors the list.
Hi, this is my first time installing the MySQL server. I have built
and installed the databases/mysql60-server via the FreeBSD ports
system (using default configuration options). But let me discuss my
installation procedure, adopted from the manual:
The mysql group and user are already added by th
> We have just moved to a new web server where we are running mysql
> version: 5.0.45
> On the old machine, when we gave the following command:
> update table1 set passwd = password('xx') where user_name="xx";
Here you're updating 'table1'...
> and then gave the following command,
> SELECT us
PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Selecting the most recent entry for each object.
Hi,
On Thu, Mar 20, 2008 at 10:35 AM, Edward Corbett <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
>
> I have a load of reviews in a table and, for each person I want to pull
out
> the
Hi,
I have a load of reviews in a table and, for each person I want to pull out
the most recent review.
So, if I wanted to do this for a single person I would order by date desc
and use "limit 1". But I'm not sure how to do this in bulk.
Thanks.
gt; and if i starts from id 6, i should be able to select 6 and 9 and no more.
>
> How can I do that?
>
SELECT * from list WHERE properties = 1 AND id >= [starting ID] LIMIT 2;
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ainst using any upper-case characters in your web folder
names (URLs) as this can lead to annoying problems later down the line. It's
much simpler to keep it all lowercase.
Edward
> -Original Message-
> From: Nicoleen Nel [mailto:[EMAIL PROTECTED]
> Sent: 17 January 2008 13:3
Hi,
I hope this finds itself as an answer to my last post. I'm new to this email
message format of lists.
It turns out that the problem with the join was that I had a column being
selected that I removed from my posting example for brevity which was
causing the select to fail. The extra c
Hi,
I am trying to join a bunch of tables together. I want a row for each
"learner", and on the row, I want some "user", "centre", "client" and
"centreManager" information if there is any. Thus, I am trying to outer join
from the "learner" table to 4 other tables. The query I have so far is bel
>
> Hello i use this query:
>
> select i.item_id
> from orders o
> INNER JOIN item i ON i.nr=i.nr
Should the line above not be
... ON i.nr = o.nr ?
> INNER JOIN user_cart u ON u.nr=i.nr
> where (i.count !=0 or i.count!=NULL) and i.isactive=1 and i.kolWo>0
> order by i.count DESC
> LIMIT 5
>
#x27; matches though Is such a thing possible?
MySQL full-text searching is out as I'm using InnoDB tables.
Does anyone have any suggestions?
Thanks!
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FYI, this did not work :)
Thanks though!
Rich(ard)
On Nov 23, 2007 3:37 AM, Paul McCullagh <[EMAIL PROTECTED]> wrote:
> Maybe this will work:
>
> SHOW CREATE TABLE table_name;
>
>
> On Nov 21, 2007, at 9:42 PM, Richard Edward Horner wrote:
>
> > Hey everybody,
Good call, Paul. I'll try it out!
Thanks, Rich(ard)
On Nov 23, 2007 3:37 AM, Paul McCullagh <[EMAIL PROTECTED]> wrote:
> Maybe this will work:
>
> SHOW CREATE TABLE table_name;
>
>
> On Nov 21, 2007, at 9:42 PM, Richard Edward Horner wrote:
>
> > Hey everyb
all or is there more that you know that I don't?
Thanks, Rich(ard)
On Nov 22, 2007 12:43 PM, Micah Stevens <[EMAIL PROTECTED]> wrote:
> Look at the data files. The extension of the file will tell you.
>
>
>
> On 11/21/2007 12:42 PM, Richard Edward Horner wrote:
> >
me? Or I guess a broader more helpful question would
be, "What are all the ways to determine a table's storage engine
type?"
Thanks,
--
Richard Edward Horner
Engineer / Composer / Electric Guitar Virtuoso
[EMAIL PROTECTED]
http://richhorner.com - updated June 28th
--
MySQL General Mail
;
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Richard Edward Horner
Engineer / Composer / Electric Guitar Virtuoso
[EMAIL PROTECTED]
http://richhorner.com - updated June 28th
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
h thousands of tables! So there is no fast dump and
> insert of tables.
>
> Any ideas (besides from dumping everything and importing at then)?
>
> Regards
> Marten
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
/07, mos <[EMAIL PROTECTED]> wrote:
> >
> > At 02:18 PM 11/6/2007, Richard Edward Horner wrote:
> > >Hi,
> > >
> > >I'm working on a program that will run in the event that tables are
> > >crashed or corrupt. Can anyone recommend a goo
t start an infinite loop with an UPDATE
statement in it and then kill -9 the mysqld process.
Any better ideas?
Thanks, Rich(ard)
--
Richard Edward Horner
Engineer / Composer / Electric Guitar Virtuoso
[EMAIL PROTECTED]
http://richhorner.com - updated June 28th
--
MySQL General Mailing List
For lis
?
>
You could create an extra 'standardised' column that is used for searches. I
discussed this in another post last week -
http://lists.mysql.com/mysql/209197
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
public static function TranslateAccentedChars($strInput) {
$strAccentedChars=
"¥µÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝßàáâãäåæçèéêëìíîïðñòóôõöøùúûüýÿ";
$strNonAccentedChars =
"SOZsozYYuAAACDNOOYsaaaconooyy";
return strtr($strInput, $strAccentedChars,
$strNonAccentedChars);
}
HTH,
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ery Browser and MySQL Administrator) but I prefer Toad:
http://www.quest.com/toad-for-mysql/
HTH,
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
always
> matched the OS time.
>
> Thoughts appreciated.
>
> Thanks,
>
> David
I suspect MySQL is configured with a differect timezone/locale from your OS.
See http://dev.mysql.com/doc/refman/5.0/en/localization.html for info.
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
es less than a second, so there is practically no
downtime.
Note that this works well as most of my DB is 'read-only'. I have to be more
careful when updating any tables that are written to via the app.
HTH,
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
llation settings, if this is the cause for my problem,
> or if there might be any other reason for it. My mysql version is
> 5.0.26-12, running on a Suse Linux 10.2.
>
> Best regards,
> H.
Try using the SET NAMES 'utf8' statement [1] to tell MySQL that your client
is s
ta infile "table.csv"
into table table_name
fields terminated by ',' enclosed by '"'
lines terminated by '\r\n' starting by ''
ignore 1 lines;
The CSV file has Windows line endings and is imported by MySql on Linux. You
wouldn't need the enclosed by bit for your data though.
HTH,
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
gine? If so, what is
> >the command/process to make this happen.
> >
Can't you just remove the INSERT/UPDATE/DELETE priviledges from the user(s)
concerned?
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
he right join
statement. I think
right join user friend on ... should be
right join friend on ...
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> -Original Message-
> From: Baron Schwartz [mailto:[EMAIL PROTECTED]
> Dan Nelson wrote:
> > In the last episode (Jun 18), Edward Kay said:
> >> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> >>
> >>>>>> At the moment, I have thi
t; >
> >
> > With my query above, the sub-query result set would be empty since
> > count(primary_entity_id) = 2.
> >
> > If I move the is_primary = 0 requirement to a WHERE clause,
> then the first
> > row would be incorrectly updated since the group function would only be
> > working on the sub-set of data (where is_primary = 0).
> >
> > It's a subtle but important difference.
>
> Then I think what you really want in your HAVING clause is "AND
> MIN(is_primary)
> = 0".
>
> Baron
But I'm first grouping by primary_entity_id and then only selecting the rows
where count(primary_entity_id) = 1, so is_primary clause will only ever be
working on one value.
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it doesn't have to be in the
> HAVING clause.
No, because that's not the same thing. Imagine the following data:
address_id primary_entity_id is_primary
---
1293 0
2 293 1
With my
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: 15 June 2007 19:24
> To: Edward Kay
> Cc: MySQL List
> Subject: Re: Hiding columns used in GROUP BY and HAVING clauses
>
>
> In the last episode (Jun 15), Edward Kay said:
> >
rimary = 0
);
Normally, I'd only return the address_id in the sub-SELECT, but I need the
is_primary column for the HAVING clause.
Any ideas on how to achieve this?
Thanks,
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
ience with
mySQL. If it's not too much trouble, could someone give me a bit more help
on how to do that please?
Ed.
no, those won't match based on just the datatype change.. you will
have to define a user defined function to do those comparisons.
On 6/14/07, Edward Quick <[
defined function to do those comparisons.
On 6/14/07, Edward Quick <[EMAIL PROTECTED]> wrote:
Thanks, that's interesting. Actually the uc.ID column is still type
tinyint
as it holds only one number, but are you saying if I change this to
varchar
my query will work e.g. 15 = 15:17 wo
will work fine. If it's an integer type, you are going to have a
problem because you have bt.category_ID holding things which can't be
represented as integers and will therefore never match. IF both
column type are being changed here, your query will work fine as is.
- michael dykman
On
Hi,
I have the following mySQL query in my script which has been working fine
but due to a recent change, I had to modify one of the columns,
bt.category_ID. This used to be defined as tinyint(3) but I've changed that
now to varchar(20) as it needs to hold values such as 15, or 74:79 or
43:56
to be able to create and update databases
> > (tables, indexes and so forth). I would rather do this than do it via a
> > command line. I would appreciate any links available.
> >
> > Andrew
> >
Also look at Toad: http://www.quest.com/toad-for-mysql/
Edward
--
MySQL
> SELECT * FROM news WHERE display='yes' ORDER BY id desc limit 1
>
> Think this would get the lastest article that is to be displayed
> but how do I get the second one.
>
Just add an offset to the LIMIT clause:
SELECT * FROM news WHERE display='yes'
asking here for an answer?
Assuming you now want to do this transformation at the database layer,
select the three date components out separately with the string functions
and then use DATE_FORMAT() to print them how you want.
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#fun
to do
>
> inet '192.168.1/24' >> inet '192.168.1.5'
>
> http://www.postgresql.org/docs/current/static/functions-net.html
>
> Is there anyway to do this using MySQL?
>
Although it wouldn't be as need as using the >> and similar operators, you
co
ooms from TABLE;
Or, if you want a boolean value depending if there are less than 10:
SELECT IF((single_rooms+double_rooms+twin_rooms) < 10,1,0) from TABLE;
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
single_rooms, double_rooms, twin_rooms) < 10,1,0) from TABLE;
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#x27;data' not 'date' :) He is talking about a reference number that
needs to be in a certain format.
I too would argue that this requirement is more application layer than in
the database. Surely anyone editting the tables directly should know what
they're doing and adhere to th
etter in my opinion.
I've just download Toad - and have to say it looks pretty good. It doesn't
appear to have the graphical representation of DB Designer but it may well be a
good replacement for the three MySQL AB tools mentioned above.
I'd be interested to hear other options though...
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> From: Baron Schwartz
> Hi Edward,
>
> Edward Kay wrote:
> > Hi,
> >
> > I have a query that returns data from a join of two tables, person and
> > company. The results look like:
> >
> > FIRST_NAME | LAST_NAME | COMPANY_NAME
> > -
fields).
Ideally I should be able to achieve this with ORDER BY
CONCAT(first_name,last_name,company_name) but of course this doesn't work
because CONCAT returns NULL if any of its arguments are NULL (which will
always be the case).
Any ideas?
Edward
--
MySQL General Mailing List
For
> How can I change character_set_xxx variables in MySQL 4.1.x in Linux?
SET NAMES ''
http://dev.mysql.com/doc/refman/4.1/en/charset-connection.html
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Francis wrote:
Question about MyISAM vs InnoDB ? What is the best to use, I have
a large table contain around 10 millons of records. What is the best
for me ? Use MyISAM or InnoDB ?
Depends VERY much on your application. If any concurrency and/or
durability is required then I would
Francis wrote:
Question about MyISAM vs InnoDB ? What is the best to use, I have
a large table contain around 10 millons of records. What is the best
for me ? Use MyISAM or InnoDB ?
Depends VERY much on your application. If any concurrency and/or
durability is required then I would
Doesn't that change when you hook up to a database?
On Oct 30, 2006, at 12:56 PM, João Cândido de Souza Neto wrote:
Ok, we are in the same snag.
Who gets the solution firstly please, share it.
""Joshua J. Kugler"" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
On Sunday 29
Ahmad Al-Twaijiry wrote:
Hi everyone
SELECT * FROM tbl_name WHERE SUM(Total)=100 ORDER BY ID
SELECT ID FROM tbl_name GROUP BY ID HAVING SUM(Total)=100 ORDER BY ID
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
What does your script look like? Code?
Ed
On May 13, 2006, at 5:46 PM, Steve wrote:
I'm fairly new to all this and duing everything step by step...
I made my first (test) php site - and it works... then, i have this
script
where i'm supposed to find out if MySQL and PHP talk with each
oth
.
---
Edward David
Sr. Systems Analyst
University of Calgary
Information Resources
Information Technology Service
---
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Bruno Cochofel wrote:
From http://www.mysqlusers.com/msg/37105.html we have:
<>Reset the password to pre-4.1 style for each user that needs to use a
pre-4.1 client program. This can be done using the SET PASSWORD
statement and the OLD_PASSWORD() function:
mysql> SET PASSWORD FOR 'some_user'@'so
Bruno Cochofel wrote:
Thank you all for the posts. Can anyone explain to me how can I connect
DBDesigner4 to MySQL 4.x? I've never used MySQL 3.x and I believe
there's some kind off trick to connect DBDesigner4 to MySQL 4.x because
the program doesn't support the MySQL 4.x
Or the ODBC connection
Graham Reeds wrote:
Bruno Cochofel wrote:
Does anyone know a sw that can reverse engineering a mysql table? I
want to
be able to draw a entity-relationship model from an already made MySQL
table.
[snip]
Also people say great things about DBDesigner4 but I haven't used it to
talk about it
Kevin Liu wrote:
This looks great! Is there anything like this for Mac OS X?
Kevin
On 10/2/05 10:39 PM, "Ligaya Turmelle" <[EMAIL PROTECTED]> wrote:
+1 - it is wonderful.
olinux wrote:
You will love this.
http://www.fabforce.net/dbdesigner4/
I know it's not 'running on OSX', but I do m
Michael Stassen wrote:
Stephen A. Cochran Lists wrote:
On Sep 27, 2005, at 3:29 AM, Jasper Bryant-Greene wrote:
mysql> SHOW CREATE TABLE Player|
| Player | CREATE TABLE `Player` (
`id` int(16) NOT NULL auto_increment,
`first_name` varchar(32) NOT NULL default '',
`last_name` varchar(32
Marcus Bointon wrote:
I installed (as root) the standard rpms over a working 4.1.10a
installation (also from standard rpms) from the mysql site with rpm - U,
and all went ok, except that the server failed to start after the
upgrade. I had a look at it from webmin too and noticed that it was
Dear Community,
My team and I have been experiencing an interesting mysql error
during the past few weeks of testing. Here is the scenario we are
trying to accomplish. We are essentially working to use MsAccess as a
windows client for a linux based mysql databases. We have installed
myO
On Sun, Jun 05, 2005 at 04:41:16PM -0700, sol beach wrote:
> IMO, you have much more a lively imagination than realistic, in depth
> & technical knowlege in either MYSQL or Oracle.
> Current production MYSQL does NOT have stored procedures.
Current production mysql doesn't, but current development
hey all,
I'm trying to convince some people here to adopt MySql as a relational database
here. However, we can't start from a clean slate; we have a very mature oracle
database that applications point to right now, and so we need a migration path.
I was thinking of taking the following steps:
Hello,
The new version of DBACentral for MySQL has been released.
DBACentral v1.6 presents powerful report building functionality,
query-based forms, reports and web pages, lookup fields showing
multiple column values, and other improvements
Download the new version of DBACentral for MySQL righ
are the same).
Thanks for your patience
Eddy
Edward Macnaghten wrote:
Hi
Announcing ShellSQL 0.7 to an unsuspecting world...
ShellSQL is a utility to allow SQL to be intergrated easily into
UNIX/LINUX shell scripts.
The web page is at http://www.edlsystems.com/shellsql - and at
sourceforge at http
Forgive me for blowing my own trumpet here.
The advantage with ShellSQL over this method is
1 - The output is not cluttered with headers, and a means exist to
easily separate fields when there is more than one column or row in the
query.
2 - The connection is persistant, whereas running "mys
Funny you should mention that
May I guide you to my recent announcment of ShellSQL 0.7 - web page at
http://www.edlsystems.com/shellsql - a utility to do just as you want (I
think) released under GPL.
It must be good - I wrote it myself :-)
Yours
Eddy
Andy wrote:
Hi all
I just wanted to know
Hi
Announcing ShellSQL 0.7 to an unsuspecting world...
ShellSQL is a utility to allow SQL to be intergrated easily into
UNIX/LINUX shell scripts.
The web page is at http://www.edlsystems.com/shellsql - and at
sourceforge at http://sourceforge.net/projects/shellsql .
Version 0.7 includes many bu
Hello All,
DBACentral for MySQL has been released!
===
The long-awaited headliner of the DBACentral Product Family has been
finally released!
We are proud to present an absolutely new product which brings MySQL
database management to the new level of fastness
rson who may need our products with
this coupon.
--
Best regards,
Edward Smirnov
microOLAP Technologies LTD
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks, adding the indexes worked beautifully. I'll go knock my head on
the desk now. Thanks for your time :)
Ed
Edward Ritter said the following on 7/20/2004 1:08 PM:
Thanks, I'll take a look at that. The id isn't unique, so that's why I
added the idx column.
Does my qu
d:
ALTER TABLE la_entire
ADD INDEX idx_email_address (email_address);
ALTER TABLE la_final
ADD INDEX idx_email_address (email_address);
See:
http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
On Tue, 2004-07-20 at 09:22, Edward Ritter wrote:
Stefan:
I added an index column t
help?
Ed
Stefan Kuhn said the following on 7/20/2004 12:05 PM:
I would expect that the speed problems are due to missing indices. Did you do
proper indexing? If unsure, post your table structures and query.
Stefan
Am Tuesday 20 July 2004 17:45 schrieb Edward Ritter:
I've got a task that'
I've got a task that's gonna require me to compare one table to another
and remove the rows from the first table that are found in the second
table that match email_address.
I'm running 4.0.20a-nt-log. The first table has 10 colomns and about 50K
records, and the second table has 46 columns and
Excuse my naivety but how do I create a Table in MySQL?
I cant find any Text/Windows based programme that allows be to create and
edit the table, fields, data types, size etc?
Im not looking for anything complex.
Many thanks,
Ed
Edward Hasted
Contact Information:
E-mail : [EMAIL PROTECTED
I am with a small business in Southern California that would like to migrate
our MS Access databases to MySQL server. Are their any computer service
companies who can help me?
-
Before posting, please check:
http://www.mysql.
I have solved my problem with MySQL and MySQLdb. The problem was:
> I have installed mysql-3.23.52 as part of the Gentoo Linux
> distribution. I am accessing MySQL via mysql-python AKA MySQLdb
> which calls the MySQL C API. During testing I start MySQL using
> "safe_mysqld" and shutdo
; [mysqld]
> local-infile=1
>
> [mysql]
> local-infile=1
>
> - hcir
> On Monday, Oct 14, 2002, at 15:46 America/Anchorage, Edward C. Jones
wrote:
>
> > Since I have had no luck whatsoever figuring out how to use the
> > "local-infile" option
Since I have had no luck whatsoever figuring out how to use the
"local-infile" options,
I modified my Gentoo ebuild to pass "--enable-local-infile" to the
compile configure.
Do I still need to use local-infile options at all?
I am using mysql-3.23.52.
I have installed mysql-3.23.52 as part of the Gentoo Linux distribution.
I am accessing MySQL via mysql-python AKA MySQLdb which calls the MySQL
C API. During testing I start MySQL using "safe_mysqld" and shutdown
MySQL using "mysqladmin -u root --password= shutdown".
When I do a "LOAD
sql query
when I am defining a table, how do I set the default of a datetime column to
the current time? I tried setting the default to now() but it just fills
the column with 00:00 etc..
Thanks,
Eddie
-
Before posting, plea
1 - 100 of 143 matches
Mail list logo