2011/2/3 Yannis Haralambous :
>
> what am I doing wrong?
>
> the query was just
>
> SELECT * FROM wasfoundin WHERE yakoright LIKE '%geography%'
When you use a leading wildcard symbol, MySQL will do a full table
scan regardless of any indexes you've created. If you've got a MyISAM
table, I recomme
On Thu, Jul 24, 2008 at 1:17 AM, Sivasakthi <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> how to Get file modified time and date of file by using builtin function or
> procedure in sql?
In a related thread from earlier today you were advised that any
interaction with the filesystem should be done via a
On Mon, Apr 7, 2008 at 1:24 AM, Moon's Father <[EMAIL PROTECTED]> wrote:
> Schema is a collection of databases.
A schema is a definition of tables & fields and their relationship.
Kevin.
--
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
On 10/10/07, Ratheesh K J <[EMAIL PROTECTED]> wrote:
> So every morning all the queries will be slow for the first time on the DB
> server 2 and thereafter will be served by the query cache as they will be
> cached and never invalidated until the night.
Sorry for the late reply, I'm trying to ge
On 4/26/07, Mike OK <[EMAIL PROTECTED]> wrote:
I read the Google blog post regarding these patches. They admit using
MySQL for some internal data storage needs but not in the general search
system.
Still, that leaves many other applications. Groups, gmail, reader,
news et al...
--
Kevin.
--
On 1/19/07, Daniel Culver <[EMAIL PROTECTED]> wrote:
Are you working on a Mac? If so, logging in as root is not good
enough. You must have set up and log into the root user account of
your Mac computer or server.
The OP is talking about managing MySQL accounts with MySQL
Administrator. MySQL A
On 12/21/06, Behrang Saeedzadeh <[EMAIL PROTECTED]> wrote:
Hi,
What is your favorite GUI tool for working with MySQL. EMS SQL Manager
is feature-rich but sometimes buggy and also very expensive. Navicat
is not very handy. It forces to switch between mouse and keyboard
repeatedly.
What is your f
Terry Spencer
Haigh Consultancy Services
Tel: +44 (0)116 262 3966
Fax: +44 (0)116 262 3946 (Leciester Office)
Fax: +44 (0)870 052 4572 (Terry)
Mob: +44 (0)7796108244
www.haigh-cs.co.uk <http://www.haigh-cs.co.uk>
Hi All,
I have a question for clearer brains than mine. I would like to join two
tables,. There may be many possible joins in table B to table A, but I only
want to join one row from B to table A - the row with the closest, but
lesser date.
TABLE A
Row Id date
1 46 3 Jan
7
On 1/2/06, JJ <[EMAIL PROTECTED]> wrote:
> Is there an easy way to drop all (MyISAM) tables of a MySQL 3.23 database
> besides deleting it and then recreating an empty database?
Read up on mysqldump. For 3.23, something like the following should
do the trick:
mysqldump databasename --add-drop-ta
On 11/22/05, Jim Winstead <[EMAIL PROTECTED]> wrote:
> On Tue, Nov 22, 2005 at 04:50:42PM -0800, Jon Drukman wrote:
> > What happened to MySQL Control Center (aka mycc or mysqlcc)? The
> > dev.mysql.com site redirects to the Query Browser page. QB is a poor
> > substitute for mycc. It looks like
On 10/25/05, Ziaul Mannan <[EMAIL PROTECTED]> wrote:
> ** Low Priority **
>
> Hello,
>
> I was able to install the following perl modules fine:
> DBI
> Data::Dumper
> Data::ShowTable
> DBI.pm
>
> Then,when I am try to install perl module called 'DBD::mysql' on AIX
> 5.2(64-bit) and 5.3. In both cas
I'm on Fedora Core 4. When I right-click on a table in
Mysql-administrator and choose "Edit table data" nothing happens, and I
get this in the console:
(mysql-administrator-bin:4628): glibmm-CRITICAL **:
unhandled exception (type Glib::Error) in signal handler:
domain: g-exec-error-quark
code
g out how to get the data out of the files and into
newer tables would be APPRECIATED
Spencer Yost
Sundance Consulting
336.287.8017
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I can connect on the command line, but have problems connecting using DBI/D
on the same server.
# ./bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.0-alpha-standard
Mysql is running
# ps -ef | grep mysql
root 10626 95
There are a few options, for more information see
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
"TIMESTAMPDIFF(interval,datetime_expr1,datetime_expr2)
Returns the integer difference between the date or datetime expressions
datetime_expr1 and datetime_expr2. The unit for the res
Im trying to speed up a query.
select
project_id
from
timesheet ts
where
ts.del is null
and signoff = 'A'
The output of explain is detailed below.
++-+---+--+-+--+
| id | select_type | table | type | possible_keys | key
On Fri, 12 Nov 2004 22:12:29 -0500, Joshua Beall <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I would like to search through all fields in a table, and anytime a search
> string comes up, have it replace it with another string. By way of example,
> let's say I wanted to replace every occurence of 'Pe
On Tue, 9 Nov 2004 13:21:54 -0600, Lewick, Taylor <[EMAIL PROTECTED]> wrote:
> I am asking before I post so I don't anger everyone...
>
> Is this list okay to post a specific question regarding multiple row
> inserts..
>
> I am doing this in perl, and I need some help with the perl part...
There
On Thu, 28 Oct 2004 12:24:02 +0100, Barry Zimmerman
<[EMAIL PROTECTED]> wrote:
>
> I have tried the following:
>
> mysqldump -u admin -p --databases yabbse > yabbsebackup.sql
>
> It seemed to work, but where can I find the yabbsebackup.sql file? Not very
> experienced with backing up.
Barry,
T
On Wed, 15 Sep 2004 11:27:55 -0700, Sanjeev Sagar
<[EMAIL PROTECTED]> wrote:
>
> Hello All,
>
> I am trying to install DBIx::DWIW but giving me following error.
>
> No such file `DBIx-DWIW-0.41.tar.gz'
>
> I am trying to install from CPAN
>
> cpan> install DBIx::DWIW
>
> Could not fetch autho
>From the manual:
REPLACE(str,from_str,to_str)
Returns the string str with all occurrences of the string from_str replaced
by
the string to_str:
mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
-> 'WwWwWw.mysql.com'
This function is multi-byt
order.
With the help of EXPLAIN, you can see when you must add indexes to tables to
get a faster SELECT that uses indexes to find the records."
http://www.mysql.com/doc/en/EXPLAIN.html
Terry Spencer
Haigh Consultancy Services
+44 (0)2073007329
www.haigh-cs.co.uk
-Original Message-
error?
Thanks
Terry
Terry Spencer
Haigh Consultancy Services
+44 (0)2073007329
www.haigh-cs.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ught, suggestion, points are greatly appreciated.
Im using 4.1.
Thanks
Terry
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 2:53 PM
To: Terry Spencer; [EMAIL PROTECTED]
Subject: RE: Update in select
Subqueries are only available in MySQL
Im attempting to update a table. We perform a select on the table to
determine what row to update.
update test a
set
visit_date = now()
where
a.id in (select b.id from test b where code ='Z')
Running this generates an error.
"You cant specify target table 'test' for update in FROM clause."
I
o e.g.
FROM_UNIXTIME(MAX(UNIX_TIMESTAMP(tstamp))) works around the bug.
>Submitter-Id:
>Originator:S. Spencer Sun
>Organization:
>MySQL support: none
>Synopsis: MAX fails to return the correct value in some MERGE table situations
>Severity: serious
>Priority: high
not able to keep up with both web and db activity)
4) While we do use MySQL on another website, it might be hard convincing
them we should put it on a windows box (we have traditionally be a UNIX
shop, though that is changing a little)
thanks
benji
---
Ben Spencer
Web Support
[EMAIL PROTECTED]
x
client like this:
this helps A LOT. MySQL doesn't have to be on the Sun Box. What OS where
you using? We could put MySQL on a Windows box. I don't know that I could
convince them to put it on a Linux box though.
---
Ben Spencer
Web Support
[EMAIL PROTECT
field which might have a condition run against it as well as
any field which does a join (which happens to be the same ones which
usually have a condition run against it)
benji
---
Ben Spencer
Web Support
[EMAIL PROTECTED]
x 2288
---
from MSSQL
to MySQL if MySQL would handle the traffic better. We do need a little
logic to determine if the user is logged in (if they aren't logged in, they
don't see the page) but it shouldn't be all that complicated.
thanks.
benji
--
away from MSSQL if possible, but in this case I don't think
changing the RDBMS will fix the problem.
---
Ben Spencer
Web Support
[EMAIL PROTECTED]
x 2288
-
Before posting, please check:
http://www.mysql.com/manual.php
of the reason MySQL
"failed" was poor database design and lack of indexes on key fields. Join
fields were not indexed!
DB design is depend on the application. Indexes we can do though, and have.
Thanks for this info. Info which is useful to build a case.
benji
---
Ben Spencer
Web Su
MySQL (or MSSQL) push out 125 MBytes/s (1
GBit/s)? At what point do we reach the Application (or OS?) limit?
thanks.
benji
---
Ben Spencer
Web Support
[EMAIL PROTECTED]
x 2288
-
Before posting, please check:
http
a database though, unless I would just
write the file "id=sfsdsdfsdfs987d897&bob=asdf8sdaf8sad9f8asd" out to disk
outside of the webroot and just have PHP open the file from the file
system. File Systems have a problem with 30K f
box.
Any information with regards to this would be of use.
If anyone also has such information on MSSQL (what is the Application Limit
of MSSQL) it would also be helpful.
thanks
benji
---
Ben Spencer
Web Support
[EMAIL PROTECT
>Description:
Users enter data from a php based web site and receive no errors
or warnings of any kind that something is amiss, but the data isn't
entered into the tables. When I go to the mysql command line and run
commands i get a table handler error.
>How-To-Repeat:
this happen
the master to the slave, or even the slave contacting the master,
and then the master establishing a connection to the slave). Is this (Slave
-> Master) correct? It also seems as if the data transfer happens on port
3306 (by default). THis is also correct?
thanks
benji
---
Ben Spencer
: 'some_database' user:
'someuser' host: `localhost' (Got an error reading communication packets)
MySQL is running on a Sun Box.
benji
---
Ben Spencer
Web Support
[EMAIL PROTECTED]
x 2288
-
Before posti
the database. This works - however one record
would
always be lost.
Its really urgent that I get this bug fixed, and I would be
exceptionally
greatful if there is anyone who can advise me on how to resolve this
problem.
I am using MYSQL version:
mysql Ver 11.15 Distrib 3.23.39
I have a big file full of ANSI SQL and a I want a script to be able to
tell Mysql to read this ANSI SQL file every few days because it updates
from a third party in ANSI SQL. I wish to avoid running a little parser
that just passes the SQL to the Perl-DBI module query methods, if I
could just sim
One problem might be if you are uploading it from a windows machine
where the lines are terminated by '\r\n' rather than a normal unix type
'\n'. I am not familiar with PHPMyAdmin so I am unsure whether or not
it accounts for that in the parsing of the file.
Curtis
-Original Message-
Fr
I have a text file with around 25 fields but I only want 5 of them.
They are not the first 5 fields that I want. Is there a way to skip
fields using LOAD DATA INFILE so I don't have to build a 25 field table
and then cut it down?
Thanks,
Curtis
I have a nicely sized database of about 40 records, which I have in
MS SQL but I need to move it to my production server, which is Mysql. I
was going to do it this way:
Export MS SQL database into a file and then use LOAD DATA INFILE
But I was wondering if there were a way to export into SQ
I was wondering what would be a better database design for long term
performance growth.
Design A:
Data Mapping
Definitions
Three Tables: Corporation ID 1 --> many Corporation ID
Corporation Data Code ID 1 --> 1
Code ID
Is this possible with 2.0 version (type 4 I think) MM driver found on
www.gjt.org? Also how do the file reading privileges for this work because
I tried doing it and it gave me an authorization error even though my mysql
user has FILE on it's privileges. Also, the file to read is chmod 774, s
46 matches
Mail list logo
