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 p

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

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

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

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

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 rem

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 Develo

Re: relational DBMS vs object-relational DBMS

DS 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 : IT"S NOT COMPLETE YET, SO YOU MAY FIND SOME ERRORS, OR CODES THAT NEED TO BE ADJUSTED TO THE EXAMPLE I POST. Sio

RE: Getting data from Oracle to Mysql

ld 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

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

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

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 200

Re: db design questions

inetly 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: <[EMAI

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

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.

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

Re: How delete the first register in a table?

Just to complete... If your table has a sequence as primary key (auto_increment column), you can delete the first row inserted based on the initial value of your sequence. However this is relevant to the application business. SQL, as mentioned before, has no concept like "first in a table". Y

Re: Proposition: Attach a comment to each connection

descriptive usernames?? Does that mean that you create a bunch of users and use their usernames to connect to the database in differente points of your application and track then by the names you provided for usernames??? Sio >From: "D'Arcy Rittich" <[EMAIL PROTECTED]> >To: <[EMAIL PROTE

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

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

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

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 wil

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

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 yo

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

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

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 pro

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 gue

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 >

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

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 cou

RE: The Syntax to Get JDBC Connection

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 O

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 scrip

Re: Error when connecting mysql or oracle

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

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

Perl list and connection to mysql example

Does anybody know a good PERL list Does anybody have a simple example of a PERL code connecting to a MYSQL database?? I just want the syntax Thanks Siomara _ Get Your Private, Free E-mail from MSN Hotmail at http://ww

Re: Loading data with a txt file

) mysql> commit; Query OK, 0 rows affected (0.00 sec) mysql> >From: "Milan Kajnar" <[EMAIL PROTECTED]> >To: "Siomara Pantarotto" <[EMAIL PROTECTED]> >Subject: Re: Loading data with a txt file >Date: Thu, 17 May 2001 08:14:14 +0200 > >Whe

Loading data with a txt file

Hi all, I tried to load data into a table (using a txt file) by following the example on chapter 9 (pg 9) and it did NOT work. Then I decided to include the path of the file and it worked fine. I got curious though. If you omit the path, where does mysql looks for it? I placed the file into t

Re: Error creating database

try: mysql>CREATE 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

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

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 wi

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 a

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\bin>mysqlshow +---+ | Databases | +

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 1

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 f

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 f

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

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 __