Do you have a question on SQL why don't you post them here and lets solve them together.
you can delete any key associated with the softwrae from your registry, but you must be very careful not to delete some other keys that are not for the software you downloaded.
just use the name of the software as your search text in your registry.
As regards to char/varChar
I will suggest varchar for text because you may not have a specied length of the data you want to store.
I think it's also a good suggestion to use char(1) for gender.
Concernin what I have done so far, I have an E-Cart already all written in JAVA and Tomcat is my server, but what I want is:
1)To make a login/sign up page that takes into the mySql database each time a person signs up or login
2) then also keeps record of every item added by each user and to be stored in d database,
3) I want to be able to make d necessary sql options from the database like updte,insert,dellete,,
SQL is just that, Structured Query Language. You can present the data using forms, reports, etc. As Microsoft has made capable with Access. Behind those forms, reports, is SQL. So, if you need to do something similar, you have to use an application that will serve as the front end/presentation layer to the SQL in the back. Some database vendors ship the appropriate tools with their products, as is the case with Microsoft Access etc. Hope you get the point.
I am having this problem: I know that Microsoft Access can prresent data in Forms and Reports [it makes it more graphical and beautiful].
I want to know if SQL can do that as well, because I have something to do with SQL and I have to display the data in forms.
Please answer as fast as you can!
Like the other posters indicated, your data has to be consistent for a join to work. However, inconsistencies are common when it comes to dealing with data.
The best solution is to handle each inconsistency programmatically. My suggestion:
Use a replace function in the join (replace all st. to street and all rd to road)
and do the same for str.
Let me know if you need more help on this. Also, what kind of DB are you using?
Well, for the join to work efficiently it's important that the fields you are joining on match in all tables that are used in the join. If they do not match, as is the case here, you will not be able to use that column as the join field. Usually you want to do a join on a key/unique field. Trying to do a join on inconsistent street names is not going to work.
OK - lets see who is a guru here.
I have a database with two tables, one table shows street names and the other table shows street names and also shows the postcode of each of the street, now i want to do a join on the tables, by writting an SQL query to create another table that will lok at the street name table, anywhere it finds a match, it should take the postcode from the other table and put it into the table of street names.
simple? it sounds so, but the problem is this, the street names in the two tables dont exactly match in all cases, e.g. you can have Ikorodu Road in one and also have Ikorodu Rd. in the other, or have street in one and have str. in the other. \how can a perfect join be done via a query?
I agree. char would be more appropriate for gender.
The char is a fixed-length character data type, the varchar is a
variable-length character data type.
Because char is a fixed-length data type, the storage size of the char
value is equal to the maximum size for this column. Because varchar is
a variable-length data type, the storage size of the varchar value is
the actual length of the data entered, not the maximum size for this
For example a char varChar will always take up 4 spaces to store the name Mike. While a char(20) will always take up 20 spaces to store the same thing,
depending on how long the text data that u want to store. If you want to store a precise or small amount of text e.g. gender which will either be male or female use char(6). if male is stored in the column the remaining column will be filled with spaces. but if u want to store for example user name use nvarchar(30). For me if i am storing anyhting more than 256 characters, i use text as the datatype. examples, Gender: char(6), FirstName: nvarchar(30), email: nvarchar(256), MessageBody: text. Hope I help u.