Use Mysql Query SET @i:=0; UPDATE tbl_fedex SET fedex_id = @i:=(@i+1)
Discy Latest Questions
Well, first rule – you should not do this. But if there is good reason, consider using such query for searching in index-based arrays: SELECT * FROM table WHERE your_field_here REGEXP '.*;s:[0-9]+:"your_value_here".*' In case you have assoc array serialized you can use: SELECT ...
Hello Guys Here we are showing how to delete duplicate row from mysql database using join query DELETE t1 FROM ot_sub_district t1 INNER JOIN ot_sub_district t2 WHERE t1.sub_district_name = t2.sub_district_name;
if you want to use all country and their related state and their city sql file then you can download from here and import in your database. Use Below Sql : Click here to download sql file of Country-State-City OutPut ...
if you want to use all phone code or country name in your web project or app. You should use this sql file. you can import that sql file. CLICK HERE TO DOWNLOAD SQL FILE
if you want to use all language code or language name in your web project or app. You should use this sql file. you can import that sql file. CLICK HERE TO DOWNLOAD SQL FILE
This error occurs while run project using Cpanel/server. If you want to save from this error on every field you don’t set the default value while creating default fields/tables. If your creating table from query than set default value like ...
How to use REPLACE() function Here we describe the replace method in MySQL MySQL REPLACE() replaces all the occurrences of a substring within a string.