Hi all,
I need some help with recursion in mySql. I have the following table:
ID | Name | ParentID
1 | Bob | 0
2 | John | 1
3 | Elm | 1
etc.
For a given ID, I need to recurse up the tree and get all the parents. I've
already read
about Joe Celko's nested set approach
Hi all,
I need some help with recursion in mySql. I have the following table:
ID | Name | ParentID
1 | Bob | 0
2 | John | 1
3 | Elm | 1
etc.
For a given ID, I need to recurse up the tree and get all the parents. I've
already read
about Joe Celko's nested set approach,
On Wed, Feb 12, 2003 at 08:06:03AM +0100, Nico Rehmann wrote:
> Hi,
>
> I have a big problem.
> I NEED to do a full table scan every month on a table.
> I really need all of the data in this table
> This table has about 1,2 GB of data.
> It takes mysql about 45 minutes to send the data.
>
> I con
Hi,
I have a big problem.
I NEED to do a full table scan every month on a table.
I really need all of the data in this table
This table has about 1,2 GB of data.
It takes mysql about 45 minutes to send the data.
I configured mysql with the my-huge.cnf and
I also tried "record_buffer=50M"
but no
Hello,
The documentation says that in order to change the root user's password, you
should run
C:\mysql\bin\mysqladmin -u root password your_password
I have tried this multiple times, on Windows 2000 and Windows XP, running
mysql as a service (mysql-max-nt), and it has had no effect on the root
use
On Wed, Feb 12, 2003 at 10:59:00AM +0800, Trevor Phillips wrote:
> I have a setup of 3 servers, with MySQL replication in a round-robin fashion
> between all 3. So far, any writes to a particular table are done only on one
> machine at any time. The replication is used as a hot backup, not a
> l
show table status:
check out the columns names you will get as idea as to how info it
gives.
>>> olinux <[EMAIL PROTECTED]> Wednesday, February 12, 2003 12:21:16 PM
>>>
SELECT count(*) FROM table WHERE whatever
olinux
--- Tim Johnson <[EMAIL PROTECTED]> wrote:
> Hello All:
> Let's sup
SELECT count(*) FROM table WHERE whatever
olinux
--- Tim Johnson <[EMAIL PROTECTED]> wrote:
> Hello All:
> Let's suppose I want to count the rows in set
> for a match
> to a value in a column. I don't need to read the
> selection
> set, I just need to know the number of matches.
>
> What is
hi guys i just tried this on my works old mysql server and it doesnt seem to work , is
it possible ? :|
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
I have a setup of 3 servers, with MySQL replication in a round-robin fashion
between all 3. So far, any writes to a particular table are done only on one
machine at any time. The replication is used as a hot backup, not a
load-balancing thing.
I now have an instance where I'd like to do inserts
I've been happy with mysqldiff.
http://adamspiers.org/computing/mysqldiff/
Lance
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
Hi Mark,
Thanks for taking the time to reply.
I like the idea of changing our counter model to reduce the
contention around the one file. I will talk to the other developers
about this.
I re-read the reference you mentioned
"http://www.innodb.com/ibman.html#InnoDB_restrictions";
I have just installed mysql-max-3.23.55-pc-linux-i686.tar.gz and now
I'm finding it impossible to run mysqld without being root. The
permisions for the mysql data tree are all set with user and group
"mysql". However when I run mysql.server I get permission denied
errors:
Starting mysqld daemon
Hi,
The new mysql extension (ext/mysqli) is now in the php-cvs-repository. Please
note that you need MySQL Version 4.1 (both server and client library) and
that this extension has experimental status.
Configuration:
--with-mysqli=/path-to-mysql-4.1 -without-mysql
If you want to use both ext/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Hello,
We are experiencing severe problems when running MySql with
INNODB in a production environment. Applications which work
fine under light load fail when under production load.
Our MySql environment is as follows
Hello,
We are experiencing severe problems when running MySql with
INNODB in a production environment. Applications which work
fine under light load fail when under production load.
Our MySql environment is as follows:
OS Platform: Windows 2000 Service Pack 2
Machine description:
C
>Description:
MAX fails to return the correct value in some MERGE table situations.
Based on experimentation I am guessing that the query fails to read all
of the member tables when the query can be performed entirely by reading
the index.
I seem to be able to reproduce this every time on MySQL 3
Hi
Try this.
select * from table where upper(text) like upper('%dog%')
Then all words with 'dog' in it, will appears in your query.
Hope this helps
/Frank
>
> I'm working on a full text search that will search through subject
> lines. The search word is not necessarily a discreet word bu
>Description:
Wrong translation of YES/NO for Polish language. They are swapped.
Same bug in mysql 4.0.10.
>How-To-Repeat:
Look into sql/share/polish/errmsg.txt
>Fix:
Here is patch that fixes problem:
diff -urN mysql-3.23.55.org/sql/share/polish/errmsg.txt
mysql-3.
I am new to mysql, but am learning fast.
I have recently downloaded several front-ends to Mysql. I used some,
deleted others.
In the process of this, I lost the ability to use the default Mysql console
window for inputting data.
The front ends are fine, but I would like to still learn the syntax
n
I'm working on a full text search that will search through subject lines.
The search word is not necessarily a discreet word but could be a fragment
like ...
dog where dog could appear as hotdog, doggone, dognapper etc.
My question is, is there a way of wildcarding the search request to look
Hi!
I have a couple of tables in a MySQL database. In one of the tables, PhpMyAdmin sorts
very strange. ID 1002 is places between ID 21 and ID 22. Any idea why?
Best Regards,
Viktor Vasiliou
-
Before posting, please check:
Hi!
On Feb 12, Peter Bryant wrote:
> Hi. I'm adding a fulltext index to two fields in a large (2300MB) table.
>
> The index created the first 200MB or so of data pretty quickly (in a couple
> of hours), but progress from there has been very slow.
>
> After 48 hours the temporary table is only
I have a table of between 90-100 columns and currently 70k rows. I
don't care how long it takes to enter the data, but I would like to
select it as fast as possible. Each column should be theoretically
queried as much as any other. Right now I am using static MyISAM
tables, which seem good enough f
: Is there a safe way to allow ordinary users, who should
: not have MySQL root privileges, to create databases using
: any name they choose? It seems to me that I would need to
: use "GRANT ALL ON *.* TO user WITH GRANT OPTION". This
: would be dangerous because of the othe
Hi!
On Feb 05, Tue Tønning wrote:
> Hey,
>
> I have discovered a strange error in the mysql versions mentioned in subj.
>
> Example.
> A table with 10 entries ...i want to draw 3 randomly
> => "select fieldName from tableName order by RAND() limit 3"
>
> this have worked for the last year or so
Kevin,
> Is there a safe way to allow ordinary users, who should not have MySQL root
>privileges, to create databases using any name they choose? It seems to me that I
>would need to use "GRANT ALL ON *.* TO
> user WITH GRANT OPTION". This would be dangerous because of the other user's
>databas
This might help.
http://www.mysql.com/doc/en/example-Maximum-column-group-row.html
I had the same problem. Before I found the webpage above, I went with a less
efficient but simpler way. I wanted the highest revision ("revision") for each news
article ("id").
$SQL = "CREATE TEMPORARY TABLE
Is there a safe way to allow ordinary users, who should not have MySQL root
privileges, to create databases using any name they choose? It seems to me that I
would need to use "GRANT ALL ON *.* TO user WITH GRANT OPTION". This would be
dangerous because of the other user's databases and the mysq
G'day Charles
> I am desperately searching for a GUI RAD environment to develop database
> applications for MySQL.
Try www.servoy.com and you might find what you're looking for
cheers
kim
-
Before posting, please check:
On Tue, Feb 11, 2003 at 03:34:52PM -0500, Peter Grigor wrote:
> Dood, he's not gonna be very happy storing an IP as 16 bits :)
Excuse my long day; 32 bits would be much more useful.
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, SQL)
http://www.fibresp
I am waiting for Mysql's UTF8 support as well.
NOt sure if the binaries can solve your issue,
according what I know, we need to specify the charset
information in configuration/compilation time inorder
to enable UTF8.
I actually tried to build mysql 4.1 out of the
source tree(my system is RH 8
there is a tool called SQLyog at http://www.webyog.com/sqlyog/download.html
It has a very good ODBC import tool which will import your Access data to
MySQL without any fuss and its FREE!!!
Insane
- Original Message -
From: "Edward Kim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wed
chown -R mysql.mysql/var/lib/mysql
Substitute the actual location where mysql stores its data files.
J. A. Tovey wrote:
ok :)
all killed now,
(not quite there yet though :))
I am now getting the error:
030211 16:26:51 mysqld started
030211 16:26:51 /usr/local/mysql/bin/mysqld:
Can't
- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "Aaron Conaway" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 3:25 PM
Subject: Re: IP Addresses -- How to Store
> On Tue, Feb 11, 2003 at 01:15:01PM -0500, Aaron Conaway wrote:
> > I'm
Hi. I'm adding a fulltext index to two fields in a large (2300MB) table.
The index created the first 200MB or so of data pretty quickly (in a couple
of hours), but progress from there has been very slow.
After 48 hours the temporary table is only 640MB / 2300MB original table
size.
I've chang
I have tried multiple times to build a version of 3.23.55 with support for
innodb under Solaris 2.6. I can not upgrade the version of the OS.
Here is the error:
source='mysql.cc' object='mysql.o' libtool=no \
depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \
depmode=gcc3 /bin/ksh ../depcom
On Tue, Feb 11, 2003 at 01:15:01PM -0500, Aaron Conaway wrote:
> I'm looking to develop a database of IP addresses for the company and
> have, of course, chosen mySQL as the backend. I want the app to add
> (remove, etc.) a host, giving its hostname and segment. The app will
> add the next availa
On Sun, Feb 09, 2003 at 03:11:54PM -0700, Doug Thompson wrote:
> Am I the only one that equates these robot replies with spam? Most of
> them are as meaningful as talking to micro$oft.
I don't know why they're sent to the list and not to the Sender address.
> >
> > * http://www.mysql.com/doc
On Sat, Feb 08, 2003 at 10:47:55PM -0800, Nasser Ossareh wrote:
>
> SQL in the "What is SQL?" phrase threw me... I thought
> you were talking about MS SQL..
SQL is and should be known as a query language, not a product.
It should be perhaps clarified the first time it is used as
not refering to t
: > select count(*) from Yellow WHERE MATCH(street_add)
: AGAINST('+GUIDO
: > +MIGLIOLI' IN BOOLEAN MODE) AND street_short = '';
: >
: > and the result was 50 rows in set.
: >
: > But when I ran the update:
: > UPDATE yellowtest.Yellow SET street_short = 'MIGLIOLI'
I am with a small business in Southern California that would like to migrate
our MS Access databases to MySQL server. Are their any computer service
companies who can help me?
-
Before posting, please check:
http://www.mysql.
On Tuesday 11 February 2003 18:13, Edgard Dapás wrote:
> I'm trying to load a text file, I've extract from access, and Ihave the
> following error
>
>
> mysql> LOAD DATA INFILE '/home/dapasedg/provedores.txt' INTO TABLE
> proveedores -> FIELDS TERMINATED BY '|' ENCLOSED BY '"';
> ERROR 13: Can't ge
On Monday 10 February 2003 17:54, Octavian Rasnita wrote:
> Please tell me what should I do to make MySQL cache all the queries that
> can be cached.
>
> Can I do this if I am not the administrator of MySQL server? (on a session
> basis...).
Take a look at query cache:
http://www.mysql.co
On Monday 10 February 2003 17:55, Octavian Rasnita wrote:
> Please tell me how to modify the variable ft_min_word_len.
>
> I've tried:
>
> set ft_min_word_len=2;
> set @ft_min_word_len=2;
>
> The second creates a new variable I think and the first one tells me that
> there is no such variable.
Yo
On Tuesday 11 February 2003 16:21, Daniele Lo Re wrote:
> I got weird behaviour from Mysql while doing some updates.
>
> Before doing the update I did a count, like this:
>
>
>
> select count(*) from Yellow WHERE MATCH(street_add) AGAINST('+GUIDO
> +MIGLIOLI' IN BOOLEAN MODE) AND street_short = ''
Thanks to Peter, Ravi, and Dan. That's exactly what I needed to know.
--
Aaron Conaway
Network Engineer III
Verisign, Inc. -- Telecom Services Division
http://www.verisign.com
Office: 912.527.4343
Fax: 912.527.4014
-Original Message-
From: Peter Hicks [mailto:[EMAIL PROTECTED]
Hi!
On Feb 04, Jianping Zhu wrote:
>
> I have mysql in a redhat machine. I need to use mysql do user
> authentication to a website.
> I have a table like following.
>
> +--+--+
> | username | passwd |
> +--+--+
> | jianping | jian1830 |
> | chichi | jian1830 |
The people who run our mysql server are using version 3.23.51, so I don't
have access to some of version 4's features like sub selectes.
I have a table with data like this:
firm firm_rank time time_rank student
A 1 10 1 jones
A 1 10 1 smith
A 1 10 1 alvin
A 2 10 1 bob
A 2 10 2 charlie
Charles.
Have you tried Omnis Studio (www.omnis.net). It's a 4GL RAD which
supports Mac Classic, OSX, Windows, Linux and Solaris.
I use the Mac and Windows version nearly everyday and find it an
excellent tool for creating database front-ends (mySQL access is via
ODBC).
The Omnis-Underground host
Has the maximum number of keys in a MyISAM table been tested more since
this post? Is it possible to get above 64 keys? (I'm going for 90, btw)
~Seth
to get past spam filter: MySQL sql query
Subject: Re: Maximum of 16 indexes per table
From: Michael Widenius
Date: Fri, 30 Jul 1999 23:57:19 +0300
You have one column detail - What do you mean by detail1, detail2 and so?
=
On Tue, 11 Feb 2003 13:13:31 +, Jeff Snoxell <[EMAIL PROTECTED]>
wrote:
Hi,
How can I write a MySQL query to grab single lines of the form
On Tue, 11 Feb 2003, Dan Nelson wrote:
> Store your addresses as INTs, so you would have three fields:
> "address", "netmask", and "gateway". You can either encode the values
> yourself, or use mysql's INET_NTOA()/INET_ATON() functions.
...and beware, INET_NTOA/ATON calls aren't compatible (as f
In the last episode (Feb 11), Aaron Conaway said:
> I'm looking to develop a database of IP addresses for the company and
> have, of course, chosen mySQL as the backend. I want the app to add
> (remove, etc.) a host, giving its hostname and segment. The app will
> add the next available address t
I'm looking to develop a database of IP addresses for the company and
have, of course, chosen mySQL as the backend. I want the app to add
(remove, etc.) a host, giving its hostname and segment. The app will
add the next available address to the database and, looking at the
segment, provide the su
I am desperately searching for a GUI RAD environment to develop database
applications for MySQL. I'm not talking about database administration
such as provided by ControlCenter or SQLyog. I'm talking about the
ability to build formatted forms/screens, queries and reports along the
lines of Access.
mysql -V:
mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
(Upgrading may not be an option.)
Not subscribed to the list, so please CC me on any responses.
I'd submit this to bugs@, but my MySQL version is way out of date and I'm not sure if
the current version has been fixed. A q
Hi all,
Can anyone help me please?
I have a database with hundreds of tables and I want to lock down certain
tables for select only.
The order of presidence for mysql privs as far as I can tell is that if
there are database level privileges, these override the table level privs.
I don't want to
Ciprian,
> I am using PhpMyAdmin and today I got a red message saying that one
> table has overhead and I need to optimize the table.
> This is the first time I got this message, I looked online and I
> understood why it shows. But my question is: can I do something to avoid
> it? What effects da
Edgard,
> I'm trying to load a text file, I've extract from access, and Ihave the
> following error
mysql>> LOAD DATA INFILE '/home/dapasedg/provedores.txt' INTO TABLE proveedores
> -> FIELDS TERMINATED BY '|' ENCLOSED BY '"';
> ERROR 13: Can't get stat of '/home/dapasedg/provedores.txt' (Errc
J.A.,
>> > Can't find file: './mysql/host.frm' (errno: 13)
>> > 030211 16:26:51 mysqld ended
>> Did you run the mysql_install_db script??
> yes, i ran everything again
I bet my b* you didn't, or maybe something went wrong when running it.
If mysqld cannot find host.frm, this means the grant t
I get this message back:
Failed dependencies:
MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.55-1
I know I have this dependency installed, but I think I know where the
problem is just not sure how to fix it. Here is what I get when I do a
'rpm -qa | grep DBI-perl':
Mysql-DBI-perl-bin-1.182
I am having problems installing MySQL 3.23.55 on RedHat 8.0. The
version that came with RedHat will not let me remotely login. I found a
thread at RedHat that said that this is a known problem. One of the
suggestions was to upgrade MySQL. That is what I am attempting to do.
This is what happens
Diana,
Thanks for the suggestion. I completely forgot to add the index/primary
key. Now it works just fine :) Thanks again.
In Peace,
Saqib Ali
"I fear, if I rebel against my Lord, the retribution of an Awful Day (The
Day of Resurrection)" Al-Quran 6:15
http://docbook.sc-icc.org
|+
Yes of course. Here you go:
mysql> EXPLAIN SELECT DISTINCT w0.l_id FROM law_words as w0
-> inner join law_words as w1 on w0.l_id=w1.l_id
-> WHERE
-> w0.w_id IN (258,282,287, 615, 1101, 1949, 1968, 3417, 3574,
3578, 3643,
-> 4345,4768, 5297, 5976,6133, 7243,7245, 9271, 9348, 11
- Original Message -
From: "J. A. Tovey" <[EMAIL PROTECTED]>
To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 11:52 AM
Subject: Re: socket error
>
> yes, i ran everything again
>
Well, the host.frm file is a mysql database table def...your perm
yes, i ran everything again
--- Peter Grigor <[EMAIL PROTECTED]> wrote:
> - Original Message -
> From: "J. A. Tovey" <[EMAIL PROTECTED]>
> To: "Peter Grigor" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Tuesday, February 11, 2003 11:33 AM
> Subject: Re: socket error
>
>
> > ok :)
Your user_info table is not indexed...
(user_info.uid should have an index)
Check the manual:
http://www.mysql.com/doc/en/MySQL_indexes.html
On Tue, 2003-02-11 at 16:16, [EMAIL PROTECTED] wrote:
> Hello All,
>
> I have the following 2 tables and "LEFT join" query as follows:
>
>
> mysql> desc
On 11 Feb 2003, at 10:30, Deependra b. Tandukar wrote:
> How do I select the very last record in a column in MySQL database?
That depends on what you mean by "last record". What are you sorting
by? Once you've figured that out, do a query like this:
SELECT * FROM table_name
ORDER BY sor
- Original Message -
From: "J. A. Tovey" <[EMAIL PROTECTED]>
To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 11:33 AM
Subject: Re: socket error
> ok :)
>
> all killed now,
>
> (not quite there yet though :))
>
> I am now getting the error:
ok :)
all killed now,
(not quite there yet though :))
I am now getting the error:
030211 16:26:51 mysqld started
030211 16:26:51 /usr/local/mysql/bin/mysqld:
Can't find file: './mysql/host.frm' (errno: 13)
030211 16:26:51 mysqld ended
?
--- Peter Grigor <[EMAIL PROTECTED]> wrote:
> > i'm
Hello All,
I have the following 2 tables and "LEFT join" query as follows:
mysql> describe user_lic;
+++--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+++--+-+-+---+
| license_id | big
I'm trying to load a text file, I've extract from access, and Ihave the
following error
mysql> LOAD DATA INFILE '/home/dapasedg/provedores.txt' INTO TABLE proveedores
-> FIELDS TERMINATED BY '|' ENCLOSED BY '"';
ERROR 13: Can't get stat of '/home/dapasedg/provedores.txt' (Errcode: 13)
Anybo
> i'm sorry - could you explain that for a
> simpleton :-)
> i have no idea what you mean :-/
>
> --- Peter Grigor <[EMAIL PROTECTED]> wrote:
> > - Original Message -
> > From: "J. A. Tovey" <[EMAIL PROTECTED]>
> > To: "Peter Grigor" <[EMAIL PROTECTED]>;
> > <[EMAIL PROTECTED]>
> > Sent: Tu
i'm sorry - could you explain that for a
simpleton :-)
i have no idea what you mean :-/
--- Peter Grigor <[EMAIL PROTECTED]> wrote:
> - Original Message -
> From: "J. A. Tovey" <[EMAIL PROTECTED]>
> To: "Peter Grigor" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Tuesday, February 11
Artem,
Have you considered using a full text index? I don't really understand
exactly what you are trying to do, but consider it if you haven't already.
Andy
> -Original Message-
> From: Artem Koutchine [mailto:[EMAIL PROTECTED]]
> Sent: 11 February 2003 14:23
> To: [EMAIL PROTECTED]
> S
create newtable select from oldtable where 1=0;
Admin wrote:
In MySQL is it possible to create a temporary table without having to
specify all the properties? On SQL Server (at least via query analyzer) you
can create temp tables fairly easily and the properties of each field are
inherited from
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 9:52 AM
Subject: SERIOUS PROBLEM
> Hi,
> I am encountering a serious problem with MYSQL 3.23.48. Mine is a java
> application with the following flow.
>
>Make a connectionobject to
In MySQL is it possible to create a temporary table without having to
specify all the properties? On SQL Server (at least via query analyzer) you
can create temp tables fairly easily and the properties of each field are
inherited from the regular table.
Doesn't look like thats the case with MySQL
Hi,
I am encountering a serious problem with MYSQL 3.23.48. Mine is a java
application with the following flow.
Make a connectionobject to Mysql
Get a record from table1
Update table2 with the table1 info.
It works in 99% of the cases i am able to fetch the record from table1. But
in 1
- Original Message -
From: "J. A. Tovey" <[EMAIL PROTECTED]>
To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 9:34 AM
Subject: Re: socket error
> ah ok, yes,
>
> the error log says
> "
> 030211 12:10:27 mysqld started
> 030211 12:10:27 Can't s
ah ok, yes,
the error log says
"
030211 12:10:27 mysqld started
030211 12:10:27 Can't start server: Bind on
TCP/IP port: Address already in use
030211 12:10:27 Do you already have another
mysqld server running on port: 3306 ?
030211 12:10:27 Aborting
"
how do i get rid of this other mysql !
Can you post your explain plan?
-Original Message-
From: Artem Koutchine [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 8:23 AM
To: [EMAIL PROTECTED]
Subject: Very slow request with many ORs in where parts
Hi!
I have the following table:
create table law_words (
l_id i
Hi!
I have the following table:
create table law_words (
l_id int unsigned not null,
w_id int unsigned not null,
primary key (w_id, l_id)
);
The request is:
SELECT DISTINCT w0.l_id FROM law_words as w0
inner join law_words as w1 on w0.l_id=w1.l_id
where w0.w_id in (258,282,... ab
Hi,
I am using PhpMyAdmin and today I got a red message saying that one
table has overhead and I need to optimize the table.
This is the first time I got this message, I looked online and I
understood why it shows. But my question is: can I do something to avoid
it? What effects daoe the overhea
- Original Message -
From: "J. A. Tovey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 9:09 AM
Subject: socket error
> hi -
>
> i have got to the beginning stages of
> installation - on trying to create a root
> password with:
>
> bin/mysqladmin -u root pass
Hi everybody
I got weird behaviour from Mysql while doing some updates.
Before doing the update I did a count, like this:
select count(*) from Yellow WHERE MATCH(street_add) AGAINST('+GUIDO
+MIGLIOLI' IN BOOLEAN MODE) AND street_short = '';
and the result was 50 rows in set.
But when I ran t
hi -
i have got to the beginning stages of
installation - on trying to create a root
password with:
bin/mysqladmin -u root password 'password'
i get
bin/mysqladmin: connect to server at 'localhost'
failed
error: 'Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (2)'
Check
Hello
Can somebody tell me what are the top sites ( except ofcourse mysql.com )
for general MySQL News, Tutorials etc.
Insane
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
Heya:
> HI
> Does mysql support function EXIST
No. It doesn't support subselects before 4.1 either.
> mysql> select * from arcdata d
> -> WHERE year='2003' AND semester='1'
> -> AND EXIST (SELECT * FROM arcdata_unitCodes u
> -> WHERE u.idnum = d.idnum AND u.semester=d.semester AN
Courier IMAP can. www.courier-mta.com
Curtis
On Wed, 5 Feb 2003, Paul DuBois wrote:
> At 17:26 + 2/4/03, Ben Clewett wrote:
> >MySQL,
> >
> >My first post, please go easy if this is the wrong pleace!
> >
> >I'm trying to find an IMAP server which used MySQL so that my
> >Mozilla Email cli
The manual suggests that the password function is really for intenal mysql
functions. Ideally you should use the encode or md5_encode functions.
update user set password=encode('password', 'salt') where user =
'your_user';
Curtis
On Wed, 5 Feb 2003, Natale Babbo wrote:
> try to use the pas
Unfortunately, good intentions don't always produce alike results.
How about if the bot replies to messages matching "newbie", "novice" and "beginner"
in the subject? They most likely tend to be from beginners, and online manual
and/or list archives are pretty much perfect solutions for their iss
Hi,
how can I update a set field such that all table rows get what they had in
the set ORed with some other set value.
I.E. If I have a field called SetField and rows:
SetField
A
A,B
A,B,C
B
etc
How can I do what I'm trying to do with this mysql query?
UPDATE MyTable SET SetField = (SetField
Hi,
How can I write a MySQL query to grab single lines of the form:
ColumnNames: EnquiryID, Name, Address, Detail1, Detail2, Detail3, Detail4
From two joined tables:
Tbl1: Enquiries
--
ID
Name
Address
Etc
Tb12: Details
ID
EnquiryID
Detail
Etc
-
Cheers.
The only limit I've hit so far on 365 tables, was the max number of open
files, so I've ramped that up and its working fine at the moment.
Jerry
-
Jeremy Hutchings
Apps R&D
Cable and Wireless
-
- Original Message -
From: "Diana Soares" <[E
Hi, you could try:
SELECT name,
SUBSTRING_INDEX(name,' ', 1) as first,
SUBSTRING_INDEX(v2, ' ', -1) as last
FROM table
For the uppercase of the first letter, as i don't know a specific
functions to do that in MySQL (it has ucase and lcase but for all the
word), you must "play" wit
Thanks, Fred.
It works perfectly.
At 01:00 PM 2/11/2003 +0100, Fred van Engen wrote:
>Hello Anya,
>
>On Tue, Feb 11, 2003 at 07:51:00PM +0800, Anya wrote:
>>
>>
>> Dear all,
>> I have a table Kids which has the following fields:
>>
>> kid char(20),
>> favorite_fruits set('apple','pear','orange
Hi ,
if you used SUSE , why didn't you just install the
mysql-packages distibuted there with yast.
It's very easy and I never had a problem with it.
It is also possible to install foreign packages with yast later ,
if you want to udate your mysql-server later.
The problem is , that SUSE is not ver
Hello everybody,
I have a problem with MySQL and an application made with Delphi. If I try to
save a modified record in a table, I get the following error: "Record can
not be locked because the record is already in use." I don't know if that is
the exact translation. The original errormessage is G
1 - 100 of 113 matches
Mail list logo