Hi,
I want to search from a table , I have a table with a column that each
record filled with different character set ,is it possible
to know what are their character set and then is it possible to change all
of them
to a character set ,how can I do that?
these records show like below that I don'
Thanks for your feedback.
By the way, I found the following to be the way to go.
Original
> Select *
> from group_mstr gm,group_payers gp
> where gm.practice_id = '1'
> and gp.location_id = '2'
> and gp.practice_id =* gm.practice_id
> and gp.group_id =* gm.group_id
> order by gp.payer_id
N
A little birdie:
http://forge.mysql.com/wiki/Top10SQLPerformanceTips
notes..
"In 5.1 BOOL/BIT NOT NULL type is 1 bit, in previous versions it's 1 byte."
Is this true?
I didn't see a note in the manual..
I assume it would be here
http://dev.mysql.com/doc/refman/5.1/en/storage-req
Hi Everyone
I have a question regarding SUM and Update.
is it possible to use SUM with Update ?
for example I have 3 tables
table_1:
idT1 Price
120
230
350
420
table_2:
idCust Total
Jerry Schwartz wrote:
Possibly you are opening another connection, using the same handle, when you
re-enter your script. If that is the case, you'll lose track of your
previous connection (the one that has the temporary table). You might also
be accumulating a lot of connections, if this recursio
I am trying to select a particular row from a table and include a column for
aq second table but I cannot get the result I am after.
I have "table1" with 1000 rows and "table2" with 12 rows. The relationship
between the tables is a column "linkedfield". Table1 has a unique key called
"lookup"
If