Hi to all,
I try to call a stored procedure using mysql_real_query and with the
CLIENT_MULTI_STATEMENTS flag on mysql_real connect() function.
When i try the statement call sp1(@myparam); the error can't return the
results in actual context is occur.
Please, if is some one which have experience
Hi again folks,
The problem is solved.Was entirely my fault because i didn't check the version
of mysqlclient library.
-Original Message-
From: Gelu Gogancea
Sent: Monday, 21 August, 2006 12:47 PM
To: mysql@lists.mysql.com
Subject: How to call stored procedures using C API
Hi to all
Hi,
It's very important to have instaled the library client related to the MySQL
server version.For example, you cannot use libmysql.dll version 3.X or 4.x to
use stored procedure from version 5.X of MySQL RDBMS.
Regards,
_
G.NET SOFTWARE
Hi ,
IMHO the corect way is to check if IS NULL
SELECT
fieldOne,
fieldTwo,
IF(fieldThree IS NULL,fieldFour,fieldThree) as Company
FROM table;
Depening on the column definition(if is byte,multi-byte...etc.), LENGTH()
function can have various behaviour and is not quite sure that you will get
address :
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-Original Message-
From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 03 August, 2005 9:58 AM
To: 'mysql@lists.mysql.com '
Subject: Re: Question about BLOB
Gelu Gogancea wrote:
Hi,
Is not the first time when i read
http://www.gonetsoftware.com
Permanent e-mail address :
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Monday, 01 August, 2005 8:41 PM
To: Gelu Gogancea; MySQL mailing list
Subject: RE: Question about BLOB
[snip]
I have a table
Hi,
I have a table with a MEDIUMBLOB field and i wish to store a picture(.BMP)
which the size is 10622 bytes.But when i look into the table i see only 9582
bytes.
Please, i wish to know for what reason on the table are few bytes than original.
I use MySQL 5.0 - Fedora Core 3
Thanks,
IMHO
You have problems on the DNS server.
_
G.NET SOFTWARE COMPANY
SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER
Permanent e-mail address :
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-Original Message-
From: Heo, Jungsu [mailto:[EMAIL
Title: Bug on MYSQL-5.0 in statement OPTIMIZE TABLE
Hi,
TABLE CREATE DESCRIPTION :
CREATE TABLE T1(IDAP INT(16),TVAL INT(2),CH_VAL_SEC INT(16),INDEX(IDAP),INDEX(TVAL),INDEX(CH_VAL_SEC));
RUNNING CONDITIONS:
-use persistent connection.
RUNNING SEQUENCE:
1-Open 1-st connection.
Hi,
You can only bind to a specific network interface IP address which is mounted and Up
from your server.
ie:
./mysqld --bind-address=YOUR_IP_ADDRESS
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER
Hi,
You can use TO_DAYS() and FROM_DAYS() functions for what you need.
All details about Time and Date functions :
http://www.mysql.com/doc/en/Date_and_time_functions.html
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
SYSTEM INTEGRATOR - AUTOMATION
even if they have no entries( ie to show
the dept and 0 as it's result)?
Cheers.
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]
Sent: 28 January 2004 15:08
To: Paul Hayer; [EMAIL PROTECTED]
Subject: RE: CALCULATING DATES
Hi,
You can use TO_DAYS() and FROM_DAYS() functions
Title: Test!!!Please ignore this message
Hi fellows,
...just a test.Please ignore this message.
_
G.NET SOFTWARE COMPANY
SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER
Permanent e-mail address :
[EMAIL PROTECTED]
[EMAIL
Hi,
I wish to make a pull for mysql-5.0 from http://mysql.bkbits.net but always is
nothing to pull.
I try with :
bk pull http://mysql.bkbits.net/mysql-5.0
I wonder, what happens ?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail
Hi,
You can not use native MYSQL C API to handle Oracle DataBase.Work very well
(mixed with MYSQL C API) the ORACLE C API which is named OCI(Oracle Call
Interface).
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
usually, to release memory is used mysql_free_result().
You do that ?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
Hi,
On the CREATE TABLE statement some mistake in syntax is not reported.
STATEMENT:
CUT-
---
CREATE TABLE prodconfirm(IDPC INT(16) AUTO_INCREMENT
Hi,
First you must add grants to the user which you want to connect to the MySQL
server.In documentation (4.3.5 Adding New Users to MySQL) you will find how
you can achieved this.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail
Hi,
...the sysntax it's not quite normal.You should try :
select @a:=max(id)+1 from t1;
To test if the variable @a is loaded with what you expect, you can do:
select @a;
...if the result is NULL something is working wrong.
Anyhow, i wonder how it works on the master ?
Regards,
Gelu
Hi,
This is usually happened becuase you don't have configured a DNS server in
your network.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
-
Message -
From: Pedro Alvarez-Tabío [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Gelu Gogancea [EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 4:34 PM
Subject: Re: mysql_query to return immediately when connection lost
Hi,
In this case I do have a DNS server. Any other hint please? I strongly
Hi,
- Original Message -
From: Daniel Kasak [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 12:35 AM
Subject: Re: AW: EMS MySQL Manager for Linux 1.15 released!
Rusch (ext) Reiner wrote:
Hi,
is anyone interested in commercial use/spam of this list?
If not, I
Hi Bruce,
- Original Message -
From: Bruce Feist [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Sunday, March 16, 2003 7:03 AM
Subject: Re: Looking for a bona fide distributed database that is open
source
Gelu Gogancea wrote:
You make confusion between terms, CONCEPTS
Hi Peter,
- Original Message -
From: Peter Stoehr [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Gelu Gogancea [EMAIL PROTECTED]
Sent: Monday, March 17, 2003 3:56 PM
Subject: RE: mySQL activity logging on a dual prozessor maschine
Hi Gelu,
thanks for your message. But I'm not confused
-
From: Peter Stoehr [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Gelu Gogancea [EMAIL PROTECTED]
Sent: Monday, March 17, 2003 6:28 PM
Subject: RE: mySQL activity logging on a dual prozessor maschine
Hi again,
I don't think, that there are longer or shorter processes. Since I
installed
]
[EMAIL PROTECTED]
- Original Message -
From: Bruce Feist [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Saturday, March 15, 2003 3:26 AM
Subject: Re: Looking for a bona fide distributed database that is open
source
Gelu Gogancea wrote:
It's quite right, some SQL
Subject: Re: Looking for a bona fide distributed database that is open
source
No, it is not distributed.
Bruce Feist wrote:
Gelu Gogancea wrote:
To anyone that *didn't see the forest because of the trees*.
You already find it.
Is MySQL really distributed, or just client-server? I've
)
Paul DuBois ([EMAIL PROTECTED]) wrote:
At 9:55 -0500 3/14/03, Bruce Feist wrote:
Gelu Gogancea wrote:
To anyone that *didn't see the forest because of the trees*.
You already find it.
Is MySQL really distributed, or just client-server? I've seen no
indication of distributed
Hi,
You can try to use IF(),CASE() function in the SQL statement.
Eg.
select USERID,IF(DAY='2003-01-02',COUNT(*),0) as
2003-01-02,IF(DAY='2003-01-03',COUNT(*),0) as
2003-01-03...how_many_days_you_wishfrom YOUR_TABLES where
YOUR_CONDITIONS GROUP BY DAY;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: DANIEL GADDIS [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, March 14, 2003 11:05 PM
Subject
Hi,
Maybe it's funny...but this is MySQL date/time format which is used in log
files.On my MySQL servers date/time are formated in the same way.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hi,
I think you have at least two ways:
1.To put the corect path to the sock file, in my.cnf configuration file.
2.To find where MySQL daemon create this file and add the argument -S to
the mysql client application.
Regards,
Gelu
_
G.NET
To anyone that *didn't see the forest because of the trees*.
You already find it.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original
the return value
End Function
I myselve created an dll (in vb) which encapsulates all the stuff to
connect
to
the database, use recordsets, (as close as possible to the ADO object
model: so with connection, recordset - objects,
bookmarks, fields, ...)
Hope this helps.
From: Gelu
Hi,
- Original Message -
From: Derick Smith [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 10:33 PM
Subject: Re: HELP mysql_server_init embedded in a DLL?
I am posting this again, in hope that I will get a response.
I tried doing the
Hi Benjamin,
I hope you have a nice day.
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Jason Maskell [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, February 17, 2003 1:14 PM
Subject: Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.
On Mon
Hi,
Already work (very well) on Win98.
You can download it from http://www.mysql.com/downloads/mysql-4.0.html
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL
Hi,
- Original Message -
From: Guddack Thorsten ICM MP SCM GO 21 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003 3:44 PM
Subject: Replication Problems/Questions
Hi List
I'm using 2 WinNT-Servers, Sp6 with mysql 4.0.5. max-nt.
I ve setup a replication between
Hi
- Original Message -
From: W. Enserink [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003 4:34 PM
Subject: copying a row
Hi all,
Im in need of some tps.
I want to copy a row in a table to a new row in the same table except for
the unique ID. Is there some
Hi,
select * from table where condition LIMIT HOW_MANY_RESULT_YOU_WISH;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message
Hi,
For the moment you can't.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Isaac Anietye Inyang [EMAIL
Hi,
Something very strange was happened on my production server where i have
mounted MySQL ver. 4.1 (latest pull on Jan 25, 12:00 GMT)
Unfortunatelly i'm not able(a...i didn't start with --log) to reproduce
the exact sequence of queries which was send to the server.
MySQL was down on this
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Sergei Golubchik [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED
]
[EMAIL PROTECTED]
- Original Message -
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, January 25, 2003 6:20 PM
Subject: Re: BUG:ALTER TABLE (MySQL 4.1)
Gelu Gogancea writes:
Hi Sergei,
I
Hi,
If you start the mysql daemon with option --log then you will find the
file with all querys which was executed, in the data directory.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
my abilities / available toolset to do this, and it would allow
me to develop far more specific / personalised 'synchronisation'
processes.
Anyone have any thoughts on how this could be achieved?
Regards and best wishes,
Murray Wells
-Original Message-
From: Gelu Gogancea [mailto
Hi,
With MySQL you can use variables which are represented using @ character.
You can not use this variable like in Oracle or DB2 because ,for the moment,
MySQL didn't have necessary tools which can handle like bind, this
variables.
I guess you can make some improvisations to suit at your needs.
Hi,
I guess is as a bug in ALTER TABLE with MySQL 4.1,compiled from BK TREE on
2003-01-22.
Table schema :
CREATE TABLE cmdlivrare(IDCMD INT(9) NOT NULL PRIMARY KEY DEFAULT 2000,mUser
CHAR(16),Dep CHAR(4),IDCLI INT(16),FactExt CHAR(20),LivrFinish
SMALLINT(1),DataIntro DATE,DataIese
PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 24, 2003 8:49 PM
Subject: BUG:ALTER TABLE (MySQL 4.1)
Hi,
I guess is as a bug in ALTER TABLE
Hi,
IMHO:
I think if you use autoheader it's possible to fix that according with your
glibc/compiler version.Also (...from what i remember what i saw in the
source code) is used macros for checking GLIBC2 style.
Regards,
Gelu
_
G.NET SOFTWARE
Hi,
IMHO:
I think the better way is to use replication between your local MySQL server
and MySQL from the Web Server.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hi,
Indeed...this happend in both main version of MySQL (ver. 3.x and 4.0.x)
However ,if you use :
select * from test_table where NAME='2';
you will have the correct result.
Regards,
Gelu
___
G.NET SOFTWARE COMPANY
Permanent e-mail address :
Hi,
I think is better to export your each table from Access to a .txt formatted
file...fields separated by ',' and end_of_line by ';'.It's better to avoid
Cr or CrLf.
Copy the .txt files into MySQL server host in a directory where MySQL have
reading rights.
And after this you can import in your
Hi,
- Original Message -
From: Hoffman, Geoffrey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 17, 2003 7:01 PM
Subject: Whats the best way to manage 'generic two-way relationships'?
I couldn't think of a better term for what I want to do...
I am building a CMS for
My dear friend,
I suppose that you already done:
./configure --prefix=PATH_OF_THE_MYSQL_APPLICATION
After compilation you must do:
make install
and after this :
cd /PATH_OF_THE_MYSQL_APPLICATION/bin
and...
./mysql_install_db.
Regards,
Gelu
_
Hi,
If i understand well you wish to concatenate different strings.
Are many options but the most handy solution is if you use sprintf.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hi Benjamin,
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, January 16, 2003 4:23 PM
Subject: Re: g++ and mySQL]
Hi.
On Thu 2003-01-16 at 13:54:14 +0200, [EMAIL PROTECTED
Hi,
I think is not a bug.The result is normal becuase function TO_DAYS() return
the daynumber and not the date.If you wish to find a date depend on the
number of days you can try(like example):
select FROM_DAYS(TO_DAYS(NOW())-3);
Read the manual about this two functions
Regards,
Gelu
Hi,
Maybe it's a good ideea to increase the value of max_allowed_packet(from
my.cnf configuration file) to 2M.By default is 1MB.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hi,
A very evasive description.
- Original Message -
From: PC Systems [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 15, 2003 8:03 PM
Subject: error report using mysql 3.23.49 max
Dear Sirs.
We are programers in Brasil and we are currently conducting tests with
MySQL
Hi,
If you use NULL on the USER parameter that means you wish to login with the
current user which is already logged under Linux.I suppose that you don't
have any user set to connect at MySQL server.
I think it's better to try with root instead of NULL.
Regards,
Gelu
Hi,
You can use INSERT...SELECT.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Michael Knauf/Niles [EMAIL
Hi,
In fact ...you can choice the RDBMS depend on what you wish to do.
If you are able to design the database for using without store
procedures,viewers,triggers...you can choose MySQL. It's stable enough and
the better part is that have very good performance.
Regards,
Gelu
Hi,
IMHO:
I think you should try :
1)
SET @a:=0;
LOCK TABLE your_table_name WRITE;
INSERT what_client_must_to_insert
SELECT @a:=MAX(ID) FROM tableetc
UNLOCK TABLE;
After unlock the table you can find the value of variable @a by doing:
SELECT @a;
2)
INSERT
Hi,
SELECT LEFT(YOUR_COLUMN,2) FROM YOUR_TABLE.for position
SELECT RIGHT(YOUR_COLUMN,2) FROM YOUR_TABLE for type
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
]
- Original Message -
From: Johannes Ullrich [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 10, 2003 4:28 AM
Subject: Re: Re[4]: mysql 4.0.8- crash on TCP connection
On Thu, 9 Jan 2003 22:56:04 +0200
Gelu Gogancea [EMAIL PROTECTED] wrote:
All this is very interesting, BUT i have
with this kind of disputation .Personally, i think
THIS NOT A PURPOSE OF MYSQL AB.
Anyhow,i think this list belong to all MYSQL users/software developers and
in this situation MYSQL AB didn't have ANY FAULT.
With all my consideration,
Gelu Gogancea
Software Developer - System Integrator
Hi,
What OS you use ?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Andrew Sitnikov [EMAIL PROTECTED]
To:
]
[EMAIL PROTECTED]
- Original Message -
From: Andrew Sitnikov [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 6:05 PM
Subject: Re[4]: mysql 4.0.8- crash on TCP connection
Hello Gelu,
GG Hi Andrew,
GG I
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Andrew Sitnikov [EMAIL PROTECTED]
To: Christopher E. Brown [EMAIL PROTECTED]
Cc: Gelu Gogancea
Hi,
Start mysql daemon with options --skip-name-resolve
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Dmitry V.
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Andrew Sitnikov [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]
Cc: Christopher E. Brown
PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Christopher E. Brown [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]
Cc: Andrew Sitnikov [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 7:48 PM
Subject: Re: Re[2
E. Brown [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]
Cc: Andrew Sitnikov [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 9:38 PM
Subject: Re: Re[2]: mysql 4.0.8- crash on TCP connection
-
Before
Peace to all,
This is not the right place for this kind of discussions.
Please STOP.
Also i have a suggestion for the administrator of this list:
-to forbidden all e-mail which have in subject or body, logo
/slogan/catchword which can be considered RINGLEADER.
Regards,
Gelu
Hi,
I'm sure that all the people from this list RESPECT in what you believe or
in values which are considered by you to be inviolable/holy.
I'M NOT JEWISH but i'm sure if you will see, like logo/slogan , something
like ...
I WILL LOVE YOU FOREVER WITH MY HEART AND MY BLOOD, BEN GURION.
... i'm
Hi,
You right.RH8 have a problem with glibc.All people from the list recommende
to make a downgrade to version 2.x or download binary distribution from
MySQL site which is compiled with the right version of glibc.
Are and other ways to solve your problems but i think you need to a stable
solution.
Hi,
Strange...you should be able to find the number of fields from resultset
with mysql_num_fields.You use MYSQL_RES like parameter for
mysql_fetch_fields ?
How do you use mysql_fetch_fields?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent
Hi,
This is an aoutomation error and is possible to be raised because you use
CreateObject instead of using object directly.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
? objConn.open or rs.open ?
Freddie
-Ursprüngliche Nachricht-
Von: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Gesendet: Sonntag, 29. Dezember 2002 12:02
An: [EMAIL PROTECTED]; Michael She
Cc: [EMAIL PROTECTED]
Betreff: Re: ADO Error '800a01fb'
Hi,
This is an aoutomation error and is possible
Hi,
I think you can try to use TO_DAYS() function;
eg:
select TO_DAYS('2002-12-28')-TO_DAYS(NOW());
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Hi,
I think you can try to use TO_DAYS() function;
eg:
select TO_DAYS('2002-12-28')-TO_DAYS(NOW());
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Hi,
You can use REPLACE...SELECT
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Jeff Snoxell [EMAIL PROTECTED]
Hi,
If you have more than one user connected to the database which handled the
same tables, you need to use LOCK/UNLOCK tables.
MySQL daemon don't lock tables or records if you don't require this.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
-
From: Michael T. Babcock [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Jeff Snoxell [EMAIL PROTECTED]
Sent: Thursday, December 12, 2002 8:44 PM
Subject: Re: More locking issues
Gelu Gogancea wrote:
If you have more than one user connected to the database which
Hi,
Old story.You have many options.Perhaps the most convenient solutions
are to start MySQL daemon with --skip-name-resolve(documentation - 4.1
Configuring MySQL) or you can add the client IP address and alias in the
/etc/host.
Other options are:
-download MySQL 3.23.53a binary distribution .
Hi,
Select * from Blah where stuff=true limit 10;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Tom Place
Hi,
If the lenght of what wish to retrieve is fixed to 2 length,you can try
something like this:
select MID(YOUR_FIELD,3,IF(RIGHT(LPAD(YOUR_FIELD,4,','),1)=',',1,2)) from
YOUR_TABLE;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail
Hi,
It's possible if you use DATE_FORMAT().
E.g.
SELECT DATE_FORMAT('1997-11-15', '%d-%b-%Y')
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
-
Hi,
You can use :
INSERT INTO SELECT * FROM YOUR_TABLE
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: [EMAIL
Hi,
It's possible that in mysql.user table to exist the old IP address of your
machine.You should check the field Host using:
use mysql;
select Host,User from user where User='YOUR_USER_NAME';
If in the Host field you see the '%' character that means your problem is
not from MySQL... else you
PROTECTED]
- Original Message -
From: Chris Walcott [EMAIL PROTECTED]
To: 'Gelu Gogancea' [EMAIL PROTECTED]; Chris Walcott
[EMAIL PROTECTED]; Mysql-L (E-mail) [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 9:52 PM
Subject: RE: my host IP changed
right now the host field has 2 entries
Hi,
You can make your own authentification system.A table which can have a
binary char/varchar field for encrypted password(effect similar like
password from mysql.user) and another char for ASCII password.
If you not use grant statement for adding new user, you can use the MySQL
authentification
Hi,
Maybe on IRC(UNDERNET) is possible to have chance to find MySQL tutorials in
spanish.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
-
Hi,
If you really wish to kill the mysql daemon in this way :
You should try :
ps -ef |grep mysql
...show all the mysqld processes and after this must enumarate all pid of
processes in a single kill command.
E.g.
kill -9 1024 1056 ...(processes which are open).
But it's more health if you can stop
-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Jocelyn Fournier [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Saturday, November 09, 2002 2:12 PM
Subject: Re
PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Jocelyn Fournier [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Saturday, November 09, 2002 2:27 PM
Subject: Re: mysqld refuse to die
]
[EMAIL PROTECTED]
- Original Message -
From: Jack Chen [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, November 09, 2002 5:45 PM
Subject: Re: mysqld refuse to die
Thanks you all for your nice suggestions. The thing is, for some reason, I
could
Hi,
Take a look in mysql.h.
#ifdef USE_OLD_FUNCTIONS
MYSQL * STDCALL mysql_connect(MYSQL *mysql, const char *host,
const char *user, const char *passwd);
int STDCALL mysql_create_db(MYSQL *mysql, const char *DB);
int STDCALL mysql_drop_db(MYSQL *mysql, const char *DB);
#define
Hi,
select last_insert_id();
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Tim Johnson [EMAIL PROTECTED]
To:
1 - 100 of 238 matches
Mail list logo