use DBI;
my $dbh = DBI-connect( DBI:mysql:rushload;192.168.0.1, $usrr, $passw, {
RaiseError = 3 } );
my $dbs = $dbh-selectcol_arrayref(show databases);
#my $dsn = dbi:mysql:information_schema:192.168.0.1:3306;
#my $dbh = DBI-connect($dsn, $usrr, $passw);
my $dbs = $dbh-selectcol_arrayref('show
I did a GRANT REPLICATION SLAVE ON *.* TO 'user'@'192.168.0.23' IDENTIFIED
BY 'psswd';
on the master. Doesn't *.* mean everything? Why would it just show me to
databases?
2013/4/2 Larry Martell larry.mart...@gmail.com
On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina gatorre...@gmail.com
On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina gatorre...@gmail.com wrote:
use DBI;
my $dbh = DBI-connect( DBI:mysql:rushload;192.168.0.1, $usrr, $passw, {
RaiseError = 3 } );
my $dbs = $dbh-selectcol_arrayref(show databases);
#my $dsn = dbi:mysql:information_schema:192.168.0.1:3306;
#my
Nope. That's just granting replication privileges so it can read updates
on all tables on all databases. It cannot select anything.
Why are you trying to connect with a replication slave user?
On 4/2/13 1:47 PM, Richard Reina gatorre...@gmail.com wrote:
I did a GRANT REPLICATION SLAVE ON
: Query take too long time - please help!
On 10.07.2012 13:16, Darek Maciera wrote:
2012/7/10 Ananda Kumar anan...@gmail.com:
can u show the explain plan for your query
Thanks, for reply!
Sure:
mysql EXPLAIN SELECT * FROM books WHERE
mysql LOWER(ksd)=LOWER('4204661375
Hello,
I have table:
mysql DESCRIBE books;
|id |int(255) | NO | PRI |
NULL | auto_increment |
| idu | int(255) | NO | MUL | NULL
| ksd | char(15) | YES |
can u show the explain plan for your query
On Tue, Jul 10, 2012 at 2:59 PM, Darek Maciera darekmaci...@gmail.comwrote:
Hello,
I have table:
mysql DESCRIBE books;
|id |int(255) | NO | PRI |
NULL | auto_increment |
| idu
2012/7/10 Ananda Kumar anan...@gmail.com:
can u show the explain plan for your query
Thanks, for reply!
Sure:
mysql EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375');
you are using a function-LOWER, which will not make use of the unique key
index on ksd.
Mysql does not support function based index, hence your query is doing a
FULL TABLE scan and taking more time.
On Tue, Jul 10, 2012 at 4:46 PM, Darek Maciera darekmaci...@gmail.comwrote:
2012/7/10 Ananda
On 10.07.2012 13:16, Darek Maciera wrote:
2012/7/10 Ananda Kumar anan...@gmail.com:
can u show the explain plan for your query
Thanks, for reply!
Sure:
mysql EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375');
That's definitely not the query you showed the first time
forwarded message:
From: Tompkins Neil neil.tompk...@googlemail.com
Date: 30 September 2011 20:23:47 GMT+01:00
To: mark carson mcar...@pixie.co.za
Cc: [MySQL] mysql@lists.mysql.com
Subject: Re: Slow query - please help
I downloaded version mysql-5.6.2-m5-win32.msi and he table
2011 20:23:47 GMT+01:00
To: mark carson mcar...@pixie.co.za
Cc: [MySQL] mysql@lists.mysql.com
Subject: Re: Slow query - please help
I downloaded version mysql-5.6.2-m5-win32.msi and he table definitions
are below, let me know if you need any more information.
CREATE TABLE `districts
Following my mail below, if anyone can help optimise the query further that
would be a great help.
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Wed, Oct 5, 2011 at 9:48 AM
Subject: Re: Slow query - please help
To: Johnny Withers joh
that
would be a great help.
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Wed, Oct 5, 2011 at 9:48 AM
Subject: Re: Slow query - please help
To: Johnny Withers joh...@pixelated.net
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
I just revised
: Wed, Oct 5, 2011 at 9:48 AM
Subject: Re: Slow query - please help
To: Johnny Withers joh...@pixelated.net
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
I just revised my query and now get the following output :
'1', 'PRIMARY', 'cities', 'ref', 'IDX_country_code,IDX_language_code
Can anyone help me ?
Begin forwarded message:
From: Tompkins Neil neil.tompk...@googlemail.com
Date: 30 September 2011 20:23:47 GMT+01:00
To: mark carson mcar...@pixie.co.za
Cc: [MySQL] mysql@lists.mysql.com
Subject: Re: Slow query - please help
I downloaded version mysql-5.6.2-m5
+01:00
To: mark carson mcar...@pixie.co.za
Cc: [MySQL] mysql@lists.mysql.com
Subject: Re: Slow query - please help
I downloaded version mysql-5.6.2-m5-win32.msi and he table definitions are
below, let me know if you need any more information.
CREATE TABLE `districts` (
`district_id` int
Hi
I've the following query :
SELECT city_id, name, meta_title, meta_description, meta_keywords,
country_code, link_text, folder_url, enabled, last_changed, nr_hotels,
(SELECT COUNT(hotels.hotel_id) FROM hotels WHERE hotels.city_id =
cities.city_id AND hotels.country_code = 'gb' AND
I downloaded version mysql-5.6.2-m5-win32.msi and he table definitions are
below, let me know if you need any more information.
CREATE TABLE `districts` (
`district_id` int(11) NOT NULL,
`language_code` char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
`city_id` int(11) DEFAULT NULL,
; mysql@lists.mysql.com
Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com
Subject: RE: Please help me.
Velentin,
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
Note the section for the droping of foreign keys used the contraint name,
not the key name. Try
like:
alter table documents_ex drop column Journal_ex_ID
or
alter table documents_ex drop foreign key Journal_ex_ID
or
alter table documents_ex drop key Journal_ex_ID
I receive the same error 150 and I don't know what to do.
Please help me.
Best regards.
--
MySQL General Mailing
the column after that.
From: Valentin Ionescu [colibry...@yahoo.com]
Sent: Wednesday, March 18, 2009 11:27 AM
To: mysql@lists.mysql.com
Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com
Subject: Please help me.
Hi!
My name is Valentin and I am writing
'./naxbmisq02-relay-bin.000157' not found
(Errcode: 2)
mysql
-Original Message-
From: David Giragosian [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2008 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: can some please help me -- REPLICATION
On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote
The background:
We are doing replication. The file-system containing the SLAVE's
relay-log got filled to capacity. Later on, I noticed replication has
not been working for the last month or more.
My Action:
I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now,
the SLAVE will not
you should probably just resync your slave. If it hasn't run for over a
month then there's not a lot of point in trying to start it up. Even if you
did start the slave (which seems doubtful) you'd have over a month's worth
of commands to make up.
You can tell mysql to not keep relay logs that
On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote:
you should probably just resync your slave. If it hasn't run for over a
month then there's not a lot of point in trying to start it up. Even if
you
did start the slave (which seems doubtful) you'd have over a month's worth
of commands to make
Re: You can tell mysql to not keep relay logs that have already been
used.
What command does this
-Original Message-
From: David Giragosian [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2008 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: can some please help me -- REPLICATION
, August 10, 2008 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: can some please help me -- REPLICATION
On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote:
you should probably just resync your slave. If it hasn't run for over
a
month then there's not a lot of point in trying to start it up. Even
On Wed, Dec 12, 2007 at 05:11:43PM -0800, Ed Reed wrote:
I've found a glaring problem with the latest ODBC connector. Data
types have been changed and data is no longer being read correctly.
That's not quite correct -- data types are now actually being read
correctly. They were wrong before,
I've found a glaring problem with the latest ODBC connector. Data types have
been changed and data is no longer being read correctly.
I'm running MySQL 5.1.16 on Netware. My apps are VB6 and VBA using ADO. The
following query produces different data types depending on the version of the
ODBC
Hi, i need of help for a serios problem.
We have installed mysql 5 and we are using InnoDB engine. OS is CentOS
5, x86.
Our problem is this.
We get this message in the log:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
ERROR 2002
To: mysql@lists.mysql.com
Subject: Please help to solve a serios problem
Hi, i need of help for a serios problem.
We have installed mysql 5 and we are using InnoDB engine. OS is CentOS
5, x86.
Our problem is this.
We get this message in the log:
ERROR 2002 (HY000): Can't connect to local MySQL
Message-
From: Ali Nebi [EMAIL PROTECTED]
Sent: Nov 6, 2007 9:24 AM
To: mysql@lists.mysql.com
Subject: Please help to solve a serios problem
Hi, i need of help for a serios problem.
We have installed mysql 5 and we are using InnoDB engine. OS is CentOS
5, x86.
Our problem is this.
We
/var/lib/mysql/mysql.sock
and then make it readable and writable by the user that owns mysql.
You can make that same file owner by the user that runs mysql.
-Original Message-
From: Ali Nebi [EMAIL PROTECTED]
Sent: Nov 6, 2007 9:24 AM
To: mysql@lists.mysql.com
Subject: Please
- Original Message -
From: Russell E Glaue [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 06, 2007 8:55 PM
Subject: Re: Please help to solve a serios problem
The mysql.sock location '/var/lib/mysql/mysql.sock' attempted to be used
by your
As Dan mentioned, you're searching on the 'tag' field which has no
index. But since that field is in the table you're joining on, adding
an index on it might not help. You actually searching on the tag_id
in the join field, not the 'tag'.
Add an index on 'object_type' in the
Yes I already did try adding an index on tag, but as you said it didn't work
as its using the primary key from the freetags table for the join , anyway I
will try adding an index on object_type, and see if that helps ...
Thanks
Kishore Jalleda
http://kjalleda.googlepages.com
On 6/20/07, Brent
-
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 20, 2007 10:23 AM
To: Brent Baisley
Cc: mysql@lists.mysql.com
Subject: Re: Slow query examining 10 Million Rows, please help !!!
Yes I already did try adding an index on tag, but as you said it didn't
work as its using the primary
Hi everybody,
we have this super slow query which is going through more
than 10 million rows to retrieve results, here is the query and other
information, I tried a few things to make this faster , but failed , so any
help from you guys in making this faster is greatly
I would try adding an index on the freetags.tag column as you are querying
against that column with
WHERE tag = 'shot'
HTH,
Dan
On 6/19/07, Kishore Jalleda [EMAIL PROTECTED] wrote:
Hi everybody,
we have this super slow query which is going through
more
than 10 million
Hi,
I'd really appreciate help with reading this db deadlock notice.
Essentially, I'd like to understand:
-what holds the lock that TX2 is waiting on index `token` of table
`eviltwin/user_sessions`? I thought it'd be TX1 (hence deadlock ?), yet
it appears that TX1 holds no locks
-if the
Nikita Tovstoles [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Do both of your SELECT statements use the same index (`token`) when setting
locks on the rows? My guess is that the situation is as follows.
TX2: SELECT ... WHERE id = ... FOR UPDATE
TX2 sets an exclusive lock for a row
VeeJay wrote:
How and at What place, can I configure the Makefile under
/usr/ports/databases/mysql50-server/
to have MySQL server working with above mentioned configurations?
Why not just use MySQL that comes from ports?
If you really want to build from source, read:
Hello there
I was wondering if someone having great knowledge of FreeBSD chroot system
could give me some help. I trying to run MySQL and Apache under a chroot
envoirnment. But I am getting these errors. Could you please help me to
solve these problems. I have googled a lot but did't find any
On Sun, Jan 07, 2007 at 12:50:34PM +0100, VeeJay wrote:
I trying to run MySQL and Apache under a chroot envoirnment. But I am
getting these errors.
[ ... ]
# /usr/local/mysql/libexec/mysqld: Can't create/write to file
'/var/tmp/ibPM3e0d' (Errcode: 13)
[ ... ]
fopen: Operation not
I am a novice with Unix and user of MySQL on windows…..
I have a problem, i.e.
I want to install MySQL5.0 at my FreeBSD 6.1 box with following
configurations:
--prefix=/usr/local/mysql
--with-mysqld-user=mysql
--with-unix-socket-path=/tmp/mysql.sock
--with-mysqld-ldflags=-all-static
I am not able to install Mysql on my 2003 server at home.
error 1045!!
I get an accesd denied for user [EMAIL PROTECTED]
my firewall is off and I know it is not the port becuase when I configure it
as 'anonymous it works like a charm. Please help me
I am not able to install Mysql on my 2003 server at home.
error 1045!!
I get an accesd denied for user [EMAIL PROTECTED]
I need the full error, but have some questions:
1. Are you sure that you set a root password?
2. Are you using the command line client or some other administrative tool?
@lists.mysql.com
Sent: Tuesday, June 27, 2006 5:15 PM
Subject: Re: Please Help - Stored Procedure Issue
On Tuesday 27 June 2006 01:52 pm, Jesse wrote:
@cInvNo
replace all instances of this with just cInvNo. cInvNo is already
declared as
an OUT variable, and @cInvNo will be set to that value
I have the following stored procedure that I'm using:
DELIMITER $$
DROP PROCEDURE IF EXISTS `bpa`.`sp_GetNextInv` $$
CREATE PROCEDURE `sp_GetNextInv`(
IN nChapterID Int,
OUT cInvNo VarChar(7))
BEGIN
Declare cPrefix VarChar(1);
Declare cNextInv VarChar(7);
Set cInvNo = '';
IF nChapterID 0 THEN
On Tuesday 27 June 2006 01:52 pm, Jesse wrote:
@cInvNo
replace all instances of this with just cInvNo. cInvNo is already declared as
an OUT variable, and @cInvNo will be set to that value when you run:
CALL sp_GetNextInv(-1,@cInvNo);
--
Chris White
PHP Programmer/DBBD
Interfuel
--
MySQL
have the same identifier as the tables. I don't
know if it is possible to have views and tables the same identifier. I didn't
create these views.
Can someone please help me figure this out?
Thanks
Murthy
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail
my operating system is linux redhat 9.0.
i am installing mysql 5.0.x binary distribution.
Which edition is the most fit in the following editions?
And would you like to tell me the difference among these editions?
Thanks very much!
[image: [ ]] mysql-standard-5.0.22-linux-i686-glibc23.tar.gz
On 6/2/06, yuan edit [EMAIL PROTECTED] wrote:
my operating system is linux redhat 9.0.
i am installing mysql 5.0.x binary distribution.
Which edition is the most fit in the following editions?
You notices most of those files are .asc and .md5 used to verify the
integrity of the archive after
, 2006 12:25:50 PM CDT
To: Joseph Alotta [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: please help optimize this query
I'd start by looking at your schema.. Quite a lot of use of
varchars... I'd suggest using chars (takes more space but processes
faster).. Or even better, normalize
Greetings,
I generate this report of all the holdings by symbol, summing up over
accounts. It is taking much too long. I was wondering if I can add
an index on something to make it more efficient. The first query
gets the most recent date, the next query sums it up by symbol.
Thank
I'd start by looking at your schema.. Quite a lot of use of
varchars... I'd suggest using chars (takes more space but processes
faster).. Or even better, normalize the data so that you have a table
for symbols that is linked to this table via an integer based foreign
key.
Also it seems wierd
i have three Values in each row of my MySQL database, im needing to sum
them in the table as they are displayed per Row ?? how do i do this ?
Projectname Elecremain Controlremainotherremain
?php ?
Project1 2300 1600
250
i have three Values in each row of my MySQL database, im needing to sum
them in the table as they are displayed per Row ?? how do i do this ?
Projectname Elecremain Controlremainotherremain
?php ?
Project1 2300 1600
250
Hi, Brian!
First of all I think next time you should better attach your database
structure. It'll be much easier to understand your problem if you will...
Maybe you're asking for something like this:
SELECT project_name, elecremain, controlremain, otherremain, elecremain
+ controlremain +
Brian,
i have three Values in each row of my MySQL database, im needing to
sum them in the table as they are displayed per Row ?? how do i do
this ?
Projectname Elecremain Controlremain
otherremain ?php ?
Project1 2300 1600
Please answer to list next time.
Good. Now, what is your Elecremain, Controlremain, otherremain?
How should they be calculated...
P.S.: Why don't you give a try to some numerical data types? ;) To use
varchar everythere isn't a right way I think.
Brian E Boothe wrote:
my database
Brian E Boothe wrote:
i have three Values in each row of my MySQL database, im needing to
sum them in the table as they are displayed per Row ?? how do i do
this ?
As Eugene said, VARCHAR values don't sum, since they are not numeric.
Either cast the column values you wish sums of to a
.
Do you really want to drop the 'billmax' database [y/N] y
Database billmax dropped
But it does not do anything.
I have tried restarting the DB and restarting the box as well
Please help
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
:22 AM
Subject: please help, can not delete database
Hello,
Not sure what is going on
i have mysql Ver 12.22 Distrib 4.0.17,
I have a database that i can not delete.
i do this
#mysqladmin drop billmax -u admin --password
Enter password:
Dropping the database is potentially a very bad thing
-
From: Randy Paries [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Sent: Saturday, April 22, 2006 11:04 AM
Subject: Re: please help, can not delete database
when i go back and try to create it , it says it already exisit?
Randy
On 4/22/06, Rhino [EMAIL PROTECTED] wrote:
What makes you think
in the database will be destroyed.
Do you really want to drop the 'billmax' database [y/N] y
Database billmax dropped
But it does not do anything.
I have tried restarting the DB and restarting the box as well
Please help
Randy
Remember that MySQL uses directories to implement databases. When you
drop
can someone post a snippit on Summing tables together of a feild of the
entire Database ? why does everyone Have such a problem with this
question? everyone i ask says the same thing,, let me show what i'm
needing by Visual representation
MySQL databaseworkorders
Brian,
can someone post
a snippit
on Summing tables together of a feild of the
entire Database ?
Do you mean summing
all row
values of a column in a table, grouped by the value of another column?
If so, for example to
retrieve all electprojcost, electprojbilling values and their
differences
Hi all,
My Windows-based database server crashed (no fault of MySQL. probably OS
or hardware), and I managed to copy out the data files. I am using
version 5.0 of the Essentials package.
I tried to install a similar setup on another server, then copy the
data\ folder over. The MySQL service
This is actually for Linux/Unix, not Windows.
What error do you get from MySQL when trying to log in? Does the
mysqld(-nt) process show within Task Manager? What does the new error
log say?
You may need to reset permissions:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
not sure, but it may be worth trying the following
run the script:
mysql_install_db --user=root
In the installation dir
this should change ownership and make mysql recognise the data dir.
good luck
Ade
Foo Ji-Haw wrote:
Hi all,
My Windows-based database server crashed (no fault of MySQL.
Thanks for coming to the rescue, Mark and Bruce.
Mark Leith wrote:
This is actually for Linux/Unix, not Windows.
What error do you get from MySQL when trying to log in? Does the
mysqld(-nt) process show within Task Manager? What does the new error
log say?
You may need to reset
: PLEASE HELP - problems with back up and restore
I saw both views and stored procedures in the dump file. What error do you
get if you process the script with the source command within the MySQL
CLI?
mysql -uroot -pmypass
(login welcome)
mysql CREATE DATABASE IF NOT EXISTS bcm;
mysql USE
Hi,
I'm really desperate on this on.
After struggling with some really weird bugs I finally finished my project.
Buut I can't perform a good backup and restore.
I'm using :
MySql 5.0.16-nt (essentials version)
Windows xp
The DB contains tables, vw's and sp's.
It is a
Barak Mery [EMAIL PROTECTED] wrote on 11/23/2005 01:51:37 PM:
Hi,
I'm really desperate on this on.
After struggling with some really weird bugs I finally finished my
project.
Buut I can't perform a good backup and restore.
I'm using :
MySql 5.0.16-nt
PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:07 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
Barak Mery [EMAIL PROTECTED] wrote on 11/23/2005 01:51:37 PM:
Hi,
I'm really desperate
Mery
Cc: mysql@lists.mysql.com
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
Barak Mery [EMAIL PROTECTED] wrote on 11/23/2005 01:51:37 PM:
Hi,
I'm really desperate on this on.
After struggling with some really weird bugs I finally finished my
Thanks again,
I will try this and read the manual again.
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:30 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: RE: urgent : PLEASE HELP - problems with back up and restore
There's
Thanks Marko :)
-Original Message-
From: Marko Knezevic [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 24, 2005 12:29 AM
To: MySQL list
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
Dear Barak,
Save yourself year or two of your life and try using MySQL Front
file
thanks
Barak
snipped out backup file
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:30 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: RE: urgent : PLEASE HELP - problems with back up and restore
There's a new option added in 5.0.13
For an PHP example of how to import data getting around
max_packet_size, performance, etc. issues.. Be sure to read this
article.
Also linked from: http://dev.mysql.com/doc/refman/4.1/en/blob.html
Article @ http://php.dreamwerx.net/forums/viewtopic.php?t=6
--
MySQL General Mailing List
For list
Dan Buettner wrote:
I tend to disagree - at my place of employment, a newspaper, we have
hundreds of gigabytes of BLOB data (ad and page layouts digital
artwork) stored in SQL databases. Granted we are using Sybase for that
and not MySQL but there are a lot of advantages to it - access
, this is a big problem for me . i couldnt sorted out yet . I used mysqlcc
and sqlYOG as well to upload images ( contents ).
in like this situations how can we work with mp3 and such huge files
please . help me very very urgent
Thanx in advance,
Kane
Kane Wilson wrote:
But when i try to store little but huge gif files it wont store .
First of all, use the method described at
http://www.php.net/manual/en/features.file-upload.php for a safe way to
handle file uploads. It could be that you run into a server limit which
will show up if you
troubles. contents wont stored.
my requrement is any how keep the contents , in the mysql database, i have high
performance machine. so then i'm not worry about perforamnce.
please , let me know how could be the way to store such files in a mysql
databse ???
please help
Jigal van Hemert [EMAIL
.
please , let me know how could be the way to store such files in a
mysql databse ???
please help
Jigal van Hemert [EMAIL PROTECTED] wrote:
Kane Wilson wrote:
But when i try to store little but huge gif files it wont store .
First of all, use the method described at
http
I tend to disagree - at my place of employment, a newspaper, we have
hundreds of gigabytes of BLOB data (ad and page layouts digital
artwork) stored in SQL databases. Granted we are using Sybase for
that and not MySQL but there are a lot of advantages to it - access
control, change control
hi ,
I wanted to check the following condition and if it is
success i wanted to display a massage.I tried as
follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die(Couldn't get
file list);
if (!isset($result))
{echo NULL;}
//if
Kane Wilson wrote:
I wanted to check the following condition and if it is
success i wanted to display a massage.I tried as
follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die(Couldn't get
file list);
if (!isset($result))
{echo NULL;}
Hello.
$dbQuery = results;
Have you forgotten to put '$' before the 'results'? Do you
have display_errors = On in your php.ini?
Kane Wilson [EMAIL PROTECTED] wrote:
hi ,
I wanted to check the following condition and if it is
success i wanted to display a massage.I
, September 07, 2005 1:40 AM
To: mysql
Subject: please help .very urgent
hi ,
I wanted to check the following condition and if it is success i wanted to
display a massage.I tried as follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die(Couldn't
John thegimper wrote:
This is what i need:
Posted by gogman on Monday May 5 2003, @10:42am on the mysql website:
MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext
search engines default to an 'AND'. These include: AltaVista, Fast Search,
Svensson [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Please help me: Boolean fulltext searches, AND instead of
OR
Date: Wed, 23 Mar 2005 22:32:49 +0100
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
!!
From: Sergei Golubchik [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Please help me: Boolean fulltext searches, AND instead
of
OR
Date: Wed, 23 Mar 2005 22:32:49 +0100
Hi!
On Mar 23, Jessica Svensson wrote:
Is there any way i can
Hello.
It is possible to obtain your results without temporary tables, but
with user variables. For a pity you should execute three queries.
With first query you're getting the Sum:
select @all_sum:= count( employee_id) from table_employee
where employee_hire_date between
Without knowing more of your requirements, I find seeing the grand total and
overall average repeated in every row strange from a usability perspective.
Do you really need that, or were you just hoping to get that information out
of your query?
I'd suggest something like:
SET @sum=0, @m=0;
Hello MySQL users,
Currently, I use MySQL 4.0.22 and I can do a straightforward count of
employees hired for each month.
select employee_hire_date, count(employee_id)
from table_employee
where employee_hire_date between 2005-01-01 and 2005-4-30
group by month(employee_hire_date)
Date |
Hi,
with a table with 33 rows, i have the row in 0s using index on term.
mysql select * from tx where term like 'Britney Spears' ;
+++
| id | term |
+++
| 327681 | Britney Spears |
+++
1 row in set (0.00
Hi,
i have table which would contain data describing holiday houses. It's it:
idbigint(20) unsigned PRIauto_increment
nametinytext
descriptiontext
webpagetinytext
emailtinytext
whole_cantinyint(1) unsigned
whole_onlytinyint(1) unsigned
type
1 - 100 of 578 matches
Mail list logo
