I save it as a CSV and stick it through phpmyadmin...it can be a bit
clumsy (getting the delimiters to agree, mostly, which isn't exactly a
monumental hurdle) but it works great unless your sheet is bloody
massive and it runs past the timeout. I guess it'd be equally simple to
do a LOAD DATA
Nitin [EMAIL PROTECTED] wrote:
I have a project in hand, where I need to accept and show data in Hindi language,
storage doesn't matter. Is that possible with MySQL, if yes, what do I need to
configure? How do I do it, any help or ideas?
No, but from 4.1 you can use Unicode.
--
For
Is there a way to use a string concatenating function in connection with a
GROUP BY clause? I mean, for a one-to-many relation (like firm-stockholders
relation), to catch a structure like:
firm | stocholders
f_1 | s_1; s_2; s_3
f_2 | s_4; s_5
f_3 | s_6
instead of
firm |
If you're using MySQL 4.1, you have the GROUP_CONCAT(expr) function.
If not, then... i think someone has already done an UDF about this...
Search the archives..or see this:
http://www.cwts.nl/buter/misc/my-mysql.html
--
Diana Soares
On Wed, 2003-11-12 at 08:56, Ciprian Trofin wrote:
Is there
Scott H [EMAIL PROTECTED] wrote:
Repost - Haven't gotten any response on this and
can't find an answer. If no one on the mysql
list knows, where does a fellow turn? Help!
Can't seem to find this one in the manual or
archives - how do I control a db to maintain
its size to an arbitrary
Is SPADE support TUFT or 1256 code page ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Everybody
Pardon me for mistake writing
Is SPADB support TUFT or 1256 code page ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Everyone
Currently I am using SAPDB as DB engine and I know that it is supported
Unicode , but for a project I `d like to use Farsi
and In presentation when I use Unicode DB , there is no problem ...but in
some functions of engine like Sorting there is
a problem and it does not sort some
On Wed, 12 Nov 2003 12:14:05 +0200, Victoria Reznichenko wrote:
Yes, 'mipradius' is a current database and if you use option 'replicate-do-db=
mipradius', 'insert into mipsessions ..' query should be replicated. But in the
first post you said about database 'myradius', is this a typo?
How
The documentation for MyISAM states two features that I am trying to find
more information on.
1) Max Keys Per Table, according to the documentation, can be increased from
the default 32 / Table to 64 / Table without recompilation. However, I am
unable to find how to do this anywhere.
2) Max
if you dont want to write program:
use MsAccess.
thx
öö
- Original Message -
From: Lists - Dustin Krysak [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 7:20 AM
Subject: Import from excel to MYSQL
Is there an easy way to get an excel spread sheet imported
Hi all,
How can I change the directory of the databases?
I have tries the basedir switch in the my.cnf [mysqld] section, but it did not work.
How should I do it?
Thanks,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
in my.cnf:
[mysqld]
datadir=/var/lib/mysql
-Original Message-
From: Daniel Kiss [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:21 PM
To: [EMAIL PROTECTED]
Subject: Changing Data Directory
Hi all,
How can I change the directory of the databases?
I have
Just an FYI, but you can also specify at startup of mysqld by passing the
--datadir option. This will override what is in your option file, until
the next restart.
-Original Message-
From: Arunas Milaauskas [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 8:26 AM
To:
Ok, I was confused about the password thing. It works now that I'm passing
root's password in the command:
/usr/local/mysql/bin/mysqldump --opt --all-databases -prootpassword
/usr/local/mysql/data/mysqldump
You're joking, right? (Perhaps you thought the original question was a
joke, too, as
Why would you created separate fields for each quarter? Create a field
called quarter and store a number in it. You could also combine year,
month and day into a date field, which would make it easier to search
on ranges.
So, I think your table should look like this:
id
quarter
eventdate
week
Be aware that you password is visible (unix anyway with a ps -ef..) when you
pass the password like -ppassword. Usually you can enter the password later if
you use
usr/local/mysql/bin/mysqldump --opt --all-databases -p
which avoids the password being visible..
Cormac.
On 12-Nov-2003 Randall
Hello,
I have had some Error 127 on my system so I ran myisamchk -rf when mysqld was down.
Now I noticed my .MYI file is at 1024K:
-rw-rw1 mysqlmysql1024 Nov 11 16:33 table.MYI
My .MYD, .frm are still there:
-rw-rw1 mysqlmysql8802 Nov 6 07:04 table.frm
Dear friends
We have our application with data tier as mysql database in our office
running on windows platform which we need to synchronize with the same
database on a remote system at data centre on Linux.
Awaiting your reply at the earliest,
Thanks Regards,
Prashant A
--
MySQL
Well, this command is running in a cron job -- so that's not an option.
Be aware that you password is visible (unix anyway with a ps -ef..) when you
pass the password like -ppassword. Usually you can enter the password later
if
you use
usr/local/mysql/bin/mysqldump --opt --all-databases
I get an error Unable to access primary key each time I attempt to
insert or update a record. But everything seems to be OK with my PK.
CHECK TABLE doesn't see any problem.
Any idea ?
Regards.
Stéphane
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Using MySQL-4.0.15
For whatever reason I cannot use the following query in Cold Fusion or
Inside the control center for MYSQL or from the command line mysql.
Here is my query:
SELECT * FROM dbwebmaster d2
WHERE (menuid 0 AND website='CMS_INFORMATION' AND parentref = 4 AND
haschildren =1)
I think that I must be missing something, as I agree with all the suggestions that to
change the seperate date element columns to a single date field, but Meli's original
post had a date falling into multiple quarters. Now to my knowledge, a date can only
be in one quarter, from a calendar
I get an error Unable to access primary key each time I attempt to=20
insert or update a record. But everything seems to be OK with my PK.=20
CHECK TABLE doesn't see any problem.
Any idea ?
Regards.
Stéphane
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
you could put a shell script as the actual cron job, and make the file only read-able
by root, using an environment variable as the password passed (defined in shell script
file), so that way even if someone 'sniffs' the process via 'ps -ef' they don't see
the actual password (if they happen to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dan, et al --
...and then Dan Greene said...
%
% you could put a shell script as the actual cron job, and make the file only
read-able by root, using an environment variable as the password passed (defined in
shell script file), so that way even
I am in the process of regenerating all the tables as per the
requirement
of custom designed JAVA and JSP codes for 'chemistry' application. It
requires lot of time to read, modify and write back to database.
The Total number of data points per table containing various types of
data (INT, VARCHAR,
Then put it in root's .my.cnf file.
Randall Perry wrote:
Well, this command is running in a cron job -- so that's not an option.
Be aware that you password is visible (unix anyway with a ps -ef..) when you
pass the password like -ppassword. Usually you can enter the password later
if
you
[EMAIL PROTECTED] wrote:
Using MySQL-4.0.15
For whatever reason I cannot use the following query in Cold Fusion or
Inside the control center for MYSQL or from the command line mysql.
Here is my query:
SELECT * FROM dbwebmaster d2
WHERE (menuid 0 AND website='CMS_INFORMATION' AND
Hi there!
I need to do a capacity planning for my MySQL database.
Can anyone help me finding information to do it? is there any methodology or at least
some information about it?
I think I have anything I need to do it, I used to do it for Oracle but we're working
with MySQL now, and I have no
The simplest solution is to keep the password in the .my.cnf file in
your home directory. See http://www.mysql.com/doc/en/Option_files.html
in the manual.
In the case of root cron jobs then, you need a .my.cnf readable only by
root in root's home. It should include
[client]
--- Egor Egorov wrote:
Scott H wrote:
Can't seem to find this one in the manual or
archives - how do I control a db to maintain
its size to an arbitrary value, say 20 GB? I
want to just rotate records, deleting those
that are oldest.
You can't restrict size of the database only
with
I have a situation using InnoDB where I cannot create even the most
basic of tables with a given name.
mysql create table card_batch ( a int );
ERROR 1005: Can't create table './test_gn/card_batch.frm' (errno: 121)
mysql show tables like 'card%';
Empty set (0.01 sec)
mysql show variables like
Hello,
i've just installed the 3.23.57 version in my account and i don't have root
privileges. The problem is the if i try to create a database, like this
mysql create database example;
i get the following message:
Error 1045: Access denied for user : '@localhost'.
Is this because i'm not the
cronjob a sql script that runs a delete statement for old jobs daily
-Original Message-
From: Scott H [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 10:40 AM
To: MySQL Mailing List
Subject: Re: maintaining size of a db
--- Egor Egorov wrote:
Scott H wrote:
Philip,
the problem is probably that the table already exists in the InnoDB internal
data dictionary. With 4.0.17, I get:
mysql CREATE TABLE ids (id varchar(255)) TYPE=InnoDB;
ERROR 1005 (0): Can't create table './test/ids.frm' (errno: 121)
mysql
Output to the .err log:
031112 17:48:39
In order to make sure of a multi-column index, you have to order the
WHERE clauses in the same order as the columns in the index. Since you
query Realm first, then AcctStartTime, then AcctStopTime, MySQL would
use an index on those columns in that order. You can either add a
differently
Hi Fernando;
you are logged in as anonymous user. log into mysql like this
mysql -u root -p
Hit enter if no password is set yet.
--
kind regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql/
On Thursday 13 November 2003 00:47, Fernando wrote:
Hello,
i've just installed
Hi Patrick
How true ;-) hohohoho
Sorry for my really bad English, I just imagine that you might have had an
experience already from somebody taking it literally ??
I will try to avoid it.
Thanks for the warning ;-)
Best regards
Nils Valentin
On Thursday 13 November 2003 01:13, Patrick Dowd
Yes sir, exactly. It's just that's what I'm
looking for, and can't figure out. I can set up
a cron job, but what exactly would the SQL delete
statement be that would allow me to delete old
records in such a way that the db maintains an
approximately constant size on disk? (Failing
that perhaps
Prashant Akerkar [EMAIL PROTECTED] wrote:
We have our application with data tier as mysql database in our office
running on windows platform which we need to synchronize with the same
database on a remote system at data centre on Linux.
Look at the replication:
I get your point Patrick.
I was customer support engineer myself. You cant always think about all
eventualities can you ;-), its really hard and needs a special way of
thinking.
Anyway that little lesson saved my day. ;-)
Thanks a lot.
Nils Valentin
On Thursday 13 November 2003 01:22, you
Dear all
A have a table mytable in which some records have the same value in
col1. I'd like to know how show up only once, how many twice, etc.
The following does what I want, but I think there should be a more
elegant way, possibly invlving subquires.
create table counts (n int);
insert into
I guess you could say that. The machine is Redhat 9 too. I logged in
locally and connected to the mysql server fine. Everything had appeared
as normal. I could see all the databases, and \u to them.
Is there a way I can turn on some extended logging to get more info on
the problem as it will
What does show processlist say when the connections are maxed out?
(You may have to leave a client logged in to reserve a slot so you can
submit this query.)
If it shows only a few connections, then there's something seriously
wrong. If it shows a ton of idle connections, it should tell you
What I would do is a classical guesstimate
find the average size per record (data file size + index file(s) size / # records in
table)
using that, find the data used per day
using that, figure out how many days, on average it takes to hit 20GB
let's say it's 89 days.
right off the top,
Hi
In version 3.23.57 when i do a rollback i get this error message and the changes are
not undone, why?
This is what i typed: (NOTE: 'insert.sql' insert a row correctly in an InnoDB table)
mysql SET AUTOCOMMIT=0;
Query OK, 0 rows affected (0.00 sec)
mysql BEGIN;
Query OK, 0 rows affected
On Wednesday 12 November 2003 17.15, David T-G wrote:
% [client]
% password=mysql_root_password
What if one user connects to the database as different users (as I do, in
fact; sometimes all-db-root, sometimes one-db-root, sometimes read-only
user)? Let's back this out of root and go to
Thanks to everybody for helping me.
I agree with the suggestion to change the quarter fields in to
one single field. The suggestion from Dan Greene to store the
quarters as binary values sounds good to me. So I will do it this way.
To explain you more about this table. The quarter
I'm mostly using mytop, and that's the way that I see that there are no
(are almost no) connections when the server claims that it is above the
connection limit... So I guess that there's something seriously wrong
then... Any ideas what?
-- Henrik
[EMAIL PROTECTED] (Pete Harlan) skrev:
What
At 09:24 PM 11/10/2003, Leo wrote:
notice the _and_ ?
*grin*
good point. I guess my reply (which I found out later was unnecessary since
the question had already been answered) would have been better stated had I
just pointed out the distinct keyword rather than constructing a sample
query. :)
Mikael Fridh wrote:
On Wednesday 12 November 2003 17.15, David T-G wrote:
% [client]
% password=mysql_root_password
What if one user connects to the database as different users (as I do, in
fact; sometimes all-db-root, sometimes one-db-root, sometimes read-only
user)? Let's back this out
Joe Lewis said:
We're experiencing the same issues, but not neccesarily after an
upgrade. We're using MySQL 4.0.12 and FreeBSD 4.7 Release. We're
getting max'd connections only on specific users, and the show
processlist is returning only the show processlist process. the
results of
Hi all
Curious as to what happens after data is repeatedly
selected from a mysql table overtime. Does it
accumulate as junk data, stored at some location and
eventually slow down the database/program/server?
Does any purging have to take place?
Thanks
J
__
Do
From the manual:
1.8.4.1 Subqueries
Subqueries are supported in MySQL version 4.1. See section 1.6.1 Features
Available in MySQL 4.1.
Hope that helps,
Mike
-Original Message-
From: Scott H [mailto:[EMAIL PROTECTED]
Sent: 12 November 2003 17:45
To: Dan Greene; MySQL Mailing List
William R. Mussatto skrev:
Joe Lewis said:
We're experiencing the same issues, but not neccesarily after an
upgrade. We're using MySQL 4.0.12 and FreeBSD 4.7 Release. We're
getting max'd connections only on specific users, and the show
processlist is returning only the show processlist
Yes let it finish. Never stop a repair in progress. Now myisamchk is
rebuilding the index file since youre the table is extremely corrupt.
Myisamchk can run faster if you set some buffer properties. Put this in
youre my.cnf file for next time.
[myisamchk]
key_buffer=256M
sort_buffer=256M
Hi,
I wish to make a pull for mysql-5.0 from http://mysql.bkbits.net but always is
nothing to pull.
I try with :
bk pull http://mysql.bkbits.net/mysql-5.0
I wonder, what happens ?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: joffrey leevy [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, November 12, 2003 9:58 AM
--To: [EMAIL PROTECTED]
--Subject: newbie question on
I'm sorry I didn't explain anything.
The problem is that it 's too slow and the result doesn't appear. I am going
to try to explain the query.
Fields from Table FASE: (300.000 records)
ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
SQL_ID_PY char(6),
SQL_ID_CE char(6),
PR_flag INT,
Hello All,
Can a 64-bit MySQL client connect to a 32-bit server? Are there any
restrictions?
Thanks,
Dave Ritter
--
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
Mike --
...and then Michael Stassen said...
%
% Mikael Fridh wrote:
[And thank you to Mikael, too.]
%
% On Wednesday 12 November 2003 17.15, David T-G wrote:
%
% What if one user connects to the database as different users (as I do, in
...
%
%
Is there a way to abort a query after it's running?
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanx so much! mysql_real_connect() certainly works.
Best,
hAj
on 2003.11.11 17:55, Nick Gaugler at [EMAIL PROTECTED] wrote:
http://www.mysql.com/doc/en/mysql_connect.html
This function is deprecated. It is preferable to use
mysql_real_connect() instead.
#includestdio.h
Jonathan Terhorst wrote:
I can't figure out if this is actually challenging or if it's a stupid
question. Table1 is a normal old relation that describes a bunch of objects:
Table1 (id INT PRIMARY KEY NOT NULL, Name varchar(255), Size int) etc.
Associated with each Table1 record is a
On Wed, Nov 12, 2003 at 02:29:12PM -0500, Jeff McKeon wrote:
Is there a way to abort a query after it's running?
You can use the KILL command from a separate connection.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL
I would like to backup databases from a linux MySQL server to another
linux machine on the same private network but I don' see in the docs how
I can do this with mysqlhotcopy or mysqldump. Is there any way to do
this besides using ftp.
Any help would be appreicated.
Richard
--
MySQL General
Hi,
Repost - its happened again. Anyone any ideas PLEASE!
Hi,
Advice on the cause of the following table corruption would be much
appreciated.
Some background:
This customer has been running MySQL for 3 or more years, and, for back
up purposes, shuts MySQL down each night, takes a
Is is possible to do a select query with a left join from a real table
to a temporary table? I'm trying it but keep getting unkown table
'tablename' in field list error.
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
mysqldump -uname -ppassword -BDatabase | mysql -uname -ppasswrod -Ddatabase
-hremotehost
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:54 PM
To: [EMAIL PROTECTED]
Subject: Backup question.
I would like to backup databases from a
ERROR: Error in Log_event::read_log_event(): 'Event too big', data_len:
1597257529, event_type: 49
ERROR: Could not read entry at offset 240378281 : Error in log format or
read error
On the master it's reporting this error. The data_len is 1.48 GB which
is an error. I know that this is not the
Create the column as a timestamp and the column will be updated on insert
and update.
-Original Message-
From: Mikel - [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 10:17 AM
To: [EMAIL PROTECTED]
Subject: table creation
Hello list:
Is it possible to create a table with a
You should determine where your bottlenecks are first. Are the updates on
columns with keys? Can you disable the keys during the load? Are you using
extended inserts? Is there available memory? What is the cpu doing? etc...
-Original Message-
From: karthikeyan [mailto:[EMAIL PROTECTED]
you may be able to put both statements to a text file, let's call it deleteold.sql
then your cron job would be :
mysql (put your connect stuff here) deleteold.sql
-Original Message-
From: Scott H [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:17 PM
To: Michael
Would anyone be kind enough to provide an example of using MySQL 4 with it's
apparent built in SSL functionality to connect from a Win client to *Nix
box?
Am I correct in assuming that this new functionality means that I will not
have to use stunnel or ssh tunneling?
Thanks for any info!
--
Unless I am misinformed, subscription to the DIGEST format of this list
should cause all messages to come in one daily e-mail? Can someone else who
is subscribed this way please at least let me know that this is at least the
case for them?
I continue to get every single post as an individual
Hello,
My Load data command seems not to load data into my db:
mysql load data local infile '/opt/week/ip.0311100440' into table logs.Nov03 ignore 2
lines;
Query OK, 1 row affected (0.66 sec)
Records: 48273 Deleted: 0 Skipped: 48272 Warnings: 48273
mysql
I have plenty of space where my
Can this be done?
No, I do not mean running multiple MySQL servers.
I need to have MySQL listen on two separate ports at the same time.
Reason being, the new port is needed for a routing issue, and the
default port 3306 needs to stay up to respond to normal traffic.
--
MySQL General Mailing
Yes, you can do it like this:
Prompt mysqldump --add-drop-table --host=source.IP.addr.spec -uuser
-ppassword databasename | mysql -uuser -ppassword
I've found that it helps things if you add --no-data to the source side on
the first pass, then remove that clause and run it again.
Dave
your best bet would be to do a port-forwarding methodology, at the os level, not in
mysql itself
I've used some for SOAP tracing, to intercept and view http traffic, but I'm sure
there are some out there that just forward traffic w/o a gui
-Original Message-
From: Misaochankun
Cool idea, but I don't think you can really do
it. When I try, mysql just gives me back the
syntax stuff. sigh I'm a bit perplexed - I
would have thought this would be a semi-common
issue in db maintenance, but no one seems to have
set this up. I'm still trying, please send any
other
* Elisenda
The problem is that it 's too slow and the result doesn't appear.
I am going to try to explain the query.
Please do that using the EXPLAIN SELECT statement:
URL: http://www.mysql.com/doc/en/EXPLAIN.html
This will show what index is beeing used on the different joins, and
HI list
When installing mysql 4.16 on debian linux 2.4.20-20.8smp
I get the following errors...
---snip-
--
031112 16:05:08 mysqld started
031112 16:05:08 InnoDB: Started
031112 16:05:08 Fatal error: Can't open
There is a C++ package called OTL (http://otl.sourceforge.net/home.htm).
It supports both MySQL through MyODBC, and Oracle. It works great with
Oracle applications, but we have not used it with MySQL.
Thanks,
Brad Teale
Universal Weather and Aviation, Inc.
mailto:[EMAIL PROTECTED]
713-944-1440
Have you checked permissions - the files should be owned by mysql
Peter
-Original Message-
From: DePhillips, Michael P [mailto:[EMAIL PROTECTED]
Sent: 12 November 2003 21:38
To: [EMAIL PROTECTED]
Subject: new install failure
HI list
When installing mysql 4.16 on debian linux
When I run:
mysql -p password -u username log_db_name
deleteold.sql
...and within deleteold.sql, I have only this
text (2 lines):
select (@aa:=seq) as low_seq from syslogTB order
by seq limit 1000,1;
delete from syslogTB where seq @aa;
I just get back a screen full of syntax
suggestions.
That did it thanks Pete
I need to my installs earlier in the day ;)
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 4:44 PM
To: DePhillips, Michael P; [EMAIL PROTECTED]
Subject: RE: new install failure
Have you checked permissions
have you verified that the number of columns match? That the data types are
matching as well?
-Original Message-
From: rmck [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:01 PM
To: [EMAIL PROTECTED]
Subject: LOAD DATA ?
Hello,
My Load data command seems not to load data
Hey - Progress! But first, I had to correct:
can't use -p password, must use the longer
form: --password=password
Then I can run it! One problem. It deleted the
first 1000 records, rather than leaving the last
1000 records in the db. What twist is needed to
get that right? ?
--- Scott H
Would someone please explain how to set the number of child mysqld
processes which start when mysql (mysql-standard-4.0.14-pc-linux-i686)
starts up?
I am using MySQL on a memory-poor (32MB RAM) machine, and MySQL
seems to hog about 10MB per child process, and there are ten (10)
You can emulate this using IPTables and a FORWARD rule. If you are
unfamiliar with IPTables see http://www.iptables.com/ for documentation.
Misaochankun wrote:
Can this be done?
No, I do not mean running multiple MySQL servers.
I need to have MySQL listen on two separate ports at the same time.
We will most likely be using that method.
We have to translate our ipchains to iptables first.
-Original Message-
From: Kevin Carlson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 2:56 PM
To: Misaochankun
Cc: [EMAIL PROTECTED]
Subject: Re: Having MySQL listen on
Hi. using MYSql 3.28
I have a surname column with a standard index and this is the column
were search are performed on, currently the filed only has the one name
i.e.:
Surname: smith
I want to include other column data in the search i.e. fathersname, so I
create an index on that column and
I use the following function in Oracle
SELECT decode(status,'A','Active','L','Active','Former') FROM Table
What it means is: if table column status = A, return Active, if status=L, return
Active, else return Former in the select statement.
Decode in mysql has nothing to do with this
The IF function works pretty much like Oracle's decode. But I recommend
using CASE..WHEN for compatibility between the two.
Check out:
http://www.mysql.com/doc/en/Control_flow_functions.html
-Original Message-
From: Jonathan Rosenberg [mailto:[EMAIL PROTECTED]
Sent: Wednesday,
Hi George,
On Thu, 2003-11-13 at 08:49, George Webb wrote:
Would someone please explain how to set the number of child mysqld
processes which start when mysql (mysql-standard-4.0.14-pc-linux-i686)
starts up?
I am using MySQL on a memory-poor (32MB RAM) machine, and MySQL
seems
Hello List,
I have a table named CHECK_SBIN with fields id,jobid,filename,sbin,count,
then I would like to create an account lets say testuser with SELECT
privileges only to a specific columns. In this case I would like to open
only id and jobid to 'testuser'.
I have already created an account
Hi.
Can someone help me with problem of max connection when it rech the limit
cause some process has lock table so I want to login as root to make some
kill that process but I can login because of max connection bloack me.
And I known some user with PROCESS_ACL can login is root has this
Hi,
No problems there:
031113 1:18:33
/applic/mysql-max-4.0.13-dec-osf5.1-alphaev67/bin/mysqld: Normal
shutdown
031113 1:18:34 InnoDB: Starting shutdown...
031113 1:18:36 InnoDB: Shutdown completed
031113 1:18:36
/applic/mysql-max-4.0.13-dec-osf5.1-alphaev67/bin/mysqld: Shutdown
Complete
That second query, byt itself, should have done it, were you logged in as
testuser when you tried to run it?
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 5:26 PM
To: [EMAIL PROTECTED]
Subject: GRANT TO SELECTED COLUMNS
1 - 100 of 110 matches
Mail list logo