mysql数据库查找指定字符串的位置并修改同一行某个数据

Public Sub upname1(ByVal in_id As String)

Dim name1 As String = "a,b,c,d"

Dim name_s() As String = Split(name1, ",")

Dim in_name As String = name_s(in_id - 1)

Dim up_m As New OleDbCommand

up_m.Connection = ole_conn

up_m.CommandText = "insert into tb1 (id1,name1) values(@id1,@name1)"

up_m.Parameters.AddWithValue("@id1", in_id)

up_m.Parameters.AddWithValue("@name1", in_name)

Try

ole_conn.Open()

up_m.ExecuteNonQuery()

ole_conn.Close()

Catch ex As Exception

ole_conn.Close()

MessageBox.Show(ex.Message)

End Try

End Sub

1、首先打开《mysql》软件，登录自己的个人账号。

2、其次将20个中文字符保存在FULLTEXT文件夹中。

3、最后使用FULLTEXT搜索来快速搜索字符串，输入20个中文字符即可快速搜索。

---