Yuri,
- Original Message -
From: Yuri [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Saturday, August 17, 2002 1:41 AM
Subject: InnoDB on FreeBSD-Alpha problem
Anyone i running MySQL with InnoDB
on FreeBSD-Alpha?
I get the mysqld compiling/running
ok. DB dump is
when I installed mysql 3.23.43 it instructed me to be sure to add a password with the
following results-
:
seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password'
Enter password:
/usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user:
Amit,
I am trying to run the following query:-
select red,green,blue from colorchanger where
colorcode = select value from jobattributekit where
attributekit = Color and jobnumber =
28200124RB4-001 and scenario=JN75K;
It doesn't support subselects. It's having a problem with the second
Dave
[ mysql query]
when I installed mysql 3.23.43 it instructed me to be sure to add a password with
the following results-
:
seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password'
Enter password:
/usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed
hi guys,
I'm trying to generate randomly a number as the primary key the key is to
be an integer in mysql. So like auto_increment I can insert values and the
pk can be generated automatically.
could someone point me to the right direction please
thanks
Tom
[ mysql, query ]
could someone point me to the right direction please
Are you generating it in MySQL (using sql) or are you using a
programming language to do it?
DSL
-
Before posting, please check:
I wish to use mysql to do the rand id generation...
Tom
- Original Message -
From: David Lloyd [EMAIL PROTECTED]
To: Tom Gao [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, August 17, 2002 11:59 PM
Subject: Re: generating random integer id
[ mysql, query ]
could
Heikki,
I get the mysqld compiling/running
ok. DB dump is restored ok locally.
Locally everything wirks. But it
what do you mean with this? If you issue SQL statements from the same
computer, they work ok?
Exactly. If I connect via local UNIX socket all
happily works.
If I just connect
Yuri,
- Original Message -
From: Yuri [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, August 17, 2002 5:13 PM
Subject: Re: InnoDB on FreeBSD-Alpha problem
Heikki,
I get the mysqld compiling/running
ok. DB dump is restored ok locally.
Hello!
I have a problem when I trying to start mysqld (as a root, under RH 7.2).
Allegedly I don't have a rights to run this program...
What I have to do to run mysqld without rebooting system?
Best regards:
Krzychu
---
Super promocyjna oferta dla mieszkancow Krakowa
Heikki,
if you can compile with the gcc -g option and run mysqld inside gdb,
then
you probably see in what function and line it crashes.
That's what I am going to do.
If you just take a connection to mysqld, it does not execute InnoDB code
at
all.
Well I was connecting to it before ok, but
Chris,
Saturday, August 17, 2002, 2:04:40 AM, you wrote:
CK Lo everyone,
CK I've implemented replication on my MySQL Server... The master is mysql 3.23
CK (FreeBSD Ports), and my one and only slave is mysql 3.23 (Win32). I added
CK the slave so that I can have a hardcopy / backup database in
Menard,
Friday, August 16, 2002, 8:44:38 PM, you wrote:
M Me again
M I found a work around to my problem:
M select country, count(distinct client_name, client_address, etc..) clients
M from addresses group by country
M But I still don't understand why the below would not work. I downloaded the
Tac,
Saturday, August 17, 2002, 12:57:24 AM, you wrote:
T A simple query in MySQL 4 that gets a count from 3 inner joined tables:
T select count(*) as C from quotes q inner join articles a using (article_id)
T inner join media m using (media_id)
T article_id and media_id are int(11), and are
Eric,
try using the mysqlbinlog program from some other version, maybe 4.0.0, or
3.23.xx.
I noticed a similar bug a while ago. mysqlbinlog seg faulted on a binlog
file.
I am forwarding this bug report to our replication expert.
Best regards,
Heikki
...
Hi,
I deleted a db I
Thanks for your input. Especially Tod for breaking it down at the hard ware
level and making me realize what is possible.
I have re-evaluated how this is going to work. Instead of trying this with
one query, I am using 2. I forget somethimes that MySQL is better at
running simple queries
Hi!
Daniel == Daniel Kasak [EMAIL PROTECTED] writes:
cut
Daniel Would it be possible to add a 'drop table' command when a connection
Daniel which has made a temporary table has been dropped, to make the logs
Daniel match up with what actually happens? Thanks!
The later MySQL 3.23 and
Hi!
duo == duo fu [EMAIL PROTECTED] writes:
duo Hi friends:
duo I try to grant privileges to a user named 'glen' but not succeed. Here is
duo the script:
mysql select * from user where User='glen';
duo | localhost | glen |...
mysql grant all privileges on test.* to 'glen'@'localhost'
Lo Victoria
FreeBSD 4.6-STABLE (Master), MySQL 3.23.51
Windows 2000 Professional (Slave):, MySQL 3.23.49-nt
I've recompiled the master about three times now, and it still crashed.
Eventually, it came to such a extend that the moment I open port 3306 MySQL
would crash. I can just use telnet ip
mysqlÄúºÃ!
Ìì½òÊб±´óҽԺǿֱ¿Æ¼Ì³ÐÖйú´«Í³Ò½Ñ§µÄ¾«Ë裬·¢¾ò³öÁËÇ峯Ãñ¼äÌØЧÖÎÁÆÇ¿Ö±ÐÔ¼¹ÖùÑ×µÄÎâÊÏÖÐÒ½ÁÆ·¨£¬ÓÐЧÖÎÁÆÇ¿Ö±¼¹ÖùÑס£
¸ÃÁÆ·¨²ÉÓöÀÌصĽ«Ö²¡Òò×ӰγöÌåÍâµÄ·½·¨,Ó¦ÓÃÏÊÖвÝÒ©Íâ·óÖÎÁÆ£¬ÎÞÐè¿Ú·þ£¬ÎÞ¶¾¸¶×÷ÓÃ,
¸ü²»»áÉ˼°³¦Î¸, Ò»°ãÇé¿öÖ»ÐèÁ½¸öÁƳÌ15Ìì
×óÓÒ¼´¿Éʹ»¼Õß½â³ý²¡Í´¡£
Where is the Dolphin
- Original Message -
From: Colin Faber [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 7:59 PM
Subject: For all you people looking for mysql shirts ;-)
Hi guys,
Just an FYI, We've finally decided to license out our logo to
I have a table where I have specified several columns which I have specified
that NULL values are not allowed.
I have created a PHP based create / update / delete page where users can
update the table.
I have an INSERT script that takes the user input and generates the
following query
Try this instead:
INSERT INTO table SET required_field =
-Original Message-
From: Dan Tappin [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 17, 2002 12:56 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Strange PHP + MySQL add / update issue with NULL values
I have a
That is what PHP / MySQL seems to be doing to the query once it is sent.
I want to pass NULL to the column not a blank field (i.e. for text and 0
for numbers). If I do INSERT INTO table SET required_field = I get the
same results. NULL means no value at all and is a empty string which in
Hi.
I'd like to know is it safe to tune mysql-4.0.2/myisam/ft_parser.c
#define true_word_char(X) (isalnum(X) || (X)=='_')
to
#define true_word_char(X) (isgraph(X) (X)!='@')
Or is anywhere better place to redefine chars which are accepted by fulltext search ?
Regards.
--
Hi
If I do this and projectdonations is say 5
sqlst = update sfproducts set projectdonations = projectdonations + 1
WHERE prodID = ' sProdID '
projectdonations then = 6 - great
however the number I want to add is in a variable called test value and
if I do this and say testvalue is 66
sqlst = update sfproducts set projectdonations = projectdonations +
testvalue WHERE prodID = ' sProdID '
^^
$sqlst = update sfproducts set projectdonations = projectdomains + .
$testvalue . WHERE prodID = ' . $sProdID . ';
$sqlstr then looks like this:
update sfproducts set
Hello,
I am continuing to have what seems to be intermittent problems with
replication. I have attempted to exclude temporary tables from replication
by using ignore wild specifications in my.cnf on both master and slave.
For some unknown reason there are times that MySQL still tries to
Lo everyone,
I seem to be having a problem with the structuring of my query - more
specifically, with the WHERE clause...
mysql SELECT ZoneName
- FROM CompanyDNSZones
- LEFT JOIN CompanyDetails ON
CompanyDetails.CompanyID=CompanyDNSZones.CompanyID
- WHERE
EEK
Tables structures :P
mysql describe CompanyDetails;
+---+---+--+-+-+
+
| Field | Type | Null | Key | Default |
Extra |
Just created a table with a column named client_nr that is a foreign key
referencing to my Clients table:
CREATE TABLE Contacts (
contact_nrint not null auto_increment,
first_namechar(30),
last_namechar(30),
client_nr char (30),
emailchar(30),
tel_1char(5),
tel_2char(30),
Hi Folks,
I have a MYSQL table with timeIn and a timeOut columns and I'm trying to
figure
out if I can calculate the difference within a SELECT statement. Both
fields are type TIME (e.g., 00:00:00).
Thanks,
Todd Schacherl
[EMAIL PROTECTED]
One of the penalties for refusing to participate in
At 16:23 -0700 8/17/02, Todd Schacherl wrote:
Hi Folks,
I have a MYSQL table with timeIn and a timeOut columns and I'm trying to
figure
out if I can calculate the difference within a SELECT statement. Both
fields are type TIME (e.g., 00:00:00).
What units do you want the result in? To get the
Hi Folks,
I'm using the following SQL SELECT statement to query a list of labor items.
I'm able to compute my number of hours(thanks Paul) and the line amount
(hours*rate=lineTotal) and now what I would like to do is to keep a running
total for hours and lineTotal. Is there any way I can do
On Fri, Aug 09, 2002 at 04:20:42PM -0400, David Miller wrote:
On Sun, 4 Aug 2002, Jeremy Zawodny wrote:
Hi Jeremy;
I didn't think my server would be doing any name resolution, particularly
while replace()ing millions of rows in a table. That said,
--skip-name-resolve *seems* to have
35 matches
Mail list logo