Do You Have A Question On Sql?

Do you have a question on SQL why don't you post them here and lets solve them together.

mat6plus,

should I store text data as char or varchar?  Please provide reasons for whatever choice you suggest

Obalalu Babatunde S. What programming language do u use?

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
column.

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, 

inbox me and i will give you what u want. symccord@yahoo.com

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 don't 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?

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)


replace([addressfield],'rd','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?

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. 

What have you done so far? Are you getting an error or so, if so what error?

Make sure the mySQL driver is in your applications classloader path. That is yourapp/WEB-INF/lib.

Also, make sure an instance of mySQL is running before accessing your web app. You can test that outside of your webapp with something like this method called "getConnection". If all is good, call this method from your servlet or whatever your webapp is.
---------------------------------------------------------------------------
Connection connection = null;
   try {
      Class.forName("org.gjt.mm.mysql.Driver").newInstance();
      connection = DriverManager.getConnection("jdbc:mysql://localhost/yourDatabasename");
   } catch(ClassNotFoundException cnfe) {
      throw new SQLException("Unable to load the driver: " + cnfe.getMessage());
   }
   return connection;
  }

  public static void main (String args[]) throws Exception{
     yourClass yc = new yourClass();
     System.out.println(yc.getConnection());
  }

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,,