weird characters inserted into mysql max 4
Hi, Can someone help on this question? I have downloaded and intalled succesfully mysql-max 4.0.4. However, when I checked the information I stored via insert statements, I noticed weird characters placed in the positions of letter that have accents. I am storing information in portuguese and the content stored is not exactly what I am putting in my sql statement. Any Ideas? Thanks Siomara _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question about mysql4
Hi, Can someone help on this question? I have downloaded and intalled succesfully mysql-max 4.0.4. However, when I checked the information I stored via insert statements, I noticed weird characters placed in the positions of letter that have accents. I am storing information in portuguese and the content stored is not exactly what I am putting in my sql statement. Any suggestion of what it can be? Thanks Siomara _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question about mysql4
Hi, Can someone help on this question? I have downloaded and intalled succesfully mysql-max 4.0.4. However, when I checked the information I stored via insert statements, I noticed weird characters placed in the positions of letter that have accents. I am storing information in portuguese and the content stored is not exactly what I am putting in my sql statement. Any suggestion of what it can be? Thanks Siomara _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Does this list work??????
Hi, Can someone help on this question? I have downloaded and intalled succesfully mysql-max 4.0.4. However, when I checked the information I stored via insert statements, I noticed weird characters placed in the positions of letter that have accents. I am storing information in portuguese and the content stored is not exactly what I am putting in my sql statement. Any suggestion of what it can be? Thanks Siomara _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
does this list work or not?
I have posted many emails asking help for my question and it seems that the list does not work. Can someone reply please? From: [EMAIL PROTECTED] To: Siomara Pantarotto [EMAIL PROTECTED] Subject: Re: testing Date: Sun, 17 Nov 2002 16:12:41 +0100 Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: testing _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How does authentication works with MYSQL??????
Can someone PLEASE explains how MySQL does authentication remotely After installing MYSQL I created a user root with xyzxyz password. The database allowed that. When I connect Mysql, via java codes, from the same machine it works perfectly. When I connect Mysql, via java codes, from a remote machine it does not work. How come the user is the same, the IP address is the same... It's getting confused with the original root user Iguess. Can someone give a hint on this??? Thanks Siomara _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems coonecting mysql remotely
Dear all I have an application running in a small network where: Machine 1 is the pdc for user authentication Machine 2 is the mail Exchange server for emails/calendar/contacts Machine 3 is the database server with (LDAP,Oracle, MSSQL and MYSQL) MAchine 4 is the aplication + webserver for Development and MAchine 5 is the aplication + webserver for DEMO. Machine 4 has MYSQL installed locally also. The application runs fine. I supposed it's because the local database that is there. Machine 5 has no local database. The aplication is supposed to grab the data from machine 3. For all databases the application is doing it OK, except for MYSQL. I get a message complaining about my user root@machine5. My question is: Why MYSQL is appending the machine name to the username to do the authentication? Even if I point to machine 4 I get the same error. How can I solve this issue? Any help is welcome. Thanks Siomara PS: Besides the root that comes with the installation I created a root user with xyzxyz as password. This root/xyzxyz is the one I am trying to connect with. I have done that for both machines that have MYSQL _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: relational DBMS vs object-relational DBMS
In Relational Database you usually create tables where the columns are primitive datatypes such as number, varchar2, date (these are oracle primitive dataypes). So... to create a table Customer, for example, you would do something like: create table customer ( customerID number(10), customerNamevarchar2(100), customerStreet varchar2(50), customerCityvarchar2(30), customerState char(2), customerZipCode varchar2(10) ); In an object-Oriented database you can create your own datatypes like: create type ADDRESS_TY as object( Street VARCHAR2(50), City VARCHAR2(30), StateCHAR(2), Zip varchar2(10) ); Then you can create another object that uses this address object like: create type PERSON_TY as object( Name VARCHAR2(100), Address ADDRESS_TY ); Then finally you can create your table like: create table CUSTOMER( CustomerID NUMBER, Person PERSON_TY ); or create table EMPLOYEE( EmployeeID NUMBER, Person PERSON_TY Department NUMBER ); See the difference now? The dataype address can be used separatelly in other tables directly, or it can be agregated to an object like person_Ty and this can be used for many different tables. The power of this is that your company would define certain datatypes instead of expect developer to do it. Work with standards is the first key to do a clean job. Now, imagine different people creating tables as they want. How many different words would exist for the same concept. Street, streetName, address, complement, etc (just for street) zipCode, zip, zCode (etc...) What a mess, and this is actually what we see in the market. I consider this no professional at all. I always like to tell people that work like that the following: JUST MAKE IT WORK DOES NOT NECESSARILL LEADS TO SUCCESS . I have a paper in my web site that is not complete yet, but it gives you some idea on how to map java objects directly to Oracle objects. Remember : ITS NOT COMPLETE YET, SO YOU MAY FIND SOME ERRORS, OR CODES THAT NEED TO BE ADJUSTED TO THE EXAMPLE I POST. Siomara Pantarotto www.geocities.com/hisiomara (under tutorials) From: Matthew Patterson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Mysql list [EMAIL PROTECTED] Subject: relational DBMS vs object-relational DBMS Date: Wed, 24 Oct 2001 14:33:58 -0500 Everything that I have read describes MySQL as a Relational DataBase Management System (RDBMS). PostGreSQL bills itself as an Object-Relational DataBase Management System. Is there a difference between the two and, if so, come someone either explain the difference or point me to a resource that explains the difference? Thank you. Matthew Patterson IS Department National Support Center, LLC Naperville, IL, USA http://www.nsc-support.com ***Privacy and Confidentiality Notice*** The information contained in this E-Mail is intended for the named recipients only. It may contain privileged and confidential information and if you are not the intended recipient, you must not copy, distribute or take any action or reliance on it. If you have received this E-Mail in error, please notify the sender immediately by using the E-Mail address. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Getting data from Oracle to Mysql
Since I know Oracle, MySQL, and Java the fastest way I did it was: 1) I created scripts for creating the tables in both DBs (this is the way I usually do). They differ a bit on datatypes, and I had to remove all the foreign key when dealing with MYSQL. I have 2 scripts called makeOraDB.sql and makeMySQLDB.sql that will call others scripts and generate the dbs in both environments any time I run them. If I need to update or fix the schemas all I need to do is run the scripts again. 2) I created a class in java to deal with the migration and persistence. This class creates 2 connections one with Oracle and another with MySQL. I read the rows in Oracle into a resultset and then I navigate this result set and for every row I do an insert in the MySQL DB. Notice that this is a one shot process. The MySQL tables are completely empty in the beginning of this process. Notice also that the scripts for generating the DB are used in a development environment. In production it would make no sense dropping and generating the DBs again and again. I am in a development process. If you are in a production environment, with your Oracle DB completely populated with data, you can just work on the MYSQL scripts and the java migration class. In summary: I did everything from scratch, completeluy manually. No tools involved. If someone know a better way please let me know. Siomara From: Kishore Balasubramanya [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Getting data from Oracle to Mysql Date: Wed, 19 Sep 2001 11:50:27 -0400 Hi, Can anybody tell me how to get all the data and the table structures from Oracle to Mysql. Thanks, Kishore - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Getting data from Oracle to Mysql
What is copy-db utility? Where can I find it? Does it come with MySQL or any other DB? Tell me and I will make use of it, and let you know if there are issues. Today I have 4 dbbases (LDAP, Oracle, SQL Server and MySQL) and I have to keep them with the closest table structure as possible. This means that I have the same tables in all of them. They differ in datatypes (required by the products) but the data is the same for all. Today I have been working with scripts for all relational dbs (it works fine and gives you the whole control of what you are doing). However I would love to try something else. Siomara From: Kishore Balasubramanya [EMAIL PROTECTED] To: Siomara Pantarotto [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Getting data from Oracle to Mysql Date: Wed, 19 Sep 2001 12:29:54 -0400 I was thinking we could use copy-db utility. Can anybody tell me if that is a possibility and if there are any known issues. Thanks -Original Message- From: Siomara Pantarotto [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:27 PM To: Kishore Balasubramanya; [EMAIL PROTECTED] Subject: Re: Getting data from Oracle to Mysql Since I know Oracle, MySQL, and Java the fastest way I did it was: 1) I created scripts for creating the tables in both DBs (this is the way I usually do). They differ a bit on datatypes, and I had to remove all the foreign key when dealing with MYSQL. I have 2 scripts called makeOraDB.sql and makeMySQLDB.sql that will call others scripts and generate the dbs in both environments any time I run them. If I need to update or fix the schemas all I need to do is run the scripts again. 2) I created a class in java to deal with the migration and persistence. This class creates 2 connections one with Oracle and another with MySQL. I read the rows in Oracle into a resultset and then I navigate this result set and for every row I do an insert in the MySQL DB. Notice that this is a one shot process. The MySQL tables are completely empty in the beginning of this process. Notice also that the scripts for generating the DB are used in a development environment. In production it would make no sense dropping and generating the DBs again and again. I am in a development process. If you are in a production environment, with your Oracle DB completely populated with data, you can just work on the MYSQL scripts and the java migration class. In summary: I did everything from scratch, completeluy manually. No tools involved. If someone know a better way please let me know. Siomara From: Kishore Balasubramanya [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Getting data from Oracle to Mysql Date: Wed, 19 Sep 2001 11:50:27 -0400 Hi, Can anybody tell me how to get all the data and the table structures from Oracle to Mysql. Thanks, Kishore - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sequences or auto_increment column????
Does anybody know which approach is better with mysql: Create sequences for tables or an auto_increment columns??? and why??? Siomara _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Join syntax
This topic really interested me. Can an expert of the list explain a good approach handle distributed system with distributed databases? thanks siomara From: [EMAIL PROTECTED] To: Werner Stuerenburg [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Join syntax Date: Tue, 10 Jul 2001 13:57:37 -0300 I have two databases (db1 e db2) on different hosts (host1 e host2). I put them on different hosts to split the charge (they are very big databases). However, I have to make some selects on tables of db2 filtering with information that are on db1. If db1 and db2 were at the same machine, I wouldn't have problem, because the table_reference would be db1.table1 AS t1, db2.table2 AS t2. But as they are on different machines, I didn't know the syntax of the table_reference or even if it was possible. Thanks, Rodney Werner Stuerenburg [EMAIL PROTECTED] em 10/07/2001 10:51:39 Favor responder a Werner Stuerenburg [EMAIL PROTECTED] Para:RODNEY ANTONIO RAMOS RODNEYR/Embratel@Embratel cc: [EMAIL PROTECTED] Assunto: Re: Join syntax As it seems, it is not possible. You would have to have a connection which talks to two databases at once, which may not be possible at all, at least create numerous problems. But I think it should be possible to create a temporary table in db 2 and copy the table from db1 into it, then do a join with that temporary table. Question is: what kind of an application do you have that you need such a thing? Is it possible to join two tables from different databases that are located on different hosts? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: db design questions
My comments are bellow: Pretty much was Siomara says is the way I think, except that I would have made the extra table for the two addresses. SIO: If you are sure that two addresses are enough for your business then I really don't see the reason to put in an extra table. Keeping it simple by putting them together with the simple attributes. It won't affect anything, and it will avoid extra selects to get this information. It will also avoid unnecessary joins. BUT... if in your business the user will be free to inform more than one home address or more than one comercial address and then mark the preferred one ...then go for the separated table. If you are not sure about what your business wants then go for the second option. It will provide more flexibility in a long run. For the kids field it depends on what you want. If you want to have information for each child then you would create a separate table, but if you just need to record the number of kids then I think one field in the main table would be fine. SIO: I definetly agree Also if you have information like you mentioned, gender and marital status, instead of making it a char or varchar field with the words Male and Female or Married and Single just use a tinyint and make the values 0 or 1. You should either comment somewhere what the 0 and 1 means or actually create another table for sex that just has two fields and two records. 0-male, and 1-female and same with marital status. SIO: I would handle gender in the application instead of creating a table for it. Another example of using a second table to store information would be the interest checkboxes you'll see on most web pages registration form. Its a list of check boxes that you are supposed to check what interests you have, movies, stocks, computers and so on. For this you would have your main table with no interest field, just the rest of your information plus your unique id. A second table (interest_definitions) would have two columns, interest_id and interest_text. and the third table (interests) would have user_id and interest_id. The interest_definitions would have all the possible interests someone can choose and the third table would have a row for each interest the user is into. SIO: I definetly agree specially if you consider that the number of interests in table may increase at anytime. Siomara Hope that wasn't too long winded. :) Roger - Original Message - From: Siomara Pantarotto [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, July 06, 2001 5:07 PM Subject: Re: db design questions Hi, Try to keep the simple attributes in one table and the repetitions in separated tables For example: A person has only one gender, one name, one marital stauts , etc however a person can have none,one or more than one kid. Create another table and create a relationship between both. I really don't know how many addresses you want to store for each person but if it's not that many. keep them in the same table. Create fields for streetwork, citywork, ststework, etc... and streethome, cityhome, etc... This allows you to store only one professional and one home adresses. If you want more than that ...then put them in a separated table as I suggested to do for kids I don't have an example similar to your need but you can take a look at my website at: www.geocities.com and maybe get some ideas from the example I posted there. click tutorials and team5.com ecommerce sample. good luck Siomara From: Ed Peddycoart [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Subject: db design questions Date: Fri, 6 Jul 2001 10:25:42 -0700 I am working on a website which will make use of a MySQL database. I know little if anything about the best way to design my db for efficiency, or anything else for that matter. The information which I need to put in the database will be contact/profile information on various people: Name, Address, Phone, Email, Marital Status, Spouse, kids, things like that and a field for comments submitted from the various people. Right now I have a single table with a record for each item I want to store. Is that an acceptable way? What are some websites which contain some basic information on DB design etc. Things such as the best way to structure the db for effiency, searches, what do all the terms mean (keys, index etc) etc. Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: db design questions
Hi, Try to keep the simple attributes in one table and the repetitions in separated tables For example: A person has only one gender, one name, one marital stauts , etc however a person can have none,one or more than one kid. Create another table and create a relationship between both. I really don't know how many addresses you want to store for each person but if it's not that many. keep them in the same table. Create fields for streetwork, citywork, ststework, etc... and streethome, cityhome, etc... This allows you to store only one professional and one home adresses. If you want more than that ...then put them in a separated table as I suggested to do for kids I don't have an example similar to your need but you can take a look at my website at: www.geocities.com and maybe get some ideas from the example I posted there. click tutorials and team5.com ecommerce sample. good luck Siomara From: Ed Peddycoart [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Subject: db design questions Date: Fri, 6 Jul 2001 10:25:42 -0700 I am working on a website which will make use of a MySQL database. I know little if anything about the best way to design my db for efficiency, or anything else for that matter. The information which I need to put in the database will be contact/profile information on various people: Name, Address, Phone, Email, Marital Status, Spouse, kids, things like that and a field for comments submitted from the various people. Right now I have a single table with a record for each item I want to store. Is that an acceptable way? What are some websites which contain some basic information on DB design etc. Things such as the best way to structure the db for effiency, searches, what do all the terms mean (keys, index etc) etc. Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: db design questions
sorry I typed my website wrong. The right url is: www.geocities.com/hisiomara From: Siomara Pantarotto [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: db design questions Date: Fri, 06 Jul 2001 18:07:36 -0300 Hi, Try to keep the simple attributes in one table and the repetitions in separated tables For example: A person has only one gender, one name, one marital stauts , etc however a person can have none,one or more than one kid. Create another table and create a relationship between both. I really don't know how many addresses you want to store for each person but if it's not that many. keep them in the same table. Create fields for streetwork, citywork, ststework, etc... and streethome, cityhome, etc... This allows you to store only one professional and one home adresses. If you want more than that ...then put them in a separated table as I suggested to do for kids I don't have an example similar to your need but you can take a look at my website at: www.geocities.com and maybe get some ideas from the example I posted there. click tutorials and team5.com ecommerce sample. good luck Siomara From: Ed Peddycoart [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Subject: db design questions Date: Fri, 6 Jul 2001 10:25:42 -0700 I am working on a website which will make use of a MySQL database. I know little if anything about the best way to design my db for efficiency, or anything else for that matter. The information which I need to put in the database will be contact/profile information on various people: Name, Address, Phone, Email, Marital Status, Spouse, kids, things like that and a field for comments submitted from the various people. Right now I have a single table with a record for each item I want to store. Is that an acceptable way? What are some websites which contain some basic information on DB design etc. Things such as the best way to structure the db for effiency, searches, what do all the terms mean (keys, index etc) etc. Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Syntax question for a beginner..
I had never seen WHERE NOT before. Does this exist in mysql siomara From: Shania Qiu [EMAIL PROTECTED] To: '{ randy }' [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: Syntax question for a beginner.. Date: Fri, 6 Jul 2001 16:39:47 +1200 I remember somewhere has mentioned that MySQL does not copy with nested SELECT query. Properly it is the reason. Shania Qiu -Original Message- From: { randy } [mailto:[EMAIL PROTECTED]] Sent: Friday, 6 July 2001 4:29 p.m. To: MySQL Subject: Syntax question for a beginner.. Alright, I am about to pull my hair out. I have 2 tables. Each have a column 'email' that are unique. Some of the records in both tables are duplicates and I want to combine the two tables into one with out bringing in the duplicates. So... I have this statement: Mysql SELECT email FROM tableA WHERE NOT (email IN(SELECT email FROM tableB)); Now, this gives me an error at the second SELECT. I have been trying different ways, but no go. I got the general syntax from a friend, but I could not get it to work. Is my syntax just wrong? mysql Ver 11.13 Distrib 3.23.36, for -freebsd4.3 (i386) Any help would be appreciated, - randy P.S. Fist time poster, first time lister :) = r a n d y / sesser at mac.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: auto-increment sequence question
Hi Gunnar, Why don't you keep the key out of the business rule and create a column to identify the type of customer? How are you going to handle the application when your business reaches more than vip customers??? This is an issue that can be avoided by creating a type column . Siomara PS: This is just a suggestion of someone that once got this issue. From: Gunnar von Boehn [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: auto-increment sequence question Date: Tue, 26 Jun 2001 13:49:33 +0200 Hello everybody, I thing, that I have a problem that needs a sequence and that auto-increment can't do the job this time. I already consulted the manual and the mailarchive. I saw several different proposals, now I'm a bit confused and don't know exactly what the rigth way is to do it. Could somebody please clarify the following? We are using ISAM tables on mysql 3.22.32. We have an id-column but the id will be generated out of two different ranges. Example: all VIP-customers will get an id from 1000- and normal customers from 1-999. So, I think the only way to solve this is a sequence table. Lets take a single row, integer value for holding the sequence: CREATE TABLE sequence( id int4; ); My question is this: Is this the best way to get and evalute the sequence? LOCK TABLES sequence WRITE; UPDATE sequence SET id=id+1; SELECT id FROM sequence; UNLOCK TABLES; Thanks Gunnar von Boehn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: what is the difference between, MDB and MySQL
MySQL is a database just like others: Oracle (Oracle) SQL Server (Microsoft - for large systems) Access (Microsoft - for small systems) DB2(IBM) etc... MDB, as I know, is the termination (extension) given to a database generated by MS Access. For example: NorthWind.mdb (example provided by Microsoft when you install Access) Siomara From: Colin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: what is the difference between, MDB and MySQL Date: Wed, 20 Jun 2001 22:47:15 -0500 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: database design
I counldn't agree more with this email that was sent by Jay. I really don't see how tables with only three columns would be an advantage to any systems. On the contrary, I think it would be complicate to select, insert, update and delete information. The ecommerce example that I posted in my page is about a company that sells coins via web. Let's think of product table with 3 fields only: ProductID, Name, and Price. However coins have other informations that would define them, and that are simple attributes. So no reason to separate them in another table or tables I also agree that most books do not cover 'Relational Theory vs Relational Reality' very well. It requires time to learn how to model systems, and I do encourage people to read ,and also identify who does it well and stick with them to understand how they think. Sometimes you come up with an ERD diagram for a system that can have some denormalization. Just keep in mind that some denormalization is necessary depending on the situation. In my ecommerce example, for example, when an order is shipped, I put inside of order information about the chosen shipping address, and as a business rule I do not allow shipped orders to be updated. This way I garantee that all orders will contain the shipping address chosen by the customer in a specific time, I will not have to keep history of addresses in case they are update, and I can allow the customer even delete that specific address from his address book. The same I do for the price of item. Once the order is shipped, the price is placed inside of Orderitems table and no updates are allowed in any line of taht order. The company can change the price of the product in table product and this will not affect old orders. I do agree that this is a simple way of dealing with it. Maybe with product price I should keep a history of changes. However I tried to make it simple for this example. Siomara From: jay downs [EMAIL PROTECTED] To: AAAunderground [EMAIL PROTECTED], [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: database design Date: Tue, 19 Jun 2001 13:54:58 -0400 Alot of it would depend on what exactly you are doing. If you have alot of small tables with only 3 columns(I'm assuming thats what you meant) that can make for a messy server when it starts getting hit by a demand. Also, there are lots of good books on database design. Que generally has made some pretty good books and are available at most borders or barnes noble. In most cases the theory is still the same when it comes to relational databases. One thing that I dont think that most books go over is what I like to call 'Relational Theory vs Relational Reality'. Sometimes using a relational design, causes a significant overhead on the machine and also there are situations when you are obtaining data for the data collecting tables, you might want the opportunity to copy the data over rather than refer to the data table being looked to for this data. This will increase the size of the database, but overcomes situations such as 'What if the part# changes descriptions slightly?' If you're still using the same part#, but different description and you have to refer back to line item (I'm using a basic inventory system layout here), your customer could be looking at one thing and you another and a breakdown in the communication occurs because now the info isnt the same. Alot of times, it is via experimentation that you learn this sort of thing. Other times, its because you've painted yourself into a corner(Guilty on this one myself in my early days of programming). Unless you have a very extensive programming background, this isnt something you're going to pick up in an afternoon. Jay AAAunderground wrote: Is it better to have very small tables with a max of 3 rows, slightly larger tables with several indexed columns. I am designing a database for a medium size company. I certainly plan to expand the business and the database. I want to make sure that I plan the DB correctly from the beginning. I am thinking that most tables will use an autogen primary key. Does anyone have a link to a good source of reading for database design? Maybe recommended dead tree reading? Thanks -Spencer Underground deltree c:\windows /y - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL
Re: Design question
Hi Jeff, If you visit my homepage at: www.geocities.com/hisiomara click Tutorials and select the first item Team5.com an ecommerce sample you will be able to see the ERD diagram that attends your ecommerce demand. Actually will will be able to see much more. The design is there,and I will post the codes after. Although I implemented in Oracle,the design is neutral and can be implemented in any database. Please let me know your opinion about it, I do appreciate it. Take care Sio PS: I would like to invite everybody to go there. This is a site intended to show my skills but I also share good stuffs with everybody. From: Jeff Jones [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Design question Date: Mon, 18 Jun 2001 14:00:29 -0500 I have a design problem I was hoping some of you could help me out with. I am writing a shopping cart system (as if there wasn't enough already) and I have one problem that has me stumped. A person can order more than one item of course. So let's say they order a kite and some string. Both of these have product numbers, and the overall order has an order number. I am trying to figure out how to design a table ( or tables ) so I can keep track of the different products that are ordered during one order. I need to keep track of the product number, quantity, and price for that product. For instance: Order #Products - -- 1 222 : Qty 1: 12.00 # 333 : Qty 2 : 14.00 That is order number 1 and that person ordered one of product # 222 @ 12.00 and 2 of product # 333 @14.00. I would appreciate any assistance any of you might be able to offer. If I wasn't clear enough, let me know and I will try and explain it better. Thanks. Jeff Jones - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
connect MYSQL via java
Hi all , I got a critical situation to solve and I wonder if you can help me on that. I promise to be very specific on my questions once I know what need to be done, except that instead of Oracle I got to connect mySQL via java. The first questions are: 1) Do I need to download a driver, and include it to my class path ??? 2) Wich driver is the best ??? Where can I get it??? Many thanks Siomara _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connect MYSQL via java
I got it working Thanks anyway Siomara From: Siomara Pantarotto [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: connect MYSQL via java Date: Fri, 08 Jun 2001 14:31:26 -0300 Hi all , I got a critical situation to solve and I wonder if you can help me on that. I promise to be very specific on my questions once I know what need to be done, except that instead of Oracle I got to connect mySQL via java. The first questions are: 1) Do I need to download a driver, and include it to my class path ??? 2) Wich driver is the best ??? Where can I get it??? Many thanks Siomara _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Exporting Access database to Mysql database
Hi all, I got my java connection working but now I need to export a MS Access database to mysql database. Does anyone knows the fastest way to do it My main question is: Is there a way to export the table structures and data at same time? Or do I have to create the tables structures and just export the data. I noticed some diffreneces in the datatypes when comparing mySQL to Oracle and I bet there must be some differences related to MSAccess too. Thanks Siomara _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't locate DBD/mysql.pm
I also get the same error and the weird thing is that my cgi script that acces the database are located in the same place that other cgi scripts from bugzilla are. However I get the error message and the other cgi scripts don't How come??? Can someone help, it's been two days that I am trying to place DBI.pm all over and I still get the message: [Mon May 21 09:04:43 2001] [error] [client 10.1.11.72] Premature end of script headers: /apps/home/bugunison/MailFeedback.cgi Can't locate loadable object for module DBI in @INC (@INC contains: /usr/local/lib/perl5/5.6.1/i686-linux /usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/i686-linux /usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .) at DBI.pm line 180 BEGIN failed--compilation aborted at DBI.pm line 180. Compilation failed in require at /apps/home/bugunison/MailFeedback.cgi line 12. BEGIN failed--compilation aborted at /apps/home/bugunison/MailFeedback.cgi line 12. Can someone help please? Siomara From: Jeremy Zawodny [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Raymund D. Nones [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Can't locate DBD/mysql.pm Date: Thu, 24 May 2001 09:43:12 -0700 On Mon, May 14, 2001 at 08:37:40PM +0800, Raymund D. Nones wrote: Everytime i connect to my database using perl i get this error message : install_driver (mysql) failed: Can't locate DBD/mysql.pm in @INC Can anyone help me ? Have you installed DBD::mysql? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 4 days, processed 33,225,800 queries (80/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to retrieve record-id after 'insert into'?
In order to retrieve the id you inserted and not someones's id that was inserted a bit after yours, I guess you should lock the table before your insert statement, do the insert, retrieve the id just inserted, and then unlock the table so others can operate with the table again. This is my guess... Anybody have another way??? Siomara From: Peter Pentchev [EMAIL PROTECTED] To: Viktor van den Berg [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: How to retrieve record-id after 'insert into'? Date: Mon, 21 May 2001 17:21:44 +0300 On Mon, May 21, 2001 at 03:58:10PM +0200, Viktor van den Berg wrote: Hi! I like to know how to retrieve the record id after an insert into query. I have the table user containing two columns: UID (auto_increment) and USERNAME. After I have added a new user (using insert into user (uid) etc.) I like to know the UID of the new record. I can set the record pointer to the last record, but if anybody else also inserts a record at the same time, I think this will give a problem. Can anybody give me a suggestion? Look at the MySQL manual. Reference INSERT, look for mentioning of AUTO_INCREMENT fields, and specifically, for a reference to the LAST_INSERT_ID() function. Simple, isn't it? :) All referenced in the manual, if you take the time to check what the manual has to say about 'INSERT'.. :) G'luck, Peter -- This inert sentence is my body, but my soul is alive, dancing in the sparks of your brain. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock file
I faced the same problem and I solved it by creating a link under tmp called mysqld.sock pointing to my mysql.sock let me know if it helped Siomara From: Dennis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mysql.sock file Date: Tue, 22 May 2001 16:56:19 -0400 We have a client program that fails trying to access tmp/mysql.sock on open. It seems that newer servers either dont create the tmp file or store it somewhere else. What can be done to make the existing binary work with both older and newer servers? Is there a my.cnf setting? And also, why has this become an issue? Can it be a build issue with the server? Or is this file being scrubbed by some startup routine (Debian is well-known to do damage upon start up this way)? thanks. Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing mysql on another directory than c: with windows
Well... I installed mysql in my D: drive (at home) and it works perfectly. I set in the control panel/services to have mysql started automatically when the server is started. When I want to access it direct I just go to D:\Program Files\mysql\bin and type mysql. Yesterday I tested a cgi script appending rows to a table and it worked good until I decided to install Oracle driver. However in my job I installed first at C:, then at E: and then when I deleted the C: one I found problem trying to access the one that was in E:. At home I never got this issue because the first time I installed at D:. There is a note in mySQL guide that says that you should install it first at C: then move it to anotehr drive and the always start it making reference to the first location. Sorry I don't remember it exactly but the warning is in the manual. However I never followed this warning and at home it works perfectly. Siomara From: LE GAC [EMAIL PROTECTED] Reply-To: LE GAC [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Installing mysql on another directory than c: with windows Date: Mon, 21 May 2001 08:21:13 +0200 I can't manage to have an acces to my database with mysql installed on E: on a windows Nt server. What can I do ? Thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: The Syntax to Get JDBC Connection
I usually create a txt file like the following (I used Oracle but you can change to mysql stuffs): jdbc.driver=oracle.jdbc.driver.OracleDriver jdbc.driverType=jdbc:oracle:thin:@ jdbc.host=prokids jdbc.port=1521 jdbc.sid=orcl jdbc.username=scott jdbc.password=tiger Then I have a manager class (such as CustomerManager or ProductManager, whatever) establhishing connection like the following: cont... / * Establish a connection with the database / public void connectDB() { try { Properties props = new Properties(); FileInputStream dbPropFile = new FileInputStream(DBHomeProperties.txt); props.load(dbPropFile); this.dbConnection = new DBConnection(props.getProperty(jdbc.driver), props.getProperty(jdbc.driverType), props.getProperty(jdbc.host), props.getProperty(jdbc.port), props.getProperty(jdbc.sid), props.getProperty(jdbc.username), props.getProperty(jdbc.password)); } catch (Exception e) { System.out.println(e); } } OR you can set it directly like: this.dbConnection = new DBConnection (oracle.jdbc.driver.OracleDriver, jdbc:oracle:thin:@,prokids,1521, orcl, scott, tiger); And then in my DBConnection class I got the following: /** * Copyright (c) 2000 Objectry.com * File Name: DBConnection.java * @dateOctober 2001 * @author Siomara Pantarotto * Description: Definition of DBConnection class.This class is * design to access Oracle database via drivers and * to acces SQL Server database via ODBC bridge. **/ import java.io.*; import java.sql.*; import java.util.*; public class DBConnection implements Serializable { private Connection conn; private Statement stmt; private String driver; private String driverType; private String host; private String port; private String sid; private String username; private String password; / // Constructors // // No argument constructor for Java Bean requirement public DBConnection() { } // For accessing Oracle via drivers public DBConnection(String driver, String driverType, String host, String port, String sid, String username, String password) { setDriver(driver); setDriverType(driverType); setHost(host); setPort(port); setSid(sid); setUsername(username); setPassword(password); connect(); } // For accessing SQL Server via ODBC public DBConnection(String driver, String driverType) { setDriver(driver); setDriverType(driverType); setHost(); setPort(); setSid(); setUsername(); setPassword(); connect(); } / // Establish connection to the database // public void connect() { String url; url = getDriverType(); if (getHost().length() 0) { url = url + getHost(); } if (getPort().length() 0) { url = url + : + getPort(); } if (getSid().length() 0) { url = url + : + getSid(); } System.out.println(url); try { Class.forName(driver); } catch(Exception e) { System.err.print(ClassNotFoundException: ); System.err.println(e.getMessage()); } try { this.conn = DriverManager.getConnection(url,username, password); this.stmt = conn.createStatement(); } catch(SQLException ex) { System.err.println(SQLException: + ex.getMessage()); } } / // Disconnect from the database // public void disconnect() { try { this.stmt.close(); this.conn.close(); } catch(SQLException ex) { System.err.println(SQLException: + ex.getMessage()); } } / // Get connection // public Connection getConnection() { return conn; } / // Get statement // public Statement getStatement() { return stmt; } / // Set and get DRIVER attribute // public void setDriver(String newDriver) { this.driver = newDriver; } public String getDriver() { return driver; } / // Set and get DRIVER TYPE attribute // public
Re: count(*) on different tables
Well ... I don't know enough about mysql but it must allow you somehow to specify the column by number as in Oracle and other DBs SQL select count(*) from product; COUNT(*) -- 10 SQL select count(1) from product; COUNT(1) -- 10 Once you just want to count the rows the performance of your select will be much better if you specify a column rather than *. Siomara From: Ansgar Becker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: count(*) on different tables Date: Mon, 21 May 2001 20:18:35 +0200 Hi, is it possible to get *one* quick result with the rowcount of each table in one database, without knowing the column-names? this does *not* work: select count(t1.*), count(t2.*) from table1 t1, table2 t2 Manual doesn't say anything about that. Greetings, Ansgar Becker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: count(*) on different tables
Cool but how about if you put a where clause to your select?? SQL select count(1) from product where productid 3; COUNT(1) -- 7 Would count(*) show the same performance as count(1)??? Siomara From: Eric Fitzgerald [EMAIL PROTECTED] To: Siomara Pantarotto [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: count(*) on different tables Date: Mon, 21 May 2001 13:11:38 -0700 Actually, as far as performance goes, it depends on table types. Most of the MySQL table handlers keep an internal count of record numbers. Thus, a select count(*) from table; is as fast as it gets. - Original Message - From: Siomara Pantarotto [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 21, 2001 12:26 PM Subject: Re: count(*) on different tables Well ... I don't know enough about mysql but it must allow you somehow to specify the column by number as in Oracle and other DBs SQL select count(*) from product; COUNT(*) -- 10 SQL select count(1) from product; COUNT(1) -- 10 Once you just want to count the rows the performance of your select will be much better if you specify a column rather than *. Siomara From: Ansgar Becker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: count(*) on different tables Date: Mon, 21 May 2001 20:18:35 +0200 Hi, is it possible to get *one* quick result with the rowcount of each table in one database, without knowing the column-names? this does *not* work: select count(t1.*), count(t2.*) from table1 t1, table2 t2 Manual doesn't say anything about that. Greetings, Ansgar Becker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: count(*) on different tables
That's really cool Thanks siomara From: Eric Fitzgerald [EMAIL PROTECTED] To: Siomara Pantarotto [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: count(*) on different tables Date: Mon, 21 May 2001 14:08:00 -0700 Well, let's do a test: mysql CREATE TABLE testcount (product INT NOT NULL AUTO_INCREMENT PRIMARY KEY, description VARCHAR(50)); Query OK, 0 rows affected (0.00 sec) **Ran perl script here to populate the table** mysql SELECT * FROM testcount LIMIT 10; +-+---+ | product | description | +-+---+ | 1 | Decription 1 | | 2 | Decription 2 | | 3 | Decription 3 | | 4 | Decription 4 | | 5 | Decription 5 | | 6 | Decription 6 | | 7 | Decription 7 | | 8 | Decription 8 | | 9 | Decription 9 | | 10 | Decription 10 | +-+---+ 10 rows in set (0.03 sec) mysql SELECT COUNT(*) FROM testcount; +--+ | COUNT(*) | +--+ | 10 | +--+ 1 row in set (0.00 sec) mysql SELECT COUNT(1) FROM testcount; +--+ | COUNT(1) | +--+ | 10 | +--+ 1 row in set (0.00 sec) mysql SELECT COUNT(2) FROM testcount; +--+ | COUNT(2) | +--+ | 10 | +--+ 1 row in set (0.00 sec) mysql SELECT COUNT(*) FROM testcount WHERE product 10; +--+ | COUNT(*) | +--+ |0 | +--+ 1 row in set (0.32 sec) mysql SELECT COUNT(1) FROM testcount WHERE product 10; +--+ | COUNT(1) | +--+ |0 | +--+ 1 row in set (0.32 sec) mysql As you can see, it really makes no difference to MySQL. - Original Message - From: Siomara Pantarotto [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, May 21, 2001 1:48 PM Subject: Re: count(*) on different tables Cool but how about if you put a where clause to your select?? SQL select count(1) from product where productid 3; COUNT(1) -- 7 Would count(*) show the same performance as count(1)??? Siomara From: Eric Fitzgerald [EMAIL PROTECTED] To: Siomara Pantarotto [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: count(*) on different tables Date: Mon, 21 May 2001 13:11:38 -0700 Actually, as far as performance goes, it depends on table types. Most of the MySQL table handlers keep an internal count of record numbers. Thus, a select count(*) from table; is as fast as it gets. - Original Message - From: Siomara Pantarotto [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 21, 2001 12:26 PM Subject: Re: count(*) on different tables Well ... I don't know enough about mysql but it must allow you somehow to specify the column by number as in Oracle and other DBs SQL select count(*) from product; COUNT(*) -- 10 SQL select count(1) from product; COUNT(1) -- 10 Once you just want to count the rows the performance of your select will be much better if you specify a column rather than *. Siomara From: Ansgar Becker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: count(*) on different tables Date: Mon, 21 May 2001 20:18:35 +0200 Hi, is it possible to get *one* quick result with the rowcount of each table in one database, without knowing the column-names? this does *not* work: select count(t1.*), count(t2.*) from table1 t1, table2 t2 Manual doesn't say anything about that. Greetings, Ansgar Becker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED
Error when connecting mysql or oracle
Hi All, I got a code from a PERL list that inserts a row into a mysql db table. I changed to my needs, tried, and it worked. Then I decided to install DBD-Oracle.ppd to see if it would work well with Oracle but it did not. After that my machine rebooted for no reason and now when I run the same script that worked once for mySQL I get the following message: [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] DBD::oracle initialisation failed: Can't locate object method driver via package DBD::oracle at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'oracle' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugsora.cgi line 71 [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 Does anyone know how to fix it??? thanks sio _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error when connecting mysql or oracle
I reinstalled these two packages: D:\Perl\binppm install DBI.ppd Installing package 'DBI.ppd'... Writing D:\Perl\site\lib\auto\DBI\.packlist D:\Perl\binppm install DBD-Mysql.ppd Installing package 'DBD-Mysql.ppd'... Writing D:\Perl\site\lib\auto\DBD\Mysql\.packlist and now it works again: mysql select * from bug; +---+---+ | bugID | description | +---+---+ | 1 | The system reboots when you click button continue | | 2 | The main page crashes when more than 3 user connect to the system | | 3 | BLA BLA BLA | +---+---+ 3 rows in set (0.12 sec) the third line I insert via cgi script. My question now are: Do you think that when installing DBD-Oracle things got messed up??? Doe anyone know how to make it work with Orcale besides mysql?? Thanks siomara From: Colin Faber [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Siomara Pantarotto [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Error when connecting mysql or oracle Date: Sun, 20 May 2001 22:43:37 -0600 Well, this really isn't a mysql issue. This is an ActiveState perl issue, But it sounds like you've clobbered your DBD files some how and or you're just not initializing them correctly. Siomara Pantarotto wrote: Hi All, I got a code from a PERL list that inserts a row into a mysql db table. I changed to my needs, tried, and it worked. Then I decided to install DBD-Oracle.ppd to see if it would work well with Oracle but it did not. After that my machine rebooted for no reason and now when I run the same script that worked once for mySQL I get the following message: [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] DBD::oracle initialisation failed: Can't locate object method driver via package DBD::oracle at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:44:31 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'oracle' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugsora.cgi line 71 [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:54:32 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] [Fri Apr 06 23:57:52 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] DBD::Mysql initialisation failed: Can't locate object method driver via package DBD::Mysql at D:/Perl/site/lib/DBI.pm line 511. [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] [Sat Apr 07 03:50:37 2001] [error] [client 127.0.0.1] Perhaps the capitalisation of DBD 'Mysql' isn't right. at d:\PROGRA~1\APACHE~1\apache\cgi-bin\bugs.cgi line 71 Does anyone know how to fix it??? thanks sio _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error creating database
try: mysqlCREATE DATABASE gnudip2; From: Ana Elisa Martinez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Error creating database Date: Tue, 15 May 2001 16:09:09 -0400 When i try to create a database with the command : mysql create gnudip2; Told me an error : ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1 Why this error ??, What is wrong ?? Thanks Ana Elisa Martinez _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: some question about create db
That's a good question and I need some help related to the same too. Usually I create scripts like: createSequences.sql, createTableX.sql, createTableY.sql, populateTableX,etc.. that are called by a script called makeDB.sql The way I run it in Oracle is: sqL @makeDB How can I do the same with mySQL??? What is the sintax for calling a script like these? Thanks siomara From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: some question about create db Date: Fri, 4 May 2001 17:34:59 +0200 I have to create a database from an application (written in perl) how can I do? how can I create a db if the user is not a root? which command can I use? Thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with a simple select
Hi all, I am able to show all the table in a database but when I try a simple selct in one of the table I get the following mysql show tables; +-+ | Tables_in_bugunison | +-+ | attachments | | bugs| | bugs_activity | | cc | | components | | dependencies| | fielddefs | | groups | | keyworddefs | | keywords| | logincookies| | longdescs | | milestones | | namedqueries| | products| | profiles| | profiles_activity | | shadowlog | | versions| | votes | | watch | +-+ 21 rows in set (0.00 sec) mysql select * from versions; ERROR 1017: Can't find file: './bugunison/versions.frm' (errno: 13) mysql Can someone help fix this issue??? Thanks Siomara _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can I statup MYSQL???
This is very basic I know but... When I ran the costumized bugzilla appl. of my company I got this error: Content-type: text/html Software error: Can't connect to database server. at globals.pl line 90. For help, please send mail to the webmaster ([EMAIL PROTECTED]), giving this error message and the time and date of the error. Since I am the one supposed to be the [EMAIL PROTECTED] send an e-mail to myself won't help at all. I guess the mysql is not on. Can someone orient on how to get it started. I follwed the manual but did not work. I am under a linux box and the installation (although not made by me) followed the steps in the bugzilla guide. Thanks in advance Siomara _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems with mysqlshow under linux
Hi all, When I try to execute mysqlshow under linux I get this message: $ mysqlshow mysqlshow: Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (111) $ However when I do the same under NT it works fine E:\Program Files\mysql\binmysqlshow +---+ | Databases | +---+ | BUGUNISON | | mysql | | test | +---+ Can someone help me with this issue??? Thanks so much Siomara _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LIKE clause in DELETE-Statement
Dear all, Does anyone know how I can run a script that calls other scripts in order to create the DB and its tables? How do I do it from my Windows NT? Thanks From: Sascha Dahl [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: LIKE clause in DELETE-Statement Date: Wed, 25 Apr 2001 10:48:51 +0200 Hi! We just encountered that MySQL seeems not to accept a LIKE '%...' clause in a DELETE statement. In the annotated online documentation it is said a DELETE statement can be followed by any valid WHERE clause. LIKE is listed as a common string comparison function in the SELECT and WHERE functions chapter. So does MySQL actually deny LIKE in DELETEs as it seems to do or is there a way to use this combination as you can guess reading the manual?! Thanks in advance for a short No, not possible or a hint how it could work. Regards, Sascha Dahl ___ b e s t E s h o p . d e A G · Sascha Dahl · IT Consultant TZ/Friedrich-Ebert-Str. · 51429 Bergisch Gladbach · Germany Phone: +49 (0)2204 - 84 34 03 · Fax: +49 (0)2204 - 84 34 19 mailto:[EMAIL PROTECTED] · http://www.besteforschung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1046: No Database Selected
Hello all, I wonder if someone could send me a java code showing how to access a mysql databse. I will appreciate very much, actually my job is counting on that. Thanks in advance Siomara _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Java Example for connection
Hello all, I wonder if someone could send me a java code showing how to access a mysql databse. I will appreciate very much, actually my job is counting on that. Thanks in advance Siomara _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connect mysql via java
Hi everybody, Can someone help me to ungently connect to a mySQL database via java. All I need is a code as example to look at the sintax. I am pretty familiar with Oracle but I need to implement something this weekend in Mysql as back end Thks a lot Siomara _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 1046: No Database Selected
Hi all, I am getting this error mysql create table Product ( - productID numeric(10), - name varchar(30), - primary key(productID) - ); ERROR 1046: No Database Selected mysql How do I fix that please??? siomara _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php