On Thu, 10 May 2001, roger westin wrote:
We have a database of size 10GB and its index is also
almost of the same size. Now we want this database in MYSQL.
Please let me know how we can slpit it across 3-4 hard
disks.We are using Linux 6.2
Hi there,
My self I have a machine runnig RH
On Fri, 11 May 2001, Anthony Colli wrote:
Hi all-
I am really new to the list and mysql. Here is my Question.
I am used to writing SELECT TOP [num] FROM [table]
I have searched the documentation online and found no mention of how to do
this. But I did find info on LIMIT that limits
Is anyone using mysql for OLAP? Any particular tools to check?
thanks in advance,
thalis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
On Sat, 5 May 2001, Daniel Goldin (E-mail) wrote:
I'bve been following SAM'S TEACH YOURSELF MYSQL and hit a glitch. Whenn I do
what I'm told to do create passwords here's what happens
prompt insert into user (host, user, password) values('localhost', 'myname'
password('testpass');
Try
Check out the myisamchk manual page and the --set-auto-increment[=value] flag.
regards,
thalis
On Fri, 4 May 2001, Stefan Wehowsky wrote:
Let´s say I got a column id that is of type tinyint and has the extra
auto_increment. Let´s further say that I have 50 entries in that
column. Now if I
On your mysql monitor do:
mysql tee filename.out
This will redirect everhting to filename.out besides ptinting it to the screen.
Alternatively from you shell:
$ echo show status;|mysql -u thalis -p lala filename.out
regards,
thalis
On Fri, 4 May 2001, Tim wrote:
Is there any way to
On Fri, 4 May 2001, Joel Desamero wrote:
Hello,
I was wondering if there is a way to aggregate string values when grouping together
results. I guess what I'm looking for is the string version of the SUM() function. Is
there such a thing in MySQL?
Thanks.
No. You could write your UDF
Hello all,
mysql uses only one index for the entire execution of a query? i.e. if it uses
one index to do the row retrieval because it matches the where criteria but then has
to sort these rows on something else that would benefit from index, would mysql use
this index?
tia,
thalis
Your mysql database (a system db with the access privileges) has a table called host
which has amongst other files, one called host.frm
It seems that mysqld doesn't have permission to read this file.
Check that the mysqld owner and this file's owner are the same and change accordingly.
regards,
On Mon, 30 Apr 2001, ryc wrote:
I have a fairly large table (greater than 4mil rows) that I would to preform
a query like:
SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50;
I have an index on the table INDEX1( a,b,c );
When running the query as is, it takes around
On Tue, 1 May 2001, Thalis A. Kalfigopoulos wrote:
On Mon, 30 Apr 2001, ryc wrote:
I have a fairly large table (greater than 4mil rows) that I would to preform
a query like:
SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50;
I have an index on the table INDEX1
On Tue, 1 May 2001, Graham Nichols wrote:
I have a table which contains a date column and an order_number column. I
need to formulate a query syntax to return the total number of orders for
each day in a given month (if any). Can someone help me with the syntax
please as I've been stumbling
On Tue, 1 May 2001, ryc wrote:
I have a fairly large table (greater than 4mil rows) that I would to
preform
a query like:
SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50;
I have an index on the table INDEX1( a,b,c );
When running the query as is, it
Hello,
The index you have created is just fine and should be utilized as long as you perform
a query that needs to use an index.
Your query:
select a,b from t;
doesn't have any conditions imposed upon the table's rows. It just asks for all the
them. Simple file scan.
regards,
thalis
On Mon,
-
Fra:Thalis A. Kalfigopoulos [SMTP:[EMAIL PROTECTED]]
Sendt: 30. april 2001 15:42
Til:Wix,Christian XCW
Cc: '[EMAIL PROTECTED]'
Emne: Re: index troubles
Hello,
The index you have created is just fine and should be utilized as long as
you perform a query
I'm having the following problem with the IGNORE INDEX()/USE INDEX() directives on a
mysql 3.23.32
mysql explain SELECT age_0,reliable,COUNT(*) FROM age,reliable WHERE age.id=rel
iable.id GROUP BY age_0,reliable;
+--++---++-++-+-
Not understanding excactly why you'd need a random string, I'd suggest doing a simple
password() call on each row's recipient
ALTER TABLE ADD COLUMN rand_string char(16) NOT NULL;
UPDATE my_table SET rand_string=password(email);
This gives you a 16 char long (I think) random string.
Sending
You can't with MyISAM and executing from shell prompt.
Either alter the table type to BDB or Innobase
If you stick with MyISAM you can use a higher level language (perl,php) to check the
return value of each insert and handle the flow accordingly. If the 2nd insert fails,
you'll have to
On Tue, 10 Apr 2001, Peter Pentchev wrote:
First, get a book on SQL. Read about joins in SELECT statements.
Then, if you still need a quick answer, try the following:
INSERT INTO table_c(name, score)
SELECT name, a.score - b.score
FROM table_a a
LEFT JOIN table_b b ON b.name = a.name;
Hello all,
Does anyone know:
1. what the disadvantages/advantages are in building a static binary (EXCEPT for the
extra space)
2. read somewhere that turning of the swap could improve performance. Anyone can
testify for or against that?
3. is there a potential impact in performance when
I sent that reply about this 1 WEEK Back.
Look up safe_show_databases and skip_show_databases in
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
regards,
thalis
On Mon, 9 Apr 2001, Fabien Salvi wrote:
Hello, is it possible to prevent users from seing other databases than
the one there
I haven't read Mysql's authorization mechanism from Paul's book, but from the Oreilly
book and it was pretty comprehensive and intuitive. I suggest you borrow that book
from your local library or buy it.
To try to write here about how it works would be a waste of time for both of us. It is
On 9 Apr 2001 [EMAIL PROTECTED] wrote:
Description:
Attempting to delete all records in a table containing NULL values in a
UNIQUE KEY field does not work as expected. Only a single record is deleted,
presumably because the server thinks that the table will only have one record
with a
I don't know if the manual says anything about this but if you check Paul's book page
150 (paul now we are referencing your book down to page level) it says:
"creating a table by selecting data into it does not automatically copy any indexes
from the original table"
regards,
thalis
On Sun,
On Sun, 8 Apr 2001, John Hart wrote:
I am working on a rather large database project, in which I am making a text column
that contains different data, seperated by commas. What I need to do is run a query
where I will return only the datasets that contain any of sets that partially, or
On Sun, 8 Apr 2001, Stephen U. Lee wrote:
i want to replace all occurences of www to http://www in all columns of a
table.
the column contains blocks of text.
is there any way to do this directly in mySQL?
Check the manual for the infinite String manipulation functions.
If all your
On Sun, 8 Apr 2001, Realbad Atgames wrote:
--- [EMAIL PROTECTED] wrote:
Hello, I'm new to MySQL and have ran into a
problem in
designing my database. I have a table of items, A,
and
each item should have any number of other records
from
another table, B, associated with
Yes, but in his case there is a full duplicate of every row for every column, so just
specifying one of the columns will do the job.
regards,
thalis
On Fri, 6 Apr 2001, Gerald Clark wrote:
You need to specify those columns that need to form a unique
combination,
"T
On Wed, 4 Apr 2001, Ashley M. Kirchner wrote:
Db - table1, table2 and table3
SELECT table1.task, table2.comment, table2.remarks, table3.history
FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;
Results
On Thu, 5 Apr 2001, Pete Koning wrote:
Greetings!
Quick background: i have extensive RDBMS experience (sybase, progress)
but have been "out of the loop" in this field for a few years working
as a sys-admin for a linux/unix-based ISP in Canada.
We want to host a web-based resource
On Thu, 5 Apr 2001, Ashley M. Kirchner wrote:
"Thalis A. Kalfigopoulos" wrote:
+--++--+-+
| task | comment |remarks | history |
+--++--+-+
| task_1 | cmt_1|
On Thu, 5 Apr 2001, Santiago LLobet wrote:
Hi,...
We've got a MySQL server running with a lot of different databases that have the
same table-structure.
Does anybody knows how to make an SCRIPT that performs an administrative task
(like ALTER TABLE 'table_name') in all the
On Thu, 5 Apr 2001, Gerald Clark wrote:
Another thought.
These are isam tables, not myisam tables.
Unless the two machines are the same hardware type and operating system,
you
can't just copy the files over. Use msqldump.
Actually I was under the impression that the way the files were
On Thu, 5 Apr 2001, Roel Vanhout wrote:
Hi all,
Is there a way to turn the query logging on and off while the database
server is running? Right now I have a script that stops and restarts the
database with loggin on or off depending on the parameters, but this is
not so great; I was
On Thu, 5 Apr 2001, Dennis Gearon wrote:
Are people using Mysql using foreign keys and how are they using them?
It seems that the way to use them is with the scripting language used to
access the database.
Sure we are...the manual way i.e. one insert/delete at a time for each foreign key
On Thu, 5 Apr 2001, Kris Gonzalez wrote:
when adding a new user or changing the authentication information for
existing users, the changes often do not take effect unless i take down
and restart 'mysqld'. example: changing root's password and exiting
the mysql client, i cannot log back in
On Fri, 6 Apr 2001, K. C. Huang wrote:
The question is regarding the previleges config on a virtual server enviroment.
I managed to set the previleges for the user so that he can not access databases
other than his own, but one problem still bothers me.
The user is able to list (show
On Fri, 6 Apr 2001, Vigile wrote:
I have a table, that DOES NOT have a primary key, but is setup like this:
Field Type Attributes Null Default Extra Action
PageID int(11)No 0Change Drop Primary Index Unique
ArticleID int(11)No 0Change Drop Primary
On Tue, 3 Apr 2001, Marcos wrote:
hi,
i would like to show 5 random field from a total of 100.
id is my primary key
id name
--
abmarcos
akjohn
how can i show 5 of them randomly?
thanks in advance,
marcos
When you say "5
Check the manual for the TIMESTAMP datatype. Will hold the last update time per record
abd therefore the insert time that you want.
regards,
thalis
--
No excellent soul is exempt from a mixture of madness.
-- Aristotle
On
On Fri, 30 Mar 2001, Herman Pool wrote:
Hi out there,
I'm new with MySQL.
I have installed Linux 6.0 and MySQL 3.23.33
This happens when I want to create a database:
[mysql@nestorix mysql]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 49
On Fri, 30 Mar 2001, Kristopher Briscoe wrote:
Two things that I am sure will be answered very quickly.
1) I have a development box that I have successfully installed and
configured 3 seperate instances. Each instances has its own port number.
When playing around with mysqladmin I know
On Thu, 29 Mar 2001 [EMAIL PROTECTED] wrote:
Hi,
I have two database`s with one table in each. (MySQL)
Is there a way that I can select data from one table and then match it with
the data in another and discard the results so all I am left with is the
original data from the first
Hello,
A question about the -O option you can pass on command line to safe_mysqld.
If for example I give -O record_buffer=64M does that mean that I'll get:
exactly 64M,
at the most 64M
or at least 64M?
Also I have a batchfile with about 150 queries (all plain selects) which I feed into
mysql.
SELECT COUNT(DISTINCT ID) FROM my_table;
Note: NULL values will be omitted from the count.
regards,
thalis
p.s. would be a good idea to read an SQL tutorial before your next post
On Thu, 29 Mar 2001 [EMAIL PROTECTED] wrote:
Hi, I am trying to count all the distinct id numbers in a
On Mon, 26 Mar 2001, Maros Klempa wrote:
Hi,
I have two servers with MySQL 3.23.24-beta. One as master and one as slave.
Replication between this two servers work fine. Now I want store pictures
to table. On master server I use command
INSERT INTO PICTURES (ID, PICT) VALUES (1, LOAD_FILE(
On Mon, 26 Mar 2001, Daniel Adams wrote:
Well, I wanted to limit the size of the index so it wouldn't take up a
lot of space. The message table is about 500mb right now and is going to
get a lot bigger. Well not limiting the size of the index get rid of the
error?
Actually you should
Hello,
I did something dumb: ran myisamchk while mysqld was up and running and, being
on a linux system, I run the deamon with --skip-locking. This is what I guess made one
of my tables appear to be empty. According to the manual if you run myisamchk while
someone else is doing an
Also with regard to the lost 32 recs, the error log mentioned:
010323 5:41:50 read_const: Got error 127 when reading table ./eval/reviewer
Where perror gives:
127 = Record-file is crashed
And Mysql version: 3.23.30-gamma-log
regards,
thalis
On Fri, 23 Mar 2001, Johan Vikerskog (ECS) wrote:
I am not sure if i should post it here but please do help my if you can.
The script is as follows:
html
body
?php
mysql_connect (localhost, username,
On Fri, 23 Mar 2001, Markus Siagian wrote:
Hi,
I'm still a newbie in mysql and also sql statements.
I
was wondering if some one can help me with this
problem.
I'm trying to select 5 of the highest values from a
table. But i can't seem to find any help from the
manual and also
Since you updated both mysql and php you presumably should recompile apache as
well. A quickdirty solution though could be to just create a link:
libmysqlclient.so.6.0-libmysqlclient.so.10.0 and see what happens from there :-)
regards,
thalis
On Fri, 23 Mar 2001, Colonel
On Fri, 23 Mar 2001, Daniel Adams wrote:
Can someone please tell me what the problem is below. All I am trying to
do is pipe a backup created with mysqldump into mysql and it gives me
this error:
ERROR 1071 at line 1291: Specified key was too long. Max key length is
500
It is excactly
I don't know how you define 'minimal' but approximately 100+ emails per day from the
user list and a response time from 5 minutes to 24 hours should be adequate for the
average "small-time real estate company" as you call it. Coming to "What will you guys
answer and not answer", I guess there
I think that Benjamin was trying to make a point here regarding an easily reproducible
scenario (I don't care if you wanna call it a "security flaw" or a "flying pig") under
some conditions which are not that hard to come upon in the real world.
The problem that really comes to mind is that
Dear Santa,
here is my wishlist:
I wish that the mysql utility had support for the shell's history functions. I catch
mysql so many time doing something like !show
regards,
thalis
-
Before posting, please check:
On Sat, 17 Mar 2001, Denis Mettler wrote:
Hi there,
Another problem.
i have the following tables:
table 1:
id, primary key, auto increment
name varchar(50)
city varchar(50)
phone varchar(25)
table 2:
categorie_id, primary key, auto_increment
kategorie varchar(50)
in table
On Fri, 16 Mar 2001, Jason Landry wrote:
Subqueries like that won't work until version 4.0.
for now it's rather ugly and inefficient, but one way you could do it would
be like this:
select table1.*, ifnull(table2.column2,-1) as marked from table1 left join
table2 on
What's wrong with SUM?
select sum(count)
from table;
Does it get any simpler than that?
regards,
thalis
On Wed, 14 Mar 2001, Maxim Maletsky wrote:
Hello everyone,
I have a quick question:
the following table keeps a track of logged in users.
CREATE TABLE auth_lost_in_space (
On Fri, 2 Mar 2001, Nick Kostirya wrote:
Hi, All!
Please, give me an opinion about multiple-column index.
May I create the UNIQUE multiple-column index, which the index of each
column is not UNIQUE in?
If yes than how do it?
Best.
Nick.
When you create a multi-column unique index, it
On Fri, 2 Mar 2001, Gerald L. Clark wrote:
The manual tells you how to reset a forgotten password.
It also tells you not to mess with these tables, but to use.
GRANT and REVOKE. We all have to explore everything,
dont't we?
Worst case, kill mysqld and reinstall privilege tables with
Did you change the permissions of the files after starting
the sever, or before?
Did you read the GRANT section of the manual.
Does your user have the UPDATE privilege?
Raman Aggarwal wrote:
Dear Sir
I am a regular user of MySql. I will be obliged if you help me.
1. The
Hi,
I've installed MYSQL on Red hat.
I'm trying to run the command
mysqlaccess
It asks for the Password for MySQL superuser root:
Can anyone tell me the password for this?
Thanks
Sandeep
mysqlaccess is a perl script to check the access priviliges of a user:db:host
On Fri, 2 Mar 2001, Richard Vibert wrote:
Hi,
I having trouble working out how to get a result set similar to the
following where I select from a table with Date Sales column.
My specific question is can I have a column that accumulates values, if so
could I have some guidance on how
:52 pm 2/03/2001, Thalis A. Kalfigopoulos wrote:
On Fri, 2 Mar 2001, Richard Vibert wrote:
Hi,
I having trouble working out how to get a result set similar to the
following where I select from a table with Date Sales column.
My specific question is can I have a column
Maybe I'm too tired to see straight and the answer is looking at me straight in the
face but that was my $0.02 anyhow.
regards,
thalis
On 2001.03.01 23:49:28 -0500 Thalis A. Kalfigopoulos wrote:
Now that I notice more closely the numbers, my answer was obviously wrong
with regard to the 3rd
This should be very simple, but for some reason, my query does not return the
desired results
I have the following two tables:
CREATE TABLE Rank (
Rank CHAR(40) NOT NULL PRIMARY KEY,
ReportsTo CHAR(40) NULL
);
CREATE TABLE ROSTER (
EntryNumber INTEGER NOT NULL AUTO_INCREMENT
On Thu, 22 Feb 2001, Oson, Chris M. wrote:
Good Day All
I have two tables...
Table 1
---
MSRSectionID ContractID Heading
1
1 107 Technical Progress:
7107 Technical
If you are using PHP there is the htmlspecialchars() function that will do just that
for you.
cheers,
thalis
- Original Message -
From: "Robert Heron" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001 6:35 PM
Subject: special characters in MySQL query
On Tue, 13 Feb 2001, Peter Skipworth wrote:
Or a handy one-liner...
perl -pi -e "s/[\012\015]//" *.sql
Or alternatively edit the file with vi and do:
:s/
//
This inteprets to the following keystrokes:
':' colon
's' s for substitute
'
' Ctrl-v-m to create the annoying ^M as
Or a handy one-liner...
perl -pi -e "s/[\012\015]//" *.sql
Or alternatively edit the file with vi and do:
:s///
This inteprets to the following keystrokes:
':' colon
's' s for substitute
''Ctrl-v-m to create the annoying ^M as one character
'//' two slashes
This is a reply to the SET column UPDATE question (I deleted to e-mail, oups!).
The question was that you have a column of type SET and value ("a,b,c") and you want
to make this ("a,b,c,d")
In the __MySQL MANUAL__ it says that the SET type is actually stored numerically and
in particular "with
Has anyone tried running the TPC-W benchmarks on MySQL? I'm not talking about making
the results official (I assume too much $$$) but just to implement them and see how it
goes.
cheers,
thalis
-
Before posting, please check:
I'm new too, but a good starting point would be:
http://www.mysql.com/doc/T/a/Table_types.html
regards,
thalis
---+
You're definitely on their list.
The correct question to ask is what list it is.
---+
On Sat, 10 Feb
Hello,
if you want to have a file with just the bare data contents of the table, you simply
do:
mysql SELECT * FROM table_name INTO OUTFILE '/tmp/lala.txt';
otherwise if you want your data represented in SQL, so that you can reconstruct the
table by importing at a later time (a backup form):
75 matches
Mail list logo