Hi,
How I can use ',' instead of '.' in a number values in mysql. I changed
charactermap but nothing.
MySQL 3.23.41 RH7.2
Liivar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
On Sat, 30 Mar 2002, Paul DuBois wrote:
> At 17:15 -0500 3/30/02, Michael Stassen wrote:
> >On Sat, 30 Mar 2002, Paul DuBois wrote:
> >
> >> At 21:25 +0100 3/30/02, Roger Baklund wrote:
> >> >* Son Nguyen
> >> >> ==> I tried this query, but... it's not working out:
> >> >>SELECT YEAR(no
* Gordon Stewart
[...]
> http://homepages.slingshot.co.nz/~gordon52/3.txt
[...]
>while ( $row = mysql_fetch_array($result) ) {
> echo("" . $row["JokeText"] . "");
[...]
> But how do i list the actual database names ?
The result column of the "show databases" command is named "Database",
-Original Message-
From: Chetan Lavti
Sent: Thursday, March 28, 2002 11:39 AM
Subject: RE: To run MySQL Server from the remote machine
> hi,
>
> Is it possible to Start the MySQL Server from the remote machine..??
> Mysql provides a Api's for shut down the server from the remote
> p
I'd like to authenticate mySQL users against an LDAP directory. Can I
do that? If so, how? Couldn't find anything anywhere ...
Thanks,
Johannes.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
G'day,
I keep on getting the following error message when trying to connect to
MySQL - ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'
This can be fixed by creating a link from the /tmp/mysql.sock file. Which I
have done and still get the same error
> Ive uploaded it to one of my sites (doesnt have PHP - (I dont think..))
as a text file...
http://homepages.slingshot.co.nz/~gordon52/3.txt
I just 'viewed source' & I saw all the correct source-code..
<
Ive changed some text of my PHP script :- New lines are :-
(see above URL - view source.
I downloaded mysqlgui linux semi static binary and installed it. I copy
my.cnf to ~/.my.cnf. I set the user name to my user. When I start it up
it prompts for password then indicates that it can't connect. I am using
the same USER/PASS that I use successfully with "mysql --user=USER
--password=PA
At this 14:31 1/04/02 +0200 Roger Baklund told us all something interesting :-
> > From the build4-5 web-page above, I'll assume that
> > $result = @mysql_query("show databases"); would be the correct code to
> > SHOW the databases available..
>
>That is correct.
>
> > However its not going &
Yes, mySQL is up to the task. Just make sure you design the DB with
fast retrivals in mind
-Original Message-
From: Zhao, Charles [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 3:53 PM
To: '[EMAIL PROTECTED]'
Subject: Beginners Question
Hello there,
I am trying to find which
Hi,
I'm responsible for a large, dynamic website that gets from 100,000 -150,000
hits per day on average. We're using PHP/MySQL along with Apache on Mac OS
X 10.1.3 to serve the site and overall it works very well. Sporadically
though, we've been encountering a very strange problem where some o
Use a combination of the DATE_ADD function and the NOW function:
SELECT DATE_ADD(NOW(), INTERVAL 20 MINUTE)
--jeff
- Original Message -
From: "Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]>
To: "MYSQL" <[EMAIL PROTECTED]>
Sent: Monday, April 01, 2002 12:04 PM
Subject: DATE_ADD
Graig,
I've been using mysql for about a year now on a linux machine and it has not
crashed or had any corrupted tables in that time. I believe mysql is just as
good in stability and safety of data has it is in speed.
Mike
- Original Message -
From: "Scalper" <[EMAIL PROTECTED]>
To: <[EM
I am working with a low-load, mission-critical database. Although I have
yet to have a corrupted table, I seem to read about it a lot on the
list. This is a scary thought for me, considering the importance of the
data I manage. Can anyone tell me if this is a rare occurrence? Is it
even r
MySQL will be good for this type of stuff.
Tyler
- Original Message -
From: "Zhao, Charles" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 01, 2002 3:53 PM
Subject: Beginners Question
> Hello there,
>
> I am trying to find which database to use. I will have text and i
I want to do a query that will find all the titles I have in my db that
start with numbers and ambigious characters (i.e. 0-9, &, #, $ etc...). My
query is below, however I don't know what to change the "a" too in order for
it to return what I just described.
select id, shortdescription, title f
Hi all,
How can i do a delete from multiple table in mysql?
Eg :
I want ot delete record something like that I dont when to select but delete
delete
from
externallink as link,
topic as topic,
topiclink as joiner
where
link.resid = joiner.resid and
topic.catid = joiner.catid and
topic.rid like
Hi,
As I'd got not answer, I repost my question ;)
I'm currently testing the BACKUP TABLE function, and to reconstruct the MYI
files, I'm performing the following action :
For exemple :
dd if=/home/mysql/Hardwarefr/cookie.MYI bs=16k count=1
of=/home/mirror/mysql/Hardwarefr
/cookie.MYI
(to res
I had the exact same problem.
when you install mysql there is a database that stores all the user permissions and
that table is created for you.
the mysql server can start without that permissions file but you have to send a -Sg
option to the server if you are on unix, linux or the like
This
Hello there,
I am trying to find which database to use. I will have text and image data.
Lots of image data. Most of the time I am doing data retrieving, but when
updating, it will be text almost always. No enterprise use, but very busy
database hits. Could any one please educate me if mysql
DATE_ADD(date,INTERVAL expr type)
DATE_SUB(date,INTERVAL expr type)
ADDDATE(date,INTERVAL expr type)
SUBDATE(date,INTERVAL expr type)
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Dat
e_and_time_functions
Mike
- Original Message -
From: "Edilson Vasconcelos de
./safe_mysqld --user=mysqld --datadir=/db/
./safe_mysqld --user=mysqld --datadir=/db/
020401 16:55:04 mysqld started
020401 16:55:04 /d2/usr2/local/mysql/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020401 16:55:04 mysqld ended
My unix user is called mysqld and I want dat
Who knows with google... ;-)
Though I do like Michael's 'peck' 'not-yet-pecked' system.
I question though how much more performance we could get out of Rats
rather than Winged Rats.
Dan Zarrella wrote:
>
> i've read the bit on google about thier pigeon rank thing, sounds like a
> cross betwe
David,
- Original Message -
From: ""David yahoo"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, April 01, 2002 7:10 PM
Subject: ib* files and their rules
> i run a mysql :
>
> mysql> select version();
> +---+
> | version() |
> +---
i've read the bit on google about thier pigeon rank thing, sounds like a
cross between reality and alittle aprils' fools to me, either way id
apreciate a better explanation of this technology and how it may be
implemented into mysql -dan
How about using the state transitions, i.e.
0 -> 1 state changed, no error
0/1 -> 0/1 state unchanged, no error
1 -> 0 state changed, overflow
C:~
-Original Message-
From: Michael Zimmermann [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 12:07 PM
Just to clarify, my problem is that I do not want MySQL to use "disk-based"
temp file. Everytime I try to ORDER a result set that contains a TEXT type
field, MySQL will use disk based temp file.
What can I do to:
1. SELECT a TEXT type field
2. ORDER by an INT column
3. not use a disk based te
I have the 3.23.49 Version of MySQL and it is saying the load data command
does not work with this version. I also read in my book that any version
past 3.22.15 should be able to complete this function. Please advise.
Rosina M. Everitte, B.A., Research Assistant
University of Arkansas for Medic
Hi,
How do i the current timestamp plus 20 minutes in MYSQL? I have a
Timestamp(14) field
and i need to insert the current datetime plus 20 minutes.
Thank u very much,
Dirso.
-
Before posting, please check:
http://www.mysql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At Montag, 1. April 2002 21:38 Colin Faber wrote:
> Is it true that mysql is planing to implement google's famous
> PigeonRank system in it's FTS word weighting schema???
I allready have a simple quick-n-dirty implementation running
on our local mysq
If you are looking for a web version, the best is phpMyAdmin which
allows you to do just about everything you need to manage any number of
mysql dbs.
Andrew Hazen
-Original Message-
From: Vu, Steve [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 2:54 PM
To: [EMAIL PROTECTED]
Subj
Hi there,
can anyone reccommend a free schema manager for MySQL? I've heard of Kermit, but it's
very expensive.
Thanks,
Steve
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
Is it true that mysql is planing to implement google's famous
PigeonRank
system in it's FTS word weighting schema???
*drool*
:-)
--
Colin Faber
(303) 859-1491
fpsn.net, Inc.
-
Before posting, please check:
http://www.mysq
I have created a database called friends with four columns:
Name / Address / City / State
I also made an XML file to coincide with those variables:
Friend 1
999 Foo Avenue
Foo Town
hi guys,
how can i use arabic language in the mysql tables data, my data in the
table looks like Extended Ascii, and it is re-interpreted in windows
programs - as MySQLMaker - into arabic, how can i let MySQL itself
understand arabic?
thx
--
Hytham Shehab
---
On Monday 01 April 2002 10:56 am, IvanLatysh wrote:
> Hi.
> I am running MySQL 3.23.44-Max
>
> I have 2 tables.
>
> Table "A"
> +---++
> IDName
> +---++
> 1 string 1
> 2 string 2
> +---++
>
> Table "B"
>
> +---++
> IDName
> +---++
> 2
Hi.
I am running MySQL 3.23.44-Max
I have 2 tables.
Table "A"
+---++
IDName
+---++
1 string 1
2 string 2
+---++
Table "B"
+---++
IDName
+---++
2 string 2
3 string 3
+---++
And I need result
+---++
ID
* Egor Egorov
> AC> REALFROM: "Anton Chalbaud" <[EMAIL PROTECTED]>
> AC> HOUR: 2002033122
>
> AC> Hi, if I need to do multiple INSERTS (I mean into different
> tables) which is
I think he asked about inserting into multiple tables... ;)
--
Roger
query
---
nl2br() works, thanks for the info
manual stinks on this subject
example code should be something like:
$newtext = nl2br($oldtext);
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Mat Murdock
Try this function
nl2br()
Mat
- Original Message -
From: "Rance Hall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 01, 2002 7:51 AM
Subject: Using MySQL text column with PHP4
> I need some help formatting a MySQL longtext column for presentation via
PHP
>
> When I
kaps,
Sunday, March 31, 2002, 9:54:00 AM, you wrote:
k> i m fairly new to mySQL. I have to work on already set up live database
k> which can be managedwith phpAdmin system.
k> Now i was wondering how can i take a backup (dump) of the database with that
k> system?
Use mysqldump utility: http:
Shelly,
Sunday, March 31, 2002, 4:12:49 PM, you wrote:
Looks like MySQL server is not running. Please check that.
SY> After running setup on Window professional , I tried
SY> to install using the follow command. I got error.
SY> C:\mysql\bin>mysqladmin -u root shutdown
SY> mysqladmin: connec
Art,
Sunday, March 31, 2002, 11:28:17 PM, you wrote:
AF> Does anyone know how or where there is a howto to import tables from an
AF> Oracle Database into Mysql and then to keep the Mysql syncronized with the
AF> Oracle database?
There is no such thing as "syncronizing" between Oracle and MySQL
Alex,
Saturday, March 30, 2002, 6:50:17 PM, you wrote:
AB> quick question, I'm setting up a script that does headlines for my site and
AB> I need to pull some information from a table with my review info from it but
AB> I only want to view the 7 latest reviews, how do I make it so I can only
AB
David,
Monday, April 1, 2002, 4:07:53 AM, you wrote:
Dy> I accidently move some database dir temporary (for space pb) but when moving
Dy> I surely forget something I cant no longer start my server.
Dy> I put the sock file where it had to be but nothing more.
Looks like the server is not runnin
Anton,
Sunday, March 31, 2002, 10:53:45 PM, you wrote:
AC> REALFROM: "Anton Chalbaud" <[EMAIL PROTECTED]>
AC> HOUR: 2002033122
AC> Hi, if I need to do multiple INSERTS (I mean into different tables) which is
AC> the best way to manage this? Do I have to run a different Query for each
AC> INSER
Soheil,
Friday, March 29, 2002, 11:45:42 PM, you wrote:
SS> Hi,
SS> I wonder if this is the place to ask this question or not!
SS> I have been trying to install DBD::mysql, or any other mysql, or DBD modules
SS> from CPAN on my Linux, and FreeBSD servers.
SS> I just can't get them to install.
S
Sihem,
Sunday, March 31, 2002, 1:26:00 AM, you wrote:
SAY> problem in connecting to server through C API function
SAY> mysql_real_connect()
SAY> the mysql handle returned by mysql_init() is not null
SAY> error message says:
SAY> Program received signal SIGSEGV, Segmentation fault.
SAY> 0x40
I have a query:
SELECT feature_type.title, feature.title
FROM feature_build
LEFT JOIN feature ON feature_build.feature_id = feature.id
LEFT JOIN feature_type ON feature_build.feature_type_id = feature_type.id
WHERE feature_build.product_id = '112479'
AND feature_type.full_ordinal != 0
O
>Description:
Existing mit-pthreads code does not compile on current NetBSD/powerpc
>How-To-Repeat:
Attempt to compile
>Fix:
Apply patch
$NetBSD$
*** mit-pthreads/machdep/syscall-powerpc-netbsd.S Thu Feb 14 12:30:14 2002
--- mit-pthreads/machdep/syscall-powerpc-netb
ERROR MESSAGE: 1 WE R DEVELOPING A PRODUCT USING KDE2.0/QT3.0.2
ENVIRONMENT, USING MYSQL AS DATABASE.
WHILE CONGIGURING THE QT3.0.2---> $./configure -qt-sql-mysql
-I/usr/local/qt/include -system-libjpeg -qt-gif -qt-libpng -debug
...ENTER
AFTER CONFIGURATION FOR gmake WE R GETT
i run a mysql :
mysql> select version();
+---+
| version() |
+---+
| 4.0.2-alpha-debug |
+---+
1 row in set (0.00 sec)
on a mandrake 8.1 box.
on /var/lib/mysql (DATADIR), I have several ib* file note that I have mysql
max install.
what t
Can you tell me what the mysqlmanager application will end up doing?
Currently you say it is for testing purposes.
But what is the future intended use of this program? What is in store for
this application down the road?
I see one of the parameters is a command length. Will this app allow a
mysq
Well, first off, I can't seem to get max_allowed_packet higher than 64
MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are
reflected in the system settings, but only up to 64 MB, then regardless
of what I put in there, it stays at 64 MB. But like I said, the file is
only 34
if I dont have the mysql.sock running in the temp folder how do I start
it???
I tried service mysql start and it did work it give me the same error in the
subject line
- Original Message -
From: "andy thomas" <[EMAIL PROTECTED]>
To: "colin o" <[EMAIL PROTECTED]>
Cc: "Mike Yrabedra" <[E
William,
- Original Message -
From: "William R. Mussatto" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, April 01, 2002 6:29 PM
Subject: Re: mysql innodb error
> I thought the 4.0 series was still Beta?
yes, 4.0.1 is beta or alpha, depe
I thought the 4.0 series was still Beta?
On Mon, 1 Apr 2002, Heikki Tuuri wrote:
> Date: Mon, 1 Apr 2002 18:09:53 +0300
> From: Heikki Tuuri <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: mysql innodb error
>
> Kannan,
>
> please upgrade to 3.23.49a or 4.0.1.
>
> 101 used to m
On 31 Mar 2002, at 17:34, Alex Behrens wrote:
> My statement is this and it still gives me an error and wont add the data,
> the addslashes doesn't seem to be working:
>
> $sql = addslashes("INSERT INTO hwureviews
> (name,title,picurl,url,author,email,category,num,info) VALUES
> ('$name','$tit
Kannan,
please upgrade to 3.23.49a or 4.0.1.
101 used to mean lock wait timeout. It has been replaced by a
clear-English error code.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual a
I need some help formatting a MySQL longtext column for presentation via PHP
When I pull the data with PHP the line feeds are not respected unless I use the
HTML tags around my data field.
This does not have the desired effect.
how can I pull the data into the php web page and maintain line f
* James Gosnell
> Does anyone know of a program or algorithm that will take a table
> structure and update another table to the new one? Like, to just change
> or add a column? What I'm trying to do is continually update the table
> with different fields, or change the field types whenever I feel
Did you dump the 24 records on both boxes and compare them?
Maybe someone updated the records on the slave, and now the dates don't
match.
Vico Timmermans wrote:
>I think i stumbled upon a bug that's got something to do with join
>size. Detailed information below.
>
>Using 2 intel-linux platfo
Does anyone know of a program or algorithm that will take a table
structure and update another table to the new one? Like, to just change
or add a column? What I'm trying to do is continually update the table
with different fields, or change the field types whenever I feel the
need to add a new fe
Hi all,
I accidently move some database dir temporary (for space pb) but when moving
I surely forget something I cant no longer start my server.
I put the sock file where it had to be but nothing more.
See that
www:/var/lib/mysql# ls -ls
total 100
4 drwxr-xr-x2 mysqlmysql4096
You might also want to consider looking at Lasso Professional 5
. This product has MySQL built-in, while also connecting
directly with external MySQL and FMP database sets. For me, its the perfect
solution when bringing parts of MySQL and FMP together using a browser
interface.
--
* Gordon Stewart
> I've been following the website of :-
>
> http://www.wdvl.com/Authoring/DB/SQL/Build/
>
> And its the best ive seen - so far...
>
> Im up to this page :-
>
> http://www.wdvl.com/Authoring/DB/SQL/Build/build4-5.html
>
> & now i'm stuck - I need to know 2-3 more things that i can
Hi!
Id would like to have 4 tables
files (
id int(8),
type set("directory", "file", "link"),
)
files_directory (
id int(8),
is_files int(8),
name varchar(20)
...
)
files_file (
id int(8),
is_files int(8),
name varchar(20)
...
)
files_link (
id int(8),
is_files int(8),
name varchar(20)
...
)
Troy writes:
> Hi all,
> Just wondering if there are any examples on the web that will compile
> using VC++ 5.0 SP3. I have downloaded the MySQL++ 1.7.1 API and cannot get
> the example to compile.
>
> Thanks in advance
>
> Troy
HI!
MySQL++ requires VC++ 6.0.
--
Regards,
__ ___
MySQL plans to implement stored procedures in 4.1
though :-)
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> MySQL doesn't have stored procedures yet. It has
> user defined
> functions (UDFs), but that's not what you're looking
> for here.
>
> Jeremy
Kenneth,
Sunday, March 31, 2002, 2:13:47 AM, you wrote:
KL>>Submitter-Id:
KL>>Originator:Kenneth Lerman
KL>>Organization:
KL> Systems Essentials Limited
KL>>MySQL support: none
KL>>Synopsis: Can't find file: 'host.frm' even though it exists
KL>>Severity: critical
KL>>Priority:
Shelly,
Sunday, March 31, 2002, 4:12:49 PM, you wrote:
SY> After running setup on Window professional , I tried
SY> to install using the follow command. I got error.
SY> C:\mysql\bin>mysqladmin -u root shutdown
SY> mysqladmin: connect to server at 'localhost' failed
SY> error: 'Can't connect to
Laxmikant,
Monday, April 01, 2002, 12:33:12 PM, you wrote:
LA> Can anybody help me out in solving the build error
LA> problem for mysql
LA> I am trying to build MySQL-3.23.49-1.src.rpm with the
LA> linux command "rpm --rebuild MySQL-3.23.49-1.src.rpm".
LA> Using redhat linux 6.2 with glibc2.1.3
kaps,
Sunday, March 31, 2002, 10:51:14 AM, you wrote:
k> how can i get a backup of the database using the mySQL Server terminal
k> access with my mySQL Sever?
k> any help?
Look at the section 4.4.1 Database Backups in the manual:
http://www.mysql.com/doc/B/a/Backup.html
Take a look at mysql
Hello All,
I've got an SQL question. I have a database that contains Reviews of some
of a clients publications. The client is interested in generating some
summary reports and I simply can't wrap my head around a single SQL query
(if that's possible) that will generate the information I'm look
On Mon, Apr 01, 2002 at 03:51:56PM +0530, Amit Mittal wrote:
> Respected Sir/Mem,
>
> Can i call java stored procedure in mysql database ?
MySQL doesn't have stored procedures yet. It has user defined
functions (UDFs), but that's not what you're looking for here.
Jeremy
--
Jeremy D. Zawodny, <
i am using egcs 2.91.66
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> On Mon, Apr 01, 2002 at 01:33:12AM -0800, Laxmikant
> Agarwal wrote:
> > Hello,
> > Can anybody help me out in solving the build error
> > problem for mysql
> >
> > I am trying to build MySQL-3.23.49-1.src.rpm with
> the
>
Respected Sir/Mem,
Can i call java stored procedure in mysql database ?
As i can do this in Posstgresql-
1) Create a procedural language (say java) using a handler.
2) Then create a function using cmd:
CREATE FUNCTION mypi() RETURNS TEXT AS 'java.lang.Math.PI' LANGUAGE'java';
3) Then exec
Placed At :
Hi ...
I 'm getting this very odd error with my update query..I run mysql-4.0.0-alpha
on a redhat linux machine..
My table type is innodb.
the error is as follows..
ERROR 1030: Got error 101 from table handler
I do not have a ver
On Mon, Apr 01, 2002 at 01:33:12AM -0800, Laxmikant Agarwal wrote:
> Hello,
> Can anybody help me out in solving the build error
> problem for mysql
>
> I am trying to build MySQL-3.23.49-1.src.rpm with the
> linux command "rpm --rebuild MySQL-3.23.49-1.src.rpm".
> Using redhat linux 6.2 with gl
hi
hope this helps
Peter
';
$db = mysql_connect( "db", "**", "**");
mysql_select_db( "net3dual_reviews",$db);
$r = mysql_query("SELECT * FROM hwureviews ORDER BY num DESC LIMIT 7");
$max = mysql_query("select max(num) from hwureviews"
Hello,
Can anybody help me out in solving the build error
problem for mysql
I am trying to build MySQL-3.23.49-1.src.rpm with the
linux command "rpm --rebuild MySQL-3.23.49-1.src.rpm".
Using redhat linux 6.2 with glibc2.1.3.
Following is the error while compiling-
make[2]: Entering
hi stephen,
the ncurses library is not part of the mysql distribution. it's
available as a solaris binary package at
www.sunfreeware.com. look for "ncurses-5.2".
HTH
michael
"Stephen D. Myles" wrote:
>
> Hi,
>
> I am new to MYSQl so any help is much apreciated! I have recently instaled
> my
Note: I am not subscribed to this list, so please Cc me at
[EMAIL PROTECTED] if you reply to this message.
Moodss (a modular monitoring application, graphical and daemon) fully
supports the MySQL database and great efforts are made in collaboration
with the MySQL AB developer Sinisa Milivojevic,
Hi!
> "Russell" == Russell E Glaue writes:
Russell> in the '{MYSQLROOT}/bin' there are two executables in particular.
Russell>mysqlmanager
Russell>mysqlmanagerc
Russell> I see these are version 1.0, and such are recently added.
Russell> Can anyone tell me:
Russell>W
Join many table with 1 query is the ideal. Because you must sure that
there are the valid data integrity. If there is only 1 broken join key
(any part of table1.key=table2.key), you'll got the null row. When you
need to display all of the first table value and retrieve another
information
85 matches
Mail list logo