Gleb Paharenko wrote:
Hello.
I have mysql-server 3.23.49-8.9 in a debian woody,
chosen for its stability. It looks like the server
stops accepting connections when it has created
more than 1024 threads.
> I recommend you to switch to the official binaries.
Does the problem remain on the latest r
Hello,
> I have just started using My-sql 4.1.9 mysql Ver 14.7 Distrib 4.1.9,
> for pc-linux-gnu (i686)
>
> Is there a way I could rollback my changes , i tried to go through the
> documentation but it wasn't of much help.
Transactions are only used when you use the InnoDB or BDB table
types.
I was trying to imnport a csv file into an online
databse table, but I kept getting error messages
alluding to a "child row," foreign key, etc. So I
decided to delete both keys (primary and index), then
import the csv file.
I finally managed to delete the primary key, but I
can't zap the index. Wh
Hi All,
I have just started using My-sql 4.1.9 mysql Ver 14.7 Distrib 4.1.9,
for pc-linux-gnu (i686)
Is there a way I could rollback my changes , i tried to go through the
documentation but it wasn't of much help.
regards
Digvijoy
Hi,
Which version of Mysql you are using? My query browser executes mutiple
commands -semicolon as seperated, and my ant script too works !! The
version Im using is 4.0.24.
Thanks
Usha
- Original Message -
From: "Justin Moore" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 23, 2005
Sorry if this is simple, but I'm a fairly new user and it's got me stumped.
Using PHP and MySql; I want to look up a specific record from a table of
people by using a select query to populate a PHP
statement. I can do it with one field, but I need to do it with more
than one field since I have
Dear all,
How to change the Default Date/DateTime Format of MySQL server?
I'm using MySQL 4.1.10-nt on WinXP Pro.
Thanks.
Shuan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have 3 different tables I need data from
And, the tables have the potential to get fairly large
I am using mysql 4.1.3
This working query below pulls up all media requests for 'Yolanda
Perez' in Los Angeles
Is there a appreciably speedier way to say the below ?
I have begun dipping my toe
stupidly
My DateTime field is in this format:
March 23, 2005, 3:49 pm
If I want to run this sql
SELECT TO_DAYS(MAX(DateTime)) - TO_DAYS(MIN(DateTime)) AS record
FROM userLog
I gather I need some extra function like..
SELECT TO_DAYS(MAX(Convert _Function(DateTime))) -
TO_DAYS(MIN(Conv
On Wed, 23 Mar 2005 22:22:34 +, "Jessica Svensson"
<[EMAIL PROTECTED]> said:
> Hi that works fine only now if a user puts + in front of a word that word
> becomes optional = OR?
> What i would like is the search to work exactly like before only that it
> defaults to AND instead of OR.
> Almo
Hi that works fine only now if a user puts + in front of a word that word
becomes optional = OR?
What i would like is the search to work exactly like before only that it
defaults to AND instead of OR.
Almost every search engine i have tried, google etc. works like this.
"black horse cat dog" only
Hi!
On Mar 23, Jessica Svensson wrote:
> Is there any way i can get results with AND instead of OR?
> Trying to search for "black cat" should only return records that contains
> both black and cat.
>
> I'm using the following code to get my result:
>
> SELECT * FROM `searchtbl` WHERE MATCH (tex
I couldn't find much on the variable you were trying to change.
Although it may have changed and now be called ft_boolean_syntax. But
that still won't help you since it doesn't appear to have an option to
change the default separator.
I think you will need to add the + to each word if you want t
If Dbase3 has an odbc driver then you can use SQLyog
(www.webyog.com) to import data to MySQL.
Karam
--- "Peter L. Berghold" <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> BG Mahesh wrote:
> > Actually I prefer to dump the dbase file on a
> Linux machine and dire
show variables like 'query%';
That will show you the setting for mainly your query cache. The
query_cache_type will tell you if it's on or not.
On Mar 23, 2005, at 3:08 PM, David Blomstrom wrote:
--- Brent Baisley <[EMAIL PROTECTED]> wrote:
There are advantages to one large
table over many
smalle
--- Brent Baisley <[EMAIL PROTECTED]> wrote:
There are advantages to one large
> table over many
> smaller tables. A large table will take advantage of
> query caching
> better (if you have query cache enabled). Lots of
> smaller table would
> probably cause the query cache to get flushed more
Is there any way i can get results with AND instead of OR?
Trying to search for "black cat" should only return records that contains
both black and cat.
I'm using the following code to get my result:
SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN
MODE);
sure there
Is there any way i can get results with AND instead of OR?
Trying to search for "black cat" should only return records that contains
both black and cat.
I'm using the following code to get my result:
SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN
MODE);
sure there
Your theory that more tables won't slow down a client if it doesn't
access them is correct, it won't slow the client down. But it's slowing
down the server that you should be worried about, not the client. The
more tables you have, the more file handles MySQL has to have open
along with caching
I have an existing database/tables and would like to add a counter to a
table that would increment when a document is downloaded from the
database. I am sure it is an easy addition to the php page but struck-out
looking for info not related to auto-increment in the mysql manual. I
tried adding
David Blomstrom said:
> I discovered by accident that I can link any website
> on my reseller account to one database. That would be
> far more convenient than working with six separate
> databases, and it would also cut down on file size
> overall, since there are certain tables that I share
> bet
I discovered by accident that I can link any website
on my reseller account to one database. That would be
far more convenient than working with six separate
databases, and it would also cut down on file size
overall, since there are certain tables that I share
between websites.
But my host warned
On Wednesday, March 23, 2005 12:13, Graham Anderson wrote:
> how do you search for an empty field ?
> I want to filter out records where the ipAddress field is empty
>
> SELECT * FROM 'userLog' WHERE 'ipAddress' IS [empty] ?
Searching for NULL's --
SELECT * FROM userLog WHERE ipAddress IS NUL
how do you search for an empty field ?
I want to filter out records where the ipAddress field is empty
SELECT * FROM 'userLog' WHERE 'ipAddress' IS [empty] ?
many thanks
g
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAI
Right, my mistake, you would have to use HAVING.
PB
mel list_php wrote:
Unfortunatly I can't use the alias txt in the where clause:
Standard SQL doesn't allow you to refer to a column alias in a WHERE
clause. This is because when the WHERE code is executed, the column
value may not yet be determi
What device driver are you using to access the database? Can you run a sql
trace or maybe turn on the logging on the server side?
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 23, 2005 11:05 AM
To: MySQL list
Subject: MySQL server disconnects when executing
"Lost connection to MySQL server during query"
The last time I saw this mysqld was segfaulting on a specific query. The
solution was to run an extended repair on the tables in question.
http://dev.mysql.com/doc/mysql/en/repair-table.html
I would reccommend against doing this until after hours as
But you can use column aliases in a HAVING clause (a simple mistake when
you are typing as fast as you are thinking). The other option is to put
the CONCAT(...) into the WHERE clause in place of the alias. Either way,
you will absolutely NOT be using an index to search that table. You will
need
Actually, exporting data from an Oracle database is one of the weak
spots of Oracle. Oracle makes it easy to get data in, but hard to get
it back out. There are ways to do it, but nothing easy that an Oracle
DBA will have if they only read the Oracle docs. Spooling an output
file can get tedius
Hi,
How do I import data from Dbase3 into MySQL?
My software, libmygis, is mainly designed for loading a set of
Shapefiles into MySQL (.SHP, .SHX, .DBF) but it's perfectly well capable
of loading just the dBase III/IV component. Grab libmygis-0.5.1 from:
http://jcole.us/software/libmygis/
You
Unfortunatly I can't use the alias txt in the where clause:
Standard SQL doesn't allow you to refer to a column alias in a WHERE clause.
This is because when the WHERE code is executed, the column value may not
yet be determined. For example, the following query is illegal:
SELECT id, COUNT(*) A
mos <[EMAIL PROTECTED]> wrote on 03/23/2005 12:04:59 PM:
> I have a compiled application that accesses a dedicated MySQL 4.1.1
server
> with MyISAM tables on Win XP. For some reason when the application is in
a
> loop doing simple single table Select statements, the MySQL server after
48
> s
You say it usually crashes near the same record? Could you post the
record information and also the query which is being run?
Also, is there any information in your hostname.err file? If mysqld is
bailing (and it appears that it is), it ought to be writing something
useful to the error log.
I have a compiled application that accesses a dedicated MySQL 4.1.1 server
with MyISAM tables on Win XP. For some reason when the application is in a
loop doing simple single table Select statements, the MySQL server after 48
seconds of processing will upchuck with the error "Can't connect to My
Normally, MySQL queries DO NOT end in a semicolon. The semicolon (;) and
the \G terminators are used by the command line client to differentiate
between normal (wide output) and vertical output. I have also used
semicolons in SQL scripts loaded by the "source" command to be processed
through
Shawn, Mel
>I am not aware of any SQL dialect that supports a query of the kind
you
>are asking about. If there were such a query it _might_ look
something
>like this
>SELECT
>FROM
>WHERE ANY_COLUMN() LIKE
Right, but Mel can emulate your ANY_COLUMN with something like
SELECT CONCAT(
The best I've been able to come up with involves some shell scripting.
If you're running Linux, using unpacked MyISAM tables, and have some
scripting ability from whatever language you're writing your application
in, you can run this in your MySQL directory:
strings -f *.MYD | grep | cut
I forgot to mention that it is happening from my ant scripts too. So the
problem is occurring outside of the query browser as well. However, from the
command line I can execute the two statements.
Any ideas what could be causing this?
-Original Message-
From: Justin Moore
Sent: Wed
I am not aware of any SQL dialect that supports a query of the kind you
are asking about. If there were such a query it _might_ look something
like this
SELECT
FROM
WHERE ANY_COLUMN() LIKE
but like I said, I can't think of any SQL server that has a function like
ANY_COLUMN() or its equivale
I can find the data, I was just wondering if mysql provides a kind of
generic scan of a whole table.
I could provide an advanced search, and ask the user what kind of info he
wants to retrieve but I first would like a quickSearch that may retrieve too
much info but is more intuitive.
As I said
"Justin Moore" <[EMAIL PROTECTED]> wrote on 03/23/2005 10:38:48 AM:
> Hi,
>
> Anyone know why I can't run multiple commands from the query browser
> using semicolons to separate the commands?
>
> ex:
> The following command works fine:
> select now();
>
>
> However the following commands do n
Hi Daniel,
> Jigal, thank you very much. However, this does not resolve my issue.
>
> even when querying:
> SELECT * FROM ae_articles AS art LEFT JOIN ae_articlesections AS sec ON
> art.ID=sec.articleID WHERE art.title LIKE '%bush%' AND sec.sectionID IN
(1,2)
> AND sec.sectionID NOT IN (3)
What *
Hi,
Anyone know why I can't run multiple commands from the query browser using
semicolons to separate the commands?
ex:
The following command works fine:
select now();
However the following commands do not
select now();
select version();
Your help is appreciated,
-JM
--
MySQL General Mail
"mel list_php" <[EMAIL PROTECTED]> wrote on 03/23/2005 06:00:08 AM:
> Unfortunatly they are not, I have something like 30 tables, with I would
say
> 10 to 15 fields per table.
> The number of row per table is quite low, i think it won't exceed
> 500-1000/table. But I may sometimes have to searc
If you have ms access you can import the db3 into access and then export
thru odbc to MySql
Osvaldo Sommer
-Original Message-
From: BG Mahesh [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 10:33 PM
To: mysql@lists.mysql.com
Subject: How to import data from Dbase3?
hi
How do I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
BG Mahesh wrote:
> Actually I prefer to dump the dbase file on a Linux machine and directly
> import it into MySQL.
>
>
There are a bunch of ways of skinning that cat. The easiest of which
IMHO is to convert the data to comma separated files first
I remember seeing some JDBC drivers for Java to read dbase 3 files. So
it might be a good idea to use that to understand the files and import
the data using the mysql jdbc drivers into the mysql database.
We can help you do it (provided you pay) since we have already done
similar exercise for a
Hello.
> I have mysql-server 3.23.49-8.9 in a debian woody,
> chosen for its stability. It looks like the server
> stops accepting connections when it has created
> more than 1024 threads.
I recommend you to switch to the official binaries.
Does the problem remain on the latest releas
I am not quite sure I understand your question, then: you would have to
make your table structure a little clearer. Generally, however, puristic
database design would say that you do not have the same "class" of data in
different tables. Instead, you have one "master" table with all the
"simila
Your query can be made a lot simpler if I understand your description:
SELECT * FROM ae_articles AS art
JOIN ae_articlesections AS sec ON art.ID=sec.articleID
WHERE art.title LIKE '%bush%' AND sec.sectionID IN (1,2)
This has nothing to do with MySQL, but is a matter of knowing SQL syntax.
You can
Unfortunatly they are not, I have something like 30 tables, with I would say
10 to 15 fields per table.
The number of row per table is quite low, i think it won't exceed
500-1000/table. But I may sometimes have to search into dna sequences
(around 5000 atcg characters in any order), so that is q
"mel list_php" <[EMAIL PROTECTED]> wrote on 23/03/2005 10:14:07:
> Hi list,
>
> I would like to search for something into one or several tables.
> My first idea was to retrieve the tables' names, then for each of them
> retrieve the columns' name and have a look in each of this column.
> Is ther
Hi list,
I would like to search for something into one or several tables.
My first idea was to retrieve the tables' names, then for each of them
retrieve the columns' name and have a look in each of this column.
Is there a more elegant (fast) way to do that with mysql?
Somebody has some tips/doc
Actually I prefer to dump the dbase file on a Linux machine and directly import
it into MySQL.
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Ehrwin Mina" <[EMAIL PROTECTED]>
Subject: Re: How to import data from Dbase3?
Date: Wed, 23 Mar 2005 02:21:48 -0600
>
> Ehr
Anyone knows who to make exclusion query when table is referenced via JOIN:
SELECT * FROM ae_articles AS art
LEFT JOIN ae_articlesections AS sec ON art.ID=sec.articleID
LEFT JOIN ae_articlesections AS sec2 ON art.ID=sec2.articleID
LEFT JOIN ae_articlesections AS sec3 ON art.ID=sec3.articleID
WHERE
I have mysql-server 3.23.49-8.9 in a debian woody,
chosen for its stability. It looks like the server
stops accepting connections when it has created
more than 1024 threads.
The kernel is 2.4.29.
failed: Can't create a new thread (errno 11). If you
are not out of available memory.
I have sear
Ehrin,
If you have dBase III or later, Clipper or FoxPro, you can export the
data comma-separated, then use a free csv-to-mysql utility eg
http://sourceforge.net/projects/csv-mysql/ to get it into mysql.
If you don't have an xbase executable, it's a little harder, but not
much provided there's
Do you want to do a one time import ?
Create an ODBC source that maps to the dBase datasource and write an
application to read it from there and import into mysql.
- Navneet
BG Mahesh wrote:
hi
How do I import data from Dbase3 into MySQL?
--
B.G. Mahesh
[EMAIL PROTECTED]
http://www.indiainfo.com/
58 matches
Mail list logo
