Syntax for Query

#11

On 14-01-11 11:16, strawberry wrote:

Quote:

this forum

lol

--
Luuk

#12

El 14/01/2011 11:16, strawberry escribió/wrote:

Quote:

I agree about formatting, but isn't this easier still...
I've centrally justified it too but I don't think this forum supports BBCode.

This is not a www forum hosted by Google. It's not even a www forum.
Actually, it's not even a www service. This is Usenet, an Internet
service that's older than Google or the web itself:

http://en.wikipedia.org/wiki/Usenet

I suggest that you open an account in a Usenet provider such as
http://eternal-september.org/ and install a real Usenet client in your
computer (Thunderbird, Opera...). That will provide a better experience
for everyone. Google's web client is among the worst Usenet clients ever
written.

--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

#13

On Jan 14, 10:16*am, strawberry <zac.ca... (AT) gmail (DOT) com> wrote:

Quote:

I agree about formatting, but isn't this easier still...
I've centrally justified it too but I don't think this forum supports BBCode.

$items = implode(', ', $items);
$paigntontb = "
SELECT *
* FROM ct_bok cb
* LEFT
* JOIN resmal r
* * ON r.resmalid=cb.resmalvalid
* LEFT
* JOIN buss_plats bp
* * ON bp.buss_req = cb.bokbus
*WHERE cb.resmalvalid IN ($items)
* *AND cb.bok_adminkod < $myvar
*ORDER
* * BY bokeft
* * *, bokfor
* * *, bokanmref"

Personally I don't feel that it's easier.

As much as possible, I like to keep each main keyword on the same line
as all its operands. That way I can easily identify the main functions
of the query.

#14

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

On 14.01.2011 11:16, strawberry wrote:

Quote:

I agree about formatting, but isn't this easier still...

SELECT *
LEFT
LEFT
ORDER
, bokanmref"

lol
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBCAAGBQJNMcuwAAoJEOv3pyQoHn/lWEwP/0WZHtKEeS/c5XZTtyS/RKST
hRAxzARs9byuPUZlDtmd0JcJqogZmIT7z/6bWPXH2o9kUws2BTuG5eXHL49TnO5w
8hVptWyn/CeUjGLTlnHC5bojA9Rk+GP5GI7VQ/1Xh7ZpzR5zFRmcp6y3AvDgsYTn
QRCE5AAPR+WPtqvhLjBhKi05VdcbXsJueTDHHDjhd/1nBl/ch6IbvNvb7OaPQO1i
R4x7vZkN7aPxqGjvfwIad5pQ0rfNNDibLE1hWoetEhFdmpoCb5 426sVZw7UyGT5e
tFu9+d8xp8hHhY+JSxsQPY9WrpD+EEKiDlw6NmTZNxKSvq6sv/SrIan3vBcDk3Ac
BWwvtgg4clUOJxu7KA/dqkwgngVCMkMAoEvNQ/qoXkepfSvmwZyiI4NgMHdJIFQu
fbbaPFc5Xyh0EDjRtqyErChkpw5qi0/4pyNNHQKbi4veiEvzu/6uJb9D22sez5IS
eBHoRtR1LRkjCk2vXhxRWD9gEg7NMmeRkLZHFf0tksrQ+n8TDY /Hg8PIiSpXhfVb
S3no93ifns6Alp+ABMpZRPojw87RITDS4TliSaQ0GeA2sjksJI NaU7JgD4oXAdYu
xGCBrddKkohkLamMbkG8PCYXZTuvyfmQJ2aoG9jEsJS6zPoNGs Yb/Q+jLdb2tL8V
Jv1lCbomfeVlXgyZrOTL
=f0MT
-----END PGP SIGNATURE-----

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Syntax for Query

comp.databases.mysql comp.databases.mysql

Re: Syntax for Query - 01-14-2011 , 04:24 AM

Re: Syntax for Query - 01-14-2011 , 05:06 AM

Re: Syntax for Query - 01-14-2011 , 06:56 AM

Re: Syntax for Query - 01-15-2011 , 10:30 AM