Why don't you try like this.
F:\\devkunde\\SENDTNER\\
'\' is escape character. so you must
use '\\' to insert '\'.
Homepage = http://www.nnr.or.kr/inos/
ICQ # = 123534385
Member of DSN(database.sarang.net), NNR(nnr.or.kr)
--MIME Multi-part separator--
Hello!
i have a query and in the where clause i want to compare dates,
for example in asp i used
select * from table where col_date1 = now and col_date2 = now
what is the similar using mysql
See http://www.mysql.com/doc/
Look up 'date'.
See especially Date and Time Types, Date and Time
I don't now ich language you are using to perform this query.
But as mysql does not know any stored procedures, you will have to do it in
code with different call's.
the value of the id (seed in mssql) can be obtained with the SQL function
LAST_INSERT_ID()
a little hint. in your stored
Dear Friends,
I am using mysql 3.23.42. I want to execute one
query to get specific result but not getting the
correct result.
I have 2 tables named: ContactList and GroupList.
snip
- Now I want to get those 'nickname' from
ContactList which do not appear in GroupList with
Mike Sosteric wrote:
Hi all
I' wondering if someone can help me out here.
I need to do a three table join. Normally not a problem but in this case I have to
select usernames from a users table twice. One for each of two other tables. I'll
need to use a user_id (int) to do the select
Don't know your where, but you probably want to something like ...
select USERS.name as name1, USERS.user_id as id1, USERS.name as name2,
USERS.user_id as id2 ...
where id1 = USERLIST.user_id and id2 = STUDENTLIST.user_id ...
4 tables join?
Mike Sosteric wrote:
Thanks Dibo but I don't
Hi,
try complete your query by adding word 'AS' syntax:
field AS name
so:
select USERS.name AS name1, USERS.name AS name2, USERLIST.user_id AS
id1, STUDENTLIST.user_id AS id2 student_id
from USERS, USERLIST, STUDENTLIST
WHERE
Michal Dvoracek [EMAIL
one.in case if he selects multiple fields, how could i
provide my user with all set of records which contains
what all data he placed in query form.
I think you want to study a bit more on MySQL and PHP. If you take the time
to go to sites like www.devshed.com you might get an idea of how
On 24-Jan-01 Jesús Gómez Pastor wrote:
I have a problem in 3.23.32,
The query
select * from table
repalce table values('','nextval+1)
^^ ^
these might be a problem, in addition to your select/replace/(update)
confusion.
returns me always nextval=1.
no, it
101 - 109 of 109 matches
Mail list logo