Thanks Jaime to reply me message so fast !
I would like to set 2 different user to maintance MySQL machine.
1st user can maintance the Unix box and MYSQL program
2nd user ONLY can maintance the MySQL program
Kevin, this should be solved at the MySQL user permissions level,
not at the UNIX
When I try to run mysql_real_connect my program crashes. If anyone
could help me understand why I would be eternally grateful. I've
tried looking at all the documentation regarding this situation and
tried many different things, but I am still stumped with the same
crash. I've tried this on
Hi,
I faced the same problem, but the solution to this is you is you add as many
qualifiers as you can (i'm sure there are more elegant ways to do it but it
works for me:-))specfiy the qualifiers FOR BOTH the tables you are picking
data from in the where clause :
For Example :
as you said lets
Dear Steve and all,
Thanks Steve !
Yes Steve, I have no problem to run MySQL with user - 'kevin' when I use
root telnet to server and the example as below:
# pwd
/usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin
#
# ./mysql -h192.10.0.113 -ukevin -p
Enter password:
Welcome to the MySQL monitor.
Dear Luke and all,
Thanks Luke... my problem was solved !
Also, I would like to say thanks for all of you who try to help me before !
THANKS A LOT ! Thanks again!
Best regards,
Kevin Chan
Luke Wrote
Sounds like you don't have permission to execute the file mysql in
/usr/local/mysql/bin.
Description:
# ./scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
./scripts/mysql_install_db[292]: 16797 Memory fault(coredump)
Hi Cindy,
SELECT Inventory.*, Customer.Name from Inventory Left Join Customer on
Inventory.PurchasedBy = Customer.ID
where Inventory.PurchasedBy = Custormer.ID;
Your query is an equi-join query, which means that there should be data
for only those rows for which the equality in
the
How about something like this ?
SELECT * FROM log_data_sig AS l1 LEFT JOIN log_data_sig AS l2 ON l1.user =
l2.user WHERE l1.type=join AND l1.user=EXTERNAL_USER_ID AND
l2.type = sign AND l1.timestamp l2.timestamp ORDER BY l1.timestamp DESC
LIMIT 1;
Terje K
-Original Message-
From:
I am trying to add floating point numbers, and also plain numerical values,
- I have looked on mysql.com but I only seem to find stuff that relate to
counting rows of a certain defined value - like count where something =
something, but I want to say give me a numerical total value for a
I am trying to add floating point numbers, and also plain
numerical values,
- I have looked on mysql.com but I only seem to find stuff that
relate to
counting rows of a certain defined value - like count where something =
something, but I want to say give me a numerical total value
for a
Thanks for all the help with counting up numer. values.
Thanks also to Richard, and Eskom for providing us the power to drive not
only our PC's but also powering solutions to our DB problems ! ;-)
Regards
Anton (JHB, RSA)
Richard Ellerbrock writes:
select sum(colnam) as x from table
### CHANGES ###
--- version 15.4 ---
The sensors module for hardware monitoring (requires lm_sensors) and
interrupts Linux module were added.
Thresholds are now internally ordered when checked to allow color
gradient effects.
The modules management dialog boxes were redesigned for easier
[EMAIL PROTECTED] writes:
Description:
See earlier emails from me. Same problem.
How-To-Repeat:
Fix:
Submitter-Id: [EMAIL PROTECTED]
Originator: [EMAIL PROTECTED]
Organization: Auctionwatch.com
MySQL support: login
Synopsis:Mysql crashing.
Severity:critical
Priority:
Hi,
I have the following error while excuting a sql INSERT query:
Commands out of sync; you can't run this command now.
What king of error is this?
--
Ir Pascal Francq
Researcher
Université Libre de Bruxelles
CAD/CAM Department
Avenue F.D. Roosevelt, 50
CP 165/14
B-1050 Brussels
BELGIUM
Hello,
anybody tryed %subj% ???
I have problem - module doesn't work.
I must recompile mysql with some directive like --lpam or --enable-pam
??
Michal
table, query, sql
-
Before posting, please check:
I noticed that STD() returns the sample standard deviation,
which is the sensible thing for it to do. However, when
working with data points sampled from a larger population
(or a distribution), it's a bit of a hassle to type
STD(x)*COUNT(x)/(COUNT(x)-1), and I noticed that Oracle has
a function
How would one load the results of the following query into a one line comma
separated list so that it could be then included with an IN expr to get
around the lack of subselect in MySQL
select distinct symbol from portfolio where type='401k' AND owner='jim'
select distinct p.symbol, i.name
Is this too simple?
select distinct p.symbol, i.name from portfolio p, stockinfo i
where p.symbol = i.symbol
and p.type = '401k'
and p.owner='jim'
order by p.symbol
-
Tom Haapanen -- Software Metrics/Equitrac Corp.
Advanced Printing Solutions -- http://www.metrics.com/
-Original
I've looked through the docs and I couldn't find out how
to do this. If you can point me to the right place in the
documentation so I can read how, that would be great. If
you could give me a little sample query to start from, that
would be great as well.
I've 2 columns in a table. Status and
Peter Zaitsev writes:
Hello mysql,
I've found the following problem often happens to me:
Then mysqld restarted unclear (sigsegv or server reset) the mysql
client library may hang during the automatic reconnect. The backtrace
is similar to this and does not changes other time (at least
Hi all,
Downloaded the binary distribution of 4.0.1 for Linux, and am attempting to launch on
an HP laptop with RedHat 7.0. This will replace my already functional installation of
3.23.46.
When I go to launch, it gives me the Starting mysqld daemon with databases... etc.
message. It then
Hello:
I am testing a new product with MySQL, and so far have been very pleased,
especially with the performance. One enhancement that I was looking forward
to in 4.0 is described below:
Updates that run over multiple tables is harder to do in MySQL. This will,
however, be fixed in MySQL 4.0
Mike Frederick writes:
Hello:
I am testing a new product with MySQL, and so far have been very pleased,
especially with the performance. One enhancement that I was looking forward
to in 4.0 is described below:
Updates that run over multiple tables is harder to do in MySQL. This will,
SELECT * FROM table WHERE (Status != closed) OR ((Status = closed) AND
(Date Now - # of seconds in 2 weeks))
That should work if your Date field is just a regular timestamp. It all
depends on how you're storing the date...
- Jonathan
-Original Message-
From: Chris Boget [mailto:[EMAIL
use a REGEXP:
http://www.mysql.com/doc/R/e/Regexp.html
- Jonathan
-Original Message-
From: julian haffegee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 01, 2002 2:11 PM
To: [EMAIL PROTECTED]
Subject: where
Hi,
I have recently gained access to mysql (new isp), and am converting
Should be something like
Select Status, Date from Table where Status closed or Date now()
- 14
(This is from memory so please dont rely on the syntax ;-)
HTH,
Chris
--
Christian Pfeiffer
Smart-Link Gesellschaft für EDV-Systemlösungen mbH
Herforder Str. 5-7 www.smart-link.de
I'm trying to use mysqlshow to display the tables of a database on a
remote host. I enter the command:
localhost:/usr/local/mysql$ ./bin/mysqlshow -h 555.55.5.5 -p samp_db
Enter password:
Wildcard: samp_db
+-+
| Databases |
+-+
| samp_db |
+-+
Hi!
I'm currently working on a menu system for web pages, but I've run into
some problems...
What I'ld like to create is a menu which can host an infinite number
of submenus. Further more, every menu should also be able to link to a
specific file, though not always used.
I would like to be
I have two NIC's with two different IP addresses on the machine that has the
mysql server running on it.
When I set up the bind-address argument(using winmysqladmin ver.1.1) under
the my.ini tab to bind to specifically one of the NIC's, it appears to have
registered that it is a valid argument.
This might help:
http://php.sitecreative.com/faq.php#3
- Jonathan
-Original Message-
From: Victor Spång Arthursson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 8:59 AM
To: [EMAIL PROTECTED]
Subject: Implement a menu structure using an relative database
Hi!
I'm
Hi:
Do you have any documentation for the required files, registry changes, etc.
for deploying MySQL with an executable developed in Delphi?
Thanks,
Mike Frederick
-
Before posting, please check:
non data driven menus not an option? I have buit java-script menus that are
pretty cool
- Original Message -
From: Jonathan Hilgeman [EMAIL PROTECTED]
To: 'Victor Spång Arthursson' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, January 02, 2002 11:02 AM
Subject: RE: Implement a
Ailes, Kevin a écrit :
I have two NIC's with two different IP addresses on the machine that has the
mysql server running on it.
When I set up the bind-address argument(using winmysqladmin ver.1.1) under
the my.ini tab to bind to specifically one of the NIC's, it appears to have
In my program i first make a lot of REPLACEs (1 and even more) and
immediately after that i make a SELECT on the same table.
Is it posible that MySQL messes up and makes the SELECT before the last
REPLACE is done?
Thanks
Goran
Goran Krajacic writes:
In my program i first make a lot of REPLACEs (1 and even more) and
immediately after that i make a SELECT on the same table.
Is it posible that MySQL messes up and makes the SELECT before the last
REPLACE is done?
Thanks
Goran
No , it is not possible, unless
On 2002-01-02, Robert Alexander [EMAIL PROTECTED] wrote:
When I go to launch, it gives me the Starting mysqld daemon with
databases... etc. message. It then fails immediately with the message
mysqld ended.
Here's the content of the error file in the data directory:
Hi,
This is generating an error:
Warning: Wrong parameter count for mysql_result() in
/usr/local/www/html/matt/add.php on line 27
I can't figure out what the problem is, here is the code in question, it
is part of an HTML form:
--Snip connect etc.. --
// process form
$sql = INSERT INTO
Hi everyone,
when we execute queries through MySQL using PHP, a significant amount of memory is
being used in the process. We have noticed that the memory is not being released
again for several hours. Despite attempts to force it to release memory in the code,
the problem is still occuring.
On Wed, 2 Jan 2002 15:30:51 -0400, Matt Rudderham [EMAIL PROTECTED] wrote:
| Hi,
| This is generating an error:
|
| Warning: Wrong parameter count for mysql_result() in
| /usr/local/www/html/matt/add.php on line 27
|
| I can't figure out what the problem is, here is the code in question, it
|
D'oh. Meant to call mysql_query! Thanks!
- Matt
Bonum volens duceris in Tartarum
-Original Message-
From: Michael Brunson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 3:36 PM
To: Matt Rudderham
Cc: [EMAIL PROTECTED]
Subject: Re: Could you look at this PHP/MySQL
Anyone have any ideas as to how I should handle a case
of the following error?
020102 13:27:28 Slave: Failed reading log event, reconnecting to retry, log
'db1-bin.008' position 1064155638
020102 13:27:28 Slave: connected to master '[EMAIL PROTECTED]:3306',replication
resumed in log
It's mysql_query($sql3) not mysql_result($sql3)
- Jonathan
-Original Message-
From: Matt Rudderham [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 11:31 AM
To: [EMAIL PROTECTED]
Subject: Could you look at this PHP/MySQL Code?
Hi,
This is generating an error:
Warning:
This sounds like it could be a caching issue. Are you running a Windows or
UNIX-based machine? Each should have methods to track what processes are
using memory and how much memory they are using.
- Jonathan
-Original Message-
From: Dan Liu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
You could just do this:
$result = ($sql3);
echo $result;
- Original Message -
From: Michael Brunson [EMAIL PROTECTED]
To: Matt Rudderham [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, January 02, 2002 1:35 PM
Subject: Re: Could you look at this PHP/MySQL Code?
On Wed, 2 Jan
Are there any odbc how-to's, tutorials, samples and/or resources I could
look at? I'm new to mySQL.
-Lew
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
It helps if you restart the mysql service after you make a change!
Sorry for the spam.
Kevin Ailes
Administrator
OTTO Engineering
-Original Message-
From: Ailes, Kevin
Sent: Wednesday, January 02, 2002 11:02 AM
To: '[EMAIL PROTECTED]'
Subject: bind-address argument
I
There are a couple of potential things you could change.
Dan,
1. On the MySQL end, there is a configuration value or two for timing
out sleeping MySQL queries - by default the timeouts are set to be 8
hours. You can make the timeouts less in my.cnf - However, be careful.
You may have
Hey Hank, guess what? G It worked.
Thanks for the nudge. Adding the symlink did exactly the expected things, and 4.0.1
is now launched. Now I wonder what the actual *cause* of the problem is...
Thanks, buddy, all the best,
/Rob
At 14:27 -0500 2002/01/02, Hank Leininger wrote:
On
Hi,
-Original Message-
From: Lew Schwartz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 11:58 AM
To: [EMAIL PROTECTED]
Subject: ODBC for newbie
Are there any odbc how-to's, tutorials, samples and/or resources I could
look at? I'm new to mySQL.
-Lew
MyODBC
[EMAIL PROTECTED] wrote:
UPDATE shpr_rcvr SET directions = 'No. ' where directions = '#';
That should do it :)
Thanks for the responce however it does not work. Nothing gets change
probably becasue no directions columns are ='#' there are just a lot of
them with '#' in the field among
I'd suggest checking to see if you (or the user MySQL is running as) have the
necessary permissions to alter or rename a file in that directory.
/Rob
At 12:16 -0800 2002/01/02, Fletcher Sandbeck wrote:
This is with MySQL 3.23.42-nt on Windows 2000.
I am issuing the following SQL statement and
I have been getting this same error. I am not able to Alter or Drop Tables.
I am definately sure that I have the necessary permissions. This has
happened on all of my recent installs of MySQL on windows XP and 2000
advanced server. I would appreciate any knowlege on this matter. Getting
tired of
On Wed, Dec 26, 2001 at 04:23:46PM -0600, Philip Molter wrote:
Are there guides out there for configuring these things? What is
a big enough log file? Honestly, on a lot of stuff, I'm just
guessing, but it takes a lot of time to fiddle with values, clean
out the database, and then shove in
On Thu, Dec 27, 2001 at 06:56:03PM +0200, Heikki Tuuri wrote:
* Recovery has been made more resilient to corruption of log files.
Can I ask what you mean here? If the log files are corrupt, is
recovery still possible then? Or are the log files themselves less
likely to get corrupted? I'm
On 1/2/02 at 3:32 PM, Robert Alexander wrote:
I'd suggest checking to see if you (or the user MySQL is running as)
have the necessary permissions to alter or rename a file in that
directory.
Some additional details. I can usually perform at least one ADD COLUMN
successfully before I start
I think this is more what you are looking for
UPDATE shpr_rcvr SET directions = REPLACE(directions,'#','No. ' where
directions = '#';
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 5:26 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
I'm currently in the preliminary planning phases of a content
delivery system. We will be generating pdfs on the fly containing our
member's statements. The system will be accessible both from our
internal systems and through our web-banking
mysql database
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
mysql database
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
Hi,
Simple question. What is the largest hardware implementation
that is know for mysql to run on? How well does mysql scale
on large platform systems such as Sun E10k, HP Superdome as
an example.
--
*** Phillip B. Bruce
I am developing a web-based mysql platform on Red Hat linux 7.2. The server
will host apache as well, but it is only for development purposes, and I am
the sole developer. Mysql and apache will be the only services running
besides minimum OS requirements. What can I get away with while not having
Phillip B. Bruce writes:
Simple question. What is the largest hardware implementation
that is know for mysql to run on? How well does mysql scale
on large platform systems such as Sun E10k, HP Superdome as
an example.
I would suppose that the number of possible file descriptors
and
configure:1592: checking whether the C++ compiler (c++ ) works
configure:1608: c++ -o conftest conftest.C 15
ld: fatal: library -lstdc++: not found
ld: fatal: File processing errors. No output written to conftest
{root}blinky:~ ls -l /usr/local/lib/libstdc++.a.2.10.0
-rw-r--r-- 1
I just downloaded the 3.23.47 source for mysql, and I tried to compile
it using Sun's Forte Compiler (6.2) however when trying to build
libmysql/hash.c I got the following error.
/opt/SUNWspro/bin/cc -DDEFAULT_CHARSET_HOME=\/opt/mysql/3.23.44\
-DDATADIR=\/opt/mysql/3.23.44/var\
Hi!
On Thu, Dec 27, 2001 at 06:56:03PM +0200, Heikki Tuuri wrote:
* Recovery has been made more resilient to corruption of log files.
Can I ask what you mean here? If the log files are corrupt, is
recovery still possible then? Or are the log files themselves less
likely to get corrupted?
I have a mySQL table which has about 15 fields. Is it possible using a
standard SQL statement to do a full text search on all fields ??
Please advise
Thanks,
Neil
-
Before posting, please check:
With InnoDB tables under 3.23.4x, if you perform an ALTER TABLE on
a table, any foreign key declarations that point to that table fail
to work (they always return a failure).
Is this a known bug? I don't see it on the InnoDB todo or bug
list, but I seem to remember hearing about it already.
*
I checked the archives for this list and saw that in 2000 Sergei recommended changing
GWS_IN_USE to GWS_IDF to disable the 50% weighting mechanism.
The MySQL manual, however says to change it from GWS_PROB to GWS_FREQ.
I'm inclined to go with the developer instead of documentation ;), but I'm
A link from .a.2.10.0 to just '.a'?
so that e.g.
{root}blinky:~ ls -l /usr/local/lib/libstdc++.a
-rw-r--r-- 1 root root 2153936 Dec 30 16:57
/usr/local/lib/libstdc++.a - libstdc++.a.2.10.0{root}blinky:~ ls -l
/usr/local/lib/libstdc++.a.2.10.0
-rw-r--r-- 1 root root 2153936
Hello,
I've searched both the documentation and the mailing list archives but
can't find the answer to this question (although several people seem to
have asked it). Here goes: What permission grants are required to allow
use of the backup table tablename to 'path' command? I can
execute the
I'd like to submit small a patch for mysql_hotcopy. I don't know where to
go with it. I'm assuming if it's worth anything, it'll get picked up from
here and stuffed in. I'm sure others have so many tables that would max
out cp's argument list :)
422a423,430
# the array size block below
Hello,
I'm having some trouble constructing my first INSERT statement into
multiple tables. I'm using PHP4. I have written the following INSERT
statement with no problems:
$sql = INSERT INTO main (name, ext, stor_pre, stor_base, width, height,
file_size, proj_id, date_cre, cre_by,
My compile seems to have stuck itself in a loop - just wondering
if this is normal - it's been over 90 minutes on:
make[2]: Entering directory `/local/src/mysql-3.23.47/libmysql'
/bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF
-DHAVE_RWLOCK_T -o libmysqlclient.la -rpath /usr/local/lib/mysql
Hi Paul,
There is no direct way to make a string by concatinating strings of
different columns. But your problem can be solved in a different way.
select distinct p.symbol, i.name from portfolio p, portfolio pp, stockinfo i
where pp.type = '401k' AND pp.owner = 'jim'
and p.symbol = i.symbol
Hi,
I have a mysql table with columns pts_t2, pts_ext and pts_other which hold
each player's point total for that category. I have it displaying player's
ranks by ordering by each of those points. However, I would like to have an
overall ranking (all categories combined), and I don't want to add
database,sql,query,table
I am new to phpmyadmin, I need to make a db for a
online job resume service site. This site is like
hotjobs but people can also attach photos. I need some
direction on where to start on this project.
Thanks
__
Do
On Wed, 2 Jan 2002 21:00:59 -0800 (PST), help used a few recycled electrons to
form:
| database,sql,query,table
|
|
|
|
| I am new to phpmyadmin, I need to make a db for a
| online job resume service site. This site is like
| hotjobs but people can also attach photos. I need some
| direction
I'm new to mysql/sql thing
thus mysql can efficiently handles a database even it has a hundred tables
thanks in advance
Arvin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Y send a mysql request :
INSERT INTO akoview_info
(FALL_NR,PAT_NR,NAME,VORNAME,GEB_DAT,DIAG_ART,BEFUND_NAME,UNTERSUCH_DAT,WR_I
D,WR_YEAR,WRIDX_ID,WR_QUART,BEHAND_MED,P_UID,S_UID)VALUES('01213658','546456
897','X','Aaaa','1953-12-10','5','F:\devkunde\SENDTNER\BD\20013\1\010027
The following should work.
INSERT INTO akoview_info
(FALL_NR,PAT_NR,NAME,VORNAME,GEB_DAT,DIAG_ART,BEFUND_NAME,UNTERSUCH_DAT,WR_I
D,WR_YEAR,WRIDX_ID,WR_QUART,BEHAND_MED,P_UID,S_UID)VALUES('01213658','546456
897','X','Aaaa','1953-12-10','5','F:\\devkunde\\SENDTNER\\BD\\20013\\1\\010027
Hi again,
From what I can see, when the driver is unloaded (I guess when my
application is shut down) it releases all handles again. But the init
shouldn't take 800.000 handles over time right? :)
/ Jens
-Original Message-
From: Venu [mailto:[EMAIL PROTECTED]]
Sent: den 19 december
Why don't you try like this.
F:\\devkunde\\SENDTNER\\
'\' is escape character. so you must
use '\\' to insert '\'.
Homepage = http://www.nnr.or.kr/inos/
ICQ # = 123534385
Member of DSN(database.sarang.net), NNR(nnr.or.kr)
--MIME Multi-part separator--
83 matches
Mail list logo