t; datasets instead of passing through the query.
>
>
> On Wed, Feb 9, 2011 at 6:36 AM, Y z wrote:
>
> >
> > I have a windows app that wants to talk to either a) an access database, b)
> > a MS Sql Express database, or c) a MS Sql 2008 database.
> >
> > Can
I have a windows app that wants to talk to either a) an access database, b) a
MS Sql Express database, or c) a MS Sql 2008 database.
Can anyone please point me in the direction of configuring My Sql to imitate
any of the above?
Thanks!
--
MySQL Gene
On Tue, 10 Jul 2007 [EMAIL PROTECTED] wrote:
=>Thanks for your response, Rolando. I know all the DML to create the
=>database is in the mysqldump. I was looking for a command or command
=>options, if there are any, to extract the DML for the database, like what
=>you can do with mysqlbinlog.
=>
Hi Jeremy Cole,
I downloaded the source code about libmygis and compiled it on linux.I tried
to use it ,but I don't know how to use it correctly,especially when i tried to
import from shapefile data and associated files and generate MySQL commands in
an output file .
Can you tell me how to u
On Thu, 14 Dec 2006, Chris Boget wrote:
=>>I tried this out this morning on MySQL 5.
=>> It works. Please try this in MySQL 4 and see.
=>
=>Unless I'm way off, I do not believe your solution will work in 4.x because
=>it doesn't support sub-queries...
=>
4.1 does. See http://dev.mysql.com/doc/re
Dear Fellows,
How to deal with the following error:
regards
mysqld-nt --console
050608 11:12:42 InnoDB: Operating system error number
1453 in a file operation.
InnoDB: See http://www.innodb.com/ibman.html for
installation help.
InnoDB: Error number 1453 means 'Unknown error'.
InnoDB: See als
MySQL 4.0.14 Win98 platform.
what could cause the following error by typing
mysqld --console.
regards
050525 16:50:13 InnoDB: Database was not shut down
normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 1 154545
Hi,
Would this be the best way, if I was to run query to
obtain first 2 records of each category from the
database. The database could contain literally 100s
of 1000s of records.
select t1.field1, t2.field2 as CommonFld from table1
t1, table2 t2 where t1.keyfield = t2.keyfield and
t1.field1 = '
SQL DBA by night)
On Tue, 22 Mar 2005 10:48:53 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Z X C V <[EMAIL PROTECTED]> wrote on 03/21/2005 08:32:24 PM:
Hello,
Are there any good rfcs or other documents that would assist in the
discussion I'm having with our organization'
Hello,
Are there any good rfcs or other documents that would assist in the
discussion I'm having with our organization's Oracle programmers in
regards the following:
Oracle DB -> MySQL
They recommend:
~ col~col ~col~ col'",~col
NOTE::I placed the '" in for a reason.
I am looking for:
"col","col"
Hi,
MySql 4.0.14
How can I do this?
Update Table1, Table2 set Table1.Field1 =
Table2.Field1 + Table1.Field1 where Table1.KeyField =
Table2.KeyField
Tried the above with no success.
Field1, in both tables is of type Text.
regards
_
MySql 4.0.14
I understand that the most effective way of speeding
up SELECT statements is to have column level indexes.
Are there any other level indexes exist? I have been
told that there are but I have no idea, looked through
the manual, could not find anything that speeds up
column level ind
MySql 4.0.14
We tried to convert MyISAM table format to INNODB
format, it took forever to finish the process, someone
intervened and killed the process through Task
Manager.
Now can't run Mysqld-nt, running it with the --console
reports the followings. Your help is appreciated.
Microsoft Window
MySql 4.0.14
We tried to convert MyISAM table format to INNODB
format, it took forever to finish the process, someone
intervened and killed the process through Task
Manager.
Now can't run Mysqld-nt, running it with the --console
reports the followings. Your help is appreciated.
Microsoft Wind
Hi,
MySQL 4.0.14
This may have been queried a lot here.
We get this error and after re-starting the server
(MySQL) it seems to go away for a while.
As per instructions we have changed the max connection
in the My.ini to 500 (max_connections=500).
MySQLAdmin displays connections = 120.
Is th
Hi,
Mysql 4.0.14
In a seconrio, some reocrds are missing from a child
table. If we run this query it returns the missing
records:
select a.field1, b.field2 from table1 a left join
table2 b on (a.field1 = b.field1) where b.field1 is
null
I want to create entries in the child table (table2)
fo
Thanks,
I did think of it but not having the option as this is
linked to executables, which I'm sure have some sorts
of calculation for this field to calculate the next
value.
regards
--- Jigal van Hemert <[EMAIL PROTECTED]> wrote:
> > I want to create entries in the child table
> (table2)
>
MySQL 4.0.14
InnoDB (File size as it stands at present) = 6 GB
We have tried move the data folder from one hard disk
to another still the same problem. We really are in
need of help here. Is there any size limit in InnoDB?
I did ask this before, I did get some reponse thank
you. But due to th
der.php
>
> Order MySQL technical support from
> https://order.mysql.com/
>
>
>
> - Original Message -
> From: "A Z" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Wednesday, November 17, 2004 1:48 AM
> Subject: mysqld-nt
MySQL 4.0.14
Are there any known issues with MySQL (above version)
and NTFS file system with 120 GB of hard-disk and Win
2000 pro.
We are facing a problem of mysqld-nt crashing
intermittently, throwing error numbers 995, 32.
any help is appreciated.
regards
___
MySQL 4.0.14
Need help please with the folowing:
On starting mysqld-nt using
mysqld-nt --console
we the get the follwing output
041115 10:31:59 InnoDB: Database was not shut down
normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: lo
Hi,
MySql 4.0.14
How can I force the following query to use a reference
in table1.
select * from table1 a left join table2 b on (a.field1
= b.field1) order by b.field2 limit 1
both a.field1 and b.field1 have indexes. Explaining
the command indicates that, MySql uses an index
(possible_keys)
On Thu, 14 Oct 2004, Dwalu Z. Khasu wrote:
=>Neither the DOS nor Unix man pages for telnet mention a colon--Why do you
=>think you need one? Let me try again, how about 'telnet web-server 3306'?
=>
Sorry for the typo. For your example, that should've been:
telnet web-se
On Thu, 14 Oct 2004, Steve Grosz wrote:
=>I have tried telnet web-server2:3306
=>
=>Didn't work
=>
Neither the DOS nor Unix man pages for telnet mention a colon--Why do you
think you need one? Let me try again, how about 'telnet web-server 3306'?
...
...
=&
On Thu, 14 Oct 2004, Steve Grosz wrote:
=>If that's the case, its not working, I type a telnet 192.168.x.x:3306
=>and get a "could not open a connection to the host" even though
=>Mysql-nt shows as running on the Win2003 server.
=>
=>Steve
=>
Try 'telnet host port'.
MySQL 4.0.14
In a scenario:
Ref EmailAddr
1[EMAIL PROTECTED]
2[EMAIL PROTECTED]
3[EMAIL PROTECTED]
4[EMAIL PROTECTED]
how can I delete duplicate email entries (records 1,
2) leaving 4.
regards
MySQL 4.0.14
Trying to run a select statement on field (varchar)
containing values (e.g. ':', '/', '\') returns blank
recordset although records exist.
select * from table1 where field1 =
'c:\folder\filename.extension'
Is there any particular rule to follow. I inserted
the same row twice and r
Hi,
Concat() returns Null if any field in the field list
is Null. How can I use it to return a String
regardless, or is there another function to do it?
regards
___ALL-NEW Yahoo! Messenger -
all new f
An existing database table structures has changed, I
want to create the same database with new table
structures. I do not want to lose any data.
How can I do this? do a backup how?
regards
___ALL-NEW
Mysql 4.0.14
2 Tables:
Table1: Indexed on Field1 (primary key), Field2
Table2: Indexed on Field1 (primary key), Field2
(Foreign key from table1)
When I do this
explain select a.*, b.* from table1 a, table2 b, where
a.field1 = b.field2 and a.field2 = 'value'. returns
the result:
Table type
4.0.14
Its rather a general SQL question, I'll ask it as I'm
using MySQL.
An converted table has field of type VarChar(6),
containing alphanumeric chars.
Is it possible to run a query to generate a unique key
so this can be used for new record?
regards
MySQL 4.0.14
regards
--- Rhino <[EMAIL PROTECTED]> wrote: > What version
of MySQL are you running? The answer to
> your question depends
> on the version.
>
> Rhino
>
> - Original Message -
> From: "A Z" <[EMAIL PROTECTED]>
> To: <
Hi,
How can I write this query?
Insert into table1 (field1) select (a.field1) from
table2 a where a.field1 not exists (select c.field1
from table1 c)
regards
Yahoo! Messenger - Communicate instantl
Hi,
Is there a function to fill an integer column in
incremental order (1,2,..,n).
Cannot use Auto_Increment as the table has another
primary key.
regards
Yahoo! Messenger - Communicate instantly..
Hi,
A field of type VarChar() with following syntax:
ABA1.
How to get the Max value. Bearing in mind that value
ABA10 comes before ABA2.
regards
Yahoo! Messenger - Communicate instantly..."Ping"
the following raises error:150. Does this mean we
cannot do this in INNODB format?
create table t1 (a1 integer not null, b1 varchar(36),
primary key (a1), foreign key (b1) references t2(b1)
on delete cascade) TYPE=INNODB
regards
_
Hi,
2 DBs sitting on different machines, any idea of how
to run the query?
Select a.*, b.field1 from computernam.db1.table1 a,
computername.db2.table1 b where a.fieldx = b.fieldx
where computername is host for DB.
regards
__
Hi,
MySQL 4.0.14
Are there any known issues on windows 2000 advance
server?
After installation, on running the WinMySQLAdmin the
green light comes on for a second or two and then
disconnected. We tried running MySQLd-nt on its own,
it simply cannot establish connection.
What could be wrong here?
MySQL 4.0.14
Possible to query for existence of a DB. For example
connect to MySQL and run run a command to check if
Database (Test2) existed.
regards
___
Yahoo! Messenger - Communicate instantly..."P
¦ BTREE
regards
--- Benoit St-Jean <[EMAIL PROTECTED]> wrote: > A
Z wrote:
>
> >Thanks for your replies regarding to my previous
> >query.
> >
> >We have encountered another problem:
> >MySQL 4.0.14, INNODB.
> >A table does have an Index
Thanks for your replies regarding to my previous
query.
We have encountered another problem:
MySQL 4.0.14, INNODB.
A table does have an Index on Field1, this field
(Field1) is also the Primary Key. Querying on this
field takes a long time, running along with Explain
command it displays that it d
gards
--- Harald Fuchs <[EMAIL PROTECTED]> wrote: > In
article
>
<[EMAIL PROTECTED]>,
> A Z <[EMAIL PROTECTED]> writes:
>
> > The problem (very slow) occurs when the query is
> run
> > on combination of these fields:
> > Select * from table1 where
A table (Table1) with the relevant indices (e.g.
Field1Idx, Field2Idx) exists. Running a query like:
Select * from table1 where Field1Idx Like 'Value%'
returns result in expected timing scale, so does the
query:
Select * from table1 where Field2Idx Like 'Value%'
The problem (very slow) occurs wh
I am running Delphi 6 Ent. along with Corelab
technology to access MySQL 4.1.14.
We run into problem of table coruption (error: 127,
145) from time to time using the following SQLs. This
is done in the transaction context. Most of the time
it works fine but it does get into problem. We have
tes
pl.schstartrun > 0)
AS SchStart
FROM
planjobs AS pj
Glenn Holden - Pivotal Z
[EMAIL PROTECTED] / 303 400 0573 / www.pivotalz.com
17328 E Bates Place, Aurora, Colorado 80013-2206 / fax 425 984 0297
--
MySQL General Mailing List
For list archives: h
Hi All;
I have written a small mysql program with c++ in linux. i compile it by
g++ -L/usr/lib/mysql -I/usr/include/mysql -lsqlplus myprogram.cc
it works properly. but when i want to execute it i receive this error:
error while loading shared libraries: libsqlplus.so.1: cannot open shared objec
thnx fo takin the time to reply anyways . :(
toby ..
From: Tonu Samuel <[EMAIL PROTECTED]>
To: toby z <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: converting from foxpro to mysql ???
Date: 28 Nov 2002 11:47:45 +0200
On Wed, 2002-11-27 at 17:05, toby z wro
ok guyz i need some inside info .
plz help me with:
1. there aint no foreign keys in mysql then what can i do about cascading
updates, deletes and all
2. if i ve to conver a db in foxpro to mysql or sql which one should i
preffer and y
3. and while im converting the foxpro db to
thnx gerald
plz tell me how can i run the qoute() function on $srch
i tried to look the function up in mysql doccumentation online but no luck
.
thnx a million
toby ..
From: gerald_clark <[EMAIL PROTECTED]>
To: toby z <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
hay guyz
im havin a weired problem
i ve this search query
$srch_qry = " select ctnt_inf.* from ctnt_inf ".
" where (match (firstName ) against (\"".$srch."\") ".
" or match (lastName ) against (\"".$srch."\") ".
" or match (summary ) against (\"".$srch."\") ".
" or match (body) against
hi guyz
i ve to alter my table n make two fields primary key
(well the combination of the two to be xact)
any idea how to do dis ?
thnx a mill
toby
:S:S:S:S:S:S:S mysql query :S:S:S:S:S:S:S
_
Join the worlds largest
thnx jan
vat im planning to do NOW is
ill store path to the pdf file in the db
as i ve been told the files r gonna take a hell lotta space (n i ve planty
of them)
secondly i ll keep the TEXT of these pdf files in the db for indexing n them
compare search keywordz with these n throw out the mat
issue
I NO THIS IS THE WRONG LIST SORRY FOR THIS Q BUT .. has anyone worked with
this thing n wouldnt mind me mailin him/her plz do lemme no
guyz plz hlp .
thnx a billion
toby
>From: "Sqlcoders.com Programming Dept" <[EMAIL PROTECTED]>
>To: "toby z" <[EMA
thnx rich
but u see the problem iz my clients want their text IN pdf format to be
displayed with all these colors on the page in other words they want
their sites layout to be maintained on the pages showing this pdf text
as they are pretty concerned bout security
so what do i do now
t table1.*,table2.* from
do that?
-z
--
z, [EMAIL PROTECTED] on 09/18/2002
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
On Thu, 18 Jul 2002 16:05:34 +0200, Massimo Petrini wrote:
>Also in may NT machine appear the same error. Which is the problem ?
DBI is a perl module for interfacing with databases
see
http://search.cpan.org/search?module=DBI
-z
sql mysql query
--
z, [EMAIL PROTECTED] on 07/18/2
;or if it will work.
you could try
select someStuff where someOtherDate > date_sub(now(), interval 7 day)
-z
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Sat, 12 Jan 2002 17:06:36 -0600, jerry wrote:
>Hi-
>
>Anyone know what web.mysql.com is doing? It's from a netstat on a
>RH 7.2
>running mysql 3.23.47
>
>myhost.mydomain:4570 web.mysql.com:auth TIME_WAIT
>
>Thanks-
>
>
this is t
Hi~:
I do use a via chipset mother board.
Today I tried the option notail, it really works!!!
Thanks :)
Julian
PS: Do you have any idea about sgi's xfs?
>From: George Eric R Contr AFSPC/CVYZ <[EMAIL PROTECTED]>
>To: Z Julian <[EMAIL PROTECTED]>, [EMAIL PROTECTED
try to copy mysql libraries to /usr/local/lib and /usr/lib
cp -a /usr/local/MySQL/lib/MySQL/* /usr/local/lib
cp -a /usr/local/MySQL/lib/MySQL/* /usr/lib
>From: "YANG" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Ask for Linux+MySQL installation help
>Date: Fri, 2 Nov 2001 13:43:46 +0800
Hi~
I want to use journaled file system on my computer. Can you give me some
advice? Furthermore, could journeled file system improve the performance of
mysql? If yes, which journeled file system is better for mysql?
Thank you~~ :)
Julian
__
Hi~
I have a question. If I do nothing after I use mysql C API to connect to
mysql server, how long the connection will be kept? If there is a time
limit, what will happen if I execute some queries when the time is out?
Will the API function like mysql_query () reconnect to the server and
ex
aybe my program has
already tried its best, and so have we(us? hehe, poor english :).
Any way, thanks for your help.
>From: "Mark Rissmann" <[EMAIL PROTECTED]>
>To: "Z Julian" <[EMAIL PROTECTED]>
>Subject: Re: high speed insertion required
>Date: Thu, 13 Sep
Hi everyone~~
I have a program inserting data into myisam tables continuously by queries
like "insert into table1 select * from table2". I need an insertion speed
about 1,000 entries per second with the average entry length of about 50
bytes. But the actual speed of the insertion is only about
64 matches
Mail list logo