date_sub(now(), interval 7 day)
-z
-
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
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/2002
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 request this thread, e-mail [EMAIL
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 the list sending you mail
-z
sql mysql
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
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
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
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
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
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
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
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
--- 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 (Field1Idx Like
'Value%' or
Field2Idx Like 'Value%')
Try a UNION query
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
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 on Field1, this field
(Field1) is also the Primary Key. Querying on this
field
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
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
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,
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
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
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
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: [EMAIL PROTECTED]
Sent: Friday, May 14, 2004 9:00 AM
Subject
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,
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)
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:
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
keys, transactions, and row level locking
for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB
which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL technical support from
https://order.mysql.com/
- Original Message -
From: A Z [EMAIL PROTECTED
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
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)
for
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)
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
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
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
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
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
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 =
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
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
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
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
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 [EMAIL PROTECTED],list mysql [EMAIL PROTECTED
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
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
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 (\.$srch.\) .
or
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]
Subject: Re: search
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 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 wrote:
ok guyz i
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 2001 11:14:26 -0700
I use Delphi and am having a similar problem. But here are some things
that
can be done (that I haven't tried).
INSERT
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
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 (CST)
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]
Subject: RE: run-all-tests
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
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
.
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 anyone please point me in the direction of configuring My Sql to
imitate any of the above?
Thanks
AND 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: http
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.
=
=
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
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'?
...
...
=Dwalu Z. Khasu wrote:
[snip]
= =
= Try
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-server2 3306
Are you sure
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:
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's Oracle programmers in
regards
61 matches
Mail list logo