take a look at /var/mysql :)
- Original Message -
From: "Philip Mak" [EMAIL PROTECTED]
To: "feldekis" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, April 18, 2001 11:59 PM
Subject: Re: there is no mysql/var directory
On Wed, 18 Apr 2001, feldekis wrote:
Hi everybody!!
On Thu, 19 Apr 2001, feldekis wrote:
./bin/mysql -p -user=root
Enter password: password
ERROR 1045: Access denied for user: 'ser=root@localhost' (Using password: YES)
^
mysql -p -u root, not mysql -p -user=root
pz
--
Bartosz Sienkiewicz
Hello everyone! This is the first time I post here, so please bear with me.
It all started when I deleted a whole table by mistake. So I try to
recovered it by copying yesterday's backup. I had never done that before and
it all worked wrong. I found out MySQL server had to be restarted in order
- Original Message -
From: John Dean [EMAIL PROTECTED]
To: Yusuf Incekara [EMAIL PROTECTED]
Sent: Wednesday, April 18, 2001 10:39 PM
Subject: Re: Plase Let us know if there is a Racialism for Mysql product and
quit
At 18:50 18/04/2001 +0300, you wrote:
You said :
Only those who don't
on my linux boxes this is:
/etc/rc.d/init.d/mysql stop | start
- Original Message -
From: "Martin Cabrera Diaubalick" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 19, 2001 9:42 AM
Subject: Help restarting mysqld !!
Hello everyone! This is the first time I post here,
Hi,
I'm using two Mysql 3.23.36 with Innobase tables on two machines running
Redhat 7.0.
I'm trying to use replication in a simple master/slave configuration,
but while it works
when I use MyIsam tables, if one of the two machines tries to use
Innobase tables
the replication doesn't work,
Please help me.! I want to Query column name to a string, But i
don't know command that i should to use.
Reguards.
Mongkol
Yusuf,
i don't understand why you are so angry and are trying to fight it out on
this list.
1. Loads of computer-related things are vulnerable for different
explanations. especially with software that is easily ported between
platforms, it's also easy to have a manual that is not dedicated for
After some hour my Database return this error message:
Warning: MySQL Connection Failed: Can't create a new thread (errno 12). If
you are not out of available memory, you can consult the manual for a
possible OS-dependent bug in conn.php3 on line 7
At conn.php3
Are there any suitable training materials on your website? In particular,
how can I best use the GUIs in WinMySQLAdmin?
Try a few of the websites already mentioned in other postings.. I think
www.devshed.com is a nice place to start.. But you can find plenty others
in the manual.txt found
Dear Ren ,
First of all i apologize from all mysql list and
all mysql team (except one :) )
I think this is a virtue that realizing when to stop and when to apologize.
your product and your documentation works fine
and i am not directly blaming anyone related to this product.
The problem is
Hi,
I have a list of words entered into a search engine held in a database. I
wish to be able to select the top 10 words held in the database. I've
fiddled around with ORDER DESC, DISTINCT and LIMIT etc but I can't hit upon
the SQL syntax to obtain the correct result. Can someone please shine a
According to crash me the function randomization 'RAND' is supported by SQL
7.0 AND MYSQL. i AM USING SQL 7.0 and when i test the SQL the results are
returned in the same order everytime. It seems that 'Rand' is recognized,
but it isn't executed.
Anybody else had this problem?
Paul
select word, count(word) as c from tablename group by word order by c
desc
On Thu, 19 Apr 2001, Graham Nichols wrote:
Hi,
I have a list of words entered into a search engine held in a database. I
wish to be able to select the top 10 words held in the database. I've
fiddled around with
Hello,
I have a rather easy question, but for some reason I can't figure it out.
What I want is a column that will indicate when the record was added, but
not when it was modified. I know a timestamp column will do the first half
of the trick, but not the other half.
The prefect solution would be
Hi,
I have a list of words entered into a search engine held in a database. I
wish to be able to select the top 10 words held in the database. I've
fiddled around with ORDER DESC, DISTINCT and LIMIT etc but I can't hit upon
the SQL syntax to obtain the correct result. Can someone please shine a
Peter Skipworth writes:
Hi all,
Has anyone experienced anything like the following ?
I have several queries which, admittedly, are quite complex and operate on
several million rows of indexed data. The tables are naturally locked
while the query occurs, which is fine, but what is *not*
Steve Newell writes:
NOTE: I have cross-posted this to the plusplus mailing list as well.
I am using sql_create_basic_N to generate structures that mirror my database
tables. The problem I have is that some of the fields in my database are
"blobs" that need to be escaped before
Hi,
I have my data in MySQL DB on a Linux machine. And I want to load same data
on a Windows 2000 server. On Linux I can easily do it using mysqldump and
mysqlimport commands but on widows I am unable to load data (which I dumped
from Linux in a .txt file)
I tried LOAD DATA and mysqlimport
$B$3$s$K$A$O!"5W$7?6$j$NEj9F$H$J$j$^$9!#$?$1$&$A$G$9!#(B
Access97 $B$G:n$C$?L>Jm%G!<%?$r!"(BMySQL $B>e$X%(%/%9%]!<%H$7$?$N$G$9$,(B
$B!Vy`!W!V|b!W$NFCDjJ8;z$,F~NO$G$-$J$$LdBj$,H/@8$7$^$7$?!#(B
$B$3$l$i$NJ8;z$O(B Linux $B$N%?!<%_%J%k>e$G$bF~NOIT2D$@$C$?$N$G!"$b$7$+(B
$B$7$?$i(B
pl reply at [EMAIL PROTECTED]
Hi,
I have my data in MySQL DB on a Linux machine. And I want to load same data
on a Windows 2000 server. On Linux I can easily do it using mysqldump and
mysqlimport commands but on widows I am unable to load data (which I dumped
from Linux in a
$B$3$l$O1Q8l$N(BML$B$G$9!#F|K\8l$N(BML$B$r;H$C$F2$5$$!#!J$9$_$^$;$s$,!"F|K\8l$N(BMySQL$B$N(BML
$B$O$I$3$K$"$k$N$,J,$j$^$;$s!#!K(B
(This is an English mailing list. Please use a Japanese mailing list.
Sorry, but I don't know where a Japanese MySQL mailing list is.)
-Philip Mak ([EMAIL
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database,sql,query
If you just reply to this message, and include the entire text of it in the
reply, your
(Is this any help?)(sql)
Hello, I become a contribution of doing it shake it for a long time.
For the list of names data that I made with Access ninety-seven, I did
fGfNfXf|[fg on MySQL
" ?" " ?" A problem that a specific character can't input
occurred.
As it is
Try mysql -u root -p mysql
feldekis wrote:
Hi again...
mysql daemon is running...
i've wrote 1 time: /my/path/mysql/bin/mysqladmin -u root password 'new-password'
nothing happened...
after that, i've tried: mysql -p user=root mysql
here it answers: ERROR 1045: Access denied for user:
PROBLEMS UNDERSTANDING FLOAT/DOUBLE COLUMN TYPES
First could you clarify the contradictions from the following extracts of
the manual.
7.3 Column types
The column types supported by MySQL are listed below. The following code
letters are used in the descriptions:
M Indicates the maximum
I have MySQL running on our server with Apache and php4.
If I try connecting to MySQL server via php I get the error:
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in...
The socket is there and is created when MySQL
Hey all,
I've been using the LIMIT feature for paginating in MySQL for a long time now. It's
really nice and makes paginating extremely simple. Up until now I've been using a
dictionary object to get the same effect out of Microsoft SQL Server. Do any of you
know a LIMIT equivalent for SQL
Nico,
does the table you are trying to replicate contain rows
with more than 8000 bytes of data?
InnoDB (= Innobase) cannot store longer rows. Arbitrary length BLOB and TEXT
fields are on the TODO list for June 2001.
Does the slave hang also for other queries you try to do
on the slave's
Nico,
it came to my mind that possibly 'load table from master' uses
LOCK TABLES to speed up processing in the slave. In 3.23.36
there was a bug with LOCK TABLES in connection with InnoDB
(named the Wisconsin bug).
It might help if you download and compile the new 3.23.37
from the MySQL
"Sica, Bill" wrote:
For instance, say the book price is
$19.44. You also have a base cost of $18, and 8% tax. You can always write a
query to find out the total cost of any book, and get rid of anything to do
with the total cost in your tables.
For all the people who've never designed
SQL Server will allow you to limit a SELECT to the first n rows, but not (to my
knowledge) to skip a number of rows before returning the desired rows.
The mechanism used is SET ROWCOUNT (6.5 and 7.0) or TOP (7.0). The difference is that
SET ROWCOUNT limits the output rows before applying an
Make sure the directory /var/lib/mysql is world readable and searchable.
Craig Pickup wrote:
I have MySQL running on our server with Apache and php4.
If I try connecting to MySQL server via php I get the error:
Warning: MySQL Connection Failed: Can't connect to local MySQL server
Dear Sir :
MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile
a simple C API program which catched from MySQL tutorial, it
chokes at the end of compile process . The program is as follows:
#include stdio.h
#include mysql.h
#define def_host_name NULL
#define def_user_name NULL
When I run safe_mysqld, it starts and ends immediatly. In the mysqld.log in
/var/log it has the following:
010418 21:19:47 mysqld started
010418 21:19:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
010418 21:19:47 mysqld ended
Below is the my.cnf file
[mysqld]
seems redundant and I really hate the fact that LIMIT is not supported.
Any ideas? By the way, suggestions for SQL Server 6.5 or SQL Server 7.0
are both appreciated.
M$??.. thought this was about MySQL :-)
I wouldn't know.. I do know you can find a few newsgroups somewhere at
On Thu, Apr 19, 2001 at 11:12:23PM +0800, john1 wrote:
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x14):undefined reference to 'open64'
/home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
mf_format.o(.text+0x201):undefined
Hi,
We are planning to move on to MySQL.
Could you send us your opinions about MtSQL. It will greatly help us to make decision
and to use MySQL.
Thanks.
Regards,
John Ding
Hallo Leute,
in Oracle kann man Indizes in einer Abfrage abschalten(Full-Table-Scan). Mit +0 oder
||''.
z.B.:
SELECT *
FROM tabelle
WHERE eigenschaft||'' = 'text';
SELECT *
FROM tabelle
WHERE id+0 = 1;
Geht das bei mySQL auch?
We often get a message from MySQL that there are too many connections.
What can we do ?
Should we use connect rather than pconnect ?
We use Php 4.04pl1, Linux, Apache 1.3.17 and MySQL 3.23.32
Regards Jacob
-
Before posting,
Well it is exactly depends on who you are , what are you doing ,
on which platform , for which purposes etc...
- Original Message -
From: johnd [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 19, 2001 6:40 PM
Subject: Run time version of MySQL
Hi,
We are planning to
chown -R mysql /var/mysql
Steve Tuckner wrote:
When I run safe_mysqld, it starts and ends immediatly. In the mysqld.log in
/var/log it has the following:
010418 21:19:47 mysqld started
010418 21:19:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
010418
You're posting to the mysql list asking us how it is? Come on... that's
like asking MS how good Windows 2000 is.
MySQL ROCKS!
At 11:40 AM 4/19/2001 -0400, johnd wrote:
Hi,
We are planning to move on to MySQL.
Could you send us your opinions about MtSQL. It will greatly help us to
make
when I run the command, (in linux) it serves up the variables. But the
variables seem to be much more than what is listed in Paul Dubois' book. So
I am unable to view all of it in terminal. The less command doesnt work with
it either so how can I view mysqladmin variable info?
We often get a message from MySQL that there are too many connections.
What can we do ?
Should we use connect rather than pconnect ?
We use Php 4.04pl1, Linux, Apache 1.3.17 and MySQL 3.23.32
Yes, you should.
That, or increade the amount of allowed connections, or decrease the
I'll try to translate:
in oracle one can turn off indexes within a query (full-table-scan) by
using: +0 or ||''.
for example:
SELECT *
FROM tabelle
WHERE eigenschaft||'' = 'text';
SELECT *
FROM tabelle
WHERE id+0 = 1;
can one do this with mysql?
- Original Message -
From: "Hagen
Description:
I cannot use the application because of socket problems. This
problem occurs with both the binary and source versions. I get the
following error:
[localhost:/usr/local/mysql] root# ./bin/mysqladmin -u root -p
password 'g7ioyhe'
Enter password:
I am trying to understand references in tables and using primary keys with
auto increment option as a reference to all tables:
What is the best way to reference other tables? I have three tables:
menus, categories, and links. I also have an ID field in each table that
uses the autoincrement
Hi,
Sorry for worrying U'll.
I want to know how can I get information about the Memory usage, can I get
details about Database Usage (How much space have used In each database).
Thanx.
--
Dilkushan Karunaratne,
# 50/1A, Sri Indrajothi Road,
Ratmalana,
Sri Lanka.
Tel 94 1 715716
My sugesstion is that you get yourself a decent old workstation, one that you would
probably consider ready
for retirement if it were to still be running MS something...Like say a p200ish
machine with a couple of
gig on the disk and say 32 but prefereably 64M of ram. Slap a cheap NIC, like the
Wade wrote:
when I run the command, (in linux) it serves up the variables. But the
variables seem to be much more than what is listed in Paul Dubois' book. So
I am unable to view all of it in terminal. The less command doesnt work with
it either so how can I view mysqladmin variable info?
problem is I have to use mysqladmin variables -u root -p
PASSWORD:x
I tried piping the less command at the end of -p but it didnt work
Of course it does.
mysqladmin variables | less
-
Before posting,
I can't start mysqld . Can you help me?
Error message:"Can't connect to local MysqlServer through socket 'tmp/mysql.sock"
Hi,
I am using SuSe 7.0 with glibc-2.2-9 installed and installed mySql from
SuSe's ftp server with yast. Contrarily to my normal experience this did not
work:
All errors I detect (by making mysql_install_db or by starting the daemon
with mysqld --skip-grant ) come down to the following error
We are planning to move on to MySQL.
Could you send us your opinions about MtSQL. It will greatly help us to
make decision and to use MySQL.
I love MySQL.. but there are others too. I think their are still some pros
and cons.. given time I think the pros will increase..
Although other
Thanks for help from this group I'm using
"select word, count(word) as total from search_words group by word order by
total
desc limit 20"
to locate the top 20 words in a database of website search engine words.
The database had been altered to include an extra column, other than the
'word'
I just loaded MySQL 3.23.37 binary on my IBM PowerPC based RS6000 computer running AIX
4.3.3.0. When I started MySQL server daemon by executing "safe_mysqld", I got
following error message:
mysqld started on Thu Apr 19 10:58:40 CDT 2001
exec(): 0509-036 Cannot load program
Well,
Check that mysqld is running and that the socket: '/tmp/mysql.sock'
exists.
Neil Mussett wrote:
Description:
I cannot use the application because of socket problems. This
problem occurs with both the binary and source versions. I get the
following error:
You see I have written a small chat server is perl where when a user wants
to chat he simply types the message it gets recorded into mysql and another
program keeps reading the mysql databse and shows the messages. Now, the
same is not yet deployed; but, I fear when I deploy it the program will
Hello again
here send al SQL to generate the database to test in MYSQL,
for example in case that I Question in the query that a Productor
TECUN (1) no cant be return, pepe(2), lolo(1)
CEIS (2) no cant be return lolo(1)
PCMAX (3) no cant be return pepe(2)
A Numbres are the ID In the table cp
Hi all,
I'm creating a fulltext index on a 400MB table, and the creation process
gets very slow. It's fast for the first 50MB of the index, and then it
grinds to what seemed like a halt after days. My question is - is there
anyone who's created fulltext indexes on this much data who can assure
Check out some testimonials at this web site
http://netgraft.com/~mbac/research/mysqlmyths.html
---
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "Scott Baker" [EMAIL PROTECTED]
To: "johnd" [EMAIL
Why would you want to re-use the deleted ID?
That would be a poor design.
When you insert a new record with an autoinvcrement, last_insert_id()
will tell you what it
is so you can insert it in dependent tables.
Fates wrote:
I am trying to understand references in tables and using primary
Hello,
When I am trying to install mySQL on a Solaris8 server I get the
following error:
# ./configure
.
.
.
checking return type of sprintf... configure: error: can not run test
program while cross compiling
Any idea what I need to do?
I have tried to add the
The put the password immediately after the -p ( no space ).
Wade wrote:
problem is I have to use mysqladmin variables -u root -p
PASSWORD:x
I tried piping the less command at the end of -p but it didnt work
Of course it does.
mysqladmin variables | less
Hello, my name is Ben Garvey and I'm doing a research paper on whether
operating systems should be rewritten to offer more support for databases.
What type of operating system features could benefit database implementors?
Thank you in advance.
Ben Garvey
American University
202-332-6218
Believe me, it's not my first choice I hate working with M$ as much as
the next guy. Unfortunately, not every project leans in the direction I want
it to. As far as the LIMIT function goes I think MySQL has spoiled me. The
only easy way to do pagination in ASP is through the ADO Object. The
"select word, count(word) as total from search_words where word IS
NOT NULL group by word order by total desc limit 20"
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]
On Thu, 19 Apr 2001, Graham Nichols wrote:
Thanks for help from this group I'm using
select word, count(word) as total
from search_words
where word is not null
group by word
order by total desc
limit 20
-Original Message-
From: Graham Nichols [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 1:36 PM
To: [EMAIL PROTECTED]
Subject: Correct syntax?
Thanks for help
it is in the FAQ.
On Thu, 19 Apr 2001 20:23:39 +0300, Goksel Misirli wrote:
I can't start mysqld . Can you help me?
Error message:"Can't connect to local MysqlServer through socket 'tmp/mysql.sock"
-
Before posting,
Sasha and Monty,
Nico had a problem in replication with InnoDB tables. Luckily
3.23.37 seems to solve his problems. But, meanwhile I was studying
'load table from master' and noticed that it uses a function
net_read_dump which is only defined for MyISAM tables.
The following printout is from
Would anyone out there have the installation instruction for Mysql for a
FreeBSD 4.2 box???
Larry
P.S. Thanks in advance...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi, Dear Sir or Madam,
I like mySQL very much and today I tried to use mySQLGUI (win32 static binary
1.7.4-2), but I found edit table and create table in commands/tables menu have no
functions. is there any problem?
Sincerely
Edwin Zhang
Are you running the version that came with Redhat 7.0? I had the same
problem and just downloaded a newer version from mysql.com and installed it.
That seemed to fix the problem.
-Original Message-
From: Goksel Misirli [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 10:24 AM
Hi there,
I installed mysql 3.22.32 on Solaris 8 and everytime I am trying to run mysqld it
gives me the following error
ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.2.10.0: open failed: No
such file or directory
Please Advise,
My email address is [EMAIL PROTECTED]
I'll try to translate this as best I can. The sender can likely understand
the response in English, so fire away. If you send them English he'll
probably try (and probably can use) English. If anyone on the list can do
a better job of translating this, please feel free to correct me!
Keep
"MW" == Michael Widenius [EMAIL PROTECTED] writes:
MW We are just now building the first MySQL-Max binaries with support for
MW Berkeley DB and InnoDB tables. The first one will be a Linux x86 RPM
Does this imply that BDB tables are stable enough for production use,
or is it still considered
cd /usr/ports/databases/mysql323-server
make
make install
reboot
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "Larry Caragay" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 19,
I need translate this SQL to any SQL that work in MYSQL
SELECT * FROM cons WHERE NOT EXISTS (SELECT idc FROM cp where
cons.id=cp.idc and cp.idp = 1);
-
Before posting, please check:
http://www.mysql.com/manual.php (the
hi.
the easiest way would be to use the port.
otherwise ./configure (--with-some-options); make; make install and hope for
the best...
more realistically, do the commands one by one, and deal w/ the error
messages as they pop up.
is there specific information that is not on these pages
(
Request help getting myself setup with my website host. They offer mySQL
but do not know very much about it and we seem to be stuck.
the error I am getting is this:
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
where "userid" is my userid and "xx.xxx.xxx.xxx" is my
Usually you need to set your environment variable LD_LIBRARY_PATH to include
the libstdc++.so.2 location (/usr/local/lib maybe ?) when you start mysqld.
Ping Lu
Cable Wireless Global
Network Tools and Analysis Group, USA
W: +1-703-292-2359
E: [EMAIL PROTECTED]
-Original Message-
Is the common way to index a site, then place that into a database? If so
whats the best(easiest) way to index a site? Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I have heard mysql is the access for unix... i would like to hear about
comparisons with Mysql SqlServer and PostgresSQL
Kevin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
We will delevope web based applications to put the databases on MySQL instead of
Oracle.
We will have plateforms such as:
1). IBM desktop 400 mhz processor 256 MB RAM 6 GB plus 20 GB hard drives Win2000
Server installed; or
2). Digital UNIX 500 mhz Alpha processor 1 GB RAM 35 GB
if you've downloaded the binary, then you don't need to configure, just like
the error says...
read this page,
http://www.mysql.com/doc/I/n/Installing_binary.html
then this one:
http://www.mysql.com/doc/P/o/Post-installation.html
hth.
(and don't forget to cc replies to the list [[EMAIL
John,
I don't think anyone can say for sure which is 'better'. MySQL is used in a
different kind of environment than Oracle. Oracle is designed for an
enterprise environment, where many different applications are used
simultaneously to add or retrieve data from a central data store. MySQL is
Hi,
We have noticed that some MySQL users are having problems to install the
MyODBC driver, receiving errors messages like this:
An error occurred while copying C:\windows\system\mfc30.dll.
Restart windows..
Generally this happens because the ODBC core stuff is ready installed
and the
Given the following table:
Name varchar(128),
CodePageEncoding varchar(32)
that a select like this could be done
select Name, CodePageEncoding
from table
group by CodePageEncoding
order by CODE_PAGE_SENSITIVE_FUNCTION(CodePageEncoding, Name);
This would produce a report/resultset like the
I have a very large table, where one of the columns is
color enum("red", "blue", "black")
The distribution of values is 90% black, 8% blue, and 2% red.
I want to be able to randomly select 10 rows matching a certain color from
the table.
Of course,
select * from my_table where
I'm sorry to write again, but I've gotten no response and I'm totally stuck.
I'm trying to install the latest version of MySQL on a P3 running Redhat
6.2. When I run mysql_install_db, it hangs after it reports "Installing all
prepared tables." I've tried setting different permissions and
Hi Matthew,
- Original Message -
From: "Matthew P. Marino" [EMAIL PROTECTED]
You've got a long way to go. "tar" is short for tape archive. It is an
ancient unix utility that takes directory and file data and builds it into
a
contiguous data base file. This is for portability and
Hi Everybody!
Anyone with any idea what to do I get this error
message:
ERROR 2002: Can't connect to local MySQL server
through socket
'/usr/local/common/mysql-3.23.33/data/mysql.sock' (13)
H. Thanks for your time and advice.
Simon
At 3:29 PM -0500 4/19/01, Wade DeWerff wrote:
Is the common way to index a site, then place that into a database? If so
whats the best(easiest) way to index a site? Thanks
Well, that's a LONG answer to a short question, but two common places
to start are
http://www.mnogosearch.ru/
More like it has already started. Do "ps -ef | grep mysql" to find out.
- Original Message -
From: "Gerald Clark" [EMAIL PROTECTED]
To: "Steve Tuckner" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 0:21
Subject: Re: Newbie Linux 7 installation question
chown
The biggest help is from INSTALL-SOURCE in the source tarball.
==
The basic commands you must execute to install and use a *MySQL* binary
distribution are:
shell groupadd mysql
shell useradd -g mysql mysql
shell cd
Hi.
On Thu, Apr 19, 2001 at 05:41:54PM +0200, [EMAIL PROTECTED] wrote:
Hallo Leute,
in Oracle kann man Indizes in einer Abfrage abschalten(Full-Table-Scan). Mit +0 oder
||''.
z.B.:
SELECT *
FROM tabelle
WHERE eigenschaft||'' = 'text';
SELECT *
FROM tabelle
WHERE id+0 = 1;
Hi.
On Thu, Apr 19, 2001 at 02:27:09PM -0700, [EMAIL PROTECTED] wrote:
This may have been covered in the past; but, marc.theaimsgroup isn't
responding so I can't run my normal search.
This is even covered in the fine manual ;-)
Hey,
Hopefully this isn't a newbie question. I'm currently using MySQL 3.23.35a
and I'm looking how to get an "olympic" style average of values in a table
where the top and bottom n scores are dropped from the average calculation.
Example:
table: opinions
columns: id, score
values:
19
Dear Kevin -
(I can't resist the obvious quip.)
Kevin Pratt writes:
I have heard mysql is the access for unix...
Yes, like emacs is the notepad for unix.
Yours (in gentle jest) - Billy
-
Before posting, please
1 - 100 of 118 matches
Mail list logo