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
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
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
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
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
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
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
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
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
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
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
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
.
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
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.
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
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
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 .
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
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
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
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,
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
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
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
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
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
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
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
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
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
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
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
)
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
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
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
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
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
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 |
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
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
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
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
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
43 matches
Mail list logo