Category: Database

Run raw insert query or SQL file in Laravel seeder

Hey, whats up! I am working to developed a base structure for one of my SAAS application and the scenario is we need to seed good amount of data wither through Laravel seeded or from sql dump file. So, I want to do it with both - I want to run the SQL dump file … Continue reading Run raw insert query or SQL file in Laravel seeder →

Update – Please visit skpaul.me for latest posts and updates

skpaul.me

Hi, Greetings!! Thanks for visiting my blog, I have open a blog (http://skpaul.me). So from now, you will get all latest posts and updates on http://skpaul.me.   Please take a look on my personal blog (http://skpaul.me), and let me know your comments and review.   Thanks in Advance sk paul http://skpaul.me

How to find a column or filed name of a table from an entire database?

If you are working on a BIG project with lots of tables in the database, then it will be a good trick query for you to find out a column name of any table from that database.   My scenario was a bit different, I had to start work in the middle of a project … Continue reading How to find a column or filed name of a table from an entire database? →

Update (custom) XAMPP/WAMP/LAMP default landing page layout

We are building website and applications on localhost and I use XAMPP package on Linux for my local development.   After installing Xampp, we always get a default home page from Xampp and most of the time we don’t need that. Basically before writing this article I always delete all items of htdocs/www folder, but … Continue reading Update (custom) XAMPP/WAMP/LAMP default landing page layout →

Joomla! 3 installation freezes at creating database table

After long time I try to install Joomla and it is Joomla 3.3.0 and face a problem as like you. All things are ok but its taking too much time during database table creation. And here is the solution To solve this go to Your joomla folder\installation\sql\mysql and open Joomla.sql file find the term "ENGINE=InnoDB" … Continue reading Joomla! 3 installation freezes at creating database table →

PHP code to execute MySQL script

There are advanced and comfortable tools to manage your MySQL databases (i.e.  server side: phpMyAdmin, client side:  SQLyog). But sometimes you can not use those tools and need the ability to execute some SQL script on server by your own hands, easy and fast way. What to do in such situation? Use this PHP code … Continue reading PHP code to execute MySQL script →