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, una
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 visto
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 limitat
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.
[...]
> Wh
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:
http://www.mysql.com/doc/en/String_function
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 -DHAVE
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 c
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
Hi,
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
sp
# - 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 t
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 $s
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 sometim
> 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
Hi,
I removed an old mysql version and I installed a new one on a machine
running Suse 8.1 Linux.
shell>rpm -i MySQL-client-3.23.54a-1.i386.rpm
shell>rpm -i MySQL-shared-3.23.54a-1.i386.rpm
shell>rpm -i MySQL-devel-3.23.54a-1.i386.rpm
shell>rpm -qa | grep -i mysql
shell>reboot
shell>safe_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 Sa
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 1,
--- 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
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
my
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. Desenvolvi
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
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:
http://www.mysql.com/ma
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:
>
* Richard Brenner
> 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"
Oops
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 what_cl
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 it.
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"
> T
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
r
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?
I
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 d
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 my-medium.cn
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.
Furthermor
* 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. B
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:
java.sql.SQLExce
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
master-host=x.
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:
java.sql.SQLExce
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 + tab
> 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. T
On Mon, 2003-01-13 at 16:41, David Rock wrote:
> 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 t
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 tr
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?
chr
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 Performance
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
myisa
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 in a multipart e-mail message?
A more general qu
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 prefera
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 poss
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 th
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 = 'I
[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 loggi
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 fu
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(''), link, '') FROM stuff;
But ple
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 prefe
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 eas
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 pr
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:
MySQ
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 http://www.php.net/manual/en
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 -uro
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
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 in
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 t
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
anothe
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
anothe
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
anothe
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
anothe
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 mysq
>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 hav
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 ta
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; If
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 =
'user2bremov
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
assum
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, y
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 c
>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. en
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:
jdbc/FormsAreUs
javax.sql.DataSource
And when I 'use' this co
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
- W
-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:
jdbc/FormsAreUs
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
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com
>
> Does the user 'mysql' have write access to t
1 - 100 of 119 matches
Mail list logo
