Hi.
I have this code:
cId = fila(cmbCodigo.SelectedIndex).ToString
cMedida = fila(cmbMedida.SelectedIndex).ToString
cDenomina = fila(cmbDenominacion.SelectedIndex).ToString
oComando.CommandText = "INSERT INTO preciodeno(id, medida, denomina ) " _
& "VALUES(?cId, ?cMedida, ?cDenomina
Hi!
How i do for transfer data from excel file to mysql?
Some example?
Thanks
d nothing. The environment permissions are set normally (for a jail),
and the apache server is running without problems...
I think there must be a permissions issue, but now I'm not sure...
Any ideas will be highly appreciated.
Thanks!
Best Regards,
Gustavo Castro.
Senior System Admi
select count(distinct membros.ID) as total_membros, count(distinct
replays.ID) as total_replays, count(distinct downloads.ID) as
total_downloads from membros,replays,downloads;
if one of the tables have 0 records all the counts will turn to 0
the count works only if all the tables have records
ho
I want to know if its possible to count the total records of multiple
tables:
Example: I have 3 tables. I want to know the total records of each table
using only 1 query.
Is that possible?
_
Quer ter um fórum para seu clan de Starcraft/BroodWar, C
did you install your debian with "bf24" option??? it´s a kernel 2.4
instalation... in my debian woody 4.0 is very goodmysql 4.0 is ok!
BOA SORTE!!!
---
Gustavo Polillo Correa - Analista de Sistemas
Instituto de Biociencias -
Hi,
I am using Oracle, Mysql Postgresql and ...MS-SQLserver, so i´d like to
know what the best tool to convert databases... The DBTolls is a good
option? does anyone use it?
thanks.
---
Gustavo Polillo Correa - Analista de Sistemas
= 50
Just ask if you need more information.
--
------
Gustavo Baratto - Systems Engineer
[EMAIL PROTECTED] * (604) 638-2525 ext. 408
Technical support web-site: http://support.superb.net
Superb Internet Corp. "Ahead of the Rest"
---
_pool_size = 128M
innodb_additional_mem_pool_size = 16M
innodb_file_io_threads = 4
innodb_lock_wait_timeout= 50
Just ask if you need more information.
--
------
Gustavo Baratto - Systems Engineer
[
Does anybody know what this error is all about? and how do to get rid of
it... It started when I upgraded 4.0.13 to 4.0.15
---
030922 5:17:30 InnoDB: Error: page 1 log sequence number 0 768348475
InnoDB: is in the future! Current system log sequence number 0 330400180.
InnoDB: Your data
is it work?
---
Gustavo Polillo Correa - Analista de Sistemas
Instituto de Biociencias - USP
Sao Paulo - Brasil
Tel/fax : 55-11-3091-7436
---
--
MySQL General Mailing List
For list
I already use linuxthreads for freebsd...
Do you think mysql would run well with the new threads for freebsd 5.XX?
Did anybody try it?
thanks
Jeremy Zawodny wrote:
On Thu, Sep 18, 2003 at 10:51:49AM -0300, Gustavo A. Baratto wrote:
no problem for me... 1000+ DBs on RH linux (ext3 fs), then
l?
Franky
--
------
Gustavo Baratto - Systems Engineer
[EMAIL PROTECTED] * (604) 638-2525 ext. 408
Technical support web-site: http://support.superb.net
Superb Internet Corp. "Ahead of the Rest"
-
--
M
l?
Franky
--
------
Gustavo Baratto - Systems Engineer
[EMAIL PROTECTED] * (604) 638-2525 ext. 408
Technical support web-site: http://support.superb.net
Superb Internet Corp. "Ahead of the Rest"
-
--
M
It will be running on RedHat 9. Would there be any problems running backups
with this many DBs on
one box?
Some filesystems become slow if you have +1000 subdirectories.
ReiserFS doesn't have that problem.
--
------
Gustavo
this?
thanks
--
--
Gustavo Baratto - Systems Engineer
[EMAIL PROTECTED] * (604) 638-2525 ext. 408
Technical support web-site: http://support.superb.net
Superb Internet Corp. "Ahead of the
ction with little
modifications.
> - Original Message -
> From: "Sergei Golubchik" <[EMAIL PROTECTED]>
> To: "Gustavo Castro" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>; "Fortuno, Adam" <[EMAIL PROTECTED]>
> Sent: M
ith little
modifications.
- Original Message -
From: "Sergei Golubchik" <[EMAIL PROTECTED]>
To: "Gustavo Castro" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Fortuno, Adam" <[EMAIL PROTECTED]>
Sent: Monday, September 08, 2003 10:30 PM
Subj
Hello,
i´m using the 3.23.57 version and i´ve declared a native function, but when
i call it (SELECT GETUPDATE(1);) i
get this line
ERROR 1064: You have an error in you SQL syntax near '(1)' at line 1;
I think i´ve followed all the steps right:
1)added the line in lex.h
{"GETUPDATE"
Hello, in order to call a native function do i have to add something else to its name,
i.e. mysql_get_update? because everytime i try to call my native function from the
mysql prompt it gives me a syntax error.
Hello, i know this must be the dumbest question by far (i think i´m even blushing
myself), but how do i call my own native functions? i did all the steps in the
item_create.* and the item_func.* but when call it from the mysql prompt i always get
a sintax error, even if i call some function of t
Hello, i know this must be the dumbest question by far (i think i´m even blushing
myself), but how do i call my own native functions? i did all the steps in the
item_create.* and the item_func.* but when call it from the mysql prompt i always get
a sintax error, even if i call some function of t
Hello, i´m running the Mysql 3.23.57 version in Suse 7.1 and i can´t
add new functions to it. I´ve tried with native functions but just
in the first step, as it appears in the tutorial,
when addding my line in the lex.h file, like this
{"GET_UPDATE", SYM(FUN_ARG1),0,CREATE_FUNC(create_func_get_u
Hello, i´m running the Mysql 3.23.57 version with Suse 7.1, and i´m
getting problems trying to add UDFs to my MySQL
- In /mysql/sql/tipo.h i´ve declared this data type:
typedef struct st_del {
int empty;
char *table;
List keys;
}BUFFER_DEL;
where List is included from the sql_list.h, a
Hello, i´m running the Mysql 3.23.57 version with Suse 7.1, and i´m
getting problems trying to add UDFs to my MySQL
- In /mysql/sql/tipo.h i´ve declared this data type:
typedef struct st_del {
int empty;
char *table;
List keys;
}BUFFER_DEL;
where List is included from the sql_list.h, a
I want to remove the old 2.50 myodbc driver. I installed a new version
of myodbc, and the old driver is still being diplayed in the list...
I know this is not really a mysql problem, but I'm not much of a windows
user and google didn't return good results this time... maybe someone
here could gi
ye")) |
+--+
|0 |
+--+
1 row in set (2.59 sec)
Regards,
Jake Johnson
[EMAIL PROTECTED]
______
Plutoid - htt
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Gustavo A. Baratto" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 11:31 PM
Subject: Re: stopping innodb engine
> At 21:47 + 7/9/03, Gustavo A. Baratto wr
Greetings,
What happens if I use the command below when innodb engine is running?
set global have_innodb=0;
I want to stop innodb engine without stopping the whole server for
backup (most tables are myisam).
Any ideas on how to do that?
Thank all
--
MySQL General Mailing List
For list arc
ing Oracle, but I need to change it to mysql, I have been
trying with the operator <=> but I got nothing, could you give a hand
with this please ?
Thanks a Lot.!
Gustavo Mejia
---
[This E-mail scanned for viruses]
[Deteccion de virus para una mayor seguridad en sus correos de Entrada y Salida.]
user, 1.8% nice, 1.2% system, 0.2% interrupt, 96.9%
idle
Jeremy Zawodny wrote:
On Mon, Jun 09, 2003 at 01:41:00PM +0000, Gustavo A. Baratto wrote:
the load average in my freebsd 5.0 (latest releng) compiled statically
with linuxthreads decreased 80% after I tunned these variables:
What
fluke. But it
happens much more than I had thought.
It's still happening on the site I first reported it on. We're currently
running max-4.0.11-gamma, but the problem has been present since 3.x.
FreeBSD 4.4 and 4.5.
--
-------
Any ideas?
--
------
Gustavo Baratto - Programming and Technical Support
[EMAIL PROTECTED] * (604) 638-2525 ext. 408
Technical support web-site: http://support.superb.net
Superb Internet Corp. "Ah
times :)
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Gustavo A. Baratto" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, June 05, 2003 8:06 PM
Subject: Re: threads not being killed
> On Thu, Jun 05, 2003 at 1
Hi, it seems that when there is an 'union' in a query it transforms the 'null' to '0'
when the field is a number, and more over, I think the result is wrong...
I am using the 4.0.12 mysql server for Win32 in a Windows NT server.
this is the query...
select id, name from customer
union all
select
TimeStamp in the database.
I would appreciate a lot your answer.
Thanks in advance.
Gustavo.
***
Gustavo Cebrian
Analyst/Programmer
Want to improve the ROI on your EAI project?
Download RV Tester and reduce your development
and testing timescales by as much
think about implementing inheritence this way in the =
database?
Thanks.
Gustavo.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
What is Connector/J. Is it just the program which runs on the server?
What GUI do you use for mysql?
Gustavo.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 03 March 2003 13:10
To: Gustavo Cebrian
Subject: Re: Connector/J
Your message cannot be posted
You can use --skip-name-resolve when starting mysqld, but this is not a real
solution.
Even doing that,'I'm still having some odd problems I never had before, like
table corruption (I'm on 4.0.8 though)
- Original Message -
From: "Patrick de Kievit" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECT
ew features.
Ideias?
--
------
Gustavo Baratto - Programming and Technical Support
[EMAIL PROTECTED] * (604) 638-2525 ext. 408
Technical support web-site: http://support.superb.net
Superb Internet Corp
Florian Litot wrote:
>
> hi,
>
> Somebody saw comparaisons of productivity for mysql and others RDBMS?
> or somebody do comparaisons?
>
> thanks
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (th
Hi folks!
I have just installed mysql version 3.23.49! It's all ok!
I have setted error message to be shown in portuguese language! But i
cannot write (using mysql client) any query that uses special portuguese
character, any advice?
Of course, my charset is already setted to latin1.
--
inux threads?
> Apache ,Tomcat, MySQL is running on the same
> machine.Kindly give us your
> expert opinion is it wise to run the three servers
> with the given server
> hardware configuration on the same machine...?
Depends what kind of load and size
than $1500.
Best reagrds,
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consulting: [EMAIL PROTECTED]
Technical: [EMAIL PROTECTED]
Web related: [EMAIL PROTECTE
HELLO,
ANYBODY HAS COMPILED MYSQL - MAX IN HPUX 11.0 ?
THANKS,
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consulting: [EMAIL PROTECTED]
Technical: [EMAIL
ion `int com_edit(String *, char *)':
mysql.cc:1892: implicit declaration of function `int system(...)'
Any idea ?
Thanks,
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [
Thanks Peter,
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consulting: [EMAIL PROTECTED]
Technical: [EMAIL PROTECTED]
Web related: [EMAIL PROTECTED]
General
What I mean is to get the internal id of every existing row in a table.
Thanks.
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consulting: [EMAIL PROTECTED
Hi list members,
How to get the unique row id for a row in a table ?
Thanks.
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consulting: [EMAIL PROTECTED
Hi Mike.
Check if you data directory is in: /usr/local/mysql/var as specified in your
startup script, or in: /var/lib/mysql
On redhat using the binary distribution, the data dir is in /var/lib/mysql
--
On December 19, 2001 06:19 pm, Mike Blain wrote:
> I keep trying
16 character before the changes, why am I getting this
32 characters limitation after the changes?
Any ideas?
Thanks,
Gustavo
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
characters. Does,
anyone have any work around for that?
Any ideas will be greatly apreciated.
Best Regards,
Gustavo
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
ith a clustering solution...
Thanks,
Gustavo
On Thu, 2001-12-06 at 23:34, Jeremy Zawodny wrote:
> On Thu, Dec 06, 2001 at 07:42:29PM -0800, Gustavo A. Baratto wrote:
> > Hi Guys,
> >
> > The documentation in http://www.mysql.com/doc/R/e/Replication.html ,
> > is not clear en
I'm not sure,
But I don't think symbolic links are allowed on win2k...
Take a look into this...
Regards,
gustavo
On Fri, 2001-12-07 at 12:04, A. Clausen wrote:
> I have been using replication for several months between to Win2k machines.
> Last week I upgraded
give me a web-site or something else I can read,
it would be really appreciated.
Thanks
Gustavo
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
If you have PHP installed, try phpMyAdmin. It's a very good tool, easy use
and installing.
Regards.
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consu
Thanks for your answer, but I need to know the names of the users currently
logged in the database.
Regards,
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED
Dear members,
How to know how many sessions are currently open against a MySQL database ?
Thanks.
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consulting
>
> Dear members,
>
> How to know how many connections are established using the MySQL ODBC
driver ?
>
> Thanks.
>
> Ing. Gustavo A. Edelstein
> Tech. Mgr.
> Equiplus Argentina S.A.
> __
> Visit us On Line at www.equiplus
hanks
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consulting: [EMAIL PROTECTED]
Technical: [EMAIL PROTECTED]
Web related: [EMAIL PROTECTED]
General: [EMAIL
ds defined column size.
The value has 4 chars long and the database field is 10 chars long. In this
table I have a primary key defined and a timestamp field.
Any help ?
Thanks to all of you.
GUSTAVO.
-
Before posting, please chec
eclaration of function `int getsockname(...)'
make[1]: *** [mysqld.o] Error 1
make[1]: Leaving directory `/usr/local/mysql-3.22.32/sql'
make: *** [all-recursive] Error 1
Thanks &best regards,
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
_
Hi list members,
After
./configure --prefix=/usr/local/mysql
I do a make and when change dir to mit-pthreads, I got following err msg:
Making all in mit-pthreads
Make: Must be a separator on rules line 26. Stop.
Thanks for any help.
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina
Hi list members,
After
./configure --prefix=/usr/local/mysql
I do a make and when change dir to mit-pthreads, I got following err msg:
Making all in mit-pthreads
Make: Must be a separator on rules line 26. Stop.
Thanks for any help.
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina
your system did not crashed. What special
customization did you do when building mysql?
Really enjoy to know!
On Sat, Jul 14, 2001 at 03:22:46PM +0300, Sinisa Milivojevic wrote:
>Gustavo Vieira Gonçalves Coelho Rios writes:
>> >Description:
>> MySQL Daemon crashes wh
feedback (Not only developer but the user comunity
too)
>Submitter-Id:
>Originator:Gustavo Vieira Gonçalves Coelho Rios
>Organization:
Ifour Sistemas.
>MySQL support: none
>Synopsis: MySQL Crash with "show logs" queries
>Severity: critical
>
- Original Message -
From: Gustavo Santos
To: [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 12:43 PM
Subject: Installing on FreeBSD 3-4
Hello
I´m trying to install MySQL binary in a FreeBSD 3-4. I´ve gone thru all the
installation steps but I still get the following message
explaining how to set it up I´d be very grateful.
Gustavo Santos
Marlin Internet
Hi folks!
I would like to know if it's possible that some have read access to MySQL cvs
repository? If yes, how may i have read acces (like an anonymous account).
Other question:
Which CVS TAGS MySQL uses for production environment? STABLE , CURRENT? (FreeBSD
Project uses STABLE for productio
ke. Security is
>not made by a system or by mysql, security is made or broken by humans.
>
> regards,
>
> rene
>
> On Mon, 30 Apr 2001 07:28:44 -0300
> Gustavo Vieira Gonçalves Coelho Rios <[EMAIL PROTECTED]> wrote:
>
> > Hi folks!
> >
> > Si
Yes, i use the same directory for data and log files (/var/db/mysql).
And, as far as i know, there is mysqld options that allows me to specify a directory
to hold all logs.
How can this be accomplished?
Thanks for your support and time.
-- Original Message -
greatly on the tech support
> (patches) of the manufacturer. Given your expertise and knowledge you might
> be able to protect yourself, but not everybody is (as a matter of fact even
> Gustavo said he isn't). In addition, to make things worse, today is Sunday,
> and given the usua
ce (My environment):
shell> mysql -h 192.168.1.11 -u awp -p root etosha-bin.001
>Fix:
I lack the required level of expertise to fix it, sorry!
>Submitter-Id:
>Originator:Gustavo Rios
>Organization: Ifour Sistemas
>MySQL support: [none]
>Synopsis:
have anybody already faced a mysql crashed connection after a 'show
logs' query?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reques
. Is there anything that can be done to
circumvent this problem?
Thank you,
Gustavo.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Dear gentleman,
I am running mysql over FreeBSD and when i issue a "show logs" query to
mysql, my connection is droped (cause the process is killed).
Take a closer look:
mysql> show logs;
ERROR 2013: Lost connection to MySQL server during query
mysql> select user();
ERROR 2006: MySQL server has
Benjamin Pflugmann wrote:
> > Or, should I drop Linux and go with Windows CE, or some other RTOS?
>
> Well, I am biased there, but I would really avoid Windows. ;-)
>
> Other RTOS are probably a good idea, as someone else already said.
>
> > Or, should I stop being a software developing and be
char*reg[] = {
"Gustavo",
"Vieira",
"Goncalves",
"Coelho", "Rios", NULL};
i = 10;
(void) t(&i);
c(reg);
return
78 matches
Mail list logo
