In the last episode (Nov 02), Kevin McManus said:
> >Description:
> The WHERE statement does not correctly return rows matching NULL
> fields when using NOT with IN, LIKE or REGEXP - or using REGEXP
> with negation ^
Please see http://www.mysql.com/doc/en/Working_with_NULL.html
At 5:21 + 11/2/02, Kevin McManus wrote:
Date: Sat, 2 Nov 2002 05:09:44 +
From: Kevin McManus <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: behaviour of WHERE statement with NULL fields
User-Agent: Mutt/1.4i
Description:
The WHERE statement does not correctly return rows mat
Hi I'm new to this list so forgive me if I break some rules with this first
post.
I have been receiving random mysql errors over the past few days where the
server just dies. The server dies at various times, under various loads.
I have included as much information as I can from various places o
Date: Sat, 2 Nov 2002 05:09:44 +
From: Kevin McManus <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: behaviour of WHERE statement with NULL fields
User-Agent: Mutt/1.4i
>Description:
The WHERE statement does not correctly return rows matching NULL
fields when using NOT with
mysql_fetch_row does not return an associative array, only enumerated.
http://www.php.net/manual/en/function.mysql-fetch-row.php
Try mysql_fetch_array instead.
-Original Message-
From: Tom Rogers [mailto:trogers@;kwikin.com]
Sent: Friday, November 01, 2002 7:53 PM
To: Steve Jackson
Cc: MyS
Hi,
Friday, November 1, 2002, 11:11:52 PM, you wrote:
SJ> Sorry to keep on at you guys but this is really getting to me now!
SJ> I want to pull a shipping quantity (the very last record in the Db) into
SJ> a page and am still having problems. Tried looping through the records
SJ> and I can't seem
At 18:22 -0600 11/1/02, John Ragan wrote:
how about a double left join. pick your base
table, and then pick your request table twice,
with each request table left joined to the base
table and each returning its appropriate field.
maybe?
look in the portals for a tool that makes the
outlandish c
At 19:19 -0500 11/1/02, Paul wrote:
Does MySQL support cascaded deletes? If so is it only with InnoDB?
Thanks
Paul
Right, only with InnoDB, and only as of 3.23.50.
-
Before posting, please check:
http://www.mysql.com/manual.
At 15:25 -0600 11/1/02, Aaron Merrick wrote:
Ladies & Gentlemen,
The manual says "FULLTEXT indexes are used with MyISAM tables and can be
created from VARCHAR and TEXT columns at CREATE TABLE time or added later
with ALTER TABLE or CREATE INDEX."
Believe the manual.
I get the following error
At 21:45 +0100 11/1/02, ddd wrote:
hello
i'm using mysql 3.23.41
i want to search in fulltext indexed table for word "Down-Syndrom" but the
result is the same like when I search "138721-Syndrom"..
WHY
"-" isn't considered part of a word so you're really searching for
"down" or "syndrom" i
At 16:27 -0800 11/1/02, CM Miller wrote:
Still workin' at it here.
Ok, I've added to my PATH
/usr/local/MySQL/mysql-3.23.-52-pc-linux-gnu-i686/bin
and at least I'm getting this now
$ mysql
Error 2002: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (111)
Sounds like the
At 16:01 -0500 11/1/02, [EMAIL PROTECTED] wrote:
Hello,
I am relatively new to using MySQL and cannot understand why when I
use mysqladmin or mysql client with any other id than root I get the cannot
connect to local MySQL Server though socket '/var/lib/mysql/mysql.sock. Can
someone tell me
Steve,
The first thing I'd advise you to do is to check out PHP for showing the
data. It's a language similar to Perl and it's perfecdtly matched for MySQL
(you'll see a lot of sites using a MySQL/Apache/PHP combination). check it
out at http://www.php.net I also have a large ebook on MySQL/PHP
Hello,
I am relatively new to using MySQL and cannot understand why when I
use mysqladmin or mysql client with any other id than root I get the cannot
connect to local MySQL Server though socket '/var/lib/mysql/mysql.sock. Can
someone tell me if it's a permission's problem or something else.
Hello.
I am starting a project that requires a simple database for use as a
back-end to a web-accessible look-up facility. When I say "simple" I
mean that the data is static and that the queries are done on single
keys.
The catch is that I have zero experience in any kind of database work. I
> That's actually very SQL related ... well, MySQL related, but
whatever;
> the success stories are always good (although accompanying hardware
> description is helpful too; I'm sure anyone could handle 100M
pageviews
> with the Earth Simulator ... :)
Well, my source for tech is Frys Electronics.
There is a "primary key" which is not the main order to access rows.
What I am emulating is a large memory space and the "primary key" is just
used not to duplicate rows.
In the current DB I use, I simply use the row number as my "memory pointer".
Since rows are fixed length, it should be a strai
Still workin' at it here.
Ok, I've added to my PATH
/usr/local/MySQL/mysql-3.23.-52-pc-linux-gnu-i686/bin
and at least I'm getting this now
$ mysql
Error 2002: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (111)
I'm not sure what it is trying to tell me, btw, I'm
run
the manual indicates that "mysql follows ansi
sql, and a comparison with null is always null".
after years of server work, i still sometimes
forget that, at least in all the servers that
i've used, null and nothing are not the same
thing.
> >Description:
> Empty fields are not matched
how about a double left join. pick your base
table, and then pick your request table twice,
with each request table left joined to the base
table and each returning its appropriate field.
maybe?
look in the portals for a tool that makes the
outlandish claim of querying any data source ever
Does MySQL support cascaded deletes? If so is it only with InnoDB?
Thanks
Paul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reques
Trying again, sql.
when you grant privileges, does the user have to exist at the start?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
>Description:
Uneventful download and build of Source Package for 4.0.4 beta. Upon
running the test suite, the program aborts after 30 seconds of waiting for
a master.pid file to be created. truss and error log analysis show this is
due to either: the lack of a valid latin1_de.conf charset fi
>Description:
If a thread grabs a lock on a table, the
__unlocked__ tables don't show properly in "show table status". In particular,
almost all fields (except for table name) are returned as NULL.
>How-To-Repeat:
show table status from mysql;
lock tables my
Frank LaLone wrote:
I am having a nightmare of a time getting Red Hat 7.3 to connect to Mysql
using the jdbcwith jakarta-tomcat-4.1.12.
I had to switch to a new dedicated service that went from Red Hat 7.2 to
Red Hat 7.3 . Everything else is the exact same version of Java, Tomcat,
and the
On Friday, November 1, 2002, at 05:39 PM, [EMAIL PROTECTED] wrote:
Hi,
Hello.
I'm new to mysql and I'm reading a pdf book on how to change the
default
password for admin to my own choosing.
The problem is once I do the steps of -password mypass it comes back
with
an error message.
Try to do
Mark Lewellen wrote:
In the time since this posting, has the capability of
using tables with 2 different character sets been added?
If so, how is it done?
If not, what workarounds have people used? In case 1)
above, is it feasible to have multiple servers running,
each configured with a differe
Hi, I'm new to mysql and I'm reading a pdf book on how to change the default
password for admin to my own choosing.
The problem is once I do the steps of -password mypass it comes back with
an error message.
I'm not for sure what the message is because I'm at work now and its on my
home machine.
Michael,
- Original Message -
From: "Michael Ryan" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, November 01, 2002 3:38 PM
Subject: InnoDB Status
> Hi. I'm new to mailing lists so I don't know if this will work or not yet.
>
> I'm using the InnoDB table type with M
Howdy -
I have a question concerning MySQL performance. From the list, it seems to
be the topic as of late!
Database Server: Dual Pentium III 1.2GHz COMPAQ server with 2GB of RAM
running Red Hat LInux, 7.2 (Enigma). MySQL version is 3.23.52-Max-log. All
tables are InnoDB.
Storage: All MySQL
Hi-
From sections 4.6 and 2.3.3 of the mySQL manual, it
appears that Chinese character encodings are supported
in the v 3.23.53 binaries (traditional with 'big5' and
simplified with 'gb2312' and 'gbk'). However, that
discussion only lists ways in which mysqld can be
configured with '--default-
I am having a nightmare of a time getting Red Hat 7.3 to connect to Mysql
using the jdbcwith jakarta-tomcat-4.1.12.
I had to switch to a new dedicated service that went from Red Hat 7.2 to
Red Hat 7.3 . Everything else is the exact same version of Java, Tomcat,
and the jdbc connector.
I ca
I'm not sure about not being able to put FULLTEXT on blobs, but it would
make sense that it only works on specifically text fields. Here is the
syntax to change the column type (this may affect the data stored so you
might want to dump the data and reimport after you have changed the column
type)
I think this is because a NULL is not and empty string. They are different
things. to match NULL you got to do:
WHERE grp IS NULL or to exclude NULL: WHERE grp IS NOT NULL.
I think that NULL values are excluded from string comparisons.
I might be wrong though!
JFernando
** sql **
-Ori
Ladies & Gentlemen,
The manual says "FULLTEXT indexes are used with MyISAM tables and can be
created from VARCHAR and TEXT columns at CREATE TABLE time or added later
with ALTER TABLE or CREATE INDEX."
I get the following error when I try to add a full text index for a
mediumblob column - but not
>Description:
Empty fields are not matched using where clause
NOT IN
NOT LIKE
NOT REGEXP
Also not matched using regular expression negation [^]
>How-To-Repeat:
SELECT * FROM bugtest WHERE grp REGEXP '[^AB]'
Returns
Here you go -
http://www.mysql.com/information/benchmarks.html
---
I'm just now starting to play with MySQL. I had a client ask me how it
performance compared to Oracle, DB2, and MS SQL server. Does anyone know of
any benchmarks of other specs that can compare performance?
-
I'm just now starting to play with MySQL. I had a client ask me how it
performance compared to Oracle, DB2, and MS SQL server. Does anyone know of
any benchmarks of other specs that can compare performance?
-
Introducing NetZero Long Distance
1st month F
hello
i'm using mysql 3.23.41
i want to search in fulltext indexed table for word "Down-Syndrom" but the
result is the same like when I search "138721-Syndrom"..
WHY
thanks
SQL command:
select IDpage, URL from news where match Words against ("Down-Syndrom");
O'Reilly's MySQL Cookbook has been released. Information is available at:
http://www.kitebird.com/mysql-cookbook/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi!
On Friday 01 November 2002 15:03, Jon Frisby wrote:
> Why not just do:
> DELETE FROM MyChannels;
> DELETE FROM MyPackages;
>
> If you're concerned about atomicity, simply acquire a lock on both
> tables at once first.
Exactly, it was my concern. I'm not using MySQL tables with transaction
sup
So add the user.
See the privilege section of the manual. The GRANT command.
[EMAIL PROTECTED] wrote:
I have the MySQL client installed on "workstation_2". MySQL is installed on
"server_1". When I try to login to the MySQL server using the admin client
it tries to login using username [EMAIL PR
I did the configuration below but the server doesn´t make the replication.
I tryed some commands.
start/stop slave
status master
but they didn´t.
What else do I have to do?
Alexander
sql,query
> - Original Message -
> From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
> To: "Alexander Burbell
I have the MySQL client installed on "workstation_2". MySQL is installed on
"server_1". When I try to login to the MySQL server using the admin client
it tries to login using username [EMAIL PROTECTED] and it will
not let me specify another user like [EMAIL PROTECTED] The problem
is that [EMAIL PRO
If you do:
SELECT * FROM MyChannels, MyPackages;
Then you should also get nothing because what you're asking the database
to do is to perform a cartesian cross of the rows in both tables. Since
there's no row in one of the tables, the cross will contain no rows.
Ideally one could do:
DELETE FR
I have done this on about 72,000 domains.
Set up one master group.
Allow databases to be created under the name the user wants.
Then configure the grant statement so that it uses their virtual host name.
GRANT ALL on dbasename TO [EMAIL PROTECTED] IDENTIFIED BY
'somepassword';
FLUSH PRIVILEGES;
On Redhat Linux is there an easy way to have an ISP style setup where
each "user" has their own database directory?
Why not just create a database per user and run them all under the one
MySQL instance?
Then call the database the name of the user, or some unique name anyway.
You can then limit
>Description:
Multi-table delete is not working if one of the tables in the delete statement is
empty.
In my case I tried:
DELETE FROM MyChannels, MyPackages USING MyChannels, MyPackages
According to documentation this should delete all data in both tables.
In my case table MyPackages was empty
hi all,
i'm trying to get mod_auth_mysql up/running on my OSX 10.2.1 box
to date, i've successuflly gotten Apache2, PHP, Perl, & MySQL humming along
together. Here's the env:
my current apache server-info reports as:
Apache/2.0.44-dev (Unix) mod_perl/1.99_07-dev Perl/v5.8.0
mod_webapp
>From: <[EMAIL PROTECTED]>
>
>I need a 20 GB + DB that I'd like to access by row number or physical order.
Are you certain?
In my experience, people who claim they need to access by physical order are making a
bunch of faulty assumptions, and REALLY want to access by temporal order, which is not
>Description:
We are running MySQL 3.23.53 on Solaris 2.6. There seems to be a problem
with MySQL finding libz.so. A plain vanilla installation (using ./configure
with no extra arguments) results in make carping and then exiting. We thought
we had a sort of workaround in passing the following arg
John Chang wrote:
In the output table I see:
I Spy Eddie Murphy
I Spy Kelly Robinson
I Spy Owen Wilson
This discussion has taken place in the last two weeks before; what
you're missing is that it doesn't matter what your output looks like in
mysql; you're supposed to format it in your progr
Okay killall -HUP then
-Original Message-
From: Mark [mailto:admin@;asarian-host.net]
Sent: Thursday, October 31, 2002 6:45 PM
To: Black, Kelly W [PCS]; 'CM Miller'; [EMAIL PROTECTED]
Subject: Re: Still not getting a mysql prompt
- Original Message -
From: "Black, Kelly W [PCS]"
" want to see something like this:
I SPY Eddie Murphy, Kelly Robinson, Owen Wilson
OR
I SPY Eddie Murphy
Kelly Robinson
Owen Wilson"
-- Not sure if you can return the column value of title only once, but when
you are displaying the field you can hide it then.
"Here is the
1) What is the correct select statement to use in MYSQL so that it only
shows the TitleName once and all the stars in a video. I have a search
button for Titles and when it gets submitted it shows it not the way I want it.
So if there is a Video with TitleName=I Spy and the stars are Eddie Murp
I've made a few changes to my Solaris - MySQL setup, following some
instructions in the manual for tuning.
(512MB RAM - single SCSI disk - combined web/db server - about 150 db tables
all with small query returns / single updates / hardly any joins)
I have set
max-connections = 200
table-cache = 2
Hi, all,
Greetings. sql, query.
I met a error when I use mysqlhotcopy:
bash-2.05a$ mysqlhotcopy --user=jqu --password=jqu1234@ test
/usr/local/mysql/backups
dyld: perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
Ever seen this happen when you start safe_mysqld? Google shows some
hits, but no concrete answers to fix it.
Number of processes running now: 1
mysqld process hanging, pid 9039 - killed
021101 09:17:59 mysqld restarted
/opt/mysql/bin/safe_mysqld: line 273: 9059 Segmentation fault
$NOH
> Create the record for the user in the user table (do not forget to do
> password=PASSWORD('pastext'))
> Then insert a record in the db table with the db name you want them to
> access and the options.
Or you could use:
GRANT SELECT, UPDATE, INSERT, DELETE ON somedb.* TO someuser@localhost
IDENT
Jeff,
Try a JOIN:
http://www.mysql.com/doc/en/JOIN.html
or for some good articles:
http://www.onlamp.com/pub/ct/19
HTH!
Cory
On Fri, 2002-11-01 at 10:01, jeff wrote:
> Hello
>
> I am having some trouble writing a query that will pull the information I
> need from the database. I hope i
Kevin,
...
/
Empties the hash table when it has been fully processed. */
static
void
recv_sys_empty_hash(void)
/*=*/
{
ut_ad(mutex_own(&(recv_sys->mutex)));
ut_a(recv_sys->n_addrs == 0);
...
looks like
Hello
I am having some trouble writing a query that will pull the information I
need from the database. I hope it's even possible at this point.
A little background -
I have one table called 'request' and another table 'countries'
The request form we have has three seperate address groups in
Hello.
On Thu 2002-10-31 at 19:17:57 -0800, [EMAIL PROTECTED] wrote:
> I noticed that the resources used by MySQL grow continually. I recently
> restarted our MySQL server because the process had grown to 259MB.
> MySQL is used by our Webserver running CGI scripts with roughly
> 57,000 connec
> Can naybody tell me how can i get the last 10 inserted record in the table
> in MySql. Is MySql uses rowid like Oracle.
>
> Thanks in advance
> Regards
> D K Dubey
How about ...
SELECT ... ORDER BY id DESC LIMIT 10
PB
---
Create the record for the user in the user table (do not forget to do
password=PASSWORD('pastext'))
Then insert a record in the db table with the db name you want them to
access and the options.
HTH.
JFernand
** sql **
-Original Message-
From: John Meyer [mailto:johnmeyer_1978@;yahoo.com
Not sure if this is a bug or not, I just read the output after restore
failed
ibbackup --restore /etc/my.cnf
InnoDB Hot Backup version 1.03b; Copyright 2002 Innobase Oy
License serial n:o A320
(--restore works in any computer regardless of the hostname)
Licensed for use in a computer whose hos
You have not fetched any data yet.
I would suggest reading the DBI/DBD docs, and some
working programs.
Aamer Rauf wrote:
In my perl script I do the following:
my $sth = $dbh->prepare("SELECT MAX(Id) FROM sometable");
my $id = $sth->execute();
print "id: $id\n";
It prints 1 which I guess is th
Steven Roussey wrote:
At any rate, my point is that we have a very dynamic site (all forums
and chat) powered by MySQL that continuously both updates and reads from
the same server and does 100,000,000+ pageviews a month. Replication not yet
warranted for us. MySQL rocks!
That's actually ver
Steve Jackson wrote:
function get_shipping($shippingvar)
{
$conn = db_connect();
$query = mysql_query("SELECT MAX(receipt_id) from receipts");
$myrow = mysql_fetch_row($query);
$shippingvar = $myrow["shipping"];
return $shippingvar;
Check http://php.net/mysql_fetch_row ... specifically, mysql
Hi. I'm new to mailing lists so I don't know if this will work or not yet.
I'm using the InnoDB table type with MySQL and I have produced InnoDB
statistics using the "SHOW INNODB STATUS" command. The InnoDB manual basically
gives no help at all on what all the figures means. I can work work out wh
ÏÈÉú(Ůʿ)£ºÄúºÃ!
¡¡¿´ÁËÎÀÐǵçÊÓ½ÚÄ¿£¬ÈÃÄúÇáËÉÓÖÓä¿ì!
ÕâÀïÓÐÊÀ½ç×îÈÈÃŵĸŲ̂×îÐÂÓéÀÖƵµÀ£¬¹ú¼ÊÖªÃûÐÂÎÅ¡¢ÊÀ½çÐԵIJƾƵµÀ£¬ÓÐʱװ¡¢ÌåÓý¡¢×ڽ̵ÈרҵƵµÀ¡¢Êý×Ö»¯ÐźŴ«Ê䣬¶þÊ®ËÄСʱ¾«²Ê²¥·Å£¬DVDµÄͼÏñ±ê×¼£¬¸ßƷζµÄÏíÊÜ£¬ÈÃÄú»ØζÎÞÇ¾ø¶ÔÂú×ãÄúµÄÒªÇ󣬵绰Ԥ¶©°²×°£¬Õû»ú±£ÐÞÒ»
> -Original Message-
> From: Jörgen Winqvist [mailto:jorgen@;winqvist.net]
>
> I need to let the values in two columns change place with each other.
> I've tried to "update xxx set a=b, b=a" but that doesn't work
> (b=a uses
> the "new" a).
Here's a cute trick for swapping two numbers w
Sorry to keep on at you guys but this is really getting to me now!
I want to pull a shipping quantity (the very last record in the Db) into
a page and am still having problems. Tried looping through the records
and I can't seem to get it to return anything:
function get_shipping($shippingvar)
{
$
Adrian,
- Original Message -
From: "Adrian Liang" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, November 01, 2002 1:46 PM
Subject: how to recover innodb tables
> Hi,
>
> Recently my MySQL (3.23.52-max) db crashed. Although
> I'm still trying to debug what happened,
I need a query:
Select * from table where field = ' var ';
and var is a string variable 'otoño'
mysql not find 'otoño' , find 'otono' ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Every time I want to replicate, do I have to restart?
Alexander
sql,query
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Alexander Burbello" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 9:33 PM
Subject: Re: Replication
> On Thu, Oct
Jörgen,
Friday, November 01, 2002, 11:06:38 AM, you wrote:
JW> I need to let the values in two columns change place with each other.
JW> I've tried to "update xxx set a=b, b=a" but that doesn't work (b=a uses
JW> the "new" a).
If you want to change place for all values, you can just rename
colu
Victoria,
Friday, November 01, 2002, 2:20:48 AM, you wrote:
VM> I'm migrating my access db's to mysql but some querys in Access need sub
VM> querys.
VM> I know that is n't possible with mysql but maybe with the beta
VM> distribution I could do it.
VM> can some body helpme, maybe there are other wa
Silvia,
Friday, November 01, 2002, 12:47:06 PM, you wrote:
S> I have the MySQL client installed on "workstation_2". MySQL is installed on
S> "server_1". When I try to login to the MySQL server using the admin client
S> it tries to login using username [EMAIL PROTECTED] and it will
S> not let me sp
Hi,
Recently my MySQL (3.23.52-max) db crashed. Although
I'm still trying to debug what happened, the bigger
issue is for me to get the data out of there as soon
as possible.
I thought that by setting the variable
innodb_force_recovery would allow the database to come
up so I could at least do
Hi all ,
as I came across a certain prob , so I am here ,
I have three tables
1 customer_mast ( custid pk )
2 comment_mast ( multiple comments against custid , sysdate()
3 contact_mast ( multiple contacts ( three each ) against single
custid , contact id )
i wa
Sorry the error message should have been - "Connection closed by foreign
host"
-Original Message-
From: Kevin Passey [mailto:kpassey@;kdpsoftware.co.uk]
Sent: 01 November 2002 11:01
To: Mysql (E-mail)
Subject: New Linux install - not sure if it is working correctly
Hi everyone,
I've ha
Hi,
> Can naybody tell me how can i get the last 10 inserted record in the
table
> in MySql. Is MySql uses rowid like Oracle.
Yep, you can use _rowid and a user variable to get what you want:
select @startrow:=count(*)-10 from mytable
select * from mytable where _rowid>@startrow
Greetings
Lutz
Hi everyone,
I've had some dialog with Mark Mathews about this and thought I'd sorted my
problems out. I've just scanned my system with Nessus the open source
security scanner and it thinks that MySQL is not running on port 3306. When
I try and Telnet to that port I get escape characters and a mes
I have the MySQL client installed on "workstation_2". MySQL is installed on
"server_1". When I try to login to the MySQL server using the admin client
it tries to login using username [EMAIL PROTECTED] and it will
not let me specify another user like [EMAIL PROTECTED] The problem
is that [EMAIL PRO
Hi,
Can naybody tell me how can i get the last 10 inserted record in the table
in MySql. Is MySql uses rowid like Oracle.
Thanks in advance
Regards
D K Dubey
-
Before posting, please check:
http://www.mysql.com/manual.php
My apologies if this is a known bug, I could not find a list of known
bugs. The detailed description is below, but basically,
works: match() against () AND match() against()
nope: match() against () OR match() against()
works: match() against ()>0 AND match() against()
nope: match() against
Hi All,
I need to let the values in two columns change place with each other.
I've tried to "update xxx set a=b, b=a" but that doesn't work (b=a uses
the "new" a).
sql,query
/Jorgen
-
Before posting, please check:
http://w
mysql_result requires at least two parameters - the result set and the row.
The return value is only one field not the whole row. You need to say -
$date = mysql_result($date_result, 0);
This e-mail is intended for the recipient only and
may c
89 matches
Mail list logo
