> Hi, I am curious if there is a way to delete exactly the same rows from a
> table with one query?
> Or must I do select and delete one query at a time?
> I accidentally parse an html file twice, and I want to keep the rows that
> are distinct.
bonjour,
use: deletewhere some-matchi
> simrad_4# safe_mysqld --skip-grant-tables &
> [1] 57953
> simrad_4# Starting mysqld daemon with databases from /var/db/mysql
> simrad_4# mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1 to server version: 3.23.38
> Type 'help;' or '\h' for help.
> Hi,
>
> I'm new to mysql. I've installed an RPM undr Linux PPC and after running mysql
>server as root and trying to use a sample database from Paul Dubois book MySql, I '
>ve got the error 13, can't create directory/file ./samp_db/president.xxx.
>
> The thing is I'm using an example DB, any
> > When i try to insert records into a mysql table through a php script, it
> > is not inserting all the records. eg, i tried to insert 100 records, it is
> > inserting only 94 records...
> > plese help me in sorting out this problem
bonjour,
trying to insert duplicate rows in a unique
> (REGEXP).
>
> I have a text field that contains some plain text intermingled with html
> tags. In querying the database, if the keyword I'm searching for falls
> within the plain text, that record should be returned. However, if the
> keyword falls within an html tag, it should not be returned
> I am trying to use php to print my results. This is my code (I have checked
> to see if fields are correct with regards to spelling and so on):
>
> printf("Genus: %s\n", mysql_result($result,0,"genus"));
>
> and I get the error message:
>
> Warning: Supplied argument is not a valid MySQL resul
> >Thank you all for your original suggestions, but I'm still having problems.
> >I copied this verbatim from the MySQL docs and tried it on two seperate
> >servers:
> >
> >mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
> > ->IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
> >ERROR
> Installing mysql on solaris 6 sun4u sparc SUNW,Ultra-5_10
> release:
>
> -- mysql-3.23.38.tar.gz
>
> via
> ./configure --prefix=/dir --with-low-memory
Is that really what you type: --prefix=/dir ?
strange name for a DIRectory? Can be a reserved word.
> make
> make install
>
> I get to:
>
> ya
> echo("You must review the site"); } else {
> if (!isset($anegative)) {
> echo("You must review the site"); } else {
> connectdb();
> mysql_select_db(xtopsites);
^^ quotes
> $sql = "insert into sitesats set areview='$areview', apositive='$apositive',
>anegative='$anegat
> When I run test.php I get this:
>
> Warning: Supplied argument is not a valid MySQL result resource in common.php on
>line 27
> 0
>
> Here are lines 25-27:
> 25: $sql = "select urate, arate, inhits from sitestats where id = $id";
> 26: $r = mysql_query($sql);
> 27: $row = mysql_fetch_array($r)
> >The Linux kernel is 2.2.13 and has been installed from a Mandrake
> >distribution. This is also the source of Apache, PHP 3 and MySQL. The
> >distribution puts files in non-standard places so I am wondering if the
> >solution to my problem is to find the right base directory to use in the
>
Have you tried 'flush privileges' after having set root password?
jean-michel
On Thu, 31 May 2001, Damnish wrote:
> I am using MySql on linux.
> I can start mysqld by "safe_mysqld --user=mysql --skip-grant-tables &
> But when i try to start it withour --skip-grant-tables, it said A
On Mon, 28 May 2001, Lefebvre, Cedric wrote:
>
> I have a problem adapting a multiple select to MySQL.
> Can someone help me ?
>
> Here is my request (Oracle format)
>
> SELECT Tactic.teamCode FROM Tactic WHERE
> Tactic.teamCode NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE
> Game.gameTu
On Sun, 27 May 2001, David Loszewski wrote:
>
> when you first install mysql server does it assign a default password
> becuase it tells me to enter these in to make a password for my server,
> but I don't know what the heck to do with them, but when I try them it
> says access denied
>
> /u
On Fri, 25 May 2001, Stephanie Deville wrote:
> I'm running FreeBSD 3.4, Apache 1.3.9 w/ php4 and mysql 3.22.32. The
> problem I'm having is that my php scripts work fine, mysql works fine. When
> I run a php script, everthing in the script works up to the point were I try
> mysql_connect. I
On Fri, 25 May 2001, Andrey Kotrekhov wrote:
> I don't agree.
> If mysql install in other directory then /usr/local
> you need use --with-mysql=mysqldir
> and sometimes --with-mysql-include and --with-mysql-lib
> options.
>
> > Do you need to specify a directory? I just did --with-mysql
> >
>
On Sun, 29 Apr 2001, Philippe Louis Houze wrote:
> Date: Sun, 29 Apr 2001 10:56:52 -0400
> From: Philippe Louis Houze <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: Password security
>
> Hi,
>
> How do you keep MySQL password out of view of "visitors" when needed in PHP to
>access
On Wed, 25 Apr 2001, newsgroups wrote:
> Date: Wed, 25 Apr 2001 20:15:07 -0400
> From: newsgroups <[EMAIL PROTECTED]>
> To: MySQL-Group <[EMAIL PROTECTED]>
> Subject: File Not Found Error
>
> Sorry to be such an everything newbie. Perhaps this a unix error and not
> MySQL but a simple Describe
On Fri, 20 Apr 2001, Siomara Pantarotto wrote:
> Date: Fri, 20 Apr 2001 19:35:52 -0300
> From: Siomara Pantarotto <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: ERROR 1046: No Database Selected
>
> Hi all,
>
> I am getting this error
>
> mysql> cre
On Thu, 12 Apr 2001, Dennis Gearon wrote:
> Date: Thu, 12 Apr 2001 15:16:42 -0700
> From: Dennis Gearon <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: relationship/field design
>
> I have a table design question, looking for tips, not the exact sql to
> create the tables.
>
> I have tri
On Tue, 10 Apr 2001, Erik Kabo wrote:
> Date: Tue, 10 Apr 2001 18:37:17 -0400
> From: Erik Kabo <[EMAIL PROTECTED]>
> Reply-To: Erik Kabo <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: client problems
>
> Hi,
>
> I installed MySQL version 3.23 in RedHat 7.0 using gnorpm. After I install
On Fri, 6 Apr 2001, Kenneth wrote:
> Date: Fri, 6 Apr 2001 10:22:29 +0800
> From: Kenneth <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: rpm with php
>
> Hello All,
>
> I'm trying to install MySQL RPM with php.
> Should I use:
>
> --with-mysql or
>
> --with-mysql=/usr/bin or
>
> -
On Fri, 6 Apr 2001, Vigile wrote:
> Date: Fri, 6 Apr 2001 01:26:05 -0400
> From: Vigile <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Duplicate of Everything in Table
>
> I have a table, that DOES NOT have a primary key, but is setup like this:
>
> Field Type Attributes Null Defa
On Thu, 5 Apr 2001, Dennis Gearon wrote:
> Date: Thu, 05 Apr 2001 14:24:25 -0700
> From: Dennis Gearon <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Foreign Keys
>
> Are people using Mysql using foreign keys and how are they using them?
> It seems that the way to use them is with the sc
On Mon, 2 Apr 2001, Derek Sivers wrote:
> Date: Mon, 02 Apr 2001 19:42:18 -0700
> From: Derek Sivers <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: NEW "MAKE" BUG? sigcontext.h
>
> Doing a "make" on the newest MySQL stable 3.23.36 source tarball - on a
> stock Cobalt RaQ3 (Linux 386) wh
25 matches
Mail list logo