Hi Roger,
Quick rundown.
Table:
Assignments
CaseID auto_increment
FileNumber char(18)
FirstName char(20)
LastName char(20)
and on and on and on
Indexes on
CaseID (Primary)
FileNumber
Name (LastName, FirstName)
What I would like to do is something along the lines of
SELECT CaseID
Hello all at mysql list,
can anyone tell me, please, what kind of format is Time in PROCESSLIST?
thanks
--
Martin Hudec
--
:@: [EMAIL PROTECTED]
:w: http://www.corwin.sk
:m: +421.907.303.393
In google non est, ergo non est.
- unknown IRC operator
HI there, I'm running Solaris9X86 and trying to compile version 4.0.12 from source.
I'm using the suggested flags and configure options from the reference manual.
However I'm not really sure which of the compile options I can add/remove/tinker with
as I've never really done any c programming.
Try,
insert into user ('host', 'user', 'password')
values ('localhost', 'chicken', password('soup'));
flush privileges;
the password field needs to be encrypted with the one-way password function.
rgds
- Original Message -
From: Helge Moulding [EMAIL PROTECTED]
To: [EMAIL
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.
I've tried to do the operation
SET SQL_LOG_BIN = 1
But
Hi,
have you setup a my.ini File?
mine looks like:
[mysqld]
basedir=f:/mysql
datadir=f:/mysql/data
language=f:/mysql/share/german
Bernhard
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 31, 2003 4:11 AM
Subject: Cant connect to Mysql server on
You have to compile loads of statically linked libraries before compiling and linking
the app.
Bernhard
- Original Message -
From: Martin Gainty [EMAIL PROTECTED]
To: Michael Edlund [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, March 28, 2003 12:38 AM
Subject: Re: Soon?
Hej
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
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
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
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.com/[EMAIL
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Helge Moulding wrote:
[snip]
|
| 10 further investigation shows that these users have all privileges
| mysql select * from user;
|
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/en/
-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
-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
sometimes
-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 message
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
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
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
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
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
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 of
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
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 |
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
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
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/
__ ___ ___
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.
I've
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
originally
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
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
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 command
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;
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 2000
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 accept mail.
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
-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
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]
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
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
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
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 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]
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, April
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
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
everyting
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
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
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
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.
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
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,
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
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
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)
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.
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
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:04
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
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
-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
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
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, but I am
---
** 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:
Are
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
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 01
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. Com
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]
---
** 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:
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\binmysql -u root -p
Enter password: *
Welcome to the MySQL monitor. Commands end with ; or
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
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]
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
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 due
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 which
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
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
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:
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/Copy
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 Message
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 run
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 don't
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
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
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 :
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
If you use PHP
program like below...
?
$conn = mysql_connect($host,$user,$pass)
if(!$conn) exit;
mysql_select_db($dbname);
$query = rename table old_table to new_table;
$res = mysql_query($query, $conn);
if(!$res) {
echo(Rename table failed);
exit;
}
echo(Rename table successfully !!!);
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
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 with it,
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
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: No
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
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 01, 2003
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
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
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
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 AND
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
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 update
1 - 100 of 102 matches
Mail list logo