Hallo,
I am using the latest Version of mysqlgui-win32-static-1.7.5.2.
When I "save-to-file" a query, in all text fields BLANKS are pre-fixed. How
can I manage that the query is saved without leading BLANKS as it appears on
screen, e.g. text fields start at the first byte as in the data base?
Tha
Hello "Heikki Tuuri" <[EMAIL PROTECTED]>,
Where can I find InnoDB Hot Backup product?
On Sat, 6 Apr 2002 10:35:33 +0300
"Heikki Tuuri" <[EMAIL PROTECTED]> wrote:
> Hi!
>
> - Original Message -
> From: "Eric S" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Saturday,
Hi!
- Original Message -
From: "Eric S" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, April 06, 2002 2:10 AM
Subject: Re: InnoDB is better than MyISAM ?
> On Fri, 5 Apr 2002, BD wrote:
>
> > At 01:54 PM 4/5/2002, you wrote:
> > >I have seen many people saying th
Paul,
Do you know if there is any performance differences between a
unique index and primary key (if there are no nulls)?
Is the index file format the same as the primary key?
Brent
At 05:09 PM 4/5/2002, you wrote:
>>Here are a few easy philosophical questions for a change:
>>
Hi,
I hava a table "tblA" that has two fields (id, description) and a table
"tblB" with two fields (fk_tblA, dtInsert). My problem is that i need to
count records in tblB grouping them by (id, description) to know how many
children each record from tblA has in tblB. The sql i'm using is:
On Sat, 06 Apr 2002 [EMAIL PROTECTED] wrote :
>Your message cannot be posted because it appears to be either
>spam or
>simply off topic to our filter. To bypass the filter you must
>include
>one of the following words in your message:
>
>sql,query
>
>If you just reply to this message, and incl
Placed At :
Hi all..
I have been looking for a document which would describe the architecture of
mysql..Something like how a query traverses along the system and how a query
gets served.
.Has someone come across such a document or even a book tha
On Fri, 5 Apr 2002, Steve Rapaport wrote:
> On Friday 05 April 2002 06:37 pm, andy thomas wrote:
> >On Fri, 5 Apr 2002, Steve Rapaport wrote:
> >> With InnoDB, I'm sure this problem goes away, but as soon as we
> >> go to InnoDB, we have to pay for backups and support,
> >> which means we start
Hi!
> "Richard" == Richard Spangenberg <[EMAIL PROTECTED]> writes:
Richard> I don't mean to start an opinion war, but ...
Richard> Can mySQL handle many processors, many servers (clustering), load
Richard> ballancing, etc as well as Oracle. Or should one use Oracle (some other
Richard> da
At 22:50 3/4/2002 -0800, SankaraNarayanan Mahadevan wrote:
Hi,
>I have MySQL 3.23 installed in Windows 2000 Server 4
>days ago. It runs as a service of the server. It was
>working fine.
>But now it stops abrubtly. When I run the PhpMyAdmin
>I ahve a doubt that it shuts down by itself after a
>sp
Many thanks. You filled in the missing piece for me. It appears to be
working... at least with both databases on the same MySql server. I hope
that
putting one db on the file server and one locally does not prove to be
problematic (that issue never occurred to me), but if worse comes to worse,
On the grounds that someone else may have this problem, and in response to
John's post, below, I am providing a "cookbook" of how to do what I asked.
The problem: I have a bunch of users, all with small local MySQL databases
on their Windows boxes (which get synchronized with a large server
data
Hi,
I had a question and perhaps somebody could help me.
I create a table with these characteristics:
mysql> CREATE TABLE Usuarios (Nombre TEXT NOT NULL,
-> Password TEXT NOT NULL,
-> Permiso INT(1),
-> PRIMARY KEY(Nombre(30)));
Query OK, 0 rows affected (0.05 sec
Paul,
Ok. But that isn't what we are talking about.
If I understood him correctly, Dormition said he has one database on a remote
server and one on a local computer and thus they are NOT managed by the same
database "server":
> I have queries that have to be able to join tables in the
> local
It's perfectly possible to join tables from different databases, as long
as the databases are managed by the same server. Just qualify your
table names with a leading database name.
For example, a join between two tables in the same database might
be written like this:
SELECT t1.col1, t2.col2
F
You are talking about "heterogeneous queries". I believe it is Delphi which
achieves this feature for you, not the databases themselves. Here is a quote from
the Delphi help system:
"Delphi supports heterogeneous queries, that is, queries made against tables in
more than one database. A hete
I need some help creating a Primary Key in MySQL with autoincrement
Hello, how can i do a concatenated primary key index of:
date,"NOTA",id
e.g. 05042002NOTA1
which the id is generated daily, everyday start with id=1 and increments
Azul
-
rory oconnor <[EMAIL PROTECTED]> writes:
[...]
> each item in a cart is a record, so simply querying on records won't
> work. What I need to count is how many distinct customerId's there
> are. a sample from the table looks like:
>
> cartItemIdcustomerId productId
> 1944 244
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
I'm trying to write a query that will tell me how many abandoned carts
there are in a "cart" table I have.
each item in a cart is a record, so simply querying on records won't
work. What I need to count is how many distinct customerId's there
are. a sample from the table looks like:
cartItemId
>Here are a few easy philosophical questions for a change:
>
>1) For performance or storage benefits, is there a difference between a
>Unique Index and Primary Key?
There can be only one primary key. There can be multiple unique indexes.
Primary keys cannot contain NULL values. Unique indexes
On Fri, 5 Apr 2002, BD wrote:
> At 01:54 PM 4/5/2002, you wrote:
> >I have seen many people saying that InnoDB is a great deal, that InnoDB
> >rocks, etc. and I am concerced about how much better InnoDB is compared to
> >MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB
Problem is I'm accessing mysql through scripting against a table
that may or may not have ID field,
select count(*) from (desc ATTRIBUTES) where Field ='ID';
if count(*) > 0 then
select ID from ATTRIBUTES;
else
do something else;
end if;
-Original Message-
From: Gurhan Ozen [mai
Here are a few easy philosophical questions for a change:
1) For performance or storage benefits, is there a difference between a
Unique Index and Primary Key?
2) Is there a reason why I should use Primary Key instead of a Unique Index?
3) Why isn't there a syntax for "create primary index inde
-Original Message-
From: hong chen
Sent: Friday, April 05, 2002 5:50 PM
To: 'Gurhan Ozen'
Subject: RE: create tmp table of column list of a table for future use
I am trying to check if a certain column exists before I try to select it from the
table.
in Oracle or Sql Server I would:
Are you trying to create a new table with an existing table's structure only
? or with the structure and data? If you just wanna duplicate a table with
the data inside it you can use CREATE TABLE .. SELECT ... syntax. More info
is at: http://www.mysql.com/doc/C/R/CREATE_TABLE.html
IF you just wan
-Original Message-
From: hong chen
Sent: Friday, April 05, 2002 5:32 PM
To: 'Alex Behrens'
Subject: RE: create tmp table of column list of a table for future use
No luck. Oracle and Sql Server have system tables to check.
mysql> desc ATTRIBUTES;
+---+--+--+-+
I believe it has to be like this:
create table column_list (MYTABLE_NAME DESC);
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ:
mysql> create table column_list (desc MYTABLE_NAME);
ERROR 1064: You have an error in your SQL syntax near 'desc MYTABLE_NAME)' at line 1
Anyone know how to make something like it?
-
Before posting, please check:
http://www
On Friday 05 April 2002 2:54 pm, Zhao, Charles wrote:
> Thanks Todd and Tyler for the encouragement,
>
> When I searched on Mysql column types, I did not find any obviously
> suitable for images. I do not suppose I can use VARCHAR, can I?
Use one of the BLOB types.
Note that if you are running
-Original Message-
From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 4:02 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MYSQL maximum query size?
Is there a maximum number of characters you can use in a query?
I have a giant query using the UPDATE command (updati
Thanks Todd and Tyler for the encouragement,
When I searched on Mysql column types, I did not find any obviously suitable
for images. I do not suppose I can use VARCHAR, can I?
Also, I need to have very good performance on data retrieval and transport,
which means I also need to have maximum re
> At 10:16 AM 4/5/2002, you wrote:
> >Actually, according to the objective eWeek test results at the link
> >provided in another reply, the gap between Oracle 9i and MySQL 4.x is
> >rather slim...
>
> Gregory,
> A point that was sadly missing from that article was
> what was the
> cost
Hi,
Try to use tee command to log all the output into a file. It will have the
column names and everything you see in the screen.
See:
http://www.mysql.com/doc/m/y/mysql.html
Gurhan
-Original Message-
From: colin o [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 4:14 PM
To: mysql
Hello there,
anybody here has some background using InnoDB and MySQL replication feature
? If so, would you mind sharing those information with me ?
--
João Paulo Vasconcellos
Gerente de Tecnologia - NetCard
Tel. 3852-9008 Ramal 31
[EMAIL PROTECTED]
> Adriano Manocchia wrote:
> Well, first off, I can't seem to get max_allowed_packet higher than 64
> MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are
> reflected in the system settings, but only up to 64 MB, then regardless
> of what I put in there, it stays at 64 MB. Bu
Lenny,
You might find it easier to use a GUI like MySQL Front from
http://www.anse.de/mysqlfront/. It will save you a great deal of time. Just
enter (or copy and paste) the SQL into their query window and press a
button. Editing your errors are also a lot easier. It is free or you can
At 10:16 AM 4/5/2002, you wrote:
>Actually, according to the objective eWeek test results at the link
>provided in another reply, the gap between Oracle 9i and MySQL 4.x is
>rather slim...
Gregory,
A point that was sadly missing from that article was what was the
cost to create the Orac
At 01:54 PM 4/5/2002, you wrote:
>I have seen many people saying that InnoDB is a great deal, that InnoDB
>rocks, etc. and I am concerced about how much better InnoDB is compared to
>MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB
>have foreign keys support, but I deal
Hi,
Is it possible to print a table from the database in
the same format as you can see it. I tried to export a
table to an outfile, but i dont get the column names.
I am using Linux so i don't have a print screen
option,
I think you can do using a software package called
EMS MySQL Manager, but
(and I say again...)
> -Original Message-
> From: de Chateau Thierry Axel [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 05, 2002 1:15 PM
> To: Gregory Junker; [EMAIL PROTECTED]
> Subject: RE: Insert ?'s
>
>
> do not send me mail
>
> I am not your friend.
>
> Thank you
>
> --- G
Is there any sort of mysql load monitoring tools out there? If not how
can I get how many query's per/sec, users, etc, which I can log to a
flat file or db, and I could run rrdtool against it to get graphs?
-Jason
-
Before pos
Hi,
Victoria Reznichenko wrote:
VR> Martin,
VR> Wednesday, April 03, 2002, 5:45:00 PM, you wrote:
VR>
VR> MM> would anyone please explain me what are these error messages?
VR>
VR> MM> 020327 12:29:26 mysqld started
VR> MM> 020327 12:29:26 Warning: listen() on TCP/IP failed with error 98
V
(and I say again...)
um, I don't know you, I have no idea why you would take such an
attitude, and if you'll look closely, as a rule I send email to the
list, not to individuals. If you don't want emails from me filter me out
or unsubscribe from the list.
> -Original Message-
> From: de
> The table has
> mysql> select count(*) from repository;
>+--+
>| count(*) |
>+--+
>| 5673838 |
>+--+
>records inside.
>
> 1. I get table a "table crashed" whenever I try to fix it or check it with MYISAMCHK
> using -r, -o or -f parameters. And t
[EMAIL PROTECTED] wrote:
>
> Here is a FABRICATED table I have TYPED OUT to demonstrate the information
> that I'm looking for.
> I'm looking for a single query that can produce:
>
> +--+--++---+
> | clientid | revision | name
Hi, all:
I am trying to use JDBC to connect MySQL, and use JDBC
to config the MySQL. As default root@default has the
privilege to do everything. So I use JDBC to connect
with "root". I got error. "[EMAIL PROTECTED]"
failed.
I read a note said that this only happen to Redhat.
Any suggestion how t
here's the scoop:
Basically I'm listing pieces of information from a two-key table and I am
not getting the information I want.
BACKGROUND
Consider this sample table (which although goofy, does illustrate what I'm
attempting to do)
SELECT clientid, revision, name, address FROM clients;
+--
Hi,
Does InnoDB use some form of "group commit" like BerkeleyDB and Postgresql?
In Postgresql you can specify a "COMMIT_DELAY" to force a wait before the
commit returns. Disk IO to the log files can be reduced quite alot if you
tweak this setting, and it can be very useful when tuning batch-like
Hi,
actually I know about current problem in 3.23.49a on linux at least -
there's something weird with the cache I think. I've posted some reports
with my ideas to the bugs list already. For you:
I can get rid of such problems whenever they appear by doing :
mysqladmin flush-tables
They disappe
I have seen many people saying that InnoDB is a great deal, that InnoDB
rocks, etc. and I am concerced about how much better InnoDB is compared to
MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB
have foreign keys support, but I deal very well without then since now.
Can you please tell me, is it possible to do queries that join MySql tables
that are in different databases?
I have a couple of Delphi database programs that use Paradox tables. I'd
like to move them over to something else that is faster. These programs are
set up so that they have a shared dat
How can I download this version?
Regards
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 4:07 PM
Subject: Re: InnoDB
> Hi!
>
> - Original Message -
> From: ""Rodrigo Gonzalez"" <[EMAIL PROTECTED]>
> Newsgroups:
Hi!
- Original Message -
From: ""Rodrigo Gonzalez"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, April 05, 2002 8:59 PM
Subject: InnoDB
> First of all excuse my english...I hope someone can understand me
>
> I am thinking in converting from MyIsam to InnoDb t
Hi!
- Original Message -
From: ""Murphy, Land"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, April 05, 2002 5:52 PM
Subject: MySQL for Datawarehousing Experience
> Esteemed listers,
> I am currently researching the feasibility of using MySQL to replace our
> curr
Steve,
> With InnoDB, I'm sure this problem goes away, but as soon as we
> go to InnoDB, we have to pay for backups and support,
> which means we start looking around at 'pay' solutions.
I must correct that MySQL technical support is not free, whether you use
InnoDB or not. Note also that mysqld
Hi!
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, April 05, 2002 8:51 PM
Subject: MySQL Book
> We are writing a book about MySQL. There will be emphasis on using MySQL
with perl/php, .net & java. The publisher needs lots of emphasis on S
um, I don't know you, I have no idea why you would take such an
attitude, and if you'll look closely, as a rule I send email to the
list, not to individuals. If you don't want emails from me filter me out
or unsubscribe from the list.
> -Original Message-
> From: de Chateau Thierry Axel
6:35 a.m.
(writing this on the web)MYSQL :-)
Hi - in my first PHP file, :-
- earlier this week, Ive posted a few messages about my PHP webpage which Roger
Baklund was able to help me start off..
Anyway, - Ive been to some MySql Help sites & found some useful commands, which
ive been able to
I agree with Chris...
Writing a book on features that do not exist yet is asking for trouble.
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:00 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MySQL Book
On Friday 05 A
I am using MySQL Manager to manage a database created with the tool a week or so ago.
Worked on the database last night and all was fine. Opened up mySQL Manager today and
any change to the tables (add or edit of columns) gives the error below:
Error on rename of:
'.\\.MYI' to '.\\#SQL2-a60-4f.
why do you have to pay? I was under the impression
innodb was free as well...
-Original Message-
From: Steve Rapaport [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2002 08:33
To: [EMAIL PROTECTED]
Subject: Re: MySQL Power ?
I'm currently running MySQL for a big, fast app without
problems.
do not send me mail
I am not your friend.
Thank you
--- Gregory Junker <[EMAIL PROTECTED]> a
écrit : > no, you need to follow the list rules when
posting.
> That's why you see a
> lot of posts that have a line at the end that just
> says
>
> mysql,sql,query
>
> or something similar.
>
>
>
Do not send me any more mail , please.
--- Paul DuBois <[EMAIL PROTECTED]> a écrit : > At 11:17
-0600 4/5/02, Henning, Brian wrote:
> >Hello-
> >Is there a console app that exists for windows 2000
> pro such that i can
> >access mysql server(at home on windows 2000 pro
> machine) with it from wo
Hi,
> 5:40 a.m.
>
> MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
MYSQL SQL
> MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
MYSQL SQL
>
> (is that enough, to get past the filter ?)
> (sent this via the website, & got a reply re the filter...)
>
Pe
Hi Gordon,
Update your settings in Eudora. You are probably currently sent a text
attachment of every email you sent out. This could occur if you have "send
both plain & styled" option checked.
By the way, there is no reason to insult the people who have created and/or
have followed this list my s
Then you need to fix your messages so that it will pass thru the filter.
That statement is wrong because INSERT INTO statement inserts a new record
to the table so you can't have a where restriction. If you wanna change the
logo value where seller_ID=1 then use UPDATE TABLE syntax. See:
http://w
On Friday 05 April 2002 10:29 am, [EMAIL PROTECTED] wrote:
> We are writing a book about MySQL. There will be emphasis on using MySQL
> with perl/php, .net & java. The publisher needs lots of emphasis on SPs and
> nested subqueries. We need to be able to write about implementing biz rules
> using
no, you need to follow the list rules when posting. That's why you see a
lot of posts that have a line at the end that just says
mysql,sql,query
or something similar.
And to answer your question, it appears that you are actually attempting
an UPDATE, not an INSERT? i.e.
UPDATE Sellers
SET Lo
At 11:17 -0600 4/5/02, Henning, Brian wrote:
>Hello-
>Is there a console app that exists for windows 2000 pro such that i can
>access mysql server(at home on windows 2000 pro machine) with it from work?
>Can i use the one that is ported with the server? The server is not running
>on port 3306. Tha
On Friday 05 April 2002 10:16 am, john wrote:
>
> Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID =
> "1";
>
> that is the command that I am attempting to issue, but states the where...
> is wrong. What's wrong with that?
It isn't valid SQL. You are, I think, trying to
5:40 a.m.
MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
(is that enough, to get past the filter ?)
(sent this via the website, & got a reply re the filter...)
Original #2 message
No problem Paul, I understood what you meant.
Lenny Sorey
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Lenny Sorey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 11:17 AM
Subject: Re: Command Line Tool
> At 10:43 -0600 4/5/02, Paul DuBois wr
We are writing a book about MySQL. There will be emphasis on using MySQL with
perl/php, .net & java. The publisher needs lots of emphasis on SPs and nested
subqueries. We need to be able to write about implementing biz rules using table
constraints, which means FKs. Your site says 4.1 is to hav
then you need to fix your filters
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:55 AM
To: john
Subject: Re: Insert ?'s
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
Hello-
Is there a console app that exists for windows 2000 pro such that i can
access mysql server(at home on windows 2000 pro machine) with it from work?
Can i use the one that is ported with the server? The server is not running
on port 3306. Thanks for the help.
Brian
-
> in perl: [very simple code]
>
> my $stime = time;
>
> prepare();
> execute();
> fetchall_array_ref();
>
> my $etime = time;
>
> my $ftime = $etime - $stime;
>
> print "Your query took $ftime seconds\n";
>
> stupid filter: sql, query, mysql, db, table, select, insert, update,
delete,
> join, crea
At 10:43 -0600 4/5/02, Paul DuBois wrote:
>At 10:29 -0600 4/5/02, Lenny Sorey wrote:
>>I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt
>>binary version
>>
>>to accept The Command - Line Tool to run a script to create a table.
>>
>>My operating system is Windows 2000 Pr
Hey guys,
We're having a weird authentication problem. We have a .jsp (on box1) that tries to
connect to a MySQL database (on box2). The privileges have been set to give insert,
update, delete to the user.
GRANT select, insert, update
on d_name.*
to d_user IDENTIFIED by "d_user";
It works fi
I've been having an off-list discussion with gordon52 at slingshot dot co
dot nz, who is having a problem
posting anything to the list. Apparently when he sends something, the list
manager thinks it's
got attachments and bounces it. Now when he sends me a message - no
attachments.
Can any
Agreed. As soon as subselects and the Stored Procedure support is
complete I can almost ditch MSSQL entirely...
> BUT: the sql-set is too limited for most of the real use cases
> out there. just think of the missing sub-selects or
> multitable-updates/deletes or stored procedures. i worked with
According to the manual, the DATETIME field can be stored "As a string with
no delimiters in either 'MMDDHHMMSS' or 'YYMMDDHHMMSS' format, provided
that the string makes sense as a date." So this should provide you with the
format you require.
TIMESTAMP was created so that we would NOT have
Yes I did, but it is very long, and it was very long ago.
Could someone please explain to me why this was done? It seems more
confusing to do this than to not do this. Why when you can just say "SET
field=NOW()" in the update statement would anyone build this auto update of
timestamps in? (the ki
First of all excuse my english...I hope someone can understand me
I am thinking in converting from MyIsam to InnoDb tables.
I have this table:
> du -sm table*
323 table.MYD
276 table.MYI
0 table.frm
How much tablespace I need to convert it to InnoDb, I found that I need a
lot
Hi,
> I have a table whose schema contains:
> id INTEGER AUTO_INCREMENT,
> gen_time TIMESTAMP,
> rec_time TIMESTAMP,
> repeats INTEGER DEFAULT 0,
> PRIMARY KEY (id),
> INDEX (rec_time))
>
> When I do an:
> UPDATE table SET repeats=repeats+1
>
> gen_time gets updated as well:
[snip]
> mysql> sel
March 26 issue of PC Mag has a comparison of database engines, including
oracle, mysql and sql server (ack).
-Original Message-
From: Steve Rapaport [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 11:33 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL Power ?
I'm currently running
At 10:29 -0600 4/5/02, Lenny Sorey wrote:
>I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt
>binary version
>
>to accept The Command - Line Tool to run a script to create a table.
>
>My operating system is Windows 2000 Professional. I can connect with
>MyODBC-3.51.02.ex
From: "Hihn Jason" <[EMAIL PROTECTED]>
> I have a table whose schema contains:
> id INTEGER AUTO_INCREMENT,
> gen_time TIMESTAMP,
> rec_time TIMESTAMP,
> repeats INTEGER DEFAULT 0,
> PRIMARY KEY (id),
> INDEX (rec_time))
>
> When I do an:
> UPDATE table SET repeats=repeats+1
>
> gen_time gets upd
At 18:33 +0200 4/5/02, Hihn Jason wrote:
>I have a table whose schema contains:
>id INTEGER AUTO_INCREMENT,
>gen_time TIMESTAMP,
>rec_time TIMESTAMP,
>repeats INTEGER DEFAULT 0,
>PRIMARY KEY (id),
>INDEX (rec_time))
>
>When I do an:
>UPDATE table SET repeats=repeats+1
>
>gen_time gets updated as w
No, this is NOT a bug.
According to the manual (you read it, right?), TIMESTAMP is created so that
when a record is UPDATEd or INSERTed, the time of the change is entered into
the record. If you want a date that does not changem use the DATE fiel
-Original Message-
From: Hihn Jason [mai
just wanted to add another category of comparison:
mysql is fast, reliable and scalable. that's a fact! we don't
need to discuss this anymore.
BUT: the sql-set is too limited for most of the real use cases
out there. just think of the missing sub-selects or
multitable-updates/deletes or stored pr
At 21:45 -0800 4/4/02, Cliff wrote:
>Short and simple, is it possible to escape by two different parameters? This
>used to work:
I think you are mistaken. I just checked the grammar files for 90
versions of MySQL, and that syntax isn't legal in any of them.
I don't see how it could be legal, ei
I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt
binary version
to accept The Command - Line Tool to run a script to create a table.
My operating system is Windows 2000 Professional. I can connect with
MyODBC-3.51.02.exe without any problem and run successful queries.
I'm currently running MySQL for a big, fast app without
problems. BUT:
I'm in the middle of specifying a new application with a high
load, and I'm consideing looking for alternatives to MySQL
because without InnoDB, it gets really slow on tables
with frequent updates and reads (no row locking).
I have a table whose schema contains:
id INTEGER AUTO_INCREMENT,
gen_time TIMESTAMP,
rec_time TIMESTAMP,
repeats INTEGER DEFAULT 0,
PRIMARY KEY (id),
INDEX (rec_time))
When I do an:
UPDATE table SET repeats=repeats+1
gen_time gets updated as well:
mysql> select id, gen_time, rec_time, repea
For what a newbies opinion may matter,
I breifly worked with Oracle, and am working with MySQL. Fact, as it may
be, I will never look for or take a job where they are using the P.O.S.
Oracle. Oracle is not stable enough, it bombs if you make one misleading
query. MySQL just says "eh, try again
Actually, according to the objective eWeek test results at the link
provided in another reply, the gap between Oracle 9i and MySQL 4.x is
rather slim...
> I will look forward to hearing the response of the
> well-informed to this.
>
> However, my impression is that while the answer, for the ver
Since you are writing out the file, you must select which character to
ESCAPE with. How would you expect mysql to choose?
-Original Message-
From: Cliff [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 11:46 PM
To: [EMAIL PROTECTED]
Subject: Escaped by 2 things?
Short and simp
Thanks to all the reponders. Just what I needed!
sql, query = filter pass
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request th
> I don't mean to start an opinion war, but ...
>
> Can MySQL handle many processors, many servers (clustering), load
> ballancing, etc as well as Oracle. Or should one use Oracle (some other
> database) for large volume high response requirements. Is mySQL too
basic
> for these capabilities?
>
1 - 100 of 129 matches
Mail list logo
