Hola de nuevo, ahi va otra consulta de MySQL
Quisiera que una de mis columnas no tuviera valores repetidos, con lo cual
creo que deberia utilizar UNIQUE, y a la vez esta columna no pueda ser nula
en función del valor de otra columna. ¿Existe alguna posibilidad?
Me explico, tengo dos columnas,
At 08:40 13/01/2003 +0100, Vicente Valero wrote:
Hola,
Hola,
Tengo la versión 3.23.54 instalada sobre Windows. He esta leyendo algunos
documentos acerca de el soporte de claves foraneas y he visto que para ello
dicha versión necesita un patch llamado MySQL-MAX. En la sección de
downloads he
On Mon, Jan 13, 2003 at 09:41:12AM +1000, Jason Brooke wrote:
No, I've been ignored on this problem for 18 months now, for some reason.
Quite peculiar.
The limitations of replicate-do-db are documented in:
http://www.mysql.com/doc/en/Replication_Options.html
I found out about this
MySQL from New Riders, author Paul DuBois
HTH,
Ganbold
At 08:34 AM 1/8/2003 -0500, you wrote:
I got a gift certificate for book store. I am looking for good MySql
books with reference, examples, etc? Anyone have some ideas on good
books to look at
Chuck
This is what I have in /etc/my.cnf on my current MySQL server (dual
AthlonMP,2GB RAM)
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
log-slow-queries = slowqueries.log
set-variable = key_buffer=256M
set-variable = max_allowed_packet=1M
set-variable = table_cache=1024
set-variable =
Hi.
On Sun 2003-01-12 at 22:01:37 -0500, [EMAIL PROTECTED] wrote:
On Sun, Jan 12, 2003 at 08:12:35PM -0700, Rodney Broom wrote:
I'm trying to delete 5 million rows...
[...]
If I was deleting things regularly, I'd have to delete maybe a couple
hundred thousand rows every day.
[...]
When I
Haisam,
I want to insert into content an entire text document. How do I do
that without
puting the entire content into a variable, let's say in perl, and then
writing the
INSERT statement.
In MySQL, you have the LOAD_FILE() function to do this:
Hello,
please help me. I try to compile mysql 3.23.53 on HP-UX 11.11 and get the following
errer:
mysql-3.23.54/readline# gmake
source='rltty.c' object='rltty.o' libtool=no \
depfile='.deps/rltty.Po' tmpdepfile='.deps/rltty.TPo' \
depmode=gcc3 /bin/sh ../depcomp \
gcc -DUNDEF_THREADS_HACK
Vicente,
the language on this list is English. I will try to answer your
question, anyway.
The patch you're speaking of is no patch, but another table handler in
MySQL. Native tables are MyISAM, and MySQL has a number of alternative
tables it can handle. One of them is InnoDB. In MySQL, you can
I may add, that it is always the same comment, so the query is exactly the
same and SHOULD be cached.
-Ursprungliche Nachricht-
Von: Christian Rabe [mailto:[EMAIL PROTECTED]]
Gesendet: Sonntag, 12. Januar 2003 01:41
An: [EMAIL PROTECTED]
Betreff: Problem with query cache and comments
Jeremy Zawodny wrote:
On Fri, Jan 10, 2003 at 01:59:07PM +0100, Csongor Fagyal wrote:
Hi,
I have a RedHat 8 box /w MySQL 3.23.54, /w 640M RAM.
It looks like there are some sort of a memory leakage somewhere in the
system, because slowly (in a day or two) I run out of memory. Even SWAP
# - PLEASE HELP -- #
hi to all,
is it still true that mysql/innodb needs explicit
index creation on foreign keys?
why can't i use a standard syntax for foreign keys
creations?
i have a database schema (ddl) with over 50 tables and
i was trying to create the database on mysql when
The problem is with the new glibc-2.2.5-40 package released on October 3,
2002. Apparently its a known issue, and people are aware of it. The best
solution I've seen so far is to role back to a previous version of this
package, and its dependencies.
If you are a redhat member, you have access to
Hi,
I see your point re:
Some code to illustrate:
printf Query: %s\n, $query;
my $sth = $dbh-prepare ($query);
$sth-execute();
# metadata information becomes available at this point ...
printf NUM_OF_FIELDS: %d\n, $sth-{NUM_OF_FIELDS};
print Note: query has no result set\n if
I have a problem with a query:
I use an application where users can post messages. The messages are stored
in two tables that are related by the id of the new created message. I get
the last id with the following query: select max(id) as maxid from
tasker_app
The forum has many users and
I would suggest appending an ORDER BY atomtype first of all.
That's what I did, see original select statement:
mysql select distinct atomtype from `gentradedb`.`gpatomdb` order by
atomtype;
You could also experiment with SELECT DISTINCT to remove any dupes from
your output.
Experiment how?
Hi,
I removed an old mysql version and I installed a new one on a machine
running Suse 8.1 Linux.
shellrpm -i MySQL-client-3.23.54a-1.i386.rpm
shellrpm -i MySQL-shared-3.23.54a-1.i386.rpm
shellrpm -i MySQL-devel-3.23.54a-1.i386.rpm
shellrpm -qa | grep -i mysql
shellreboot
shellsafe_mysqld
I don't know if i understood you very well, but here's a try..
mysql select * from Classes;
++-+
| ID | Name|
++-+
| 1 | XO-312 |
| 2 | PA-211a |
| 3 | XUL-001 |
++-+
3 rows in set (0.00 sec)
mysql select * from Workshops order by ClassID,Date;
[root@localhost ~]# perror 13
Error code 13: Permission denied
Also check the permissions and ownership of /usr/local/var .
See the Post installation setup chapter from the manual.
http://www.mysql.com/doc/en/Post-installation.html
and
http://www.mysql.com/doc/en/File_permissions.html
On
HI,
I have a few questions related to DB archving / restore capability of
MySQL. Most of them are design issues but have a lot to do with what
MySQL provides.
PLease share your view on them.
1. How can i trigger a database archive when a certain data base limit
is reached in a table.
Ex: when
--- Amer Neely [EMAIL PROTECTED] wrote:
Greetings all. Hope someone could give me some pointers on this.
I am working at a small ISP in Montreal. Some of our corpo users. have
access to a MySQL database, that we created for them (usually, this DB is
named after there username). The way
Hi,
I've got a mysql application that was developed on win32 and linux that is
now going to be deployed on a Sun E250 Solaris 9 box with 3 36Gb non raided
SCSI disks. No problem I thought - the performance is fine on my PIII
850MHz laptop, so it will rock on an E250...
Not the case - the laptop
Description:
I'm unable to start more than 1 thread, here are
the processes launched, as far as I know, one mysqld daemon is launch
per client/connection, but not in this case :
root 191563 1443 0 Jan 10 pts/2 0:00 /bin/sh
/usr/mysql/bin/safe_mysqld --user=mysql
I'm confused , what is the difference and raw device and a disk
partition ?
ex: on innodb I'm using /dev/sda1 for raw device, is it correct ?
tnks.
sql,query
-
++ Dyego Souza do Carmo ++ Dep.
On Wednesday 08 January 2003 22:32, Stefan Hinz iConnect \(Berlin\) wrote:
Have you tried to reproduce them?
Bug #1: GRANT USAGE doesn't seem to create a user:
mysql GRANT USAGE ON *.* TO 'foo'@'foohost';
Query OK, 0 rows affected (0.26 sec)
mysql SHOW GRANTS FOR 'foo'@'foohost';
Empty
Hi,
I wonder if someone can paste a OLEDBSQL provider connection string to look at .
Many thanks..
Sam
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
I understand the SQL statement in MySQL to be SELECT sum(column name) FROM table;
but I would like to get a SUM of multiple columns. Is this possible??
Thanks,
Ryan
-
Before posting, please check:
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
Description:
Hi,
IMHO:
I think you should try :
1)
SET @a:=0;
LOCK TABLE your_table_name WRITE;
INSERT what_client_must_to_insert
SELECT @a:=MAX(ID) FROM tableetc
UNLOCK TABLE;
After unlock the table you can find the value of variable @a by doing:
SELECT @a;
2)
INSERT
Thank you for your responses Paul,
To get MySQL4 to use OpenSSL I had to install OpenSSL 0.9.7 and modify the
configure script to move my new include and lib
directories to the end of the loop where it's searches for the OpenSSL files
so it would see the 0.9.7 version last and therefore use
On Monday 13 January 2003 13:50, Richard Brenner wrote:
I use an application where users can post messages. The messages are stored
in two tables that are related by the id of the new created message. I get
the last id with the following query: select max(id) as maxid from
tasker_app
The
Could someone please post the basics on connecting to a MySQL 4 server from
PHP at my website using a secure connection? The server is ready to accept
a connection, I'm just not sure what to do next to initiate it. It seems
like I would need to set something up at our ISP to talk securely to the
Set up a loop where you delete with a LIMIT,
pause a few milliseconds to give others a chance to get in,
and loop until no records are deleted.
Philip Mak wrote:
I have a table in a database. I'm trying to delete 5 million rows from
it. But whenever I try to do this, while the delete command is
Does the user 'mysql' have write access to the mysql database and files?
Loren McDonald wrote:
Im not sure what has gone wrong but the mysql.users table is set as
read only. I am trying to grant user privileges but cant because of
this. How can I change the status so that I can add to it?
Ahmed,
1. How can i trigger a database archive when a certain data base limit
is reached in a table.
Ex: when 1,00,000 records is reached, archive to file and clean table.
You will have to wait for MySQL 5.0. This version will have SQL
triggers.
2. How can i restore multiple files into
I would like to return rows, with specific columns, for each individual in
my NAMES table, with address and e-mail if these exist. Thought I had the
syntax down but I'm getting NULL results where I know there is data. I'm
used to using SQL Server shortcut * for outer joins, guess that's catching
Description:
I've installed MySQL v4.0.8 chrooted like described in detail at
http://www.linuxquestions.org/questions/showthread.php?threadid=34338
Operating System is RedHat Linux v8.0 including ALL current available patches
...
As example I used the
Victoria,
Thank you for bug reports, both bugs are fixed.
That's fast :-))
What about the LOCAL bug (or feature)? I.e. you can start
mysqld --local-infile=1, or you can start MySQL Monitor like
mysql --local-infile=1, or even both, and it won't help. You cannot use
load data LOCAL.
* Stevens, Ryan
I understand the SQL statement in MySQL to be SELECT sum(column
name) FROM table; but I would like to get a SUM of multiple
columns. Is this possible??
Yes. You can add multiple columns inside the SUM() function:
SELECT SUM(col1+col2+col3) FROM table;
--
Roger
sql
Hi,
Since you don't specify your OS, I assume you are using Linux;
if you are using another UNIX like system (BSD, Solaris,...),
my explanations below may be useless :(
A disk partition (as /dev/sda1) is a bloc device,this is not the
same as a raw device. You can get more info in Linux HOWTO:
Hi,
I've got a mysql application that was developed on win32 and linux that is
now going to be deployed on a Sun E250 Solaris 9 box with 3 36Gb non raided
SCSI disks. No problem I thought - the performance is fine on my PIII
850MHz laptop, so it will rock on an E250...
Not the case - the laptop
On Thu, 2003-01-09 at 17:40, David Rock wrote:
Hello,
Can someone give me a some overview information regarding using SSL with
MySQL version 4? I want to setup a 128bit SSL connection between our website
hosted at an ISP and our MySQL (on FreeBSD) server which is hosted in our
office.
SELECT SUM(colA+colB) FROM TABLE ?
Stevens, Ryan wrote:
I understand the SQL statement in MySQL to be SELECT sum(column name) FROM table;
but I would like to get a SUM of multiple columns. Is this possible??
Thanks,
Ryan
Hi,
I compiled MySQL 3.23.54, try MySQL CLI. Everything
looks fine. But when I tried to connection MySQL
through mm.mysql JDBC Driver, I got:
08:25:09SQLDataManager: Connecting...
jdbc:mysql://localhost:3306/mysql
08:25:09SQLDataManager: EXCEPTION:
I don't think I have anything that should cause this. Here is my my.ini
from the the slave. The tables that are being excluded are not listed.
[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data
set-variable=max_allowed_packet=16M
log-slave-updates
log-bin
# Replication variables
Hi,
I compiled MySQL 3.23.54, try MySQL CLI. Everything
looks fine. But when I tried to connection MySQL
through mm.mysql JDBC Driver, I got:
08:25:09SQLDataManager: Connecting...
jdbc:mysql://localhost:3306/mysql
08:25:09SQLDataManager: EXCEPTION:
On Mon, 2003-01-13 at 14:11, Stevens, Ryan wrote:
I understand the SQL statement in MySQL to be
SELECT sum(column name) FROM table; but I would like to get a
SUM of multiple columns. Is this possible??
Yes, you may use:
SELECT sum(c1+c2) FROM table;
or even:
SELECT sum(table1.v +
Stupid filter fodder: sql,query,queries,smallint
-Original Message-
From: Dean Householder [mailto:[EMAIL PROTECTED]]
The problem is with the new glibc-2.2.5-40 package released
on October 3,
2002. Apparently its a known issue, and people are aware of
it. The best
Hi all,
I've seen the following code in MySQL cookbook:
eval
{
# move some money from one person to the other
$dbh-do (UPDATE money SET amt = amt - 6 WHERE name = 'Eve');
$dbh-do (UPDATE money SET amt = amt + 6 WHERE name = 'Ida');
# all statements succeeded; commit
My isp is Omnis.com.
They have mySQL on my host server, and I have entered some contact info
for a password login system. The system they already have doesn't let me
use email addresses for logins.
This is my first time using mySQL, how do I get it to link? Will it let
me use email for login?
I've read the manual concerning REVOKE commands but how would I
completely remove a user inside MySQL? I can't imagine that it's as easy
as removing them from the user table.
TIA,
Ed
mysql
-
Before posting, please check:
Hi Andy
Is MySQL loading the tables in to memory?
MySQL AB say running MySQL on 64bit system should be faster.
Sorry I can not be more help.
Simon
-Original Message-
From: Andy Eastham [mailto:[EMAIL PROTECTED]]
Sent: 13 January 2003 15:34
To: [EMAIL PROTECTED]
Subject: Solaris
Since the http://lists.mysql.com/ archives site is down, I'll have to
ask this question without the benifit of the archives...
I have a (very large) Perl script that has a bad tendency to cause the
following warning from myisamchk:
myisamchk: MyISAM file /var/lib/mysql//table_name.MYI
In the MySQL manual, under http://www.mysql.com/doc/en/Upgrading-from-3.23.html
it says:
---
The old C API functions mysql_drop_db, mysql_create_db, and mysql_connect
are not supported anymore, unless you compile MySQL with
CFLAGS=-DUSE_OLD_FUNCTIONS. Instead of doing this, it is
I´m upgrated the mysql to 4.0.8 version ( from 4.0.6 )
after this my server is going down of one hour for another one.
the log message is:
/usr/local/mysql4//libexec/mysqld: ready for connections
mysqld got signal 11;
This could be because you hit a bug. It is also
would like to help you but I can't. This is PHP issue, not MySQL-s.
SSL connections are supported by MySQL, they are also available in C API
but I am not sure if and how PHP uses them.
Looking up into PHP manual http://www.php.net/manual/en/ref.mysql.php
won't show up needed functionality for
At 12:59 +0200 1/13/03, Octavian Rasnita wrote:
Hi all,
I've seen the following code in MySQL cookbook:
eval
{
# move some money from one person to the other
$dbh-do (UPDATE money SET amt = amt - 6 WHERE name = 'Eve');
$dbh-do (UPDATE money SET amt = amt + 6 WHERE name =
[EMAIL PROTECTED] wrote:
I've read the manual concerning REVOKE commands but how would I
completely remove a user inside MySQL? I can't imagine that it's as easy
as removing them from the user table.
If you remove them (or blank their password) in the user table, they'll
have no way of
Angel Flow wrote:
Would like to ask people's thoughts on whether Perl or
PHP has higher performance with MySQL. I've heard
rumours that DBI is slower than the PHP MySQL driver.
I would say that comparing DBI to ADODB is more appropriate; PHP more or
less directly calls the mysql C library
Stephen Brownlow wrote:
You can make backup of the database and then drop the database..
Why do you want to do it?
When maintenance is necessary, it would be far better to be able to:
1. turn off one database,
2. use myisamchk, Unix or other applications to adjust it in any way,
3. turn it
Rodney Broom wrote:
If so, then the answer is that there isn't such a data type. If you want a link, then you'll have to make it yourself. I suggest making your column a varchar(). Then, you ~might~ get the data with a query like this:
SELECT CONCAT(CONCAT('a href=', link, ''), link, '/a')
Mike wrote:
I'm making a library website where users can store preferences about the
types of books/cds/etc... they like (e.g. romance, rock, cooking,
etc).
Once a month the list of 'New Releases' is updated. Currently there is
a New
Release box which shows releases based on the users
That would work but is there no way to completely remove their record?
Ed
On Mon, 13 Jan 2003, Michael T. Babcock wrote:
[EMAIL PROTECTED] wrote:
I've read the manual concerning REVOKE commands but how would I
completely remove a user inside MySQL? I can't imagine that it's as easy
as
MySQL gurus:
I'm a big fan of the general query log for taking the occasional audit
of activity against our database server, as well as a tool for checking
on the efficiency of new (mostly PHP) projects that interact with MySQL.
What I don't like is that I have to stop and restart the server
I also got error from terminal:
sendsig: useracc failed. 0x8003bf6dbe00
0x005020
Pid 3093 was killed due to failure in writing the
signal context - possible static overflow.
I tried to logon on as mysql user. I didn't set
mysql user password.
I looked at hostname-bin.err:
MySQL
Simon,
Thanks, for the reply. I guess I better try the 64 bit version and see if
it makes a difference.
I'll report back what I find.
Cheers,
Andy
-Original Message-
From: Simon Green [mailto:[EMAIL PROTECTED]]
Sent: 13 January 2003 16:58
To: 'Andy Eastham'; [EMAIL PROTECTED]
On 13 Jan 2003, at 18:49, Tonu Samuel wrote:
I would like to help you but I can't. This is PHP issue, not MySQL-s.
SSL connections are supported by MySQL, they are also available in C API
but I am not sure if and how PHP uses them.
Looking up into PHP manual
On Fri, 10 Jan 2003, Michael T. Babcock wrote:
if test -n `ps acx|grep mysqld`; then
/usr/bin/mysqladmin flush-logs
fi
You're probably running it as root with the password loading from the
/root/.my.cnf or something. Try adding the -uroot -p
In the last episode (Jan 13), Toomas said:
Hello List,
Is there a simplier way to embed an image stored in BLOB field into
HTML than using 2 calls to Perl scripts - one to generate HTML and
another call from that HTML via IMG tag to retrieve and print image?
I mean, something like you do it
Hi All,
Trying my best to maintain some production servers running
mysql-max-3.23.53a-pc-linux-gnu-i686 with one master and one slave.
We keep having issues where we create a new table on the master, and
a short while later the slave will crash because it starts trying to
perform queries which
Is there any way to disable log messages being written to the standard
output using Embedded Server? Using mysqld, they are automatically
redirected to mysql.err (under Windows, at least), but there seems to be
no way to do this in Embedded.
We would like to be able to display our own output to
Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
On Monday 13 January 2003 17:49, Tonu Samuel wrote:
Hi,
Currently PHP's mysql extension doesn't support SSL. This will be available
in PHP 5.
Regards
Georg
-
Before posting, please check:
http://www.mysql.com/manual.php
Matthew K. Gold wrote:
I agre with the DuBois recommendation. I have a couple of quibbles, but
overall, I think it's a great book (and I did a pretty exhaustive check when
I was first learning mysql.
Of course, if you want a generic how-to on designing databases or SQL
itself, there are an
Hello
I have two tables of InnoDB type.
CREATE TABLE `ledger` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) default NULL,
PRIMARY KEY (`id`),
KEY `id` (`name`)
) TYPE=InnoDB;
CREATE TABLE `voucher` (
`id` int(11) NOT NULL default '0',
`vdate` date NOT NULL default
Hi,
SELECT LEFT(YOUR_COLUMN,2) FROM YOUR_TABLE.for position
SELECT RIGHT(YOUR_COLUMN,2) FROM YOUR_TABLE for type
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hello, I'm in the process of moving from Postgres to MySQL and I have a
question.
+How do you prevent a field from being left empty?
I have an InnoDB table that looks like the following.
CREATE TABLE `stuff` (
`stuff_id` int(11) NOT NULL auto_increment,
`somevalue1` varchar(35) NOT NULL,
Matt,
the variable mysql_embedded makes InnoDB more silent:
heikki@hundin:~/mysql-4.0/sql grep -n mysql_embedded *.cc
ha_innodb.cc:659: if (mysql_embedded) {
ha_innodb.cc:768: srv_print_verbose_log = mysql_embedded ? 0 : 1;
mysqld.cc:390:bool mysql_embedded=0;
mysqld.cc:392:bool
From you example, not quite sure what you are trying to do (I could if, for
example generic tree was 0199, and 01 was tree and last two characters were
color or something like that)
At any rate, you can use string functions to pull data from portions of
fields to build whatever you want to search
Was working on a database job last night, and ran into a little stumbling
block, hope all this comes though in email, if you see a ® it is a
registered mark just in case the email clients out there change it around.
So I have a simple database, one table, and say one field, varchar(14) and
in it
Hello,
This is discouraging after I spent most of the weekend getting OpenSSL
working with our MySQL 4 server. Unfortunately I can't use Stunnel to secure
the connection between our website and our MySQL server because our ISP will
not allow me to run the Stunnel daemon on their servers. They
on 01/13/2003 1:58 PM, Paul DuBois at [EMAIL PROTECTED] wrote:
How do you know this isn't simply a failure of your terminal window
to display the character properly? That's the most likely problem
here, not that your data are stored incorrectly.
Well, I don¹t for certain, I just did a dump
At 13:51 -0800 1/13/03, Scott Haneda wrote:
Was working on a database job last night, and ran into a little stumbling
block, hope all this comes though in email, if you see a ® it is a
registered mark just in case the email clients out there change it around.
So I have a simple database, one
Hi,
MySQL 4.0.9, a new version of the world's most popular Open Source Database,
has been released. It is now available in source and binary form for a number
of platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
Note that all mirrors may not be up to date;
Maximo,
My company's website is running version 3.23.53a, and the main client
that
uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in
PHP? Although this manual entry is talking about the C API functions,
I
assume PHP uses these to communicated with MySQL. Perhaps I might be
Ed,
That would work but is there no way to completely remove their
record?
With REVOKE, you can partially or totally revoke privileges from users.
What you can't do with REVOKE (in MySQL) is to erase a user completely.
For this, you will have to DELETE FROM mysql.user WHERE User =
At 23:45 +0100 1/13/03, Stefan Hinz, iConnect (Berlin) wrote:
Maximo,
My company's website is running version 3.23.53a, and the main client
that
uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in
PHP? Although this manual entry is talking about the C API functions,
I
At 23:40 +0100 1/13/03, Stefan Hinz, iConnect (Berlin) wrote:
Ed,
That would work but is there no way to completely remove their
record?
With REVOKE, you can partially or totally revoke privileges from users.
What you can't do with REVOKE (in MySQL) is to erase a user completely.
For this,
on 01/13/2003 2:10 PM, Scott Haneda at [EMAIL PROTECTED] wrote:
How do you know this isn't simply a failure of your terminal window
to display the character properly? That's the most likely problem
here, not that your data are stored incorrectly.
Correct you are, the data in MySql was clean,
Description:
There seems to be a problem with mysql replication. When the slave server encounters
sql that uses backticks instead of single quotes. The
+replication stops until you manually advance the position number in the master.info
+file.
How-To-Repeat:
1. Set up a replication server
2.
Hi
First off I would like to say I appreciate all your help very much.
Now, here's what I have.
I installed, and confirmed that it runs properly, the Connector/J v3
drivers. my resin.conf looks like this:
resource-ref
res-ref-namejdbc/FormsAreUs/res-ref-name
Hello,
I need to get a single result from a SELECT from a table with the following sturcture:
component - varchar(25) primary key
catNum - varchar(25) primary key
price - decimal(10,2)
my component list may contain duplicate catNum ie:
primary drive -WD1GJB
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John Bateman wrote:
Hi
First off I would like to say I appreciate all your help very much.
Now, here's what I have.
I installed, and confirmed that it runs properly, the Connector/J v3
drivers. my resin.conf looks like this:
resource-ref
Just tried. Nope...
mysql grant all privileges on mysql.* to ext identified by 'ext1tex2'
with grant option;
ERROR 1036: Table 'user' is read only
--
Loren McDonald AKA MisterrMac
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com
Does the user 'mysql' have write
On Mon, Jan 13, 2003 at 03:45:59PM -0300, Maximo Migliari wrote:
In the MySQL manual, under
http://www.mysql.com/doc/en/Upgrading-from-3.23.html
it says:
---
The old C API functions mysql_drop_db, mysql_create_db, and mysql_connect
are not supported anymore, unless you compile
Sounds like the same problem I'm having (for which I'm still stumped and
don't know what has caused it): table mysql.user is read only.
Test this by logging into mysql and using the GRANT or REVOKE
statements.
--
Loren McDonald AKA MisterrMac
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
Excellent! It works.
H M Kunzmann wrote:
Yes there is !
Use LOAD_FILE(path_name) as the value component of the insert/update
statement
On Mon, 2003-01-13 at 00:41, Haisam K. Ido wrote:
I have the following table,
CREATE TABLE cp (
id INT(11) NOT NULL auto_increment,
file
1 - 100 of 115 matches
Mail list logo