try something like this:
select site_id, max(service_date), name from
site_service left join site on site.id =
site_service.site_id group by site_id;
--- Tom Beidler [EMAIL PROTECTED] wrote:
I¹m having problems with a left join. I¹m not even
sure if I should be using
a left join.
I have
Hi
There are many ways to convert an Oracle DB to MySQL.
1 - Scan, process Oracle exp files, very painful
2 - Use a tool that can access both databases, ie Excel via ODBC
3 - Access oracle schema tables, user_tables, user_tab_columns, user_objects
etc and create a MySQL SQL file.
The third
Description:
segfault during make
How-To-Repeat:
CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti
./configure --prefix=/usr/local/mysql --enable-assembler --with-embedded-server
make
Fix:
Submitter-Id: submitter ID
Originator:Nigel Wetters
Description:
with my setup (rh8.0), no matter what configuration options I use, I get segfaults
during make.
here's the error with a straight ./configure make
os0file.c: In function `os_aio_simulated_handle':
os0file.c:2406: internal error: Segmentation fault
Please submit a full bug report,
* Deependra b. Tandukar
How do I select the very last record in a column in MySQL database?
The expression last record implies that there is an ORDER in your query...
if you add the keyword DESC and a LIMIT 1, you should get the desired
result:
SELECT *
FROM mytable
ORDER BY mycolumn DESC
I have just set up a new MYSQL cluster running MySQL 3.23 on a 6 processor Sun 4500
running Solaris 8. I installed from a Solaris binary and everything loks functionally
OK. The only thing I couldn't do what run the sql-bench tests as are version of Perl
doesn't have the requirired modules.
hi,
i am having no end of problems with installing
mysql (any 3.23.* version) on linux.
i started off on SuSe and received different
errors, I am now trying with mandrake,
The current error is that I have downloaded the
mysql.3.23.55-pc-linux-i686.tar.gz
and done the following:
tar -zxvf
Um - you would only ./configure if you have downloaded the source tarball - you have
the linux binary so you need to follow the instructions for binary installation.
DC
\J. A. Tovey\ [EMAIL PROTECTED] wrote:
hi,
i am having no end of problems with installing
mysql (any 3.23.* version) on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 11 Feb 2003, J. A. Tovey wrote:
i am having no end of problems with installing mysql (any 3.23.*
version) on linux.
i started off on SuSe and received different errors, I am now trying
with mandrake,
The current error is that I have
Dear all,
I have a table Kids which has the following fields:
kid char(20),
favorite_fruits set('apple','pear','orange',)
favorite_fruits has choices of up to 64 items.
Now I want to query the count of each fruit appears in the favorite_fruits of the kids
in the table. Is there anyway
Hi
We've put together an installation of our tool together with MySQL
The question is now what files are required (must be included) to run
MySQL?
I've included:
Bin/
mysql.exe
mysqladmin.exe
mysqld-nt.exe
mysqldump.exe
mysqlimport.exe
libmySQL.dll
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',)
favorite_fruits has choices of up to 64 items.
Now I want to query the count of each
Hi,
On Sat, 2003-02-08 at 09:33, Jerry wrote:
Hello all.
Does any one know, or can anyone point me in the direction of the limits of
a number of tables I can put in a union of a merge table, I can figure out
what the sql would be.
Don't know if there is a limit..
But you must take into
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
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
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, 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 with
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 RD
Cable and Wireless
-
- Original Message -
From: Diana Soares
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
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 =
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 issue.
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
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 client can file
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 AND
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)
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
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
- 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 password
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
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,...
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
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 !
- 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 start server:
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
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
- 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 Mysql
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
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]
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, 2003 9:34 AM
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, 2003
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)
Anybody
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 |
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
- 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:
030211
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
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 describe
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 :)
all killed now,
- 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 permissions
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, 11146,
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
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
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':
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 tables
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' (Errcode:
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 daoe
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
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
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.
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
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 to
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 far as I
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:
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
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
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
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 |
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
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 = '';
and
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.
You should
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:
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 get stat of
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:
: 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' WHERE
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 the
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.
*
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 available
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
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
- 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 looking to
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
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:
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
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)
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:
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 mysql
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
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
databases and
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.but
: 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
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
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 640MB
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:
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
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
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
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 but
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
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:
-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
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
1 - 100 of 113 matches
Mail list logo