Jinu in postgreSQL
Generate the “create table” sql statement for an existing table in postgreSQL 3 Ways
In this video I have shown 3 ways to get create table statements for an existing table in postgreSQL. 1. By creating a function. CREATE OR REPLACE FUNCTION generate_create_table_statement(p_table_name varchar) RETURNS text AS $BODY$ DECLARE v_table_ddl text; column_record record; BEGIN FOR column_record IN SELECT b.nspname as schema_name, b.relname as table_name, a.attname as column_name, …
Read Write to excel using JAVA
In this video, I have shown how you can create an excel file using java. 1. Project structure. 2. DB_Connection.java, This connection class is used to connect with database. You will need to update the host,dbname,username and password according to your project. package jinuclass; import java.sql.Connection; import java.sql.DriverManager; public class DBConnection_HR { public Connection …
Import excel file which includes multiple sheets using PHP into Mysql Database
In this project we are uploading an Excel file with multiple sheets to MySQL database. We are reading the PHP file with the help of PHPExcel class. The project Structure is as shown below. You can download the complete project here. UploadExcelmysql 1. Create the MySQL table inside be DB. As we are saving the …
PHP Read CSV file and insert 10 million record into MySQL table
Here we are trying to read a CSV file with 10 million records with PHP and insert the values in MySQL table. In the video I have shown step by step how do I added this much records instantly. It took only 15 minutes to insert 10 million rows to the DB. 1. So first …
note: previous implicit declaration of ‘point_forward’ was here [SOLVED]
In this video I have shown how you can solve ‘note: previous implicit declaration of ‘point_forward’ was here’ Also the issue ‘incompatible types when assigning to type’. As shown in the video, The error was thrown on compiling the code. #include “stdio.h” struct mystruct { int item1; int item2; }; void main() { struct …
MySQL server is running with the –secure-file-priv [SOLVED]
In this video I have shown how you can solve the error “MySQL server is running with the –secure-file-priv”. This example is shown in Windows 10 PC. 1. How to see the default MySQL uploads folder. The error comes because MySQL is limiting the upload file from only one specific folder. To see the current …
Export MySQL table To Excel or CSV without any Software
In this video I have shown how you can export a MySQL table to excel or CSV without any third party software. All you can use CMD prompt to export export the table. 1. First login to your MySQL database through command prompt. You can check below link to see the steps for that. https://chillyfacts.com/connect-remote-mysql-database-using-command-prompt/ …
Best Mysql Client for Windows
In this video I have shown the Best MySQL client for windows PC. Please see the video to see how to manage the databases. Download the 32 bit here HeidiSQL_11.3_32_Portable.zip Download the 64 bit here HeidiSQL_11.3_64_Portable.zip Login screen will look like below screenshot, Enter the username and password to login. After Login you can see …
Earn Money by adding captchas in websites
In this video I have shown how you can earn money by adding captchas in your website. In this example I have shown with JAVA JSP as my webpage. You can use the same method for any front end technologies. You can download the source code I have shown in the video here solvemedia.zip
How to create a CSV file using PHP easily
In this video I have shown how to create a CSV file using PHP. The example is shown with the help of XAMPP server installed in windows 10 PC. The below code can be used to create a CSV file. <?php header(“Content-type: text/plain”); header(“Content-Disposition: attachment; filename=jinu.csv”); echo ‘”jinu”,”jawad”,”one”,”two”‘.”\n”; echo ‘”jinu”,”jawad”,”one”,”two”‘.”\n”;; echo ‘”jinu”,”jawad”,”one”,”two”‘.”\n”;; for ($x = …