MYSQL: SQL Server ADD Column Using ALTER TABLE In this time we will learn how to create a new table in MySQL. Manually it’s so easy, but we will learn it using query. So let’s start. First, decide column name which name create a new table. You can create one or multiple column with types […]
SQL Server Replace or Replace Part of String Using MySQL
Today discuss about SQL Server Replace. For this, we know about 3 parts. One is String which full or a part you want to replace, Second is old string portion and Last is new string that change the old string. Sudo code is here: Example I have face a problem to rename my domain and […]
MySQL: Get Last Inserted Record ID
MySQL: Get Last Inserted Record ID Sometimes we need to know last inserted id record in MySQL. Use this code and get last automatic generated id. In here, $conn is our MySQL connection variable.