On 21/07/2010 16:33, Karthik Pr wrote:
I have created a table as follows but i was not able to use full text search on
a specific data.
create table racebike (id int auto_increment not null primary key, name
varchar(10), user text,fulltext(name,user));
[snip]
The query is
mysql select *
-Original Message-
From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com]
Sent: Thursday, February 11, 2010 12:52 AM
To: mysql@lists.mysql.com
Subject: help me out for this scenario
I have a table like as follws
Emp_id, first_login , second_login
[JS] I think you are asking for
A handler is something you handle things by, for example a table you've
opened. It's basically a pointer to an object. A cursor, like the one on
your screen, keeps track of where you are in a resultset - operations like
next() move it around.
Those things are only useful to you if you're also
Instead of:
- else 2003
- where id between 1 and 6;
Try
- else 2003
- end
- where id between 1 and 6;
Or maybe even:
mysql update table1
- set year=case when id IN (1, 2, 4) then 2000
- when id IN(2, 4, 6) then 2001
- else 2003
- end
- where id between 1
See this link.
Might me help for you
http://answers.yahoo.com/question/index?qid=20070309043307AATLe9k
On 5 February 2010 17:46, misiaQ mis...@poczta.fm wrote:
Instead of:
- else 2003
- where id between 1 and 6;
Try
- else 2003
- end
- where id between 1 and 6;
Or
Thanks to everyone who replied. So simple I couldn't see it. :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wednesday 12 March 2008 00:14:46 Brian Dunning wrote:
I am an idiot. table_a and table_b have exactly the same structure.
How do I say this in SQL:
INSERT (all records from table_a) into table_b where table_a.customer
= '12'
Just trying to eventually duplicate the whole table, one
SELECT *
FROM table_one t1
INNER JOIN table_two t2
ON t1.column_one = t2.column_one
LEFT JOIN table_three t3
ON t3.column_two = t1.column_three
AND t3.column_four = t1.column_five
WHERE column_six LIKE '%dsc%'
AND column_seven LIKE '%aaa%';
There is no need for a derived table.
Also, using LIKE
No, because you have no WHERE condition.
wangxu wrote:
sql:
SELECT *
FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one =
table_one.column_two
INNER JOIN table_one table_one2 ON table_one2.column_one =
table_one.column_three
thank you
- Original Message -
From: Jay Pipes [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, March 06, 2007 4:29 AM
Subject: Re: help me optimize this ALL
No, because you have no WHERE condition.
wangxu wrote:
sql:
SELECT
Yes, the two examples are equivalent.
UNLOCK TABLES releases any locks held by the current thread. All tables
that are locked by the current thread are implicitly unlocked when the
thread issues another LOCK TABLES...
So there is a hole there with either example. In order to keep others from
Hello.
The start point for you in such kind of problems should be researching
the output of the following statement:
SHOW VARIABLES LIKE '%char%';
Please, run it from different environments (PHP, MySQL Query Browser),
and send results to the list. Include the CREATE statement for you
Hello.
This is a line from one of your files which were attached in archive:
[EMAIL PROTECTED] Test_pgms]# gcc -c -I/usr/lib/bcc/include
^^
-I/usr/include/mysql createdb.c
Are you using Borland C++ includes with gcc?!
Carlos J Souza wrote:
Dear Friends,
Iam trying to install MySQL 4.1.x in Windows 2003
Server, and on error occurs when installation try a
start de service. The service does not start and
installation don't finish.
I Try install and reinstall many times and all fail
My WIndows is a 2003
Carlos J Souza wrote:
The error as follows:
when installation is try to finish, the install try a start de new service MYSQL
4 and does not success
I try the install and reinstall many times and nothing.
Regards
On Wed, 29 Jun 2005 08:39:51 -0400, JamesDR wrote:
Carlos J Souza wrote:
Hi Carlos,
My suggestion for this problem is, just uninstall the
MySQL Server and manually delete all the corresponding
files, restart the system once (not a must, but it's a
advisable), then u install the MySQL, hope now it'll
definitely work.
This is happening because of mis-configuration b/w
Hello.
Very often similar error occurs when you didn't remove
service from previous MySQL installation. See:
http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html
Carlos J Souza [EMAIL PROTECTED] wrote:
Dear Friends,
=A0
Iam trying to install MySQL 4.1.x in Windows
Thanks for your inputs Eric.
I tried this but it couldn't give me any insight abt
how can optimize this
for space saving of temp tables.
Maybe I am not expert enough to interpret this
output, so here it is -
- Manish
Seeing the explain log, it looks to me like you donot
have any index defined
Thanks for your inputs Eric.
I tried this but it couldn't give me any insight abt
how can optimize this
for space saving of temp tables.
Maybe I am not expert enough to interpret this
output, so here it is -
- Manish
Seeing the explain log, it looks to me like you donot
have any index defined
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Wu_Yang_SKZ, JPcommon wrote:
java.sql.SQLException: Communication failure during handshake. Is there a
server running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:275)
at
,
- Manish
- Original Message -
Sent: Saturday, December 04, 2004 10:26 AM
Subject: Re: Help me optimize this query
If you change the update to a select you can use explain to see it's
execution path just like you would with a normal select. The rows
returned are the rows that would
If you change the update to a select you can use explain to see it's
execution path just like you would with a normal select. The rows
returned are the rows that would be matched by the update query.
Example:
explain select * from t1, t2 where t1.YYY=t2. and t2. like '%X%';
Optimize the
PM
Subject: Re: HELP ME WITH THIS
Hi,
The only way I can think of is to join the table to itself. It should look
something like this:
select unix_timestamp(concat(s.date,' ',s.time)) -
unix_timestamp(concat(e.date,' ',e.time))
from table s left join table e on
( s.CallingStationId
If it were all in one row, you may be able to compare datetime fields.
I do not know if you can do this with 2 rows, and the query will probably
be rough.
Did you design the table? Can you create it so that your row has start and
stop times, instead of creating another row?
-Original
* Karma Dorji
i have a table, like the one below,
i need to find the time difference between the Start and Stop from a
particular CallingStationId to particular CalledStationId.
++--++---+
--
+---+
|
Hi,
The only way I can think of is to join the table to itself. It should look
something like this:
select unix_timestamp(concat(s.date,' ',s.time)) -
unix_timestamp(concat(e.date,' ',e.time))
from table s left join table e on
( s.CallingStationId=e.CallingStationId and
xian ting [EMAIL PROTECTED] wrote:
in sql: insert into table select from ...
can select from a remote data base server such as sqlserver using odbc
as 'SELECT * into test01 FROM Fund IN [ODBC] [ODBC;Driver=SQL
Server;UID=admin;PWD=;Server=(lacal);DataBase=CMBXMDM;]'in access.
thanks!
You
i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear the
error again. Please again!!!
On Thu, 18 Dec 2003, Chris Elsworth wrote:
On Thu, Dec 18, 2003 at 05:28:30PM -0200, Carlos Andr? Moura de Amorim wrote:
031217 14:32:34 Warning: setrlimit couldn't increase number of
You must be 'root' to do a ulimit -n 1024.
Marc.
-Message d'origine-
De : Carlos André Moura de Amorim [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 19 décembre 2003 14:55
À : Chris Elsworth
Cc : [EMAIL PROTECTED]
Objet : Re: Help me - please
i added ulimit -n 1024 in mysql_install_db
what distro are you using? what is running on this server? another
server is runnin' on the same machine? what hardware are you using? is
it heavy loaded?
On Fri, 2003-12-19 at 09:54, Carlos Andr Moura de Amorim wrote:
i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear the
de Amorim [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 19 décembre 2003 14:55
À : Chris Elsworth
Cc : [EMAIL PROTECTED]
Objet : Re: Help me - please
i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear the
error again. Please again!!!
On Thu, 18 Dec 2003, Chris
On Thu, Dec 18, 2003 at 05:28:30PM -0200, Carlos Andr? Moura de Amorim wrote:
031217 14:32:34 Warning: setrlimit couldn't increase number of open files
to more than 256 (request: 510)
It might be worth putting a ulimit -n 1024 (or some other decent
number) in the rc.d script that starts
You may be better asking this one on the PHP list:
http://www.php.net/mailing-lists.php
But you will need a bit more detail such as your version/setup/platform and
some code (without password/username that is!)
On 6/26/03 2:12 PM, Syamsul Arifien [EMAIL PROTECTED] wrote:
Date: Thu, 26
On Thu, Jun 26, 2003 at 08:07:48AM -0400, David Bush wrote:
I run the following query:
select * from x where x like 'x/%' ;
I would like the result of this query to go to a file or pause at the end of the
screen so that I can view each page. Any help would be
- Original Message -
From: Fred van Engen [EMAIL PROTECTED]
To: David Bush [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 3:11 PM
Subject: Re: Help me: I'm a beginner
On Thu, Jun 26, 2003 at 08:07:48AM -0400, David Bush wrote:
I run the following query
David Bush [EMAIL PROTECTED] wrote:
I run the following query:
select * from x where x like 'x/%' ;
I would like the result of this query to go to a file or pause at the end of the
screen so that I can view each page. Any help would be appreciated.
Use SELECT ..
mailto:[EMAIL PROTECTED]
This is what I found at lists.mysql.com
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Luis Enrique Bauzá Peña [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 10:00 AM
To: Lista Mysql Inglés
Subject: Help me!!!
Hi, I need some
Luis Enrique Bauzá Peña,
[EMAIL PROTECTED]
David M Friscia
friscia.rootsweb.com http://friscia.rootsweb.com
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
From: Luis Enrique Bauzá Peña [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 9:00 AM
To: Lista Mysql
mailto:[EMAIL PROTECTED]
- Original Message -
From: Luis Enrique Bauzá Peña [EMAIL PROTECTED]
To: Lista Mysql Inglés [EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 11:59 AM
Subject: Help me!!!
Hi, I need some link to a spanish mysql list, would you ...?
--
MySQL General Mailing
Hola,
Puedes encontrar una lista Mysql Espanol a
http://lists.mysql.com/list.php?list=mysql-es#b . Yo pienso que ellos
pueden ayudarte ma's que nosotros podemos.
You can find a spanish MySQL list at
http://lists.mysql.com/list.php?list=mysql-es#b . I think they can help
you more than we can.
select * from your_table order by no desc limit 0,1
-Original Message-
From: mustakim abas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 12:07 PM
To: [EMAIL PROTECTED]
Subject: help me, please
Hello, i am new in mysql. I got a problem. I try write
my C program
On Thu, 19 Dec 2002, mustakim abas wrote:
Hello, i am new in mysql. I got a problem. I try write
my C program with mysql API.I have 5 field in
table.No,Name,Phone,Date,Time. How can i take one row
where the No is bigger?
Thanks for help.
Provided I understand your question, then I would
At 8:06 -0800 12/19/02, mustakim abas wrote:
Hello, i am new in mysql. I got a problem. I try write
my C program with mysql API.I have 5 field in
table.No,Name,Phone,Date,Time. How can i take one row
where the No is bigger?
Thanks for help.
Bigger than what?
Select max(No) from table
Marcos Henke
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: mustakim abas [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 19, 2002 1:51 PM
Subject: Re: help me, please
At 8:06 -0800 12/19/02, mustakim abas wrote:
Hello, i am new
At 8:06 -0800 12/19/02, mustakim abas wrote:
Hello, i am new in mysql. I got a problem. I try write
my C program with mysql API.I have 5 field in
table.No,Name,Phone,Date,Time. How can i take one row
where the No is bigger?
Thanks for help.
Bigger than what?
Maybe
SELECT No, Name,
* Maximo Migliari
Im running the following query:
SELECT
user.nickname,
user.id,
user_detail.points
FROM
user,
user_detail
WHERE
user.details = user_detail.id
AND user.id 101
AND user.language = 'en'
ORDER BY user_detail.points DESC
Im running the following query:
SELECT
user.nickname,
user.id,
user_detail.points
FROM
user,
user_detail
WHERE
user.details = user_detail.id
AND user.id 101
AND user.language = 'en'
ORDER BY user_detail.points DESC
LIMIT 5;
Try:
Im running the following query:
SELECT
user.nickname,
user.id,
user_detail.points
FROM
user,
user_detail
WHERE
user.details = user_detail.id
AND user.id 101
AND user.language = 'en'
ORDER BY user_detail.points DESC
LIMIT 5;
John Ragan wrote:
Im running the following query:
SELECT
user.nickname,
user.id,
user_detail.points
FROM
user,
user_detail
WHERE
user.details = user_detail.id
AND user.id 101
AND user.language = 'en'
ORDER BY user_detail.points DESC
LIMIT 5;
I don't really know how LEFT JOINS, INNER
Hi Eric
I dunno why people make 100 field tables, sounds a little harsh. I'll keep
you in mind the next time i wanna make a 100 field table.
Anyways, just to let you know mysql 4 will be supporting foreign key
constraints. And yes thoes other db technologies like postGrep already
support key
So, one of my associates has made a linking table (some people also call it
intersection table, cross tab table, but i believe that the propper way to
model a many to many relationship is via a linking table). in the linking
table, there is no primary key defined.
Let us suppose you wish to
Desmond,
A primary key is needed to maintain a unique identity of each record and
there by help in linking it to other records in other tables. However, we
have certain tables which link one table to another (needed because of
absence of foreign keys in mysql) which don't necessarily have primary
Hello Desmond,
I am not an expert in DB, but I support your ideas. The primery key is
one of the fundamental concept of database. With the key, you can refer
faster to the record that you are looking for. Even you have a perfect
codes, you will be not able to cover all senario that your
Well, there are people who feel that tables should be linked by foreign keys
to ensure referential integrity. Everyone who uses MySQL gets by without
them though. Its up to your coding to make sure referential integrity is
not violated.
Although foreign keys are left out of MySQL for
Hi,
Is it such a big deal to use more than one field for a primary key? Two
field keys are only a little slower than single field Primary keys for
selects. Often in linking tables you want to have duplicates of the two
foreign keys right?
I just wish people would stop making 100 field tables,
If it's for a linking table, you'd just have something like this:
CREATE TABLE linking_table (
first_id INTEGER,
second_id INTEGER,
PRIMARY KEY (first_id, second_id)
);
For an n-m relationship, that's the only way to do it.
Dean Harding.
P.S. The syntax may be wrong, that's just
Hi.
IMHO, the self-join is the correct solution for the given table layout
(which looks reasonable to me).
Greetings,
Benjamin.
On Wed 2002-07-17 at 09:26:48 +0530, [EMAIL PROTECTED] wrote:
[...]
Select companyid, count(*) from CompanyServices where
serviceid = 1 or serviceid = 2
these situations
-Arul
- Original Message -
From: Francisco Reinaldo [EMAIL PROTECTED]
To: Arul [EMAIL PROTECTED]; MySQL
[EMAIL PROTECTED]
Cc: Arul [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 3:27 AM
Subject: Re: help me with this query
Hi,
Select companyid, count
Hi,
Select companyid, count(*) from CompanyServices where
serviceid = 1 or serviceid = 2 or serviceid = 3
group by companyid
having count(*) = 3
Bye and Good Luck.
--- Arul [EMAIL PROTECTED] wrote:
Hi All
The Table design goes like this
Company Table
companyid
PROTECTED]
Sent: Wednesday, July 17, 2002 3:27 AM
Subject: Re: help me with this query
Hi,
Select companyid, count(*) from CompanyServices where
serviceid = 1 or serviceid = 2 or serviceid = 3
group by companyid
having count(*) = 3
Bye and Good Luck.
--- Arul [EMAIL PROTECTED] wrote:
Hi All
Bas,
Thursday, July 04, 2002, 9:43:07 PM, you wrote:
BM When I start mysqlgui on my mandrake 8.2 machine the program starts, but
BM I get an error message:
BM Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2)
BM I don't know what to do and I cannot acces the help file or
You might have your socket files in /var/lib/mysql/. Search for the socket
file and create a symlink in the /tmp directory as such:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
Regards,
Bhavin.
- Original Message -
From: Bas Mooyman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
select u.userid , c.companyname from
users u left join company c on (u.companyid = c.companyid)
where u.status = 'ACT'
Best regards,
Mikhail.
- Original Message -
From: Arul [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Tuesday, July 02, 2002 5:15 PM
Subject: help me with this
I would structure things differently. Have you thought about making each
question a record/row in a table? Then if you add or remove a question, you
don't have to change you table structure or your code if you do it right.
You could also then easily compile stats on a per question basis. Like how
prajak,
Friday, April 05, 2002, 7:50:44 AM, you wrote:
pp mysql select distinct(nexthop) ip from NameRoute
pp where OwnerIP='10.0.1.1' and
pp nexthop not in (select ip from NameIP where
pp OwnerIP='10.0.1.1');
pp ERROR 1064: You have an error in your SQL syntax near
pp 'select ip from NameIP whe
hello,
mysql doesn't support sub-select yet...maybe in 4.1 ;)
mysql select distinct(nexthop) ip from NameRoute
where OwnerIP='10.0.1.1' and
nexthop not in (select ip from NameIP where
OwnerIP='10.0.1.1');
ERROR 1064: You have an error in your SQL syntax near
'select ip from NameIP whe
re
Have you got your LD_LIBRARY_PATH set correctly?
Andrea Soracchi wrote:
Hello,
I have a Sun Os 5.8 with gcc version 2.95.3.
When i try to compile mysql with the following command:
CC=gcc CFLAGS=-O6 CXX=gcc
CXXFLAGS=-O6 -felide-constructors -fno-exceptions -fno-rtti
./configure
Did you try installing a new copy of MySQL and then simply copying the
appropriate files from mysql/data/mysql over to your damaged installation?
Just an idea.
joe
-Original Message-
From: noat naut - nart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 5:49 AM
To: [EMAIL
solution.
Hope this helps.
- Original Message -
From: Brian Smith
To: Bill Easton
Sent: Saturday, March 02, 2002 8:51 AM
Subject: RE: help me with complicate sql query
I guess this would work if person_id 3 was also assigned to org 1 as well
as org 2, they wouldn't show up
Well, it's possible, but it's not pretty.
The right way, of course, is to have subselects. Ah, well, someday...
You can't do it using just joins (inner or outer) and where clauses. The
reason is that the joins will give you a cross product and the on clauses
and the where clauses will throw
Check out:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
Gurhan
-Original Message-
From: Charitha [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 10:51 PM
To: [EMAIL PROTECTED]
Subject: Help me to create a table with autoincrementing field
Hi all there,
I am a
Hi.
On Tue, Oct 02, 2001 at 01:02:19PM +0100, [EMAIL PROTECTED] wrote:
Hi there. I have problems with mySQL
What I would like to do is:
I have a statement
SELECT a.id AS ID, IDmark, IDrecipe, ocenjevalec, ocena,
ROUND(AVG(ocena),1) as povprecje, COUNT(*) as all, IF (ID=ocenjevalec,
Hi there. I have problems with mySQL
What I would like to do is:
I have a statement
SELECT a.id AS ID, IDmark, IDrecipe, ocenjevalec, ocena,
ROUND(AVG(ocena),1) as povprecje, COUNT(*) as all, IF (ID=ocenjevalec,
'yes', 'no') as zeocenil
FROM ocenerecepti, obiskovalci
WHERE IDrecept = 1365
Pablo,
Try this. The key part is putting LIBS=-lz in. The rest of it was
specific to my configuration.
SSL_BASE=/usr/local/openssl-0.9.6b \
LIBS=-lz \
./configure \
(etc)
Hope this helps!
Eric
-Original Message-
From: Pablo Javier Gonzalez Mateos [mailto:[EMAIL PROTECTED]]
Sent:
On Fri, Aug 31, 2001 at 05:37:58PM -0300, Pablo Javier Gonzalez Mateos wrote:
Hello, im in this situation:
i have a PC AMD K6-2 with 64 MB RAM. SuSE Linux 6.3 OS
when i compile the php with mysql everything works fine, but after y
compile the apache with this command:
./configure
Best I can come up with is something like
2 words:
SELECT c1.id
FROM crossref c1, crossref c2
WHERE c1.word='word1'
AND c2.word='word2'
AND c1.id=c2.id
3 words:
SELECT c1.id
FROM crossref c1, crossref c2, crossref c3
WHERE c1.word='word1'
AND c2.word='word2'
AND
Hi!
Query:
-
select a.id
from crossref a
, crossref b
, crodsref c
where a.id=b.id
and a.id=c.id
and a.word= word1
and b.word= word2
and c.word= word3;
It isn't ideal construction, but it works.
For your example (two words - tintin register):
select a.id from
Please inform me how to load IMAGES INTO MYSQL TABLES.
You can do so with MySQL-Front - www.mysqlfront.de . Simply paste image from
clipboard into BLOB-Editor.
Greetings,
Ansgar
-
Before posting, please check:
Please inform me how to load IMAGES INTO MYSQL TABLES.
Having created several similar applications in the past I would recommend
NOT storing these images IN the database; your filesystem makes for a nice
blob storage device. I would instead store pointers of some sort to the
files to
Hi.
On Wed, Jun 13, 2001 at 11:12:02AM +0200, [EMAIL PROTECTED] wrote:
[...]
Hi, I want to insatll Mysql in my station, i have
Debian (linux 2.2),i installaed all the package of
mysql, and after when i Write command : mysqladmin -u
user create db , It ansers,
mysqladmin: connect to server
On 03-Jun-01 Derby wrote:
Dear Everybody,
Today I received the following error message in my web site (which
is in php with mySql in UNIX environment), but it worked half a year
until Today:
snip
MySQL said: Got error 127 from table handler
I suppose too many records are in the
The error log in ~mysql/var should give you a hint as to your problem.
P
On
Fri, 6 Apr 2001, Franois Grenapin wrote:
I have a little matter for begin my server mysql...
When I want to connect to mysql, it happends that :
RROR 2002: Can't connect to local MySQL server through socket
the file error_lod said me that :
10406 10:59:50 mysqld started
010406 10:59:51 Can't start server : Bind on unix socket: Permission
non accorde
010406 10:59:51 Do you already have another mysqld server running on
socket: /var/lib/mysql/mysql.sock ?
010406 10:59:51 Aborting
010406 10:59:51
Grenapin [SMTP:[EMAIL PROTECTED]]
Enviado el: Friday, April 06, 2001 12:22 PM
Para: Peter Skipworth
CC: [EMAIL PROTECTED]
Asunto: Re: HELP me!
the file error_lod said me that :
10406 10:59:50 mysqld started
010406 10:59:51 Can't start server : Bind on unix socket: Permission
non accorde
please : give me the solution!
Just a few thoughts.. you connect via PHP.. your php.ini is not pointing to
the right location mysql.sock would normally live in /tmp Normally..
other location could be..
Do a ps -ax and see if mysqld shows up.. If not, it's not running at all..
On Fri, Feb 23, 2001 at 06:05:53PM -0600, Don Hosek wrote:
This'd be a piece of cake with sub queries: What I have is a table with two relevant
fields: iIssue and iSubId
iSubId represents a magazine subscriber
iIssue represents any issues that person has/had coming
SELECT iSubID
On Sat, Feb 24, 2001 at 08:56:03AM +0100, Fred van Engen wrote:
On Fri, Feb 23, 2001 at 06:05:53PM -0600, Don Hosek wrote:
This'd be a piece of cake with sub queries: What I have is a table with two
relevant fields: iIssue and iSubId
iSubId represents a magazine subscriber
iIssue
Redhat comes with mysql already installed as a RPM usually. I had the
same problem until I unstalled the RPM that came with Red Hat. A fix
for this problem if you don't want to uninstall the original can be found
at:http://www.mysql.com/doc/I/n/Installing_many_servers.html
Usually means you haven't started the server. Check by doing a ps command
and also check the manual if you don't know how to start it.
- Original Message -
From: "hocine grine" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 07, 2001 1:00
Subject: help me !
my name
89 matches
Mail list logo