Category: mysql
How to import an SQL file using the command line in MySQL
- 0
When I was working with MySql command prompt, I was wondering how to import an available sql file into the available database. First you need to open the MySql Command prompt. And select the database. Here “smartcart” is the database. Now I select that database using “use” command as below: mysql> use smartcart; Database changed…
Read MoreQuerying date with just month and day argument in MySql with PHP
- 0
While We were working on a web portal, one of the use case was to send the greeting email to the members on their birthday and anniversaries. Here we had to get all the email ID’s from the database whose birthday is today. And we set the crone job to execute this script(script to send…
Read MoreSyncing image/audio/video with parameters to the server in android
- 0
In any applications if you are working with a client server application, there is a high probability of syncing the images with some parameters to the server. We have seen lot of examples to sync the text or parameters to the server and also the image or audio or video or any files to the…
Read MoreDirectory Separators Ignored on Inserting into mySQL
- 0
Hi, I faced a problem while inserting the file path to mysql database. You can also encounter similar problem when you work with Mysql. So thought of adding this info for your information. While inserting a file path to my mysql table, I noticed that the slashes in the path are missed once they added…
Read MoreParagraph Retrieval from Mysql
- 0
Greetings of the Day!!! When I was working with one of the website Designing, I noticed a strange problem. May be it’s not a problem. But for a developer it looks like a problem. Many of us can come across such issue. So I thought of penning down the known solution for it. When you…
Read More