The comma at the end of the SELECT statement needs to be removed
Naz Gassiep wrote:
Hi,
I'm trying to execute this query:
SELECT group_post.group_thread_id,
FROM group_post
LEFT OUTER JOIN group_post_moderation ON (group_post.group_post_id
=
nm ... I found the problem ... I need to use BINARY(LPAD ...)
-Original Message-
From: Rob Brooks [mailto:[EMAIL PROTECTED]
Sent: Monday, December 19, 2005 10:04 AM
To: mysql@lists.mysql.com
Subject: Query Error Help
Hello, I have this query:
SELECT FL3_PatientControlNumber,
On Tue, 14 Sep 2004 19:55:42 -0700, Soheil Shaghaghi [EMAIL PROTECTED] wrote:
I have a subroutine which checks for multiple entries and if a user has
voted once in the same day, it will not calculate the vote. However, I
found out that it does not really do this.
What it does is only look at
Timotius Alfa wrote:
Pls help me guys.
what's wrong with this command ?
select a.siswa_id,a.nama,b.Nilai from Query_DataSiswa a left join ( select siswa_id,Nilai,Tes_Id from Nilai_Harian where tes_id = 1 and pertemuan = 1 and paket_id = 1 and tingkat = 1) b on a.siswa_id = b.siswa_id where
Odhiambo Washington wrote:
Hello gurus,
Please help. Where is my mistake?
I get the following error...
MYSQL: query failed: You have an error in your SQL syntax near ') rei_ts' at line 1
When I run the query below
SELECT rei_ip \
FROM relay_ip \
WHERE
HI,
The 127 error message is Record-file is crashed - use
myisamchk -r table_name
to fix it.
For further information on this topic check
http://www.mysql.com/doc/R/e/Repair.html
Hope this helps
Dobromir Velev
Web Developer
http://www.websitepulse.com/
-Original Message-
From:
hi,
try your first SELECT statement, but with
ORDER BY table1.table1_row
maybe this helps (I didnt try it).
Anton Tichawa
-Original Message-
From: Bruno FaƩ [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 5:44 PM
To: [EMAIL PROTECTED]
Subject: Query Error
Hi !
First try to find out where you socket is located:
# lsof -p {$PID_OF_MYSQL] |grep unix
mysqld 1277 root 4u unix 0xcb596580 1712 /var/lib/mysql/mysql.sock
And then point to this file in mysql conf file:
# more /etc/my.cnf
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
Did you follow the rest of the instructions?
Did you create the mysql user?
Did you run mysql_install_db --user=mysql ?
Did you start the server ?
"Foresight Systems Ltd." wrote:
Dear Sir,
We are trying to install and configure mysql version .23.32 on Linux Red
Hat 7.
Usinf the