The replay on the webpage says that:
"Nope. That would be a really slow search since mysql cant use any indexes
and a table
scan would be the only way to find it."
Then even "LIKE" operator should suffer from the same performance drawback,
how does LIKE operator work with indexes?
Shamit Verma,
Jeff,
> I'm wondering if its somehow possible to create a pk/fk constraint for
> the table below
> create table Example (
> id int not null auto_increment primary key,
> table_name enum('TabA','TabB') not null,
> table_id int not null
> ) type = InnoDB;
> if table_name is
Ruben,
> I has a column defined as
> enum not null (percent,absolute) default value percent (in psuedocode)
> and I was able to update a record which filled it either with a NULL or
> an empty string.
> How does this happen? the value should be either percent or absolute,
> or the updat
Todd,
> At startup, the computer says something about starting a MySQL server.
> Could it be that the startup item is still trying to start mysqld even
> though it no longer exists and in the process is tying up port 3306?
Comparing it to Windows (I've not enough money to run an Apple ;-) you
s
Eric,
> I have a query which I did several months ago, it recently caught my
> attention since it seems to be very slow when done a lot of times, which
> causes a very loaded server.
> The query I used looks like this:
> SELECT files.file_id, filename FROM access, files WHERE
> directory_id="0
Hi,
If you desperately need Views/Triggers/Stored procedures. Then there is way
to use some of them on MySQL if:
1. You can use Windows/MAC in your project (at least for the clients).
2. Amount of Data is not extremely large.
I have not tested this solution thoroughly, but it worked for me in one
Another problem with load data and replication? I've identified 2 confirmed
bugs in the last 2 releases. Honestly, I've pretty much given up on using
load data on my master server for the time being. I'm now using scripts that
generate extended insert statements instead.
--jeff
- Original Mes
On Tue, 1 Apr 2003 20:30:32 -0800 (PST), Jinesh Varia used a few
recycled electrons to form:
| Hello group,
|
| I have a simple composite key
| create table a_b (aID int NOT NULL, bID int NOT NULL, primary key
| (aID,bID));
|
| Where aID is primary key in the table a and bID is the primary key in
Ive seen plenty examples in books but are there any
working MySQL examples someone can use immediately..Anything anywhere?
Thank You,
Martin
- Original Message -
From: "Marko Hrastovec" <[EMAIL PROTECTED]>
To: "'gerald_clark'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, April
That was my first thought too. Shouldn't then MySQL also report nonexisting
databases? When I run client "mysql database_name" it runs only on existing
databases. When I write wrong database name it won't run, so it look in the
right directory. If the database directory was wrong it shouldn't work
On 01-Apr-2003 Hutterer wrote:
> DO not know what I have changed, but afte mmonths of using mysql without
> problems -
> NOW I get ERROR 28 ( (errno: 28) and cannot create new databases.
>
> Does anybody know how to fix this
> Thanks Robert
>
>
localhost.dread$ perror 28
Error code 28:
Hello group,
I have a simple composite key
create table a_b (aID int NOT NULL, bID int NOT NULL, primary key
(aID,bID));
Where aID is primary key in the table a and bID is the primary key in table b,
While my primary keys are automatically indexed, I am having problems when I use the
bID.
I re
mysql> use mysql;
mysql> update user set grant_priv = 'Y' where user = 'root';
mysql> flush privileges
and reconnect to mysql server as root user and
retry grant clause. You'll be happy!!! ^^
> Greetings,
>
> I'm trying to create a database and then adding a
> specialized user so it can work wit
On Tue, 1 Apr 2003 13:15:00 -0800, Jeremy Zawodny used a few
recycled electrons to form:
| On Tue, Apr 01, 2003 at 01:04:59PM -0800, Steven Nakhla wrote:
| >
| > Are there currently any open-source mail servers that utilize MySQL?
|
| Yes, many.
|
| > I know that there are some that will authenti
If you use PHP
program like below...
It's simple
OK ?
if you use other programming language, It's similar to above example.
Sorry, My english is so poor -_-;;
> Is it possible to rename a MySQL table? If so, how?
> If not, is there a simple query syntax to copy a table?
> I don't have access
In desperation I have restarted my machine a couple of times, and once
I actually watched the start-up routine...this gave me a clue:
In accord with the installation instructions, I used Marc Liyanages'
startup item installer. Since then, I have removed the every vestige of
my MySQL installation
Is it possible to rename a MySQL table? If so, how?
If not, is there a simple query syntax to copy a table?
I don't have access to the command-line version,
just a web interface, and no, not anything nice like PhpMyAdmin! :-(
--
Mark Wilson, Computer Programming Unlimited (cpuworks.com)
Web : h
Greetings,
I'm trying to create a database and then adding a
specialized user so it can work with it, but so far i
got no luck:
[EMAIL PROTECTED] josevnz]$ mysql -u root -p -h
localhost.localdomain
Enter password:
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id
Ed,
1: It depends on your hardware. I don't think MySQL imposes a restriction.
2: It doesn't work that way. It's not like VFP or Access where you 'edit' a
record. You can SELECT the contents of a record, you can manipulate them and
then you can UPDATE that record (assuming you have a primary key
The key to Pandoras Box is available to those who wrote the encryption
algorithm
Triple DES anyone?
-Martin
- Original Message -
From: "Doug Thompson" <[EMAIL PROTECTED]>
To: "Martin Gainty" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 8:06 PM
Subject: Re: Passwords
RENAME TABLE tbl_name TO new_tbl_name[, tbl_name2 TO new_tbl_name2,...]
you can find it from MYSQL MANUAL section RENAME TABLE SYNTAX
> (I tried to post this once, but it didn't show up - sorry if
> this is a duplicate!)
> Can you rename a table? If so, how?
> If not, is there an easy query to ru
It is all disinformation to confuse Micro$oft. 8-)
On Mon, 31 Mar 2003 09:45:09 -0700, Martin Gainty wrote:
>Michael et al-
>I am trying to locate ONE working MySQL example for windows. Is this a myth
>or is there WORKING source example out there somewhere?
>Thanks,
>Martin
>- Original Mes
You can rename a table by using the alter syntax
http://www.mysql.com/doc/en/ALTER_TABLE.html
ALTER TABLE tbl_name RENAME [TO] new_tbl_name
> -Original Message-
> From: Mark Wilson [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2003 4:41 PM
> To: Mysql Mailing List
> Subject: Rename/C
Jeremy,
I appreciate your candid view of the situation. No,
you don't need Oracle, but you do need PF-Merge to
fully exploit MySQL into a cosmic-class database.
Tom
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> On Wed, Mar 26, 2003 at 03:51:09PM -0800, thomas
> getty wrote:
> > ==
Hi,
I have a query which I did several months ago, it recently caught my
attention since it seems to be very slow when done a lot of times, which
causes a very loaded server.
Its a webbased filesystem, which stores access/file information in
mysql, the actual files are stored on disk. The prob
(I tried to post this once, but it didn't show up - sorry if
this is a duplicate!)
Can you rename a table? If so, how?
If not, is there an easy query to run to copy a table?
(Preserving the data as well as the structure, of course.)
Couldn't find it in my MySQL on-line manual...
--
Mark Wilson, C
Is this a bug or just not implemented in 3.23.56-Max?
mysql> SELECT alarm_notes, DATE_FORMAT(alarm_date,'%m/%d/%y %h:%i %p') AS
alarm_date_format, IFNULL(CONCAT(contact_fname, ' ', alarm_date),
alarm_date_format) AS contact_name, contact_email, contact_phone FROM
alarm_table LEFT JOIN contact_tabl
Jennifer Goodie wrote:
Why the join? Why not just "select p1.email, count(*) as occurances from
table p1 group by p1.email having occurances > 1"? Am I missing something?
Possibly. It depends on whether the OP wanted to see which rows had
duplicates, or to actually *see* the duplicates, in whi
In message <[EMAIL PROTECTED]>,
Andrew Braithwaite <[EMAIL PROTECTED]> writes
Hi,
What are the sizes of your index files? (i.e. name_index2.MYI in the
datadir).
It's a complete guess but with a large table like that, it's possible that
you're reaching some kind of limit with your os/mysql setup d
Peter,
>1. If a column is a primary key, there is no need to declare it a
unique.
Thank you, I was doing that for every table since I started.
>2. Without foreign keys, your CREATE statements don't reveal table
relationships.
I am surprised, I thought my SQL is not a proper relationnal database
a
How many people can be accessing the same mysql database at the same time?
Can several people work on the same record at the same time?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Privilege changes (at least on Windows) don't seem to take effect until
either (a) the server is restarted, or (b) the server is instructed to
re-read its permissions tables.
The best solution I've found is to include the line "flush privileges" into
Mysql sessions that manipulate users or permiss
Andy Eastham wrote:
> Make sure you don't enter a space between -u and the username
> and -p and the password ie mysql -uuser -ppassword
Actually, that works for me, i.e.
C:\Program Files\mysql40\bin>mysql -u root -p
Enter password: *
Welcome to the MySQL monitor. Commands end with ; or
---
** ORIGINAL MESSAGE FROM:Jeff Kilpatrick <[EMAIL PROTECTED]>**
** ORIGINAL MESSAGE SENT:Tue Apr 01 14:38:21 **
** ORIGINAL MESSAGE BELOW **
---
>On Wed 1969-12-31 at 17:59 mazur wrote:
>
Question answered.
Thanks to all who responded.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Why the join? Why not just "select p1.email, count(*) as occurances from
table p1 group by p1.email having occurances > 1"? Am I missing something?
> -Original Message-
> From: Andy Eastham [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 01, 2003 12:29 PM
> To: [EMAIL PROTECTED] Mysql.
This is not flamebait. I'm not trying to be disagreeable or a jerk.
Just a thought.
What about IMAP?
-jeff
On Wed, 1969-12-31 at 17:59, mazur wrote:
> ---
> ** ORIGINAL MESSAGE FROM:Jeremy Zawodny <[EMAIL PROTECTED]>**
> ** ORIGINAL MESSAGE SENT:Tue Apr 0
To find duplicates, use something like:
SELECT address, count(*)
>From Customer
GROUP BY address
HAVING count(*) > 1;
-Original Message-
From: Bob Sawyer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 12:04 PM
To: MySQL List
Subject: Opposite of DISTINCT()
I know that using SE
---
** ORIGINAL MESSAGE FROM:Jeremy Zawodny <[EMAIL PROTECTED]>**
** ORIGINAL MESSAGE SENT:Tue Apr 01 13:15:00 **
** ORIGINAL MESSAGE BELOW **
---
>>re: On Tue Apr 01 2003 at 01:04:59PM -0800 Steven Nakhla wrote:
>>
>>
Take a look at dbmail.
http://www.dbmail.org
-- Jason
On 4/1/03 4:04 PM, "Steven Nakhla" <[EMAIL PROTECTED]> wrote:
> Are there currently any open-source mail servers that
> utilize MySQL? I know that there are some that will
> authenticate against accounts stored in a MySQL
> database, bu
On Tue, Apr 01, 2003 at 01:17:45PM -0800, Steven Nakhla wrote:
>
> Why? Well, we have our reasons.
I'm sure you do. But I'm curious to know them... unless they're
secret, of course. :-)
> Particularly because we want an efficient way to handle millions of
> messages, plus the ability to search/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Eldon, et al --
...and then Michael Shulman said...
%
% Or, you can use the alternate, more legible syntax:
%
% mysql --user=username --password=pass
Or, better yet, you can use
mysql -uusername -p [database]
or
mysql -user=username -p [dat
Elby Vaz schrieb:
hello,
i installed MySQL (server, max and client) for linux but i`m needing of
`mysql.sock` file.
some body has?
obs.: what path stays the `my.cnf` file? how do i do to configure it?
eg. rhl8.0
$ rpm -q mysql-server
mysql-server-3.23.54a-4
$ ll /etc/my.cnf;cat /etc/my.cnf
-rw
Eric Persson wrote:
CREATE TABLE access (
class_id int(10) unsigned NOT NULL default '0',
group_id int(10) unsigned NOT NULL default '0',
class_tbl char(10) NOT NULL default '',
conn_id int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;
CREATE TABLE files (
file_id int(10) unsigned NO
Bob,
You have to do a self join - try this off the top of my head... -
Select p1.email
FROM tblperson p1, tblperson p2
WHERE p1.email = p2.email
GROUP BY p1.email
HAVING count(p1.email) > 1
Andy
> -Original Message-
> From: Bob Sawyer [mailto:[EMAIL PROTECTED]
> Sent: 01 April 2003 21:0
Well
To do selects on your mail archive?
BTW - I've heard that Linux Magazine has developed into a handsom
rag. Congradulations. I would never had thought it after seeing the
first issue.
Ruben
On Tue, Apr 01, 2003 at 01:15:00PM -0800, Jeremy Zawodny wrote:
> On Tue, Apr 01, 2003 at 01:04:59
I has a column defined as
enum not null (percent,absolute) default value percent (in psuedocode)
and I was able to update a record which filled it either with a NULL or
an empty string.
How does this happen? the value should be either percent or absolute,
or the update should just fail.
I'm a little concerned by the possibilty of a malformed query
accidentally destroying a whole databse. For example, a badly
constructed boolean, intended to select exactly one row, but which
actually modifies all rows.
update mytables set data='who' where row='1234';
(updates 1 row)
verses
Add your database directory to your my.cnf file.
They were possibly compiled with diferent default
database locations.
[EMAIL PROTECTED] wrote:
Description:
I have upgraded from 3.23.5x versions to 4.0.12 on Linux Redhat
operating system. On 3 machines I only upgraded the RPMs
Why don't you try it yourself.
You could have tried it in less time than it took to mail the question.
The manual works too.
I'm not going to answer because you need to learn how to learn.
Noel Wade wrote:
I know its possible to use multiple fields for the primary key in a table
i.e. "primary ke
Why? Well, we have our reasons. Particularly because
we want an efficient way to handle millions of
messages, plus the ability to search/manipulate/data
mine through them using specific applications.
SN
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> On Tue, Apr 01, 2003 at 01:04:59PM -0800, S
Greetings.
I'm using mysql 3.23.54-Max with MyISAM tables on Linux 2.4.9-34 (RedHat
7.2). We've got about 20 users and a myriad of automated scripts (Perl
DBI, Java JDBC) connecting to the database on a regular basis.
Twice now, we've had problems with too many connections (max connections
is cu
I am now pretty sure that I have got my previous problem licked. I am
posting the following additional information to the list in order to help
others in the future who have the same problem and come across this thread
in the list archives.
Here's a really interesting experiment I just did. I
On Tue, Apr 01, 2003 at 01:04:59PM -0800, Steven Nakhla wrote:
>
> Are there currently any open-source mail servers that utilize MySQL?
Yes, many.
> I know that there are some that will authenticate against accounts
> stored in a MySQL database, but I am looking for a mail server that
> actually
Or, you can use the alternate, more legible syntax:
mysql --user=username --password=pass
-ms
-Original Message-
From: Andy Eastham [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 10:36 AM
To: [EMAIL PROTECTED] Mysql. Com
Subject: RE: password not working from command line
Eldo
Are there currently any open-source mail servers that
utilize MySQL? I know that there are some that will
authenticate against accounts stored in a MySQL
database, but I am looking for a mail server that
actually stores the messages in the database.
Ideally, I'd like to be able to setup an IMAP
Hi there,
I'm running MySQL-server-4.0.10-0.i386 on a Linux Box (SuSE 8.1) and all
tables are MyISM. Today a made strange observation. All update
statements on one table where completely "ignored" by the server. There
was no error message - just a "0 rows affected". After restart of mysqld
everyti
hello,
i installed MySQL (server, max and client) for linux but i`m needing of
`mysql.sock` file.
some body has?
obs.: what path stays the `my.cnf` file? how do i do to configure it?
thanks,
Elby.
_
MSN Hotmail, o maior webmail
Answered my own question. For posterity:
"alter table abc add unique(foo, bar);"
And the index will be created using the name of the first column you
specify. Works like a charm!
--Noel
- Original Message -
From: "Noel Wade" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, A
I use MDK 9.0 and use MySQL installed with RPM Package
How can i change or set new charset on mysql .
Caz , i want to use tis620 charset ..
I live in thailand and must use charset that i can sort my data correctly on my MySQL
... sir
Thank u for advance sir .
[EMAIL PROTECTED]
" Ever
hello all,
I'm wondering if its somehow possible to create a pk/fk constraint for
the table below
create table Example (
id int not null auto_increment primary key,
table_name enum('TabA','TabB') not null,
table_id int not null
) type = InnoDB;
if table_name is 'TabA', th
SELECT col1
FROM table1
GROUP by col1
HAVING count(col1) > 1
-ms
-Original Message-
From: Bob Sawyer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 12:04 PM
To: MySQL List
Subject: Opposite of DISTINCT()
I know that using SELECT DISTINCT(colname) will result in output that do
Hi.
On Mon 2003-03-31 at 21:20:25 +0100, [EMAIL PROTECTED] wrote:
> Sorry everybody. I assumed that as it had been out for a long time (2
> years?) it was stable.
It's been 1 1/2 years (Oct 2001). But that was an alpha release. The
open development model of MySQL screws numbers a bit. The first
I know that using SELECT DISTINCT(colname) will result in output that does
not contain any duplicates from that column. But how would I output JUST the
duplicates? If I have as part of a table a column containing email
addresses, and I want to list just the duplicate addresses rather than the
disti
Hi -
I would like to access a mysql database server from a NUMA-Q Sequent platform running
Dynix/ptx v4.5.2. Does any of mysql's connectivity products (Connector/ODBC,
Connector/C++) run under this platform/OS? Also, is there a C (not C++) API available?
Tom Klepetka
Senior Software Engineer
Hi Don,
Thanks again so much for your help. Here is where things stand right
now. I tried a lot of different things today, mostly to no avail, and then
stumbled on an old MySQL mailing list message that suggested this problem
might be related the OS limit on the number of processes a single u
Perhaps it's this...
C:\>perror 28
Error code 28: No space left on device
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeremy, et al --
...and then Jeremy Zawodny said...
%
% On Mon, Mar 31, 2003 at 11:37:47AM -0800, Seth Brundle wrote:
% > First people, please dont get all angry about my suggestion...please hear me
% > out...
I admit that I was one of those to bris
DO not know what I have changed, but afte mmonths of using mysql without
problems -
NOW I get ERROR 28 ( (errno: 28) and cannot create new databases.
Does anybody know how to fix this
Thanks Robert
> From: "Arthur Lessard" <[EMAIL PROTECTED]>
>
> > Thanks, Juan, and Patrik as well, this helped
> > immensely. I can get postfix working, and it seems to
> > read the mysql tables on startup, which it wouldn't do
> > before.
great :)
> > However, I still have one bad problem - it
> > won't
I am running MySQL on both NT4 and Win2K servers across a 64k WAN with over
600 users at 60 geographical sites - It rocks !!!
Jeff
- Original Message -
From: "Bernhard Döbler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 01, 2003 7:34 PM
Subject: Re: mySQL on Windows 2
Sorry for my mails, but i'm blocked with my work from several days.
Last info about my problem.
The webserver.bin is not updated after insert operation in db. I've
found a Delayed_insert...
If i do on the master
>SHOW PROCESSLIST;
++--+-+--+-
Eldon,
Make sure you don't enter a space between -u and the username and -p and the
password
ie mysql -uuser -ppassword
Andy
> -Original Message-
> From: Eldon Ziegler [mailto:[EMAIL PROTECTED]
> Sent: 01 April 2003 16:15
> To: [EMAIL PROTECTED]
> Subject: password not working from comm
Thanks, Juan, and Patrik as well, this helped
immensely. I can get postfix working, and it seems to
read the mysql tables on startup, which it wouldn't do
before. However, I still have one bad problem - it
won't accept mail. Specifically, when I telnet to
port 25, postfix looks OK, but if I send
Hi,
What are the sizes of your index files? (i.e. name_index2.MYI in the
datadir).
It's a complete guess but with a large table like that, it's possible that
you're reaching some kind of limit with your os/mysql setup due to file
size. (greater than 4 GB would be my guess)
Cheers,
Andrew
On Tuesday 01 April 2003 08:57, Noel Wade wrote:
> Say I have a table with an auto_increment field that is being used at the
> primary key.
>
> When I insert a new record, is there any way to easily grab the primary key
> value for that new record? I had another unique field that I was
> original
On Tuesday 01 April 2003 12:31, trashMan wrote:
> I've found the error, but now i must solve it!
> The master, when i execute an insert operation in db, don't update the
> 'webserver-bin.010'.
> If i do
>
> >SHOW MASTER STATUS;
>
> The pos is the same as before and webserver-bin.010 is not updated
On Tuesday 01 April 2003 09:04, Noel Wade wrote:
> I know its possible to use multiple fields for the primary key in a table
> i.e. "primary key(foo,bar)"
>
> Is it possible to do this with "unique" identifiers as well? Like "unique
> key(foo,bar)" ??
>
> I already have a primary key on a table,
On Tuesday 01 April 2003 08:37, hemanth wrote:
>Can any body tell me the various reasons why the MySQL replication
>stops?
Because something is going wrong ;)
Check error logs, you can find causes there.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
On Tuesday 01 April 2003 10:55, Martin Hudec wrote:
> can anyone tell me, please, what kind of format is Time in PROCESSLIST?
In seconds.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___
Hi,
I would add some indicies to the two tables.
Looking at the below I waould add an index on the following fields:
files.directory_id
files.lang_id
files.class_tbl
access.conn_id
access.group_id
access.class_id
You can do this easily with the "alter table add index..." syntax
easily.
It
Hi, I've been bashing my brains out for a day or two on this, so I'd
appreciate some pointers.
When altering a table to add indexes I get a message like :
error 1034: 126 at record pos 957847618
mysql -V tells me:
mysql Ver 11.18 Distrib 3.23.51, for unknown-freebsdelf4.6.2 (i386)
myisamchk -d
Hi all,
I've seen a strange replication problem with MySQL v4.0.12.
Steps to duplicate...
I have a table 'andrew'..
mysql> desc andrew;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---
As John said, these are supposed to be upcoming features.
Take a look at the bottom portion of this page where it says "Upcoming
Features".
http://www.mysql.com/products/mysql/index.html
The MySQL User's Conference next week is supposed to have a spot on
the future feature of Stored Procedures t
On Tue, Apr 01, 2003 at 11:07:30AM +0530, hemanth wrote:
> Hi there,
>
>Can any body tell me the various reasons why the MySQL replication
>stops?
All of them? No, not off the top of my head.
If you have a question about a specific instance, I'd be glad to
help. Please post the output
The password I entered in a GRANT statement isn't being accepted from the
command line after entering mysql -u username -p and then entering the
password from the GRANT statement. Is there something else I need to do?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi,
I have a query which I did several months ago, it recently caught my
attention since it seems to be very slow when done a lot of times, which
causes a very loaded server.
Its a webbased filesystem, which stores access/file information in
mysql, the actual files are stored on disk. The problem
Hi,
PL/SQL is an Oracle proprietary language and can not be used. I know that the good
people at MySQL are planning to add a language to MySQL but I do not think that there
is a target release for this. Views, Functions and Procedures are also on the list of
things to add to MySQL but I do not
Check the manual for last_insert_id().
Noel Wade wrote:
Hi All,
Say I have a table with an auto_increment field that is being used at the primary key.
When I insert a new record, is there any way to easily grab the primary key value for that new record? I had another unique field that I was
seconds
- Original Message -
From: "Martin Hudec" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 01, 2003 3:55 PM
Subject: processlist
Hello all at mysql list,
can anyone tell me, please, what kind of format is Time in PROCESSLIST?
thanks
--
Martin Hudec
---
> -Original Message-
> From: Seth Brundle [mailto:[EMAIL PROTECTED]
> > I don't have to wait for some remote, overloaded server
> > to respond.
>
> I dont understand this one at all.
Every web forum I've used has been slow. I don't want to have to wait 10-20
seconds to pull up each me
> -Original Message-
> From: Seth Brundle [mailto:[EMAIL PROTECTED]
> This makes no sense as message I post to a Yahoo! Group get emailed to
> opt-in members and appears on the group within seconds, while
> I may not
> receive something I posted to the MySQL list for minutes or
> somet
> -Original Message-
> From: Seth Brundle [mailto:[EMAIL PROTECTED]
> I've worked with MySQL for about 7 years
> and have never
> found it convenient.
Fair enough. But I've worked with probably half a dozen web boards and have
yet to see one I liked better than an email list. All the
From: "Arthur Lessard" <[EMAIL PROTECTED]>
> This is probably a topic that has been beaten to
> death, but I need help in finding a resource for
> getting postfix to support mysql on RedHat 8.0.
You can use Simon J. Mudd's SRPMs or Tuomo Soini's ones...
Simon J. Mudd's:
http://postfix.wl0.org/e
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Helge Moulding wrote:
[snip]
|
| 10 further investigation shows that these users have all privileges
| mysql> select * from user;
|
+---+--+--+-+-+-+-+-+---+
Hi, I need desperatly some help.
I have two mashines and in ONE of them all Field Type that are "text" is
handled as Objects instead of String in my Windows 2000 server with IIS5
(ASP application) and mySQL.
I use mySQL ODBC 3.51 and mySQL server 3.23.55-nt
If I use "Response.Write(Vartype(rsSh
> TheBS>>> Do you mean the "stock" kernel branches
> TheBS>>> (2.0, 2.2, 2.4, 2.6)?
> yes, as you point
I need to enumerate the changes between all Version
Regards
Luiz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
Not only is MySQL a native Win2k app, but it also runs as a NT-Service...
Bernhard
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 28, 2003 2:34 PM
Subject: re: mySQL on Windows 2000 Server
> On Friday 28 March 2003 11:23, Neil T
Hello
I would download the original source - rpm.
Then install the rpm and switch mysql on in the spec - file
(/usr/src/redhat/SPECS/).
You can build your rpm then with rpm -bb SPEC-FILE
Patrick
Arthur Lessard wrote:
This is probably a topic that has been beaten to
death, but I need help i
I once got this answer to a similar question on another group.
http://www.mail-archive.com/[EMAIL PROTECTED]/msg00280.html
Bernhard
- Original Message -
From: "Nick Arnett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 27, 2003 8:59 PM
Subject: Fulltext search -- no
1 - 100 of 107 matches
Mail list logo
