Hi,
Thank you so much for your response. That has helped me.
Once again thank you for your kind help
Samuel
samuel123
Last Activity: Mar 31 '08, 03:46 AM
Joined: Nov 21 '07
Location:
-
Just found a little way..
Did this way
update users set firstname=subst r(user_name,1,7 )
Above query got nearly correct result
Pearson
Allie
Some are like this
Bobsol L
Now my question in Bobsol L Now I want to remove white space and L charcter
ThanksLeave a comment:
-
Just want to have first name only
Greetings All,
Once again back to this forum.
I have got a problem and hope to get solution.
Senario..
I have a table called users, it has following fields
user_name firstname lastname
---------------- -------------- -------------
Parker Alan & Jenny Parker
... -
Hi,
Greetings!
Thank you so much for your help on relating the two tables. I was really struggling on this. I would greatly appreciate your kind help. I will try to impliment this.
One more Question:
For e.g, I have got 6 tables which are related like pk and fk. Do I have to write ALTER TABLE" while showing relation one at a time?
Once again, thank...Leave a comment:
-
How to relate between two tables in Phpmyadmin
Dear All,
Greetings!
I have problem that how to relate between two table in phpmyadmin.
Say I have two tables,
project
-------
user_id int(11) pk
title varchar(20)
commitment
-------------
commitment_id int pk
user_id int fk
Now, how to relate user_id fields of those two tables..?
Your help will... -
Confused in Relation in Phpmyadmin
Dear All ,
Greetings!
This is my first post on this forum and seeking the solution of a problem. Hope, I would certainly get from the forum.
Say, I have got Two tables. Those are..
1. users
Field in users: user_id(pk)
2. commitment
Field in commitment: user_id(fk for commitment table)
A. My question is: How should I set the relation between... -
Dear All ,
This is my first post on this forum and seeking the solution of a problem. Hope, I would certainly get from the forum.
Say, I have got Two tables. Those are..
1. users
Field in users: user_id(pk)
2. commitment
Field in commitment: user_id(fk for commitment table)
A. My question is: How should I set the relation between users and commitment...Leave a comment:
No activity results to display
Leave a comment: