What do you want to save?
Add Code snippet
New code examples
-
PHP 2021-09-06 11:21:02
big database file into database php
<?php // Name of the file $filename = 'churc.sql'; // MySQL host $mysql_host = 'localhost'; // MySQL username $mysql_username = 'root'; // MySQL password $mysql_password = ''; // Database name $mysql_database = 'dump'; // Connect to MySQL server mysq... Add solution -
SQL 2021-09-05 21:22:02
sqlite select split string
-- using your data table assuming that b3 is suppose to be b2 WITH split(one, many, str) AS ( SELECT one, '', many||',' FROM data UNION ALL SELECT one, substr(str, 0, instr(str, ',')), substr(str, instr(str, ',')+1) FROM split WHERE s... Add solution -
Javascript 2021-09-05 02:49:02
auto increment string in javascript
function autoIncrementCustomId(lastRecordId){ let increasedNum = Number(lastRecordId.replace('ABC','')) + 1; let kmsStr = lastRecordId.substr(0,3); for(let i=0; i< 6 - increasedNum.toString().length; i++){ kmsStr = kmsStr+'0'; } kmsStr = ... Add solution