Has anyone ever seen or used these type of variables when creating an sql_query?
ex...
Insert Into db.table ('id','name','address') Values(:0:, :1:, :2:)
Please let me know what the heck they are?
8 1285
No never seen it. I also never have seen a column name within single quotes. I am sure that will not work.
Ronald
No never seen it. I also never have seen a column name within single quotes. I am sure that will not work.
Ronald
Actually it's only the :0:, :1: (use of colons) that I'm concerned with...
<br />
Can't seem to find anything on it.
Atli 5,058
Expert 4TB
I have never seen this either, nor do I think this is valid syntax in either PHP or MySQL.
Only possible reason I can see for doing something like this is if you plan on using regex to replace them with valid values.
Perhaps a part of some custom template system?
Has anyone ever seen or used these type of variables when creating an sql_query?
ex...
Insert Into db.table ('id','name','address') Values(:0:, :1:, :2:)
Please let me know what the heck they are?
Actually i have seen this, but it intrigued me then but never followed through.
It has to do with variables like you said, mysql variables.
Why not check out the manual and let us know. I'd like to find out and i'm sure these two knuckleheads would like to know that this is actually valid syntax. (or there is something like this).
FOUND IT!! http://dev.mysql.com/doc/refman/6.0/...variables.html
That's in 6.0, didn't look to see in prev ver but i'm sure this isn't something new.
roverdonk, atli..... go hit the books! ;)
But your right, what he had, was not valid syntax, but I think this is where I've seen colons used. In his example 1 and 2 are variable names.
C YA!
Has anyone ever seen or used these type of variables when creating an sql_query?
ex...
Insert Into db.table ('id','name','address') Values(:0:, :1:, :2:)
Please let me know what the heck they are?
Hi,
'id' can be `id` in MySql but never seen the values clause like that... post here if anyone gets answer..
Regards,
RP
FOUND IT!! http://dev.mysql.com/doc/refman/6.0/...variables.html
That's in 6.0, didn't look to see in prev ver but i'm sure this isn't something new.
roverdonk, atli..... go hit the books! ;)
But your right, what he had, was not valid syntax, but I think this is where I've seen colons used. In his example 1 and 2 are variable names.
C YA!
Hi,
Its there in earlier version as well but not what he has written... : on both side.. or something like that...
Regards,
RP
Thanks for the help... and I'm sorry about the confusion.
It should have been
Insert Into db.table id, name, address Values(:0:, :1:, :2:)
The colons are used for user defined variables in Mysql 6.
But, in my case I believe that they are being used differently.
Possibly as stated above in a regex statement on retrieval.
Not a MySql or PHP thing.
This is a great forum...
Sign in to post your reply or Sign up for a free account.
Similar topics
by: francescomoi |
last post by:
Hi.
I'm trying to build 'MySQL-python-1.2.0' on my Linux FC2:
----------------------------------
# export PATH=$PATH:/usr/local/mysql/bin/
# export mysqlclient=mysqlclient_r
# python setup.py...
|
by: mikey |
last post by:
Hi all,
I'm having great problems trying to install the latest MySQl RPM
package onto my Red Hat Linux OS.
There is already MySQL v 3.0 pre-installed with the RH Linux
distribution disk but I...
|
by: Yun Guan |
last post by:
Hello mysql gurus,
I am trying to run perl on mysql database on Red Hat box. I want to install
DBI and DBD:mysql using CPAN:
perl -MCPAN -e shell
cpan>install DBI
The above succeeded, but...
|
by: Mike Chirico |
last post by:
Interesting Things to Know about MySQL
Mike Chirico (mchirico@users.sourceforge.net)
Copyright (GPU Free Documentation License) 2004
Last Updated: Mon Jun 7 10:37:28 EDT 2004
The latest...
|
by: Saqib Ali |
last post by:
I installed mySQL and have it running.... but I think I made a
mistake somewhere along the line...... I believe I did follow the
instructions that were provided with the distribution at:...
|
by: Alex Hunsley |
last post by:
I am trying to install the DBD::mysql perl module. However, it claims I
need mysql.h:
cpan> install DBD::mysql
CPAN: Storable loaded ok
Going to read /home/alex/.cpan/Metadata
Database was...
|
by: ./Rob & |
last post by:
Hi gang:
I'm experiencing a problem with MySQL -- I updated MySQL from version 4.1.0
to 4.1.10 and now when I login as root it doesn't show all the databases I
should have access to, nor it...
|
by: trihanhcie |
last post by:
I m currently working on a Unix server with a fedora 3 as an os
My current version of mysql is 3.23.58. I'd like to upgrade the version
to 5.0.18.
After downloading from MYSQL.COM the package on...
|
by: manish deshpande |
last post by:
Hi,
When i'm installing MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm by the following command:
rpm -i MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm the following error is being shown:
...
|
by: menzies |
last post by:
Hi, I"m new to this forum, but I have been trying all day to install DBD::mysql onto my Intel MacBook. I've read lots of forums pages and none have gotten me to a successful 'make test' or a...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| | |