MySQL version is greater than 5.0, there is a default database Information_schema, which holds all the database information (such as table name, column name, corresponding permissions, etc. ), through this database, we can cross-Library query,
Explode
explode-using one string to split another string
Array explode (string $separator, string $string [, int $limit])
This function returns an array of strings, each of which is a substring of string, separated by the separator of the strings
What SQL injection can doIn the "SQL Injection Basics" article describes the basic principles of SQL injection and the experimental methods, then you need to ask, what can SQL injection in the end?It is estimated that many friends would think that
Use of implode, explode, implodeexplode. The use of implode and explode. the implodeexplodeimplode function converts an array into a string, which is especially useful when combining SQL statements! For example, $ aarray (a, B, c); $ bimplode (, $ a
The explode () function in PHP is to split another string with one string and return an array of strings. The implode () function returns a string that is composed of array elements. The two functions are between the strings and the array
function
The use of Implode,explode, Implodeexplode
Implode the function of turning an array into a string, use it in combination with SQL statements!
Like what
$a = Array (' A ', ' B ', ' C ');$b = Implode (', ', $a);Echo $b;
The returned string is
Use of PHP explode function, this is my own use of explode
if (!empty ($CT)) {
if (Strpos ($ct, "|") ===false) {
mysql_query ($sql) or Die (Mysql_error ());
Exit (" ");
}else{
$ex =explode ("|", $CT);
for ($i =0; $i
$r =mysql_query ("select
The table structure of the course selection system is as follows:Student table: Student (Sno,sname,sex,age,class)Timetable: Course (cno,cname)Selected timetable: SC (Sno,cno,score)(1) Inquiry into the "database application" student number and name(2)
Is there any explode function in MYSQL like PHP? ------ solution -------------------- here is an example of the stored procedure I wrote, which contains what you want. DELIMITER $ DROPPROCEDUREIFEXISTS 'sp _ get_new_release '$ CREATEDEFINER 'root' @
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.