xpcer
Last Activity: Apr 14 '07, 04:30 AM
Joined: Jul 13 '06
Location: Indonesia
-
Why i can't exceute the "show databases" query
hi friend, can you tell me, why i can't execute the "show databases" query using vb?, i use a myProv -
MySQLProv
halo freinds, can anyone help me, where i can download MySQLProv?
it's use for connect vb 6.0 to mysql.
or anyone can tell me how to connect vb to mysql? -
how to copi file from website to localhost using php?
hi friends, can you help me..?
if i want to copi file from localhost to localhost, i can use the scripts like this:
copy("d:/picture1.jpg"," c:/picture1.jpg");
but when i wanna to copy file from website, i use like this:
copy("www.me.co m/picture1.jpg"," c:/picture1.jpg");
it cannot work.. anyone have solutions?
thanks b... -
i0+i1+i2+i3+i4
i think it cannot do -
Just Give You An Tricks
hi friends, i ever found any question like this, how to show any data in crosstab query.
The case like this:
I have one table like this (table name people):
=============== ==
No Name Gender
=============== ==
1 Sukrisno M
2 Xpcer M
3 Elizabeth F
if we want to count the people group by the gender, we can use the query like this:... -
select nQtyOut, nQtyIn
from (
Select sum(a.nQtyOut) nQtyOut from
tbl_StationData a, tbl_Materials b
where b.dtFinished is not null and a.vcSONo = b.vcSONo and a.nStationId = '11' and
convert(datetim e, convert(varchar , b.dtFinished, 101)) = '12/04/06'
UNION ALL
Select sum(a.nQtyIn) nQtyIn from
tbl_BatchQty a, tbl_Materials b
where b.dtFinished is not null and a.vcSONo =...Leave a comment:
-
you can't do like that, because, this subquery in the update query may be return a multiple value, then, the system can't to detect which value will be updated to the old data.
in my suggestion, you can create an aplication that can be use to loop the result of the 'select' statement, and then update the data....Leave a comment:
-
ORDER BY must be at end
$sql = ("SELECT gameandtoyname, pricetype, dollsimage.imag e_id, dollsimage.imag e_date
FROM dollsimage, dolls
WHERE dollsimage.imag e_id = dolls.image_id
ORDER BY image_date DESC");...Leave a comment:
-
select id,sum(units) as units,tag from table_above
group by id, tag...Leave a comment:
-
select id,sum(units) as units,tag from table_above
group by id, tags...Leave a comment:
-
you must to use "/" not "\"
so, your query must be
mysql -u user -p passwd -h localhost database < C:/dumpfile.mysql...Leave a comment:
-
That's right....Leave a comment:
-
if u create foreign key and primary key, it's automatic create relationship...Leave a comment:
-
using
form2.show...Leave a comment:
-
stored procedure in sql server need not to compile, you just declare your stored procedure, then you can run it using query analyzer, may be.
to call your stored procedure just use:
exec sp_name(paramet ers)...Leave a comment:
-
please try it:
SELECT CONVERT_TZ('200 4-01-01 12:00:00','+00: 00','-07:00')...Leave a comment:
-
Optimizing Query
hi, friends, i have an problem, like this,
i have tables, when i want to use "select" statement that include "join" sintaxt, my query will execute about 1 hour, so long.
can u tell me how to optimizing my query, may be using index, or another? -
can i get a free one?...Leave a comment:
-
thanks mr. Banfa...Leave a comment:
-
Excel to MySQL
hi friends, anyone have source codes for converting excel file to mysql format? thanks before
No activity results to display
Leave a comment: