esigns.com]
> Sent: April 26, 2010 10:29 PM
> To: mysql@lists.mysql.com
> Subject: Re: Join 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 "." wou
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"" wrote in message
news:20100426233621.10789.qm...@lists.mysql.com...
I cant seem to get this working.
I am reading this on a tiny screen but it looks like you need
whitespace before the where.
On 4/26/10, Gary 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.ameri
On 4/26/10 7:36 PM, "Gary" 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" .
> "FROM *images A
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)" .
Thanks for the tip. I am looking at just making 16 separate queries.
It will be easier to manage and faster to run.
Dan
On Sep 6, 2008, at 9:37 PM, Brent Baisley <[EMAIL PROTECTED]> wrote:
Well, for your simple example, you can use query variables to add
the "counters".
SET @cntr:=0, @last
Well, for your simple example, you can use query variables to add the
"counters".
SET @cntr:=0, @lastVal:='A'
INSERT INTO tableB LOC,DATA SELECT CONCAT(LOC,
CONCAT( IF(@lastVal=LOC, @cntr:[EMAIL PROTECTED], @cntr:=0),
IF(@lastVal:=LOC,'',''))) LOC, CONCAT(DATA, @cntr) FROM tableA ORDER
BY
I have an existing data set - here is an example (the real one is more
complex than this)
LOC DATA
-
A 1
B 2
C 3
D 4
E 5
F 6
...
and I am looking to run some sort of INSERT ... SELECT on this to make
a new table like this:
LOC DATA
Field was wrongly named - Cheers!
--
View this message in context:
http://www.nabble.com/Syntax-Problem-tf2779708.html#a7756233
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
> I have a query running within a project from a Windows machine retrieving
> data from a Linux Source the query works perfectly. If i upload the exact
> same project to the Linux machine and run it the query doesnt work ??!!??
>
> the query string is ...
>
> SELECT DISTINCT ID, BatchID FROM Conta
am i going mad ?
Cheers
JugLugs
--
View this message in context:
http://www.nabble.com/Syntax-Problem-tf2779708.html#a7755229
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
Select syntax is correct on my 4.1.10a MySQL instance.
EXPLAIN is telling me 'Impossible WHERE' until I put
values in the tables so the query could produce at
least several rows. After that everything was OK.
Graham Anderson <[EMAIL PROTECTED]> wrote:
> this sql works on mys
this sql works on mysql version 3.23.58...my remote server
SELECT c.City, r.Region, co.Country
FROM subnets s, cities c, regions r, countries co
WHERE c.CityId = s.CityId
AND c.RegionID = r.RegionID
AND c.CountryID = co.CountryId
AND s.SubNetAddress = '24.24.172'
LIMIT 0 , 30
but the same syntax fa
--- Ligaya Turmelle <[EMAIL PROTECTED]> wrote:
> Think I found it. I made the changes with
> explanations of what I did.
> If you have any further questions feel free to ask.
> Oh and this should
> be on the list for others to see and maybe learn
> from
Wow, thanks so much for going to all th
Think I found it. I made the changes with explanations of what I did.
If you have any further questions feel free to ask. Oh and this should
be on the list for others to see and maybe learn from
Respectfully,
Ligaya Turmelle
[DATABASE CONNECTION]
Country
> -Original Message-
> From: David Blomstrom [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 10, 2004 4:08 PM
> To: [EMAIL PROTECTED]
> Subject: SQL Syntax Problem
>
> $sql = 'SELECT
> F.IDArea,
> C.IDArea, C.Name, C.Pop, C.Nationality,
> C.Nation
First echo out the SQL and verify it is what you are expecting. If it
isn't try changing it to:
$sql =
'SELECT F.IDArea,
C.IDArea,
C.Name,
C.Pop,
C.Nationality,
C.NationalityPlural,
C.NationalityAdjective
FROM cia_people C, famarea2 F
WHERE (C.Nati
It's not translating your vars to their respective values.
I didn't look to see why...
But MySQL doesn't know what
$_POST['order']
is.
David Blomstrom wrote:
This may be a purely PHP problem, but the error
message says "SQL syntax. Check the manual that
corresponds to your MySQL server version.
This may be a purely PHP problem, but the error
message says "SQL syntax. Check the manual that
corresponds to your MySQL server version..."
More important, I haven't been able to find a solution
on any PHP forums. :)
This is the complete error message:
Failed to run SELECT F.IDArea, C.IDArea, C
* Franz Edler
> I have a perhaps simple problem, but it's a problem for me:
>
> I have made the following GRANT statement:
> mysql> GRANT ALL ON ser.* TO [EMAIL PROTECTED];
> Query OK, 0 rows affected (0.01 sec)
>
> But when I want to REVOKE the GRANT I get the following syntax error:
>
> mysql
Hi,
I have a perhaps simple problem, but it's a problem for me:
I have made the following GRANT statement:
mysql> GRANT ALL ON ser.* TO [EMAIL PROTECTED];
Query OK, 0 rows affected (0.01 sec)
But when I want to REVOKE the GRANT I get the following syntax error:
mysql> REVOKE ALL ON ser.* TO [EM
I think your INSERT syntax is wrong. There is no "TABLE" in the syntax.
It has to be INSERT INTO admin VALUES .
- Shanta
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 2:03 PM
To: [EMAIL PROTECTED]
Subject: ENCRYPT Synt
, ensure the number of columns your inserting
match the schema of the table - if not explicitly specify the columns.
Regards,
Adam
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 3:03 PM
To: [EMAIL PROTECTED]
Subject: ENCRYPT Syntax problem
Dear list:
I`m trying to insert some values into my table but I received a error
message when I type::
INSERT INTO TABLE admin VALUES ('admin',ENCRYPT('system'),15,0);
The error said:
Error 1064: You have an error in SQL syntax.
Could someone help me to clarify the correct syntax for ENCRYPT
Hello,
This sql query works fine with mysql 4.0.15, but it gives an error with
mysql 3.23.49:
SELECT officiele_naam, rechtsvorm, activiteit1, activiteit2, adres, postnummer,
gemeente, Biogarantie, Hefboom, Netwerk_Vlaanderen, Vibe, Fair_Trade, NULL , Vosec,
Solidr, Demeter, Europees_Ecolabel, B
David,
Tuesday, November 19, 2002, 5:20:23 PM, you wrote:
DN> (sorry if this is a duplicate -- I don't think the original made it)
DN> Running mysql 3.23.53-max binary on a RedHat 7.2 based server. Replication
DN> is working fine, but I'm running into errors with the replicate-rewrite-db
DN> dir
Hi All,
(sorry if this is a duplicate -- I don't think the original made it)
Running mysql 3.23.53-max binary on a RedHat 7.2 based server. Replication
is working fine, but I'm running into errors with the replicate-rewrite-db
directive. Here's a snippet from my my.cnf file on the slave:
maste
Hi All,
Running mysql 3.23.52-max binary on a RedHat 7.2 based server. Replication
is working fine, but I'm running into errors with the replicate-rewrite-db
directive. Here's a snippet from my my.cnf file on the slave:
master-port = 3306
replicate-rewrite-db=mysql->master_mysql
When I
sage -
From: "Werner Stuerenburg" <[EMAIL PROTECTED]>
To: "Sara" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, July 22, 2001 7:11 PM
Subject: Re: syntax problem
> > I rather thought that this was the whole purpose of this mailing list?
>
&g
> I rather thought that this was the whole purpose of this mailing list?
You are right both in your inquiry and in your reply to Sinisa.
It is not his usual way, though, I was astonished myself.
I think most is ok. Try
select handicap_results.date,
handicap_results.victor,
handic
after all trying to learn mysql and am a beginner.
Regards
Sara
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, July 22, 2001 11:22 AM
Subject: Re: syntax problem
> Sar
Sara writes:
> Hi
>
> I have compiled a report using Mascon only to find I can't export it to any other
>software I have! Great report but not much good to me as it is :-(
>
> (I'm not well versed in php yet, otherwise this might be an issue)
>
> However, I did get the sql query script and th
Hi
I have compiled a report using Mascon only to find I can't export it to any other
software I have! Great report but not much good to me as it is :-(
(I'm not well versed in php yet, otherwise this might be an issue)
However, I did get the sql query script and thought I could run it in Masc
On Tue, Apr 10, 2001 at 12:48:26PM +0200, Guerin Damien wrote:
> Hi,
>
> How use CHECK constraint in a CREATE TABLE declaration ??
> The language used is MySQL
> Indeed, i try many attempt but no success... Somebody could help me ??
>
> I try to do that :
>
> create table Picsou (
> nam
Hi,
How use CHECK constraint in a CREATE TABLE declaration ??
The language used is MySQL
Indeed, i try many attempt but no success... Somebody could help me ??
I try to do that :
create table Picsou (
name varchar(5)
check (name=='fifi' or name=='riri' or name=='loulou')
)
;
Bu
What is the CORRECT syntax for the mysqladmin command to start the slave
thread at a particular position in the log?
Here's the situation I ran into.
I got an error message in the slave's .err file that said the following:
010125 9:11:16 Error running query, slave aborted. Fix the problem
36 matches
Mail list logo
