-Original Message-
From: Yang Yang [mailto:dapiy...@gmail.com]
Sent: Sunday, February 27, 2011 12:29 PM
To: Johnny Withers
Cc: mysql@lists.mysql.com
Subject: Re: centos server's mysql version's problem
thanks johnny
what about 5.1,did it performance better than 5.0 on centos
problem
thanks johnny
what about 5.1,did it performance better than 5.0 on centos when it has
large traffic?
5.1 is newer,but i know not newer is better
How much traffic is large traffic? How large is your database? How is it
structured? What type of hardware are you using?
-David
...@gmail.com]
Sent: Sunday, February 27, 2011 12:38 PM
To: David Brian Chait
Cc: Johnny Withers; mysql@lists.mysql.com
Subject: Re: centos server's mysql version's problem
about 8,000,000 visit,and about 40,000,000 sql do
about 2g database,and the large table who aften use about 400m
2x Intel Xeon
The only 5.1 version I tried was percona's. I only tested it in
development. Can't speak for MySQL's version. 5.5 is GA now, its supposed
to have many improvements for mulitiprocessor machines over 5.0 and 5.1.
This will be my first production install of 5.5, real traffic has not hit
yet, but it
, 2011 6:33 AM
To: mysql@lists.mysql.com
Subject: Insert data in one table from Another Problem
Dear all,
Today I am puzzled around a problem of inserting data into new table in
new format. I have a table named *user_news* as :
We have four rows with respect to each record_id.
fore.g : I have
Dear all,
Today I am puzzled around a problem of inserting data into new table in
new format. I have a table named *user_news* as :
We have four rows with respect to each record_id.
fore.g : I have listed main columns as
*record_id field_name field_value*
572SOI
Dear all,
I stuck around one more simple problem today.
I have a table named *event_loc* having below data : ( It has many
columns but I show you main columns that I needed )
_*Tables Data :-*_
*source_idevent_text*
1233 meet
1233
You need to group by event_text, not obj_text:
select source_id ,event_text,count(*) from event_loc
group by source_id,event_text;
Date: Tue, 8 Feb 2011 16:31:39 +0530
From: adarsh.sha...@orkash.com
To: mysql@lists.mysql.com
Subject: Group By Problem
Dear all,
I stuck around one
Greetings, all...
I'm having an issue with a SELECT in our system. We have an event log table,
with about 9 million rows in it. Inserts happen with some pretty high frequency,
and these selects happen periodically. The event_log table is MyISAM, the
rest of the tables are InnoDB.
What's
I had this same issue a while back and solved it by writing my events to
a disk-based file and periodically importing them into the event log
MyISAM table. This way, even if your select statements lock the table,
it won't affect the performance of your application. Of course, this
may
Do you delete data from the table ?
MyISAM will only grant a write lock when there are no locks on the table -
including implicit read locks. That may be your problem.
There is a single situation when concurrent reads and writes are possible on
MyISAM, however: when your table has no holes
problem...
Greetings, all...
I'm having an issue with a SELECT in our system. We have an event log table,
with about 9 million rows in it. Inserts happen with some pretty high
frequency,
and these selects happen periodically. The event_log table is MyISAM, the
rest of the tables are InnoDB
I messed up the ibdata1,ib_logfile1,0 files and encounter the problems of
openning innodb tables even after I copied the back-up files of few months ago.
I don't have many innodb tables and so this not causing too much trouble.
I don't know what to do for restoring those tables, and not even
Dont you have mysql dump file for those table? It is best way to restore
InnoDB tables.
2011/1/7 Elim PDT e...@pdtnetworks.net
I messed up the ibdata1,ib_logfile1,0 files and encounter the problems of
openning innodb tables even after I copied the back-up files of few months
ago. I don't
I messed up the ibdata1,ib_logfile1,0 files and encounter the problems of
openning innodb tables even after I copied the back-up files of few months ago.
I don't have many innodb tables and so this not causing too much trouble.
I don't know what to do for restoring those tables, and not even
with a 100 (or more) items SELECT request.
The problem (or situation) is reproductible, you can see an example below.
Anybody could explain this to me ?
Cheers
XC
My MySQL version : Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486)
using readline 6.1
== Example
://yueliangdao0608.blog.51cto.com
2010/12/20 Xavier Correyeur x.correy...@free.fr
Hi everybody !
A have a discontinued AUTO_INCREMENT sequence when i insert data in a
table
with a 100 (or more) items SELECT request.
The problem (or situation) is reproductible, you can see an example
below
...@free.fr; mysql@lists.mysql.com
Sent: Tue, 21 December, 2010 3:28:00 PM
Subject: Re: Discontinued AUTO_INCREMENT problem
Too curious...could you share a SHOW CREATE TABLE from this table as
requested before?
Best regards.
--
Wagner Bianchi
2010/12/21 杨涛涛 david.y...@actionsky.com
Hi.
You
Sent: Tue, 21 December, 2010 3:28:00 PM
Subject: Re: Discontinued AUTO_INCREMENT problem
Too curious...could you share a SHOW CREATE TABLE from this table as
requested before?
Best regards.
--
Wagner Bianchi
2010/12/21 杨涛涛 david.y...@actionsky.com
Hi.
You can show us your show
Hi everybody !
A have a discontinued AUTO_INCREMENT sequence when i insert data in a
table with a 100 (or more) items SELECT request.
The problem (or situation) is reproductible, you can see an example below.
Anybody could explain this to me ?
Cheers
XC
My MySQL version : Ver 14.14 Distrib
I can't tell you 'why' it is occurring when the field name begins with 4E5,
but you can solve your problem by enclosing all your field names
in backticks ( ` ).
IE:
SELECT field AS `4E5664736F400E8B482EA7AA67853D13`
On Mon, Dec 20, 2010 at 11:43 AM, Ramsey, Robert L
robert-ram
Here's my 5 second guess..
4E5664736... is being interpreted as a number in scientific notation ..
i.e. 4*10^5664736 and the parser doesn't like that as a field name.
-Hank
On Mon, Dec 20, 2010 at 12:43 PM, Ramsey, Robert L
robert-ram...@uiowa.eduwrote:
I am having the hardest time
I have table post (id INT and parent VARCHAR)
+--+-+
| id | parent |
+--+-+
|1 | 0 |
|2 | 0 |
|3 | 1 |
|4 | 0 |
|5 | 1 |
|6 | 0 |
|7 | 1,5 |
|8 | 1,5
i.e. just try this:
mysql select 4E5664736F400E8B482EA7AA67853D13;
ERROR 1367 (22007): Illegal double '4E5664736' value found during parsing
-Hank
On Mon, Dec 20, 2010 at 12:50 PM, Hank hes...@gmail.com wrote:
Here's my 5 second guess..
4E5664736... is being interpreted as a number in
The sub-select only returns a single row, so IN(...) is only looking at a
single value in the list .. it doesn't expand to into IN (5,7,11).
On Mon, Dec 20, 2010 at 11:52 AM, muhammad subair msub...@gmail.com wrote:
I have table post (id INT and parent VARCHAR)
+--+-+
| id
In the last episode (Dec 20), Johnny Withers said:
On Mon, Dec 20, 2010 at 11:52 AM, muhammad subair msub...@gmail.com wrote:
I have table post (id INT and parent VARCHAR)
+--+-+
| id | parent |
+--+-+
|1 | 0 |
|2 | 0
@lists.mysql.com
Subject: Re: odd problem with select as statement
i.e. just try this:
mysql select 4E5664736F400E8B482EA7AA67853D13;
ERROR 1367 (22007): Illegal double '4E5664736' value found during parsing
-Hank
On Mon, Dec 20, 2010 at 12:50 PM, Hank
hes...@gmail.commailto:hes...@gmail.com wrote:
Here's
in my database,
if i want to render firstname and lastname match case ,
am using REGEXP '^[abcd]' WORK FOR SINGLE FIELD,
Now i have fname and lastname ,
How to make the query , which display both and single field satisfieds
records ,
That is my query should return like
Name(combined
Is this what you meant?
SELECT * FROM tbl where Fname REGEXP '^[abcd]' AND Lname REGEXP '^[abcd]'
(alternatively, the extression could be simpliefied as REGEXP '^[a-d] )
- md
On Fri, Oct 22, 2010 at 11:01 AM, bharani kumar
bharanikumariyer...@gmail.com wrote:
in my database,
if i want to
Hi ,
Am just trying alphabetical pagination ,
Yes there is lot of pager class there for this ,
but in my requirement little but diff , that is
totally 4 sets ,
A-DE-H I-PQ-S (Assume there are pager links)
When user click the A-D , then it should show all the customer name
You regular expression is alittle off. You don't need the OR operator
'|' inside the character class definition, it is implied. Try this:
[php]
SELECT * FROM tbl where Fname REGEXP '^[abcd]'
[/php]
- michael dykman
On Thu, Oct 21, 2010 at 11:07 PM, bharani kumar
bharanikumariyer...@gmail.com
MySQL Administrator 1.2.15 is fails with the same problem. Do anyone have
any other suggestions ?
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Fri, Oct 15, 2010 at 11:21 AM
Subject: Re: Backing up MySQL using PHPMyAdmin problem with UTF-8
Oh this isn't good. Because the database in on a shared server and I don't
think I've got console access ?
On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman mdyk...@gmail.com wrote:
I have had this problem with PHPMyAdmin many times, and the only way I
know around it, is to go in and do your
I managed to use the older version of MySQL Administrator 1.2.15 and it
appears to back up find using InnoDB online backup.
On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman mdyk...@gmail.com wrote:
I have had this problem with PHPMyAdmin many times, and the only way I
know around it, is to go
connection: utf8*
*character set results: utf8*
*collation connection: **utf8_unicode_ci*
The problem I have is that the foreign characters like ăÿć etc are being
backed up as scrambled non-readable characters. Any ideas why this is
happening ?? Are there any other variables I need to check/set
I have had this problem with PHPMyAdmin many times, and the only way I
know around it, is to go in and do your dump at the console. PHP does
not deal with UTF very well.
- michael dykman
On Thu, Oct 14, 2010 at 5:48 AM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
Hi,
I'm using PHP
So I'm having a problem with an update query. I have three tables:
Table: A
Columns: acnt, name, company, email, domain
Table: AM
Columns: acnt, m_id
Table: M
Columns: m_id, name, company, email, domain
and I want to conditionally update the columns in one to values from the
other. i.e
Try using the IS NULL operator instead of !
-Travis
-Original Message-
From: Andy Wallace [mailto:awall...@ihouseweb.com]
Sent: Thursday, September 16, 2010 10:47 AM
To: mysql@lists.mysql.com
Subject: Update query problem
So I'm having a problem with an update query. I have three
Hi Baron
This tool works better than mytop, you solved my problem, thanks a lot
Carlos
Date: Tue, 17 Aug 2010 10:41:23 -0400
Subject: Re: Problem with mytop
From: ba...@xaprb.com
To: mysql@lists.mysql.com
Carlos,
Have you tried innotop instead? It's a better replacement for mytop
If sombody can help me I'll be gratefull
I have a problem with mytop1.6 on Mandriva 2010.1, when I install it on a Slave
server mytop works,
but when I install it on a Master Server don't works, don't display the queries.
I use mysql version 5.0.77
and linux mandriva 2010.1
Very Thanks
Carlos,
Have you tried innotop instead? It's a better replacement for mytop.
(I wrote it.)
- Baron
On Tue, Aug 17, 2010 at 8:50 AM, Carlos Eduardo Caldi
ce_ca...@hotmail.com wrote:
If sombody can help me I'll be gratefull
I have a problem with mytop1.6 on Mandriva 2010.1, when I install
Hi;
I have this code:
select f.id from Flights f join Planes p where f.plane_id=p.id and
p.in_service=1
mysql describe Flights;
+-+---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
What do you mean by not working? What results do you get?
-Original Message-
From: Victor Subervi [mailto:victorsube...@gmail.com]
Sent: Monday, August 16, 2010 6:59 AM
To: mysql@lists.mysql.com
Subject: Join Problem
Hi;
I have this code:
select f.id from Flights f join Planes p where
Review your join type.
From: ext Gavin Towey [gto...@ffn.com]
Sent: 16 August 2010 19:36
To: Victor Subervi; mysql@lists.mysql.com
Subject: RE: Join Problem
What do you mean by not working? What results do you get?
-Original Message-
From: Victor
From: Manasi Save manasi.s...@artificialmachines.com
To: Michael Dykman mdyk...@gmail.com
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
Sent: Tue, August 10, 2010 10:34:37 AM
Subject: Re: MySQL data get and set problem
Hi Michale,
I have made that parameter column name change
Dear All,
Table values are getting rollback without calling rollback.
I have a table Test with some columns in it.
Here's the Table Structure:-
Create Table TestID
(
TestID int not null,
MyID int
);
I am calling two procedures one is get the value of MyID column and one is to
set the value
You might have better results if you use unique identifiers:
Select MyID From Test Where TestID = TestID;
I'm not sure how mysql is supposed to tell the param 'TestID' from the
column name.
- michael dykman
On Mon, Aug 9, 2010 at 3:10 AM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi Michale,
I have made that parameter column name change. but I am unable to
understand how even after execution of update statement and commit
after that, data is getting reverted.
Any inputs on this will be a great help.
--
Regards,
Manasi Save
On Mon, 9 Aug 2010 14:11:19 -0400,
On 7/21/2010 12:16 PM, Nunzio Daveri wrote:
database is around 150GB with over 5,000 tables. To make things worse, if I
shutdown MySQL, top-c still says all the memory is still used? Is this a bug,
why would it say all the memory is used when I turn off MySQL. The weird thing
is that when I
On Tue, Jul 20, 2010 at 9:58 PM, dennis skinner dlsvi...@hotmail.comwrote:
Hello I am a new mysql user. Can anyone tell me why this does not create
a table?
?php(the spaces before the question mark are not in the
code)
$dbuser=smeduser;
$dbpassword=x;
$dbname=smed;
Hello Gurus, I just inhereted a Sun 2 U Server with 2 Intel Quad Core CPU's and
16 GB of ram. Here is the problem. The machine is constantly at 99% Memory
utilization and we get random row locking, we are only using InnoDB. The
database is around 150GB with over 5,000 tables. To make things
Hello I am a new mysql user. Can anyone tell me why this does not create a
table?
?php(the spaces before the question mark are not in the code)
$dbuser=smeduser;
$dbpassword=x;
$dbname=smed;
mysql_connect(localhost, $dbuser, $dbpassword);
mysql_select_db($dbname) or
On Tue, July 20, 2010 09:28, dennis skinner wrote:
Hello I am a new mysql user. Can anyone tell me why this does not
create a table?
?php(the spaces before the question mark are not in the
code)
$dbuser=smeduser;
$dbpassword=x;
$dbname=smed;
'unsigned' is part of your data type which must be before the 'not
null' Your closing ) needs to be at the very end. There is no reason t
have the unique id since the primary key is unique.
First you need the column name 'patid' then the data type 'INT UNSIGNED'
then the other column
.
When you ask about listing only the arqueology sites that's just a
simple query:
SELECT * from site_arqueology inner join sites on sites.id_site =
site_arqueology.id_site
I can't see where your problem is. Can you provide some additional details?
--
Shawn Green
MySQL Principle Technical Support
on sites.id_site =
site_arqueology.id_site
I can't see where your problem is. Can you provide some additional details?
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
On 7/8/2010 10:59 AM, John Nichel wrote:
Hi,
I'm hoping what I'm trying to do can be done, but I can't seem to find
the right syntax. I have the following query:
SELECT
... snipped ...
if(
(
Hi,
I'm hoping what I'm trying to do can be done, but I can't seem to find
the right syntax. I have the following query:
SELECT
a.productid,
a.productcode,
a.product,
if(
Is there a way I
can do a IF((SELECT.), expr2, expr3) and have expr2 populate with
whatever is returned from the select statement?
Yes, select if( (select count(*) from mytable ) 100, 1, 0) works fine.
The alias inside your last If(...), though, is not visible outside its
parentheses;
-Original Message-
From: Peter Brawley [mailto:peter.braw...@earthlink.net]
Sent: Thursday, July 08, 2010 12:27 PM
To: mysql@lists.mysql.com
Subject: Re: Problem with IF() inside of a select statement
Is there a way I
can do a IF((SELECT.), expr2, expr3) and have expr2
Hi,
I am having some uncertainty while designing the following structure:
I have two sets of data:
* arqueology sites (can be natural):
id
name
description
id_category
id_period
x
y
* natural sites (can be arqueological also - bear with me -, so there will
be duplicate records in the above
Hi;
mysql alter table Flights type=InnoDB;
Query OK, 1 row affected, 1 warning (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql alter table Flights add pilot_id int not null;
Query OK, 1 row affected (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql alter table Flights add foreign
Problem solved. I tried everything that *should* have worked and didn't.
Then I just wiped the test database and started with everything *fixed* (all
engine=innodb, all keys of same type, etc.) and it all worked.
V
Hi Victor,
The actual problem is with the key field.
Flights.pilot_id is set to INT NOT NULL and you had specified Pilots.id to
INT NULL.
You have to change both the columns to NULL or else NOT NULL to avoid the
error.
Regards,
Jay
MySQL DBA
Datavail CORP
On Tue, Jun 22, 2010 at 7:45 PM
On Tue, Jun 22, 2010 at 11:53 AM, jayabharath jbhara...@gmail.com wrote:
Hi Victor,
The actual problem is with the key field.
Flights.pilot_id is set to INT NOT NULL and you had specified Pilots.id to
INT NULL.
You have to change both the columns to NULL or else NOT NULL to avoid
Hi Brian, all!
brian wrote:
On 10-06-14 09:13 PM, brian wrote:
[[...]]
This not only gives an empty set, but also throws 171 warnings (more on
that below). I've remove both the WHERE and GROUP BY clauses with no
success. I've been staring at this for an hour now and can't see what
the
Using 5.1.41/Ubuntu
I have 2 tables, members countries. The former has a column,
country_id (tinyint(3) unsigned). The countries id column is the same
(although auto_increment). I'm trying to select just those countries for
which there is a member. So I decided this query should do the
On 10-06-14 09:13 PM, brian wrote:
Using 5.1.41/Ubuntu
I have 2 tables, members countries. The former has a column,
country_id (tinyint(3) unsigned). The countries id column is the same
(although auto_increment). I'm trying to select just those countries for
which there is a member. So I
Hi there. Sorry for my poor english.
Iinstalled MySQL 5.5 m3 though original RPM package and I modified the MySQL
root password. When Iinstall WordPress, I got the error message like 'Error
establishing adatabase connection'. But when I clear MySQL root password,
everything goes well. I don't
This seems like a wordpress problem, not mysql.
On 5/30/10, Lancer skyleac...@gmail.com wrote:
Hi there. Sorry for my poor english.
Iinstalled MySQL 5.5 m3 though original RPM package and I modified the MySQL
root password. When Iinstall WordPress, I got the error message like 'Error
Hi there. Actually phpbb returns error message 'Access Denied r...@localhost',
I mean isn't wordpress problem. Because all the program a could not normal
working that use the mysql(mysqli is normal working) function.
Sorry for my poor english grammar.
Regards.
Sent from my HTC Touch Diamond2
On 5/30/2010 5:44 PM, Lancer wrote:
Hi there. Sorry for my poor english.
Iinstalled MySQL 5.5 m3 though original RPM package and I modified the MySQL
root password. When Iinstall WordPress, I got the error message like 'Error
establishing adatabase connection'. But when I clear MySQL root
This is just for the sake of future googlers of this thread. The correct
mysql command is:
ursor.execute('create table if not exists Passengers (id int(11)
auto_increment primary key, flights_id int(11) not null, customer_id int(11)
not null, foreign key (flights_id) references Flights (id),
Hi;
When I try to execute this code from my Python script, I get this error:
Traceback (most recent call last):
File
/var/www/html/creative.vi/clients/sea-flight/reservations/create_edit_bags3.py,
line 38, in ?
create_edit_bags3()
File
I'm canceling this thread. It belongs in the Python list. Sorry!
V
On Fri, May 21, 2010 at 1:24 PM, Victor Subervi victorsube...@gmail.comwrote:
Hi;
When I try to execute this code from my Python script, I get this error:
Traceback (most recent call last):
File
On Wed, May 19, 2010 at 12:02 PM, Shawn Green shawn.l.gr...@oracle.comwrote:
Victor Subervi wrote:
On Wed, May 19, 2010 at 10:59 AM, Shawn Green shawn.l.gr...@oracle.com
wrote:
Shawn Green wrote:
look again closely at your FK definitions. The pattern should be
FOREIGN KEY
On Tue, May 18, 2010 at 2:23 PM, Shawn Green shawn.l.gr...@oracle.comwrote:
Shawn Green wrote:
I may be confused but how can the ID of the Passengers table be both the ID
of the Flight they are taking and their Customer ID at the same time?
Victor Subervi wrote:
On Tue, May 18, 2010 at 2:23 PM, Shawn Green shawn.l.gr...@oracle.comwrote:
Shawn Green wrote:
I may be confused but how can the ID of the Passengers table be both the ID
of the Flight they are taking and their Customer ID at the same time?
On Wed, May 19, 2010 at 10:59 AM, Shawn Green shawn.l.gr...@oracle.comwrote:
Shawn Green wrote:
AH! that's your mistake. You think that creating the FK will also create
the column. That does not happen. You have to define the table completely
before you can associate the columns on this
Victor Subervi wrote:
On Wed, May 19, 2010 at 10:59 AM, Shawn Green shawn.l.gr...@oracle.comwrote:
Shawn Green wrote:
AH! that's your mistake. You think that creating the FK will also create
the column. That does not happen. You have to define the table completely
before you can associate the
Hi;
mysql create table if not exists Passengers (id int unsigned auto_increment
primary key, foreign key (id) references Flights (flights_id), foreign key
(id) references Customers (customer_id), name varchar(40), weight
tinyint(3));
Query OK, 0 rows affected (0.00 sec)
mysql select c.first_name,
You're not specifying an engine, and the default is MyISAM, which doesn't
support foreign keys and will likely silently ignore requests for them. Can
you confirm that you've changed the default engine to InnoDB ?
On Tue, May 18, 2010 at 3:44 PM, Victor Subervi victorsube...@gmail.comwrote:
Hi;
On Tue, May 18, 2010 at 10:06 AM, Johan De Meersman vegiv...@tuxera.bewrote:
You're not specifying an engine, and the default is MyISAM, which doesn't
support foreign keys and will likely silently ignore requests for them. Can
you confirm that you've changed the default engine to InnoDB ?
On Tue, May 18, 2010 at 6:00 PM, Victor Subervi victorsube...@gmail.comwrote:
So apparently it didn't like my foreign key. Do I need to do something with
the table I'm referencing or what?
TIA.
Well, quickfix is to convert your tables to innoDB, starting with the
lowest-level (foreign-key
Johan De Meersman wrote:
On Tue, May 18, 2010 at 6:00 PM, Victor Subervi victorsube...@gmail.comwrote:
So apparently it didn't like my foreign key. Do I need to do something with
the table I'm referencing or what?
TIA.
Well, quickfix is to convert your tables to innoDB, starting with the
On Tue, May 18, 2010 at 1:09 PM, Shawn Green shawn.l.gr...@oracle.comwrote:
Johan De Meersman wrote:
For additional details about failed FK attempts, check the error details in
the SHOW INNODB STATUS report.
I get this:
100518 10:26:22 Error in foreign key constraint of table
Victor Subervi wrote:
On Tue, May 18, 2010 at 1:09 PM, Shawn Green shawn.l.gr...@oracle.com
mailto:shawn.l.gr...@oracle.com wrote:
Johan De Meersman wrote:
For additional details about failed FK attempts, check the error
details in the SHOW INNODB STATUS report.
I get this:
syntax problem
Thanks for the replies. It was my understanding that whitespace is
ignored,
and I did not think that not having space, in particular with . would
result in an error message.
Gary
Gary gp...@paulgdesigns.com wrote in message
news:20100426233621.10789.qm...@lists.mysql.com
I cant seem to get this working.
$query=SELECT im.image_id, im.caption, im.where_taken, im.description,
im.image_file, im.submitted, kw.fox, kw.wolves, kw.wildlife, kw.american,
kw.scenic, kw.birds, kw.africa, kw.eagles, kw.hunter .
FROM *images AS im.JOIN keywords AS kw USING (image_id) .
On 4/26/10 7:36 PM, Gary gp...@paulgdesigns.com wrote:
I cant seem to get this working.
$query=SELECT im.image_id, im.caption, im.where_taken, im.description,
im.image_file, im.submitted, kw.fox, kw.wolves, kw.wildlife, kw.american,
kw.scenic, kw.birds, kw.africa, kw.eagles, kw.hunter .
I am reading this on a tiny screen but it looks like you need
whitespace before the where.
On 4/26/10, Gary gp...@paulgdesigns.com wrote:
I cant seem to get this working.
$query=SELECT im.image_id, im.caption, im.where_taken, im.description,
im.image_file, im.submitted, kw.fox, kw.wolves,
Thanks for the replies. It was my understanding that whitespace is ignored,
and I did not think that not having space, in particular with . would
result in an error message.
Gary
Gary gp...@paulgdesigns.com wrote in message
news:20100426233621.10789.qm...@lists.mysql.com...
I cant seem to
Hello List,
I am kind of novice to MySQL
I am using MySQL 5.1.44 with partitioning.
I have a table with daily partitions. Master table and child tables are in
innodb engine.
Few days before I have created partition for april month from 1st to 30th.
Everything was working properly till today
alba.albetti wrote:
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written
C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says Enter password: and I've given enter and I
get
mysqladmin: connect to server at
what is mysql2010, it it host name or password.
If password, there cannot be space for a password, it its host, then dont
use if u connecting from the server.
regards
anandkl
On Fri, Apr 9, 2010 at 2:06 AM, Michael Dykman mdyk...@gmail.com wrote:
If you want to specify the password itself on
On Wed, 2010-04-07 at 21:37 -0700, Karthick Subramanian wrote:
I need to read an array's content using a while loop and inside the loop
read another array's content. Using the variables from the two arrays I need
to execute a query. My problem is the inner while loop reads all records
On Thu, Apr 8, 2010 at 10:25 AM, nwood nw...@plus.net wrote:
OK, at a 5 minute glance:
1.) I think the reason it isn't working is that MySQL/PHP don't support
reading from two buffered result sets concurrently: read from one then
the other.
Specifically, it doesn't support multiple buffered
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written
C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says Enter password: and I've given enter and I
get
mysqladmin: connect to server at 'localhost' failed
At 09:02 AM 4/8/2010, alba\.albetti wrote:
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've
written C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says Enter password: and I've given enter
and I get
mysqladmin:
don't have a space between '-p' and 'password', i.e. -ppassword
/ Carsten
alba.albetti skrev:
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written
C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says Enter
201 - 300 of 8646 matches
Mail list logo