Hi,
Does anyone know which version of MySQL first exposed an API for
developers? Is there a changelog somewhere that might have this info? I'm
interested in seeing how the API has evolved over time.
TIA,
Vikram
--
Luke: "I don't believe it!"
Yoda: "That, is why you fail."
--Star
http://since.vip.sina.com/smscai.html";>http://since.vip.sina.com/pic2/smscailogo.gif"; width=730 height=70 border=0
alt="射雕英雄传彩信">
http://since.vip.sina.com/shoujijiaoyou.html";>http://since.vip.sina.com/pic2/yzjiaoyou.gif"; width=730 height=59 border=0
alt="亚洲真情交友中心">
http://www.cctvt.com/[E
How are you dumping the database? It doesn't seem like you should have
problems going either direction, especially to a case-insensitive
filesystem.
Copying databases with something like
$ mysqldump | mysql -h
works for me, even if it is fairly slow.
-jeff
(formerly kilpatjr_at_lupus.omrf.ou
Hai, am having the problem in creating CD of my project(Online Tutorial).While
creating the CD only am having the problem. Actually am working in SSH(linux),right.
I have to make a dump of my source code and mysql ..to copy (from server to C:\ of my
PC with windows not case- sensitive, right).
Hai, am having the problem in creating CD of my project(Online Tutorial).While
creating the CD only am having the problem. Actually am working in SSH(linux),right.
I have to make a dump of my source code and mysql ..to copy (from server to C:\ of my
PC with windows not case- sensitive, right).
Is the inability for 4.0.12 (and previous) SRC RPMs to build on RedHat 8 the
fault of something in MySQL or RedHat? Is there any plans to resolve this any
time soon?
Thanks!
-
This mail sent through IMP: http://horde.org/imp/
-
Since InnoDB tables don't support fulltext searching yet, what is the
recommended way to work around the problem?
Thank you,
Wynne Crisman
patternWare Systems Inc.
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 11:10 AM
To: [EMAIL PROTECT
sql/sql_update.cc:600
-
/* ok to be on stack as this is not referenced outside of this func */
Field_string offset(table->file->ref_length, 0, "offset",
table, 1, &my_charset_bin);
I just ran your query (create and both inserts), and it worked like a charm
on a Win32 MySQL 3.23.52.
Just out of curiousity, why are putting the \r in?
- Original Message -
From: "Tab Alleman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 20, 2003 10:51 AM
Subject: Im
I recently had a bad experience with a "feature" of
InnoDb. Whenever the server crashes, on the next
startup InnoDb detects that the server ended
abnormally and performs a
repair/rollback/magic/whatever before allowing you to
connect to the server.
Unfortunately, I had to create an index on a 45
m
Linux Redhat 7.3
MySQL 4.0.9-gamma
I tried to import a 900M file with mysqlimport command. Everything works fine.
All the data has been insert into the DB.
However, all the memory has been used up. Before the mysqlimport, I have 800M
free memory, after that, 13M free memory left.
Is there any w
Lol.. beat me by 2 minutes.. Can i fed-x that cookie ?
-Original Message-
From: Jon Wagoner [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 11:54 AM
To: Andrew Wilson; [EMAIL PROTECTED]
Subject: RE: "where drink is not equal to pepsi
Select * from Tablename where drinks != 'pepsi
Select * from Tablename where drinks != 'pepsi';
Got any milk with that cookie?
-Original Message-
From: Andrew Wilson [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 6:49 PM
To: '[EMAIL PROTECTED]'
Subject: "where drink is not equal to pepsi
Hi guys,
Hopefully have an easy q
> Hi guys,
> Hopefully have an easy question for you guys.
> Whats wrong with this query
>
>
> Select * from Tablename where drinks is not = 'pepsi';
>
> Driving me batty..
select * from CaseSensitiveTablename where drink != 'pepsi';
or
select * from CaseSensitiveTablename where drink not lik
Lol,
I keep the cookie.
I was just looking for the != syntax..
-Original Message-
From: Andrew Wilson
Sent: Friday, March 21, 2003 11:49 AM
To: '[EMAIL PROTECTED]'
Subject: "where drink is not equal to pepsi
Hi guys,
Hopefully have an easy question for you guys.
Whats wrong with th
Hi guys,
Hopefully have an easy question for you guys.
Whats wrong with this query
Select * from Tablename where drinks is not = 'pepsi';
Driving me batty..
A cookie for the right answer..
t 8920 8877
f 8920 8866
e [EMAIL PROTECTED]
w http://www.netwaynetworks.com.au
--
On Thu 2003-03-20 at 14:01:52 -0500, [EMAIL PROTECTED] wrote:
> I have a table with a column defined as the following.
>
> hash CHAR(16) BINARY NOT NULL
>
> Most data inserts fine. However, if data has trailing white space
> (ASCII character 32), it seems to be getting truncated by MySQL during
I'm not sure if a LEFT JOIN is the proper way of doing
the following to join two tables to one table (table2
and table3 to columns in table1).
Currently, I have no problems joining table2 to table1
through the following SELECT statement:
SELECT DISTINCT
table1.column1,
table2.column1,
table2.colu
Sergei Golubchik wrote:
Though your changes looked innocent - that is they most probably could
do no harm - I failed to understand when they'll do any good.
You replaced a set of checks for buffer overflow by some other set of
checks, which looked equivalent to the old one.
Hi,
it turns out that m
I'm trying to install MySQL-4.0.12 on a glibc-2.1.3-based Linux system
which is currently quite happily running MySQL-3.23.56. MySQL-4.0.12
was configured as follows:
./configure --prefix=/opt/mysql --enable-thread-safe-client \
--enable-assembler --with-gnu-ld --with-mysqld-user=mysq
Hi, I just got involved into a project that uses MySQL. My team leader told
me that most likely we have to change the file inside the source code of
MySQL in order to use GSS API.
However, I am totally new to this area. I am wondering if there is any
resource that I can find on the internet or
Title: µL¼ÐÃD¤å¥ó
mysql
-
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 unsub
This should work, but I would consider using the 4.0.12 instead of the
alpha release.
> -Original Message-
> From: dreq jkj [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 20, 2003 11:02 AM
> To: [EMAIL PROTECTED]
> Subject: Using two databases in a query?
>
>
> Is it possible to use
I'm trying to get going with InnoDB.
As for now I created several tables which relate to each other with some
foreign key restrictions.
mysqldump --all --opt writes 6++ MB stuff in a textfile that mysqld
won't accept without SET FOREIGN_KEY_CHECKS=0;
After SET FOREIGN_KEY_CHECKS=1; is my
You can use other ways to protect your images from linking by others. Like
with Apache and htaccess..
I don't agree with you on your opinion that it's easier to code. If you
insert a link into your database all you have to do is retrieve it and push
the link to the browser.
B.
At 20:18 20-0
All:
It would be really nice if there were some way (a variable) to make
MySQL totally ignore certain directories in the datadir - for example,
"lost+found", "RCS", and suchlike.
The listed dirs should not show up in SHOW DATABASES and you should not
be able to CREATE a database with a name th
I have been having a similar problem with a backup file from a phpBB forum
errors keeping showing a syntax error which from what you are all suggesting is
the size of the sql, is that correct?
Andrew
>-Original Message-
>From: Stefan Hinz [mailto:[EMAIL PROTECTED]
>Sent: 20 March 2003 19:
It seems that this error occurs only when I try to access mysql tables with many
rows. Just wonder if anyone knows what is the cause and how to prevent it.
Thanks in advance!
Danny
-
Before posting, please check:
http://
Stefan Hinz wrote:
> No really. But you could hit the communications buffer size
> (though that does not seem likely at all with your .sql
> file). Anyway, it can't help to try the following:
>
> C:\mysql\bin>>mysql --max-allowed-packet=32M < \dev_hotel_data.sql
>
> Regards,
Thanks, I'll try th
Tab,
>> Are you running this from a script? Maybe it's just a script
>> timeout which would stop with the following line when it gets the
>> timeout:
> Oops, no sorry for all those who don't know where I left off yesterday
> (tee hee).. This is an import of a .sql file being run from the command
I would like to purpose a change to MyODBC's cursor.c starting around line
441.
/*
@type: myodbc3 internal
@purpose : checks for the float comparison in where clause
*/
static my_bool if_float_field(STMT FAR *stmt, MYSQL_FIELD *field)
{
if (field->type == FIELD_TYPE_FLOAT || field->type
hey all.. new to the list.
Just my 5 cents...
I think it's better to store images in the database, sure you loose a bit
in performance, but it's easier to code.
The way i've done it before is always a separate render.php (or what ever)
that compares the users rights to view that image, get's the
Hi, I got the following question:
Imagine I have a table with 3 colums (column1, column2, column3), which are
of type INT.
I want the data in column3 to be generated automatically from the one in
column1 and column2 when it is inserted
For example a sum, that the data in column3 be the sum of col
I have a table with a column defined as the following.
hash CHAR(16) BINARY NOT NULL
Most data inserts fine. However, if data has trailing white space
(ASCII character 32), it seems to be getting truncated by MySQL during
the insert, such that subsequent queries to find the values fail. Full
e
I assume it is, have not tested it..
If you need to fetch the files from the database your app needs to wait
until it has recieved the data. If you only store name/path info it will
take less time to fetch the data, ship it off to the browser which can
start fetching the images without connecti
It is a mySQL UNION "problem" referenced in a couple of places on the web.
Basically, the topmost query must not select NULL, and must select character
placeholders for the largest possible piece of data that may be present in each
column, and also select zero for number columns. What is unfortun
Stefan Hinz wrote:
>
> Are you running this from a script? Maybe it's just a script
> timeout which would stop with the following line when it gets the
> timeout:
Oops, no sorry for all those who don't know where I left off yesterday
(tee hee).. This is an import of a .sql file being run from th
Tab,
> On Thursday 20 March 2003 18:51, Tab Alleman wrote:
>> Still trying to get all the way through my import batch file.
>>
>> Now I'm getting a syntax error on a certain line of the file, and a
>> subsequent run produced the same exact error on the same exact line, but
>> I can't see anything
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 20 Mar 2003, Michael Edlund wrote:
> Yes, the compilation passed that point now. However, unfortunately it
> got stuck in another place:
> ld: Undefined symbols:
> _rnd
This was caused by a bad merge from 4.0 into 4.1 - it should have been
f
The problem appears to be caused by inadvertently running
mysql_convert_table_format on a database which had a few Berkeley DB
tables. The other databases seem to work well. The comment given in
http://www.mysql.com/doc/en/Upgrading-from-3.23.html about the use of
the script should be more clea
At 21:48 +0500 3/20/03, Vikram Vaswani wrote:
Hi,
The MySQL API is available in a number of languages - PHP, Perl, C, Java,
etc. I was wondering if anyone here had any thoughts on the decision
criteria to be kept in mind when choosing which language to use when
programming with the MySQL API?
A br
>Description:
I upgraded Mysql from 3.23 to 4.0.12, and everything went well. I even
installed MySQL-Max, and the server restarted and apparently was well.
However, when I stopped the daemon with service mysql stop" and then
tried to start it again ("service mysql start"), refuses to sta
On Thu, Mar 20, 2003 at 10:32:07AM -0600, Dan Nelson wrote:
> In the last episode (Mar 20), Fred van Engen said:
> > > See msg 135092 for sample script if you want to see a physical example.
> >
> > Which message is 135092? I'm reading a mailing list, not a newsgroup.
>
> The mailing list softwar
Hi,
On Wed, Mar 19, 2003 at 03:11:38PM -0800, Mike Lemke wrote:
> Hello MySQL Guru's-
> This is regarding UNION support in MySQL 4.0.12.
>
Never used it, but ...
> The query below is attempting to return rows that can
> be easily parsed for the purposes of creating XML.
> The ORDER BY is not
Vikram Vaswani wrote:
>
> Hi,
>
> The MySQL API is available in a number of languages - PHP, Perl, C, Java,
> etc. I was wondering if anyone here had any thoughts on the decision
> criteria to be kept in mind when choosing which language to use when
> programming with the MySQL API?
>
> A brief
On Thursday 20 March 2003 18:51, Tab Alleman wrote:
> Still trying to get all the way through my import batch file.
>
> Now I'm getting a syntax error on a certain line of the file, and a
> subsequent run produced the same exact error on the same exact line, but
> I can't see anything wrong with th
Question: is there any way (short of packet spoofing) to use the `host`
record in the `mysql`.`users` table for Local or Clustered
connections...
Like, I want a user to login with [EMAIL PROTECTED] into my
application, and after determining what server their office data resides
on, I would create
Still trying to get all the way through my import batch file.
Now I'm getting a syntax error on a certain line of the file, and a
subsequent run produced the same exact error on the same exact line, but
I can't see anything wrong with that line.
Here's the line that produces the error:
INSERT
Lai Liu-yuan wrote:
>
> Well, this may be off topic.
>
> In my case, I store tens of thousands of images, gradually growing. All of them are
> quite small, most around 30*30 gray scale. Would it still be faster to store them on
> disk?
>
In most cases yes. We have over 3.5 million images store
Benjamin,
you are right: make distclean did the trick
Best regards,
Thomas
On Thu, 20 Mar 2003, Benjamin Pflugmann wrote:
> On Thu 2003-03-20 at 15:59:29 +0100, [EMAIL PROTECTED] wrote:
> > Hi,
> >
> > I was upgrading from 4.0.10 to 4.0.12 when a strange thing happened. I
> > compiled from sour
In the last episode (Mar 20), Fred van Engen said:
> > See msg 135092 for sample script if you want to see a physical example.
>
> Which message is 135092? I'm reading a mailing list, not a newsgroup.
The mailing list software at mysql.com does number each message, and
even though the archive web
On Thu, Mar 20, 2003 at 05:06:09PM +0100, Benjamin Pflugmann wrote:
> Hi.
>
> On Thu 2003-03-20 at 15:52:25 +0100, [EMAIL PROTECTED] wrote:
> >
> > I use a lot of SET-alike fields in my tables. The fields are used to store
> > properties and such; every bit stands for a specific value. The fields
Hi,
The MySQL API is available in a number of languages - PHP, Perl, C, Java,
etc. I was wondering if anyone here had any thoughts on the decision
criteria to be kept in mind when choosing which language to use when
programming with the MySQL API?
A brief list of these would be very helpful to me
On Thu 2003-03-20 at 15:59:29 +0100, [EMAIL PROTECTED] wrote:
> Hi,
>
> I was upgrading from 4.0.10 to 4.0.12 when a strange thing happened. I
> compiled from source on SuSE-8.0 (gcc version 2.95.3, kernel 2.4.18-4GB)
> and installed and everything was fine. However I noticed that I had
> debuggin
Hi.
On Thu 2003-03-20 at 15:52:25 +0100, [EMAIL PROTECTED] wrote:
>
> I use a lot of SET-alike fields in my tables. The fields are used to store
> properties and such; every bit stands for a specific value. The fields are
> queries like 'where property_field & 1<<4' or 'where property_field & 102
Is it possible to use multiple databases in a query? (Privided that the user
has correct permissions, that is)
I have tried to use mysql as root and make a such query, and got a result.
The result, however, did look very strange.
database ccs_db.ccs_admin:
userID int unsigned
username...
da
>Description:
make test fails on create.
>How-To-Repeat:
make test
output of ./mysql-test-run --local create shown here
-- CUT --
Installing Test Databases
Removing Stale Files
Installing Master Databases
running ../sql/mysqld --no-defaults --bootstrap --s
Hi.
On Thu 2003-03-20 at 08:25:08 +0200, [EMAIL PROTECTED] wrote:
> Hi, I have a question I hope you can help me with.
>
> I try to develop a database in Borlands Delphi or with C++ and Visual Studio
> 6 (Windows 2000). Probably I choose Delphi.
> Now I want to use MySQL as a platform for my prog
On Tuesday 18 March 2003 17:20, Chris Wilson wrote:
> Using mysql 2.23.54a as both master & slave:
>
> ** On master:
>
> mysql> CREATE DATABASE repl_test;
> Query OK, 1 row affected (0.03 sec)
>
> mysql> USE repl_test;
> Database changed
> mysql> CREATE TABLE test (
> -> a INT UNSIGNED AUTO_INC
At 15:14 +0100 3/20/03, Yasen Petrov wrote:
Hello,
when I try
mysql> select * from member;
it shows lots of records and the screen goes up quickly. Thus I can't see
the results very well because of the small screen (only 19" :):):) and I
wonder if there's a way to output the results into a .txt
Hi,
I was upgrading from 4.0.10 to 4.0.12 when a strange thing happened. I
compiled from source on SuSE-8.0 (gcc version 2.95.3, kernel 2.4.18-4GB)
and installed and everything was fine. However I noticed that I had
debugging compiled in.
I went back, took out --with-debug from my configure optio
Hi,
On Thu, Mar 20, 2003 at 06:38:04AM -0800, Mike Lemke wrote:
> The topmost query in a series of queries, each connected by UNION ALL, dictates
> the allocated space for data in each column for the resulting row set! This is
> very bad - and makes the UNION useless.
>
This is as documented in
Hello,
I use a lot of SET-alike fields in my tables. The fields are used to store
properties and such; every bit stands for a specific value. The fields are
queries like 'where property_field & 1<<4' or 'where property_field & 1025'
if you look for more than one property.
Just your average SET be
On Wednesday 19 March 2003 15:19, Thorsten Schmidt wrote:
> how can I remove a foreign key in InnoDB?
> ALTER TABLE DROP (FOREIGN) KEY `key`
> isn't working (and also not specified in documentation)... : (
Currently you should recreate table to remove FOREIGN KEY CONSTRAINTS.
--
For technical
On Saturday 15 March 2003 04:08, vishnu mahendra wrote:
> create table stud(rno integer not null,
> name char(10),
> primary key(rno));
>
> create table mark(rno integer not null references
> stud,
> mark integer);
[skip]
> how is it possible.
> there is no rollno 3 in the stud table,
> then how
On Thursday 20 March 2003 06:19, RamananK at zylog dot co dot in wrote:
> Where can I the difference between MySql versions 3.23.41 and 3.23.32.
Check "Changes in release" sections:
http://www.mysql.com/doc/en/News-3.23.x.html
--
For technical support contracts, goto https://order.mys
On Thursday 20 March 2003 16:14, Yasen Petrov wrote:
> mysql> select * from member;
>
> it shows lots of records and the screen goes up quickly. Thus I can't see
> the results very well because of the small screen (only 19" :):):) and I
> wonder if there's a way to output the results into a .txt f
The topmost query in a series of queries, each connected by UNION ALL, dictates
the allocated space for data in each column for the resulting row set! This is
very bad - and makes the UNION useless.
Is there some database option that will make a UNION behave properly in mySQL?
See msg 135092 for
>But i dont want to get a row which `Mevcut Miktar`=0
>How i can modify my query.
-
SELECT urun.`StokKodu`,
urun.`Isim`,
(SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar))
AS
`Mevcut Miktar`
FROM rootdata.urun AS urun,
se
Hello
You can connect to your remote MySQL server using
SQLyog. Just give in your MySQL details and it will
connect to your remote MySQL server.
Then you can create the SQL script which will bring
your Local MySQL server and remote server in sync with
each other.
Karam
--- Florent Martineau <[EM
Well, this may be off topic.
In my case, I store tens of thousands of images, gradually growing. All of them are
quite small, most around 30*30 gray scale. Would it still be faster to store them on
disk?
On Thu, 20 Mar 2003 13:57:06 +0100
"B. van Ouwerkerk" <[EMAIL PROTECTED]> wrote:
> IMHO it
Yasen,
> why not be like:
mysql>> use samp_db
mysql>> select * from member > output_file.txt
Why not use:
mysql> SELECT * FROM member INTO OUTFILE 'output_file_text';
?
Another way:
mysql> SELECT * FROM member LIMIT 0,10;
And, to see the next 10 members:
mysql> SELECT * FROM member LIMIT 10
Just found story about MySQL in CNN:
http://www.cnn.com/2003/TECH/ptech/03/12/fortune.ff.open.source/index.html
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello,
when I try
mysql> select * from member;
it shows lots of records and the screen goes up quickly. Thus I can't see
the results very well because of the small screen (only 19" :):):) and I
wonder if there's a way to output the results into a .txt file.
why not be like:
mysql> use samp_db
m
IMHO it's better to store a link.
I have seen databases (not MySQL) getting corrupted because the file
inserted was to big.
For the visitor it doesn't really matter whether you put it into the
database or not. A link is less difficult and you don't have to retrieve
pictures from the database so
in the docs on replication features, it states that
In 4.x, we will add a voting algorithm to automatically change master if
something goes wrong with the current master.
We will also introduce 'agent' processes to help do load balancing by
sending select queries to different slaves.
does anybody
Florent,
Jon Frisby's DataDiff:
http://www.mrjoy.com/datadiff.shtml
"mysqldiff is a Perl script front-end to the CPAN module MySQL::Diff which
compares the data structures (i.e. table definitions) of two MySQL
databases"
http://adamspiers.org/computing/mysqldiff/
Best regards,
Heikki Tuuri
Inno
Thanks for sqlfs, very interessant!
know i use SQLyog
but this soft do not have a php client do deal with sql server hosted
behind a web server.
and it do diff only on the structure, not on the data.
Tonu Samuel wrote:
On Fri, 2003-03-14 at 17:19, Florent Martineau wrote:
Hi,
I'm searching for
Hello All,
My name is Tres and I'm an experienced programmer in C/C++ and trying
to learn to program some other languages better: currently Perl and the
Tk extension set for Perl. I'm also new to relational databases. I
have usually gotten frustrated with the complexity of them and writt
I am now having a database storing images of chinese characters for research purpose.
I wrote a program to store and retrieve them. My images are of type ppm. This is how I
designed my table:
mysql> describe poor;
+++--+-+-+---+
| Field | Type
rnd() function in libmysql/password.c is not being replace completely by
my_rnd()
linking fail
Alex Lau
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
On Fri, 2003-03-14 at 17:19, Florent Martineau wrote:
> Hi,
>
> I'm searching for a mysql diff tool to update my database when changing
> structure and so.
> Does anybody outthere knowing such a tool ?
As much I know, there is no such tool exists. I am doing myself some
version control of SQL ta
Thanks for reporting this - it should now be fixed.
Bye,
LenZ
Yes, the compilation passed that point now.
However, unfortunately it got stuck in another place:
--- snip ---
mkdir .libs
g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti
-traditional-cpp -DHAVE_DARWIN_THRE
I had a go with putting a image into MySQL and it did not work.
But what I did do is put the directory and image location
"/image/smile.jpg".
This is very good way to use the index of the db and the speed of the file
structure.
Sorry if this was not what you were looking for but I hope it helps a
I have a MySQL query associated with PHP code and would like to know if there
are any of you interested in working on this project for me?
Andrew
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi!
I have a problem with my MySQL
I need to have some a images related with an item
for example
--
! author ! date of birth an death ! image!
--
How can I define the field for the images? I have read that LONGBLOB
On 20-Mar-2003 Aziz DURMAZ wrote:
>
> this is my query:
>
> SELECT urun.`StokKodu`,
> urun.`Isim`,
> (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar))
> AS
> `Mevcut Miktar`
>
> FROM rootdata.urun AS urun,
> seconddata.depohareket AS depo
>
>
> WHERE urun.`ID` = depo.`U
yes I just looked in the manual and this is really very easy almost as easy as
php.
Andrew
>-Original Message-
>From: Tan Siewling [mailto:[EMAIL PROTECTED]
>Sent: 20 March 2003 08:20
>To: [EMAIL PROTECTED]
>Subject: db connection
>
>
>
>
>Hi,
>I would like to know if I can write a method
this is my query:
SELECT urun.`StokKodu`,
urun.`Isim`,
(SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar)) AS
`Mevcut Miktar`
FROM rootdata.urun AS urun,
seconddata.depohareket AS depo
WHERE urun.`ID` = depo.`UrunID`
AND depo.`Iptal` = 0
AND urun.`HizmetUrunu` = 0
GROUP
Hi,
I would like to know if I can write a method to connect to mysql through C++
using mysql++ such that everytime i want to execute a sql statement, i just
have to call the method and input the sql statement.??
Pls help... thks
__
90 matches
Mail list logo