On 8/24/06, Dan Buettner [EMAIL PROTECTED] wrote:
Sure - in your sql script, put in
SELECT text to the screen;
Then you'll get 2 copies...
Try this:
SELECT text to the screen AS '';
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I am fairly new to SQL and have run into a problem I can't figure
out. I am trying to construct a query that returns an occurrence
ranked list of results.
I have the following tables and fields:
components
id
name
componentsToPartsList
On 8/23/06, Gregor Reich [EMAIL PROTECTED] wrote:
Hi all
Is there a possibility to have some tables write-protected while others
in the same db are not (and yet the write-protected ones are updatable
through the replication mechanism, ie. there are tables on a slave
server). I guess that both,
Vielen Dank für die Hinweise; grant ... wird mir weiterhelfen.
Gruss, Gregor.
Dominik Klein schrieb:
Guten Morgen Gregor
beim nächsten mal antworte bitte an die Liste.
Beispiel:
User gregor soll auf datenbank.tabelle1 nur lesend zugreifen können,
auf datenbank.tabelle2 auch schreibend.
hi
Hope there is no privilege type of REPAIR [Repair Table] supported by MySQL
Server.
use
SHOW PRIVILEGES;
SHOW PRIVILEGES shows the list of system privileges that the MySQL server
supports. The exact list of privileges depends on the version of your server.
For the global, database,
Chris wrote:
The most common next search becomes the did you mean.
Yes, that might work well, but I wouldn't use it out of the box. I would
send a report to a human first to use that information instead of doing
it automatically.
Imagine someone searching for cous (instead of cows) and
Rhino wrote:
What do you mean by mols - molar weights?
yup... i mean, probably... ;)
And why would anyone search for anything to do with chemicals based on
smilies? How would :-) or symbols like that help? Or is this some
other sense of the word smilies than the customary Internet one?
Hello all,
I am currently working on redesigning a database structure for online
translation utility called Entrans [1].
Entrans is quite nice piece of software, but unfortunately it has one
major design flaw: it only supports languages which have only two plural
forms and to fix this issue, a
On Thu, Aug 24, 2006 at 12:43:56AM -0400, Rhino wrote:
- Original Message -
From: Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, August 23, 2006 10:15 PM
Subject: Chemistry search
Has
You might come close by using a combination of tee, select, and notee
commands. You didn't say if this was for debugging, which would tolerate a
lot of ugly, or not.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Nico, as a first stab, I would try optimizing the tables in question.
OPTIMIZE TABLE mysql.user
etc.
The one with 194,177 entries would be a good candidate for this especially.
done, but with no improvement
I wonder also if you would see something logged in the slow query log
as this
Yeah, my customer wasn't too pleased when his product search could only find
certain colors. ;)
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Hello,
I have a mysql DB running on a Windows XP machine.
I can access it locally via mysql command, I have also a ODBC driver
installed and the test says it works ok.
When I try to connect from a remote host via JDBC I get the error
message that this host is not allowed to access the db.
You ought to look at the field Host in the table Users In the db Mysql. This
field set from where this user can access. If you put a % simbol in it the
user could access from any host, or if this user can access only from on
host, you must put in this field the IP of the host.
Hope help.
Hi Andreas,
On the local host using mysql database. Execute the following command at
mysql prompt:
Mysqlgrant all privileges on [database_name].* to 'user'@'remote_host'
identified by 'password'
Please read more about this at
http://dev.mysql.com/doc/refman/4.1/en/grant.html or whatever
I've got a master (Master) with a MERGE table of foo_t (comprising of
bar_a, bar_b, bar_c) in database 'Igloo'.
There are 5 slaves that replicate the Igloo table, but ignore the
Igloo.foo_t table.
This setup was working fine. If the Master server crashed or had a
prblem for some reason,
You still get two lines, it's just that one of the lines is blank, and the
other says, text to the screen.
Jesse
- Original Message -
From: Wai-Sun Chia [EMAIL PROTECTED]
To: Dan Buettner [EMAIL PROTECTED]
Cc: Jesse [EMAIL PROTECTED]; MySQL List mysql@lists.mysql.com
Sent: Thursday,
why did they change this? I reverted everything to 5.0.19 and I'm
using load data infiles again, with zero locking issues
It has always been like that.
load data infile seems to use different logic from replace delayed,
it does not lock at all
What table type do you have in each
Hi to all the group, I have a problem with a query using mysql
4.01+mysql+php
This is the form i use to get the data for the query:
FORM method=post action=http://www.ibtec.info/resbu.php;
h1Ingrese palabra a buscar/h1
INPUT type=text name=ci
INPUT type=submit value=Buscar INPUT type=reset
I think there is an error in your PHP logic. The line of code before the
while will cause the first row of $result to be retrieved, and will move the
cursor. That first row will never be used because the condition inside the
while will retrieve the next record right away.
$row =
You ought to choice one of these ways:
while ($row=mysql_fetch_row($result)){
echo trtd$row[1]/td/tr \n;
}
OR
$row = mysql_fetch_row($result);
do {
echo trtd$row[1]/td/tr \n;
} while ($row=mysql_fetch_row($result));
Marcelo Fabiani [EMAIL PROTECTED] escreveu na mensagem
On 8/24/06, João Cândido de Souza Neto [EMAIL PROTECTED] wrote:
You ought to choice one of these ways:
while ($row=mysql_fetch_row($result)){
echo trtd$row[1]/td/tr \n;
}
OR
$row = mysql_fetch_row($result);
do {
echo trtd$row[1]/td/tr \n;
} while ($row=mysql_fetch_row($result));
Bummer! I was hoping that you'd see what actually gets executed
during a SHOW DATABASES, like select * from user, table_privs where
so you could then run an EXPLAIN on it.
For me on 5.0.21 EXPLAIN SHOW DATABASES gives me an error so no joy there.
I suspect you've got a lot more entries in
I wrote my first VIEW in version 5 and it works just fine. It will
be a powerful way to generate output for the Bosses. Why it was taken
out on version 4 I have no idea.
Karl Larsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Karl Larsen wrote:
I wrote my first VIEW in version 5 and it works just fine. It will
be a powerful way to generate output for the Bosses. Why it was taken
out on version 4 I have no idea.
That's just how software develops. People start with the later-versioned
product, with full features
On Aug 24, 2006, at 6:13 PM, Daniel Kasak wrote:
That's just how software develops. People start with the later-
versioned
product, with full features and zero bugs, and progressively remove
features and add bugs, while decreasing the version number.
I've looked all over the web, and found
Hello,
when I open mysql table with access 97 using the latet mysql-odbc driver
( 3.51.12 ) I see only deleted records.
What is happening ?
I found many posts about this problem, but I can not, as told in this
posts, add timestamp or other fields because this tables are used by a
Andreas Moroder wrote:
Hello,
when I open mysql table with access 97 using the latet mysql-odbc
driver ( 3.51.12 ) I see only deleted records.
What is happening ?
I found many posts about this problem, but I can not, as told in this
posts, add timestamp or other fields because this tables
Daniel Kasak schrieb:
Andreas Moroder wrote:
Hello,
when I open mysql table with access 97 using the latet mysql-odbc
driver ( 3.51.12 ) I see only deleted records.
What is happening ?
I found many posts about this problem, but I can not, as told in this
posts, add timestamp or other fields
Andreas Moroder wrote:
Daniel Kasak schrieb:
Andreas Moroder wrote:
Hello,
when I open mysql table with access 97 using the latet mysql-odbc
driver ( 3.51.12 ) I see only deleted records.
What is happening ?
I found many posts about this problem, but I can not, as told in this
posts,
At 06:30 PM 8/24/2006, David Hillman wrote:
On Aug 24, 2006, at 6:13 PM, Daniel Kasak wrote:
That's just how software develops. People start with the later- versioned
product, with full features and zero bugs, and progressively remove
features and add bugs, while decreasing the version number.
Daniel Kasak schrieb:
Andreas Moroder wrote:
Daniel Kasak schrieb:
You won't break anything by adding a timestamp field. Trust us :)
And no, there is no way around this problem other than adding a
timestamp field.
From the 'mysql' command-line client, do:
... where DATABASE_NAME is the
32 matches
Mail list logo