Does anybody know how to make log files for each of my
databases?
Thanx
sql, query
Do You Yahoo!?
@yahoo.grhttp://www.otenet.gr
-
Before posting, please
we use mysql 3.23.46-max-nt at customer pc. Some customers use Windows2000,
but some use Win98. Mysql Database that run at Win98 platform, sometimes
crashes, and i cannot repair it. The error often ise 144 Error that TABLE
CRASHED AND LAST REPAIR FAILED.
Tables that crashed Win2000 can be repair
Jefferey,
Tuesday, September 10, 2002, 8:19:35 AM, you wrote:
JD I'm just getting started with FULLTEXT indexes for a
JD table and am seeing some very off-base results. While
JD it may be something I'm doing, I didn't see anything
JD in the online manual to indicate why these results
JD would be
Hi
I want to log our ISA server logs to mySQL
I need to create a table using the .sql file supplied by Microsoft.
(Following below)
The last script is as I am trying to recreate it.
I can recreate everything fine, but I have two problems.
Problem 1
There is a # in the last two field names
Hello Victoria,
As far as I see bug of muliple log files still not fixed regardless
of last change in 4.0.4:
'FLUSH LOGS removed numerical extension for all future update logs.'
--
Best regards,
Artem mailto:[EMAIL PROTECTED]
sql query
Uriel,
Monday, September 09, 2002, 4:21:40 AM, you wrote:
C:mysql -r -N fall02 \mysqluw\mysql.txt
UW (i.e. using the mysql command from DOS, and running a batch file)
UW And I didn't change any configuration defaults since installing mySQL on
UW this machine.
Put local-infile=1 in the
Hi,
I have a table called users with the columns firstname and lastname. I would
like to do a search on the fullname and have tried:
select * from users where (firstname + ' ' + lastname) = John Smith
which returns all rows for some reason and not only the rows with users
named John Smith
Hi,
I hope this question hasn't been asked loads of times before but I can't see
any reference to it in the documentation.
Basically I need a way to monitor MySQL to ensure it hasn't gone down. We
are using MySQL as the backend of some important sites and need to ensure
that if it does crash for
hi,
have some interesting questions about an updated from MySQL-3.23.36 to
MySQL-3.23.52
I am using a preinstalled MySQL-3.23.36 from mandrake (is a 8.0 mdk) and will
change to a MySQL-3.23.52.
because I cannot find a MySQL-3.23.52-shared-version I would try to install
the new MySQL-3.23.52
Mike,
Monday, September 09, 2002, 2:45:36 AM, you wrote:
M I am having trouble with an sql query. I have a table with a column that
M has an '#' sign in the name. The problem is I can't seem to escape the
M column name to be able to select it.
M IE:
M select test#1 from test or select
Elin,
Tuesday, September 10, 2002, 12:03:21 PM, you wrote:
ER I have a table called users with the columns firstname and lastname. I would
ER like to do a search on the fullname and have tried:
ER select * from users where (firstname + ' ' + lastname) = John Smith
ER which returns all rows for
Andis,
Friday, September 06, 2002, 12:08:58 PM, you wrote:
AG Is it's possible to execute such query in MySQL?
AG update table_name set table1.field1=table2.field2 where
AG table1.key=table2.key
If you use 4.0.2 or higher yes, otherwise nope.
Pre-version of multi-table updates came only in
Michael,
Sunday, September 08, 2002, 10:21:20 PM, you wrote:
MB I just installed Max v3.23.52-nt and it is working. However, in following
MB the tutorial, I created a text file and tried to use the Load Data command,
MB which returned an error: ERROR 1148: The used command is not allowed with
Thomas,
Monday, September 09, 2002, 10:12:01 PM, you wrote:
TS just wanting some headsup on the following question.
TS How does the index_priv catch in at all?
TS Does a missing index_priv also block me to create a table with indexes in the
create-statement?
TS Or does it only affect the later
Hi,
I hope this question hasn't been asked loads of times before but I can't see
any reference to it in the documentation.
Basically I need a way to monitor MySQL to ensure it hasn't gone down. We
are using MySQL as the backend of some important sites and need to ensure
that if it does crash for
Hello,
I am working with mysqld-max-nt under windows 2000 and unsing InnoDb tables.
After running the following select:
Select cod,nom from grupos where cod '005' order by cod desc limit 1
mysqld crashes.
Also it crashes whith limit 10, limit 50, or whatever limit
Pada Tue, 10 Sep 2002 11:42:21 +0200
hans schneidhofer [EMAIL PROTECTED] menulis :
hi,
have some interesting questions about an updated from MySQL-3.23.36 to
MySQL-3.23.52
I am using a preinstalled MySQL-3.23.36 from mandrake (is a 8.0 mdk) and will
change to a MySQL-3.23.52.
because I
Pada Tue, 10 Sep 2002 11:03:40 +0100
Tom Freeman [EMAIL PROTECTED] menulis :
Hi,
I hope this question hasn't been asked loads of times before but I can't see
any reference to it in the documentation.
Basically I need a way to monitor MySQL to ensure it hasn't gone down. We
are using MySQL
You would have to do something like:
SELECT * FROM users WHERE CONCAT(firstname, , lastname) = John Smith
That should get you what you want.
If your taking your DB from MS SQL to MySQL only a few queries will port
directly over. You have to be careful that you follow the MySQL syntax and
DB independent? As in an entire list of tables in your MySQL server? Or as
in independent from MySQL to say MS SQL Server? If the later then I'm sure
each db as some form of query to get a list of tables, just look it up. I
don't think there would be a unified way simple because each db is
Mustafa,
Tuesday, September 10, 2002, 10:19:14 AM, you wrote:
MY we use mysql 3.23.46-max-nt at customer pc. Some customers use Windows2000,
MY but some use Win98. Mysql Database that run at Win98 platform, sometimes
MY crashes, and i cannot repair it. The error often ise 144 Error that TABLE
MY
Nikolaos,
Monday, September 09, 2002, 7:51:43 PM, you wrote:
NG I have installed mysql 4.0.2 alpha log (actually compiled by me) in a linux
NG box (Mandrake 8.2) and for 2 months was working perfectly. After migrating
NG some data from an other installation (Windows 2000 / mysql 4.0.1 alpha
Hey,
I noticed another response about tailing the log and looking for
information in the err log which looks like a great solution.
However, if you have an extra computer laying around, you can also set up a
cron job with a shell script that connects to the server (via telnet or
using a
Hey,
I thought you could just use
mysqladmin refresh -pPASSWORD -- or
mysqladmin reload -pPASSWORD
To kickstart logging again?
If not - hey, what do I know heh
Eric Lamendola
At 11:12 AM 9/10/02 +1000, Daniel Kasak wrote:
Hi all.
I've been using MySQL-4.0.3 (on Slackware-8.0) for a week or
Hi, All
I am trying to make MySQL 4.0.3b work with AIX 4.3.3.
But whenever I did the `./bin/safe_mysqld ` command,
I get following error:
020910 08:31:33 mysqld started
020910 8:31:33 Can't find messagefile
'mysql-4.0.3b/share/mysql/english/errmsg.sys'
020910 8:31:33 Aborting
020910
At 04:05 PM 9/10/2002 +0300, you wrote:
Nikolaos,
Monday, September 09, 2002, 7:51:43 PM, you wrote:
NG I have installed mysql 4.0.2 alpha log (actually compiled by me) in a
linux
NG box (Mandrake 8.2) and for 2 months was working perfectly. After
migrating
NG some data from an other
How does MySQL process a join between tables? Does it always use
nested-loop join, or does it use sort-merge join if the table is sorted
before joining it? Is the join algorithm merge if the tables are already
sorted on the join attributes (through an index)?
Sincerely,
Toni Strandell
Attn: mysql ,
My name is Ocita G, the manager, credit
and foreign bills of Ecobank Plc. I am writing in
respect of a foreign customer of my bank with account
number 14-255-2004/utb/t who perished in a plane crash
[Korean Air Flight 801] with the whole passengers
aboard on August 6, 1997.
Since
Is the file there, and readable by the user 'mysql' ?
Xiaolin Zhao wrote:
Hi, All
I am trying to make MySQL 4.0.3b work with AIX 4.3.3.
But whenever I did the `./bin/safe_mysqld ` command,
I get following error:
020910 08:31:33 mysqld started
020910 8:31:33 Can't find messagefile
At 9/9/2002, you wrote:
Dear all,
I have installed mysql 4.0.2 alpha log (actually compiled by me) in a
linux box (Mandrake 8.2) and for 2 months was working perfectly. After
migrating some data from an other installation (Windows 2000 / mysql 4.0.1
alpha log) my FULL-TEXT indexes stop
How did this get past the filters?
Ocita Gabriel wrote:
Attn: mysql ,
My name is Ocita G, the manager, credit
and foreign bills of Ecobank Plc. I am writing in
respect of a foreign customer of my bank with account
number 14-255-2004/utb/t who perished in a plane crash
[Korean Air
This must be a great scam. I'm starting to see'em all over the place.
--Walt
-Original Message-
From: Ocita Gabriel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 3:53 PM
To: [EMAIL PROTECTED]
Subject: Goodday
Attn: mysql ,
My name is Ocita G, the manager, credit
and
Hitch free? Incredible, in that case I'll give you all my personal bank details.
I can't lose!
Am I a sucker or did I miss something here.
Ocita Gabriel wrote:
Attn: mysql ,
My name is Ocita G, the manager, credit
and foreign bills of Ecobank Plc. I am writing in
respect of a foreign
Simply having that Attn: mysql , row in it. The word 'mysql' passes
through the filter. Not making that Ocita G less of an idiot, though.
On Tue, 10 Sep 2002, Clive Smart wrote:
How did this get past the filters?
Ocita Gabriel wrote:
Attn: mysql ,
My name is Ocita G, the manager,
I think the only filters on this list are that it must contain 'sql' or
'query'... The message starts with 'Attn: mysql', so I guess it got thru.
Justin
on 10/09/02 11:55 PM, Clive Smart ([EMAIL PROTECTED]) wrote:
How did this get past the filters?
Ocita Gabriel wrote:
Attn: mysql ,
Don't reply or they'll get your Email address. ;-)
Regards
**
* K e i t h B u r k e*
**
* Experience IT Ltd * Phone : +353 1
-Original Message-
From: Andrew Pickett [mailto:[EMAIL PROTECTED]]
Hitch free? Incredible, in that case I'll give you all
my personal bank details.
I can't lose!
Am I a sucker or did I miss something here.
As I understand it, they start by requesting that you finance some
'mysql' there need to be a better filter. Yes, We get this letter 20 times a
weeks. I will forward this on to the FBI to add to their list.
-Original Message-
From: Clive Smart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 9:55 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL
It depends on your database query structure and especially what
indexes are available. If you just put explain in front of your query
you will be able to see how mysql will execute your query.
On Tuesday, September 10, 2002, at 09:45 AM, Toni Strandell wrote:
How does MySQL process a join
hello
sql, query
for various reasons, i need to do a cron job that will take a snapshot of
table1 (by snapshot i mean a temporary table), do some processing, and
then save some scientific calculations to table2. after this, i need to
refresh table1 -- i.e., truncate it entirely. i need to do
Tom,
What type of problems AREN'T you detecting?
I'd take a wild guess and say you're only checking MySQL every 5 minutes
or so. You can decrease the frequency between checks for more updated
status. There are two variables that you need to look at:
normal_check_interval, which is part of
I seem to have a version problem. I'm using v. 3.23.51 on a Windows
standalone system -- there is no network here. *ALL I want* is to run MySQL
standalone on this machine. So do I need to start the server? MySQL seems
to mostly work fine if I just go and do:
C:\mysql\bin mysql
without starting
At 23:37 +0800 9/10/02, Uriel Wittenberg wrote:
I seem to have a version problem. I'm using v. 3.23.51 on a Windows
standalone system -- there is no network here. *ALL I want* is to run MySQL
standalone on this machine. So do I need to start the server? MySQL seems
to mostly work fine if I just
Mike,
I totally agree. The log solution wasn't my idea though smile.
No matter what language you write the script in, any type of Get some
kind of response by throwing something against the server and seeing if it
sticks response will get you the information you need.
I set up a dummy
At 12:09 +0400 9/10/02, Artem V. Ryabov wrote:
Hello Victoria,
As far as I see bug of muliple log files still not fixed regardless
of last change in 4.0.4:
'FLUSH LOGS removed numerical extension for all future update logs.'
This bugfix affects the update log, not the binary update
Sorry! I made a mistake here. I still have the questions below but my
problem with LOAD DATA is SOLVED! I made an editing mistake when updating
the my.cnf(my.ini) files.
- Original Message -
From: Uriel Wittenberg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002
THANKS VERY MUCH! That worked!
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 9:15 PM
Subject: re: Re: LOAD DATA LOCAL INFILE not allowed this version?
[.]
Put local-infile=1 in the [mysqld] and [mysql]
If mysql works fine, then you've already started the server.
Then does a normal Windows installation set it up so the server autostarts
whenever you boot up? I did not manually start the server.
You have to restart the server before it will notice the [mysqld] option
group change.
After I
At 23:52 +0800 9/10/02, Uriel Wittenberg wrote:
If mysql works fine, then you've already started the server.
Then does a normal Windows installation set it up so the server autostarts
whenever you boot up? I did not manually start the server.
It might be installed as a service.
You have to
Since I didn't get a response, I tried one of the suggestions here. See my response to
it below.
Additionally, I've turned on the environment variables DBI_TRACE and PERL_DBI_DEBUG,
both to level '8'. This produces voluminous, but not particularly illuminating,
output. If anyone has a
Hi,
Yes, it is existing:
ibmaix:/usr/local/mysql # ls -al
./share/mysql/english/errmsg.sys
-rw-r--r-- 1 mysqlsystem 12183 Sep 09 17:02
./share/mysql/english/errmsg.sys
The mysqld is run as mysql user.
That is why I can not understand it.
Any idea?
Best regards,
Allen Zhao
At 4:54 +0200 9/10/02, Jan Broermann wrote:
Hi,
I'm missing an answer to a topic which came up a couple of days /weeks ago.
For a database i'm administrating I would like to find out, which numbers
(of invoices)
are missing in our database. Is there a way to get this result set thru SQL?
Or do I
Hi,
Have you looked at mysql error log file on the server ?
Regards
--
Joseph Bueno
Derrell Durrett wrote:
Since I didn't get a response, I tried one of the suggestions here. See my response
to
it below.
Additionally, I've turned on the environment variables DBI_TRACE and
Joseph Bueno wrote:
Have you looked at mysql error log file on the server ?
Where would I find that?
Derrell
Derrell Durrett wrote:
Since I didn't get a response, I tried one of the suggestions here. See my
response to
it below.
Additionally, I've turned on the environment
Your db admin should know that ;)
Otherwise, you can do a
mysqladmin variables
and look at 'datadir' value.
In this directory, you should find a file named hostname.err
(see http://www.mysql.com/doc/en/Error_log.html).
Regards
--
Joseph Bueno
Derrell Durrett wrote:
Joseph Bueno wrote:
Hello,
I recently started trying to learn MySQL, and toward that goal I thought it
would be a good idea to put it on my Redhat Linux system. I downloaded all
the RPMs I could find, since I'm still fairly new to Linux and the whole
tarball idea is strange to me. However when I go to install the
Hi,
If you wish to find NUMBERS which are missing, i think you can try
this:
set @a:=0;/*initialise variable a*/
select @a:=@a+1,IF(YOUR_COLUMN_INT_TYPE= @a,'OK',@a:= @a+1) FROM YOUR TABLE;
Don't forget to initialise variable 'a' for every time when run the second
query.
This is work indeed
Thanks, I have the installation files on the HD, not using the CD. I do have
admin access to the machine, never had a problem installing programs before.
Can you explain how to make XP can run in 16 bit mode.
-=Bryan=-
-Original Message-
From: b.ware [mailto:[EMAIL PROTECTED]]
All,
We are experiencing a strange problem where one minute everything is running
fine on mysql, then the next minute, all queries seem to lockup.
Can anybody provide guidance to me so I can determine the cause of the
lockups?
So far I dump the proc logs every minute via cron. I have found
Make sure mysql has search privileges through all the
directories to the file.
Xiaolin Zhao wrote:
Hi,
Yes, it is existing:
ibmaix:/usr/local/mysql # ls -al
./share/mysql/english/errmsg.sys
-rw-r--r-- 1 mysqlsystem 12183 Sep 09 17:02
./share/mysql/english/errmsg.sys
The mysqld is
Hi all
There's probably a simple answer to this but I can't find it and it's
doing my head in.
I have two tables:
main contains user data, address,name,etc.
activity contains user activity
'user' in main has the same value as 'id' in activity
I want to produce a list of users who have not
Hello everybody,
I am getting the following error during make of mysql
3.23.45 on solaris 2.5.
Anybody has an idea please reply
Thanks,
Niranjan
ake[1]: Entering directory
`/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45'
Making all in include
make[2]: Entering directory
As is usually the case, it depends on your table structure and how you
are deleting. If you don't have any variable length fields (ie. varchar)
then all your record lengths are exactly the same and the empty space
can be reused for new records, preventing fragmentation. I'm only 95%
positive
Dear Gerald,
Many thanks!
I just did a chmod -R a+r, then everything is fixed.
It is kind of lasy and security breaking act, but at
least that confirms the nature of the problem.
Best regards,
Allen Zhao
--- Gerald Clark [EMAIL PROTECTED]
wrote:
Make sure mysql has search privileges
Try this (not sure the syntax is exactly right since I'm more used to
Oracle's outer join syntax):
select * from main left join activity on main.user = activity.id
where activity.id is null;
This should return only the users in main that are not in activity.
--Walt Weaver
Bozeman, Montana
Hi all. Does any one know how to convert dates like 06-Sep-02 00:00:00
into the mysql datetime format? The main challenge here is probably
converting the 3 letter abbreviations for the month. Thanks for any input.
David
-
Hi David!
What language do you use to build your application?
You can do this easily with PHP.
Please have a look at the following functions
http://se.php.net/manual/en/function.strtotime.php
http://se.php.net/manual/en/function.strftime.php
Best regards
/Peter
- Original Message -
Hi Peter- thanks for the reply. Yes I do use PHP but I was not aware of
those two functions. I was just going to do a str_replace() for all the
different months, then do an explode on the date and re-arrange it, but
these two functions may provide a much better solution.
David
-Original
Description:
Apparently in 4.0.3 does not like if statements in it's
SELECT query... A query that once worked now returns 0 when I use
an IF, rather than the proper value
How-To-Repeat:
This is a simple example of how I am able to recreate...
CREATE TEMPORARY TABLE temp SELECT
Thanks to Peter's hint here's an example of how I'll be doing it using PHP:
?php
$date = 06-Sep-02 00:00:00;
$t = strftime(%Y-%m-%d %H:%M:%S, strtotime($date));
print $t\n;
?
David
-Original Message-
From: Peter Engström [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002
Do schema operations affect
regular statements?
I've run alter table add column ...
on the large table and it coinsided
with select fld from same_table limit 0,1.
And this select returned as if no records
were available though there were plenty.
Is this normal?
Should schema changes run
I have been working with Mysql-Myisam, but when I converted to Inoodb I
noticed that my queries were much slower.
Why?
what can I do for best the performance?
When do I have to use the innodb?
Best regards.
Thank you!
-
I have been working with Mysql-Myisam, but when I converted to Inoodb
I
noticed that my queries were much slower.
Why?
Inno DB handles transactions. So if they are on
it generally would be slower vs. if they are off
since it has to keep both copies of data (before
and after change)
what can
Make sure mysql is the owner of /usr/local/mysql.
With Linux the command is
chown -R mysql /usr/local/mysql
This recursively makes mysql the owner, and keeps security tight.
Xiaolin Zhao wrote:
Dear Gerald,
Many thanks!
I just did a chmod -R a+r, then everything is fixed.
It is kind of
I am looking for some help on a SQL query to perform a search, but
constrain the search to those records which have a related record in
a second table. What I think I need is a subselect, but since this is
not possible in 3.23.47, I am looking for work around.
I have one table for Visitors
Hi everyone -
We recently started logging our apache logs directly into a mysql db. Two
questions:
1. The db files are growing fairly rapidly. Will inserts begin to slow the
larger the database gets? Is there a recommended method for rotating the
database every few gigs (it's all in one
version: 3.23.37 running on an RAQ
Problem: I can not log into MySql as root - it hangs after I give it a
password.
Background: MySql was running fine for a year and then just stopped
running.
Symptoms:
1) Mysqld is running when I reboot the server but can't be shut down
sql, query
thanks for the note brent.
If you don't have any variable length
fields (ie. varchar) then all your record
lengths are exactly the same and the
empty space can be reused for new records,
preventing fragmentation.
i think we can do this. since
Thanks for the tip I will try that, I'm still learning MySQL and PHP,
although I did a couple of complex applications, there are some
techniques that still are 'obscure' to me.
Regards,
Ricardo Fitzgerald
AXIS Computers
- Original Message -
From: Chris Shiflett [EMAIL PROTECTED]
To:
Eric Lamendola wrote:
Hey,
I thought you could just use
mysqladmin refresh -pPASSWORD -- or
mysqladmin reload -pPASSWORD
To kickstart logging again?
If not - hey, what do I know heh
Eric Lamendola
Yeah that only restarts the binary log. I like to have a human-readable
log which I
Hi Bryan,
could it be that you deactivated the Windows XP error reporting function?
Activate it for the Windows Operating System and All Programs and try
installing MySQL again. If an error message occurs the provided data might
help you track down the problem... If not don't forget to
Does a normal WinXP installation of WinXP result in the mySQL server being
automatically started up whenever one boots up the system? If so this is not
well documented and it's not an appropriate default, at least not for
everyone. Is there a standard way to change that so the server only runs
I am unable to find the specific DROP command to remove only test@%,
test\_%@%,
snort@localhost, and snort@%.
I am trying to clean up my db information.
Thank you.
mysql select * from db;
At 16:26 -0700 9/10/02, Daniel Curry wrote:
I am unable to find the specific DROP command to remove only test@%,
test\_%@%,
snort@localhost, and snort@%.
I think you want DELETE, not DROP.
DELETE FROM db WHERE Db='test' AND Host='%';
DELETE FROM db WHERE Db='test\_' AND Host='%';
DELETE FROM
Thanks Michel:
Enabled the error reporting, but no luck. I'm stumped why I am not seeing
any error messages when it fails to install. Do you know if the MYSQL
installation makes any modifications to the registry or adds files to the
system directory. If not I could probably just copy the
Paul,
Thank you. That did it.
You are correct I needed to DELETE.
Paul DuBois wrote:
At 16:26 -0700 9/10/02, Daniel Curry wrote:
I am unable to find the specific DROP command to remove only test@%,
test\_%@%,
snort@localhost, and snort@%.
I think you want DELETE, not DROP.
Clarify your question ... are you trying to drop TABLES, DATABASES, or
modify user privileges?
If you are trying to modify user privileges, use GRANT or REVOKE.
- Original Message -
From: Daniel Curry [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 6:26 PM
Which version of WinXP (Pro or Home)?
On WinXP Pro, you'd have to install MySQL as a service, in which case it can
either started manually or automatically. WinXP Home is more like WinME
(yuck!) or Win98, where you can start MySLQ from a batch file.
- Original Message -
From: Uriel
I am the creator of CoreReader and have done
rudimentary testing against MySql. However, not
being familiar with that data source, I hesitate to
state that CoreReader runs against it without
problems.
Has anybody who knows what they are doing used
CoreReader with MySql enough to say that
I have to do an insert and need to nest a select inside. I have tons of
documentation on a very simple version of this, however my requirements
are one step beyond that. Here is what I'd like to do in MySQL:
insert into
table1
(column1, column2)
values
(select column1a from table2 where
From my experince this is not possible.
Is there any reason why you can not simply do two inserts following each
other?
INSERT INTO table1(column1) SELECT column1a FROM table2 WHERE [something]
INSERT INTO table1(column2) VALUES(valueFromMemory)
(as if you didnt know that already) =D
There
At 18:47 -0500 9/10/02, Gerald R. Jensen wrote:
Which version of WinXP (Pro or Home)?
On WinXP Pro, you'd have to install MySQL as a service,
???
Have to, or have the option to?
in which case it can
either started manually or automatically. WinXP Home is more like WinME
(yuck!) or Win98,
At 17:16 -0700 9/10/02, Mark S Lowe wrote:
I have to do an insert and need to nest a select inside. I have tons
of documentation on a very simple version of this, however my
requirements are one step beyond that. Here is what I'd like to do
in MySQL:
insert into
table1
(column1, column2)
Hi,
I have redhat linux 7.1 server and I have downloaded the
binary version of mysql 3.23.52 and I have installed the same version on
other servers and it was all fine but on this server I am getting the
following
error
[root@abacusweb mysql]# bin/safe_mysqld
[1] 21278
[root@abacusweb mysql]#
You are right, Paul ... the service is optional on WinXP Pro. I'm a creature of habit!
-Original Message-
From: Paul DuBois [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 7:32 PM
To: Gerald R. Jensen; Uriel Wittenberg; [EMAIL PROTECTED]
Subject:Re: Default Win
Which version of WinXP (Pro or Home)?
On WinXP Pro, you'd have to install MySQL as a service, in which case it
can
either started manually or automatically. WinXP Home is more like WinME
(yuck!) or Win98, where you can start MySLQ from a batch file.
WinXP Home is MUCH more stable than ME
You should search for some SQL tutorials on the Web.
What it sounds like you are looking for is the update SQL statement
which modifies an existing row (for your second form, for example).
Thus, you insert the row to create it (which assigns the key using the
auto increment), then update that
Hi
I added a new user in mysql using the following
mysqlinsert into user
values('localhost','aman',PASSWORD('mysql024'),'Y','Y','Y','Y','Y','Y','N','
N','N','N','N','N','Y','Y');
mysqlinsert into user
values('%','aman',PASSWORD('mysql024'),'Y','Y','Y','Y','Y','Y','N','N','N','
I've put up the recipes distribution that will accompany the upcoming
MySQL Cookbook (O'Reilly Associates). It's available at the book's
companion web site:
http://www.kitebird.com/mysql-cookbook/
Note that this is more or less a pre-release, because I still have
some cleaning up to do,
At 16:40 10/9/2002 -0700, Lukoni, Bryan AG:EX wrote:
Hi,
Thanks Michel:
Enabled the error reporting, but no luck. I'm stumped why I am not seeing
any error messages when it fails to install. Do you know if the MYSQL
installation makes any modifications to the registry or adds files to the
system
1 - 100 of 111 matches
Mail list logo