SQL 中的 MID 函数

2025年3月17日 | 阅读 8 分钟

结构化查询语言（SQL）中的 MID 字符串函数可以显示原始字符串中特定索引值开始的字符或子字符串。SQL 还允许您将 MID 函数与表一起使用。MID 函数类似于 SUBSTR 字符串函数。

MID 字符串函数语法

语法1：此语法使用 SQL 表的列名执行 MID 函数

SELECT MID(Column_Name, Starting_Index_value, Number_of_Characters) AS Alias_Name FROM Table_Name;

在此语法中，我们必须指定要执行 MID() 函数的列名。这里的 Number_of_Characters 参数是可选的。如果省略，则此函数将从起始索引值提取整个字符串。

语法2：此语法使用字符串执行 MID 函数

语法2：此语法使用单个字符执行 MID 函数

MID 字符串函数示例

示例 1：以下 SELECT 查询显示了给定字符串中第 17 个位置的字符。

此 SQL 查询在字符串的第 17 个位置之后返回 24 个字符（包括空格）。

输出

website for professionals

示例 2：以下 SELECT 查询显示给定字符串中从第 -17 个位置开始的字符

此 SQL 查询显示从字符串的最后一个第 17 个位置开始的五个字符。

输出

website for professionals

示例 3：以下 SELECT 查询显示了字符串中第 5 个位置之后的所有字符。

输出

Delhi IS the Capital OF India

示例 4：以下 SELECT 查询显示字符串第 8 个位置的单个字符。

输出

示例 5：此示例将 MID 函数与 SQL 表一起使用

在此示例中，我们将创建一个新表，并在其上执行 MID 函数。

创建新 SQL 表的语法在下面的块中提及

CREATE TABLE table_name
(
First_Column_of_table Data Type (character_size of 1st Column),  
Second_Column_of_table Data Type (character_size of the 2nd column ),  
Third_Column_of_table Data Type (character_size of the 3rd column),  
...  

Last_Column_of_table Data Type (character_size of the Nth column)
);  

以下 CREATE 语句创建了 Schoolboy_Marks 表

CREATE TABLE Schoolboy_Marks
(
Schoolboy_ID INT NOT NULL PRIMARY KEY,  
Schoolboy_First_Name VARCHAR (100),  
Schoolboy_Middle_Name VARCHAR (100),  
Schoolboy_Last_Name VARCHAR (100), 
Schoolboy_Class INT NOT NULL,
Schoolboy_City Varchar(120),
Schoolboy_State Varchar (80),
Schoolboy_Marks INT 
);

以下 INSERT 查询将学院教职员的记录插入 Schoolboy_Marks 表

INSERT INTO Schoolboy_Marks 
(Schoolboy_ID, Schoolboy_First_Name, Schoolboy_Middle_Name, Schoolboy_Last_Name, Schoolboy_Class, Schoolboy_City, Schoolboy_State, Schoolboy_Marks) 
VALUES ( 4002, Vishal, Gurr, Sharma, 8, Murthal, Haryana, 95 );

INSERT INTO Schoolboy_Marks 
(Schoolboy_ID, Schoolboy_First_Name, Schoolboy_Middle_Name, Schoolboy_Last_Name, Schoolboy_Class, Schoolboy_City, Schoolboy_State, Schoolboy_Marks) 
VALUES (4007, Raj, singhania, Gupta, 6, Ghaziabad, Uttar Pradesh, 91);

INSERT INTO Schoolboy_Marks 
(Schoolboy_ID, Schoolboy_First_Name, Schoolboy_Middle_Name Schoolboy_Last_Name, Schoolboy_Class, Schoolboy_City, Schoolboy_State, Schoolboy_Marks)  
VALUES (4004, Yash, Chopra, Singhania, 9, Jaipur, Rajasthan, 85);

INSERT INTO Schoolboy_Marks 
(Schoolboy_ID, Schoolboy_First_Name, Schoolboy_Middle_Name, Schoolboy_Last_Name, Schoolboy_Class, Schoolboy_City, Schoolboy_State, Schoolboy_Marks) 
VALUES (4011, Vinay, Sharma, Roy, 8, Chandigarh, Punjab, 94);

INSERT INTO Schoolboy_Marks 
(Schoolboy_ID, Schoolboy_First_Name, Schoolboy_Middle_Name, Schoolboy_Last_Name, Schoolboy_Class, Schoolboy_City, Schoolboy_State, Schoolboy_Marks) 
VALUES (4006, Manoj, singhania, Gupta, 5, Ghaziabad, Uttar Pradesh, 83);


INSERT INTO Schoolboy_Marks 
(Schoolboy_ID, Schoolboy_First_Name, Schoolboy_Middle_Name, Schoolboy_Last_Name, Schoolboy_Class, Schoolboy_City, Schoolboy_State, Schoolboy_Marks) 
VALUES (4010, Ram, Raheem, Gupta, 9, Lucknow, Uttar Pradesh, 89);

以下 SELECT 语句显示上述 Schoolboy_Marks 表的插入记录

Schoolboy_Id	Schoolboy_First_Name	Schoolboy_Middle_Name	Schoolboy_Last_Name	Schoolboy_Class	Schoolboy_City	Schoolboy_State	Schoolboy_Marks
4001	阿曼	Roy	Sharma	4	昌迪加尔	旁遮普邦	88
4002	Vishal	Gurr	Sharma	8	Murthal	哈里亚纳邦	95
4007	Raj	singhania	古普塔	6	Ghaziabad	北方邦	91
4004	Yash	Chopra	Singhania	9	斋浦尔	拉贾斯坦邦	85
4011	Vinay	Sharma	Roy	8	昌迪加尔	旁遮普邦	94
4006	马诺吉	Singhania	古普塔	5	Ghaziabad	北方邦	83
4010	Ram	Raheem	古普塔	9	勒克瑙	北方邦	89

查询 1：以下 SELECT 查询将 MID 函数与上述 Schoolboy_Marks 表的 Schoolboy_Last_Name 列一起使用

SELECT Schoolboy_Last_Name, MID(Schoolboy_Last_Name, 2, 4) AS MID_2_4 FROM Schoolboy_Marks;

此 SQL 语句显示每个学生姓氏的第 2 个位置之后的四个字符。

输出

Schoolboy_Last_Name	MID_2_4
Sharma	harm
Sharma	harm
古普塔	upta
Singhania	ingh
Roy	oy
古普塔	upta
古普塔	upta

查询 2：以下 SELECT 查询将 MID 函数与上述 Schoolboy_Marks 表的 Schoolboy_Last_Name 列一起使用

SELECT Schoolboy_Last_Name, MID(Schoolboy_Last_Name, -3, 2) AS MID_-3_2 FROM Schoolboy_Marks;</p>
<p>This SQL statement shows the two characters from the third last position of the Last name of each student.</p>
<p><strong>Output:</strong></p>
<table class="alt">
<tr>
	<th>Schoolboy_Last_Name</th>
	<th>MID_-3_2</th>
</tr>
<tr>
	<td>Sharma</td>
	<td>rm</td>
</tr>
<tr>
	<td>Sharma</td>
	<td>rm</td>
</tr>
<tr>
	<td>Gupta</td>
	<td>pt</td>
</tr>
<tr>
	<td>Singhania</td>
	<td>ni</td>
</tr>
<tr>
	<td>Roy</td>
	<td>Ro</td>
</tr>
<tr>
	<td>Gupta</td>
	<td>pt</td>
</tr>
<tr>
	<td>Gupta</td>
	<td>pt</td>
</tr>
</table>

<hr/>
<div class="nexttopicdiv">
<span class="nexttopictext">Next Topic</span><span class="nexttopiclink"><a href="repeat-function-in-sql">REPEAT Function in SQL</a></span>
</div>

<!-- link -->
<br/><br/>

<div id="bottomnext">
<a style="float:left" class="next" href="substr-function-in-sql">← prev</a>
<a style="float:right" class="next" href="repeat-function-in-sql">next →</a>
</div>

<br/><br/>
</td></tr>
</table>
</div>
 

<hr class="hrhomebox"/>

               <div><img class="lazyload" data-src="https://images.tpointtech.com/images/youtube-32.png" style="vertical-align:middle;" alt="Youtube" />
               <span class="h3" style="vertical-align:middle;font-size:22px"> For Videos Join Our Youtube Channel: <a href="https://bit.ly/2FOeX6S" target="_blank"> Join Now</a></span>
               </div>
               <hr class="hrhomebox"/>


 

<h3 class="h3">Feedback</h3>
<ul class="points">     
<li>Send your Feedback to feedback@javatpoint.com</li>
</ul>
<hr class="hrhomebox"/>
 
<h2 class="h2">Help Others, Please Share</h2>
<a rel="nofollow" title="Facebook" target="_blank" href="https://#/sharer.php?u=https://tpointtech.cn/mid-function-in-sql"><img src="https://tpointtech.cn/images/facebook32.png" alt="facebook"/></a>
<a rel="nofollow" title="Twitter" target="_blank" href="https://twitter.com/share?url=https://tpointtech.cn/mid-function-in-sql"><img src="https://tpointtech.cn/images/twitter32.png" alt="twitter"/></a>
<a rel="nofollow" title="Pinterest" target="_blank" href="https://www.pinterest.com/pin/create/button/?url=https://tpointtech.cn/mid-function-in-sql"><img src="https://tpointtech.cn/images/pinterest32.png" alt="pinterest"/></a>
<!-- contribute start-->

<hr class="hrhomebox"/>
 
<!-- latest tutorials start --> 
<fieldset class="gra1">
<h2 class="h3">Learn Latest Tutorials</h2>
<div class="firsthomecontent">

                        <a href="https://tpointtech.cn/splunk">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/splunk.png" alt="Splunk tutorial" />
                                <p>Splunk</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/spss">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/spss.png" alt="SPSS tutorial" />
                                <p>SPSS</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/swagger">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/swagger.png" alt="Swagger tutorial" />
                                <p>Swagger</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/t-sql">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/transact-sql.png" alt="T-SQL tutorial" />
                                <p>Transact-SQL</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/tumblr">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/tumblr.png" alt="Tumblr tutorial" />
                                <p>Tumblr</p>
                            </div>
                        </a>

                        <a href="https://tpointtech.cn/reactjs-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/react.png" alt="React tutorial" />
                                <p>ReactJS</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/regex">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/regex.png" alt="Regex tutorial" />
                                <p>Regex</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/reinforcement-learning">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/react.png" alt="Reinforcement learning tutorial" />
                                <p>Reinforcement Learning</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/r-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/r-programming.png" alt="R Programming tutorial" />
                                <p>R Programming</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/rxjs">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/rxjs.png" alt="RxJS tutorial" />
                                <p>RxJS</p>
                            </div>
                        </a>

                        <a href="https://tpointtech.cn/react-native-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/react-native.png" alt="React Native tutorial" />
                                <p>React Native</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/python-design-pattern">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/python-design-patterns.png" alt="Python Design Patterns" />
                                <p>Python Design Patterns</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/python-pillow">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/python-pillow.png" alt="Python Pillow tutorial" />
                                <p>Python Pillow</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/python-turtle-programming">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/python-turtle.png" alt="Python Turtle tutorial" />
                                <p>Python Turtle</p>
                            </div>
                        </a>

                        <a href="https://tpointtech.cn/keras">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/keras.png" alt="Keras tutorial" />
                                <p>Keras</p>
                            </div>
                        </a>

</div> 
</fieldset> 
<hr class="hrhomebox"/>
<!-- preparation start -->  
<fieldset class="gra1">
<h2 class="h3">Preparation</h2>
<div class="firsthomecontent"> 
 
                        <a href="https://tpointtech.cn/aptitude/quantitative">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/aptitude/images/quantitative-aptitude-home.png" alt="Aptitude" />
                                <p>Aptitude</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/reasoning">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/reasoning/images/reasoning-home.png" alt="Logical Reasoning" />
                                <p>Reasoning</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/verbal-ability">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/verbal-ability/images/verbal-ability-home.png" alt="Verbal Ability" />
                                <p>Verbal Ability</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/interview-questions-and-answers">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/logo/interviewhome.png" alt="Interview Questions" />
                                <p>Interview Questions</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/company-interview-questions-and-recruitment-process">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/interview/images/company-home.jpeg" alt="Company Interview Questions" />
                                <p>Company Questions</p>
                            </div> 
                        </a> 

</div>
</fieldset>
<hr class="hrhomebox"/>

<!-- trending start -->  
<fieldset class="gra1">
<h2 class="h3">Trending Technologies</h2>
<div class="firsthomecontent">

                        <a href="https://tpointtech.cn/artificial-intelligence-ai">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/artificial-intelligence.png" alt="Artificial Intelligence" />
                                <p>Artificial Intelligence</p>
                            </div> 
                        </a> 
                        <a href="https://tpointtech.cn/aws-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/amazon-web-services.png" alt="AWS Tutorial" />
                                <p>AWS</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/selenium-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/selenium.png" alt="Selenium tutorial" />
                                <p>Selenium</p>
                            </div>
                        </a> 
                        <a href="https://tpointtech.cn/cloud-computing">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/cloud-computing.png" alt="Cloud Computing" />
                                <p>Cloud Computing</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/hadoop-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/hadoop.png" alt="Hadoop tutorial" />
                                <p>Hadoop</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/reactjs-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/reactjs.png" alt="ReactJS Tutorial" />
                                <p>ReactJS</p>
                            </div> 
                        </a>  
                        <a href="https://tpointtech.cn/data-science">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/data-science.png" alt="Data Science Tutorial" />
                                <p>Data Science</p>
                            </div> 
                        </a>  
                        <a href="https://tpointtech.cn/angular-7-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/angular7.png" alt="Angular 7 Tutorial" />
                                <p>Angular 7</p>
                            </div> 
                        </a>  
                        <a href="https://tpointtech.cn/blockchain-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/blockchain.png" alt="Blockchain Tutorial" />
                                <p>Blockchain</p>
                            </div>  
                        </a> 
                        <a href="https://tpointtech.cn/git">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/git.png" alt="Git Tutorial" />
                                <p>Git</p>
                            </div> 
                        </a> 
                          <a href="https://tpointtech.cn/machine-learning">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/machine-learning.png" alt="Machine Learning Tutorial" />
                                <p>Machine Learning</p> 
                            </div>     
                        </a> 
                          <a href="https://tpointtech.cn/devops">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/devops.png" alt="DevOps Tutorial" />
                                <p>DevOps</p> 
                            </div>    
                        </a> 
 
</div>
 </fieldset>
<hr class="hrhomebox"/>

<!-- B.Tech / MCA -->
                    <fieldset class="gra1">
                    <h2 class="h3">B.Tech / MCA</h2>
                    <div class="firsthomecontent">
                        <a href="https://tpointtech.cn/dbms-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/dbms.png" alt="DBMS tutorial" />
                                <p>DBMS</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/data-structure-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/data-structures.png" alt="Data Structures tutorial" />
                                <p>Data Structures</p>
                            </div>
                        </a> 
                        <a href="https://tpointtech.cn/daa-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/daa.png" alt="DAA tutorial" />
                                <p>DAA</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/operating-system">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/operating-system.png" alt="Operating System" />
                                <p>Operating System</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/computer-network-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/computer-network.png" alt="Computer Network tutorial" />
                                <p>Computer Network</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/compiler-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/compiler-design.png" alt="Compiler Design tutorial" />
                                <p>Compiler Design</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/computer-organization-and-architecture-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/computer-organization.png" alt="Computer Organization and Architecture" />
                                <p>Computer Organization</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/discrete-mathematics-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/discrete-mathematics.png" alt="Discrete Mathematics Tutorial" />
                                <p>Discrete Mathematics</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/ethical-hacking">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/ethical-hacking.png" alt="Ethical Hacking" />
                                <p>Ethical Hacking</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/computer-graphics-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/computer-graphics.png" alt="Computer Graphics Tutorial" />
                                <p>Computer Graphics</p>
                            </div> 
                        </a>
                        <a href="https://tpointtech.cn/software-engineering">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/software-engineering.png" alt="Software Engineering " />
                                <p>Software Engineering</p>
                            </div> 
                        </a> 

                        <a href="https://tpointtech.cn/html-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/web-technology.png" alt="html tutorial" />
                                <p>Web Technology</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/cyber-security-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/cyber-security.png" alt="Cyber Security tutorial" />
                                <p>Cyber Security</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/automata-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/automata.png" alt="Automata Tutorial" />
                                <p>Automata</p>
                            </div> 
                        </a>
                        
                        <a href="https://tpointtech.cn/c-programming-language-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/c-programming.png" alt="C Language tutorial" />
                                <p>C Programming</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/cpp-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/cpp.png" alt="C++ tutorial" />
                                <p>C++</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/java-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/new/core-java.png" alt="Java tutorial" />
                                <p>Java</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/net-framework">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/dot-net.png" alt=".Net Framework tutorial" />
                                <p>.Net</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/python-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/python.png" alt="Python tutorial" />
                                <p>Python</p>
                            </div>
                        </a>

                        <a href="https://tpointtech.cn/programs-list">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/programs.png" alt="List of Programs" />
                                <p>Programs</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/control-system-tutorial">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/control-system.png" alt="Control Systems tutorial" />
                                <p>Control System</p>
                            </div>
                        </a>
                        <a href="https://tpointtech.cn/data-mining">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/data-mining.png" alt="Data Mining Tutorial" />
                                <p>Data Mining</p> 
                            </div>    
                        </a> 
                        <a href="https://tpointtech.cn/data-warehouse">
                            <div class="homecontent"><img class="lazyload" data-src="https://images.tpointtech.com/images/homeicon/data-warehouse.png" alt="Data Warehouse Tutorial" />
                                <p>Data Warehouse</p>
                            </div> 
                        </a> 


                  </div>
                </fieldset>
 

</div>

<br><br/><div class="mobilemenu" style="clear:both">

</div></div>

<div id="right">

<br/><br/>
</div>

<div class="right1024" style="float:left;margin-left:10px;margin-top:120px;">
<!-- right1024only -->

</div>
<br/>

<div id="footer" style="clear:both;width:100%">
<script>var _gaq=_gaq || []; _gaq.push(['_setAccount', 'UA-24880427-1']); _gaq.push(['_trackPageview']); (function(){var ga=document.createElement('script'); ga.type='text/javascript'; ga.async=true; ga.src=('https:'==document.location.protocol ? 'https://ssl' : 'https://www') + '.google-analytics.com/ga.js'; var s=document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);})();</script><div style="margin-top:5px;text-align:center"> <sup style="font:16px arial;">Like/Subscribe us for latest updates or newsletter </sup> <a target="_blank" rel="nofollow noopener" href="https://feeds.feedburner.com/javatpointsonoo"><img src="https://images.tpointtech.com/images/social/rss1.png" alt="RSS Feed"/></a> <a target="_blank" rel="nofollow noopener" href="https://feedburner.google.com/fb/a/mailverify?uri=javatpointsonoo"><img src="https://images.tpointtech.com/images/social/mail1.png" alt="Subscribe to Get Email Alerts"/></a> <a rel="nofollow noopener" target="_blank" href="https://#/javatpoint"><img src="https://images.tpointtech.com/images/social/facebook1.jpg" alt="Facebook Page"/></a> <a target="_blank noopener" rel="nofollow" href="https://twitter.com/pagejavatpoint"><img src="https://images.tpointtech.com/images/social/twitter1.png" alt="Twitter Page"/></a> <a target="_blank" rel="nofollow noopener" href="https://www.youtube.com/channel/UCUnYvQVCrJoFWZhKK3O2xLg"><img src="https://images.tpointtech.com/images/youtube32.png" alt="YouTube"/></a> <a target="_blank" rel="nofollow noopener" href="https://javatpoint.blogspot.com"><img src="https://images.tpointtech.com/images/social/blog.png" alt="Blog Page"/></a> </div><footer class="footer1"><div class="column4"><h3>Learn Tutorials</h3><a href="https://tpointtech.cn/java-tutorial">Learn Java</a><a href="https://tpointtech.cn/data-structure-tutorial">Learn Data Structures</a><a href="https://tpointtech.cn/c-programming-language-tutorial">Learn C Programming</a><a href="https://tpointtech.cn/cpp-tutorial">Learn C++ Tutorial</a><a href="https://tpointtech.cn/c-sharp-tutorial">Learn C# Tutorial</a><a href="https://tpointtech.cn/php-tutorial">Learn PHP Tutorial</a><a href="https://tpointtech.cn/html-tutorial">Learn HTML Tutorial</a><a href="https://tpointtech.cn/javascript-tutorial">Learn JavaScript Tutorial</a><a href="https://tpointtech.cn/jquery-tutorial">Learn jQuery Tutorial</a><a href="https://tpointtech.cn/spring-tutorial">Learn Spring Tutorial</a></div><div class="column4"><h3>Interview Questions</h3><a href="corejava-interview-questions">Java Interview Questions</a><a href="sql-interview-questions">SQL Interview Questions</a><a href="python-interview-questions">Python Interview Questions</a><a href="javascript-interview-questions">JavaScript Interview Questions</a><a href="top-angular-interview-questions">Angular Interview Questions</a><a href="selenium-interview-questions">Selenium Interview Questions</a><a href="spring-boot-interview-questions">Spring Boot Interview Questions</a><a href="job-interview-questions">HR Interview Questions</a><a href="cpp-interview-questions">C++ Interview Questions</a><a href="data-structure-interview-questions">Data Structure Interview Questions</a></div><div class="column4"><h3>About</h3><p>This website is developed to help students on various technologies such as Artificial Intelligence, Machine Learning, C, C++, Python, Java, PHP, HTML, CSS, JavaScript, jQuery, ReactJS, Node.js, AngularJS, Bootstrap, XML, SQL, PL/SQL, MySQL etc. </p><p>This website provides tutorials with examples, code snippets, and practical insights, making it suitable for both beginners and experienced developers.</p><p>There are also many interview questions which will help students to get placed in the companies.</p></div><div class="column4"><h3>Contact</h3><a href="https://tpointtech.cn/contact-us">Contact Us</a> <!--<a href="https://tpointtech.cn/subscribe.jsp">Subscribe Us</a>--> <a href="https://tpointtech.cn/privacy-policy">Privacy Policy</a><a href="https://tpointtech.cn/sitemap.xml">Sitemap</a><br><a href="https://tpointtech.cn/sonoo-jaiswal">About Me</a></div></footer><footer class="footer2"><p>© Copyright 2011-2021 www.javatpoint.com. All rights reserved. Developed by Tpoint Tech.</p></footer><div id="bot-root"></div><script> (function() { var e = document.createElement('script'); e.src = 'https://app.pushbrothers.com/js/notification-bot.js?cnfg=a3cc04a1-8471-450e-b01e-c9d752b16eb0'; document.getElementById('bot-root').appendChild(e);}());</script>
</div>
<!-- auto ad code vi -->  

</div></div>  

<script src="https://images.tpointtech.com/js/shcoreandbrush.js"></script><script> dp.SyntaxHighlighter.HighlightAll('code'); </script>
<script src="https://images.tpointtech.com/lazysizes.min.js?v=5.8" async></script>


</body> </html> 

SQL 中的 MID 函数

MID 字符串函数语法

MID 字符串函数示例

联系信息

关注我们

教程

面试题

在线编译器

Python

Java

.Net Framework

AI, ML and Data Science

Cloud Technology

B.Tech and MCA

Web Technology

PHP

Software Testing

Technical Interview

Java Interview

Python

Web Interview

Database Interview

B.Tech / MCA

Important Interview

Software Testing Interview

Company Interviews

Online Compilers

Multiple Choice Questions

SQL 教程

SQL 数据库

SQL 表

SQL Select

SQL 子句

SQL Order By

SQL Insert

SQL Update

SQL Delete

SQL Join

SQL 键

Interview

SQL 多选题

SQL 注入

区别

PL/SQL 教程

其他

SQL 字符串函数

测验

SQL 中的 MID 函数

MID 字符串函数语法

MID 字符串函数示例

相关帖子

SQL 中的 INSERT 函数

如何在 SQL 中删除单行

SQL 中的 MIN 函数

SQL 中的转换函数

如何在 SQL 中使用 DISTINCT

SQL 和 MySQL 的区别

SQL 中的 ACOS 函数

N 高薪

SQL Join 示例

SQL 中的标量函数

订阅 Tpoint Tech

联系信息

关注我们

教程

面试题

在线编译器