• Sync SQLite data with MySQL

    My computer is running SQLite and I'm looking to make it sync correctly with a MySQL server (through an external network). How can I do that? Basically - whenever data is modified in SQLite, I need that data to be modified in MySQL too.

    ITKE976,705 pointsBadges:
  • Migrate MySQL database to SQL Server

    My MySQL database is already full of data but I need to migrate it all over to SQL Server 2008. Is there a particular script / code I need to do this? I don't want to download any third-party software. Thanks!

    ITKE976,705 pointsBadges:
  • Backup MySQL database in AWS

    I'm working with both AWS and MySQL and I noticed peculiar - my instance disappeared because of hardware failure. For that reason, should I backup my MySQL database so I don't use anything? Thank you.

    ITKE976,705 pointsBadges:
  • Delete all MySQL events

    Is there a way for me to delete an event in MySQL? For some reason, I can't find the command to do this - I have to do it one-by-one too. Is there a certain query to do this? I tried the below code but it didn't work: "DROP EVENT IF EXISTS (SELECT EVENT_NAME FROM information_schema.EVENTS)" Thanks.

    ITKE976,705 pointsBadges:
  • Restoring MySQL database from WAMP

    Due to a security scare, I recently re-installed Windows and had to move my WAMP folder to another partition. I just installed WAMP again but I need my old MySQL database. Is there a way to take it from the old / saved WAMP folder to my new partition?

    ITKE976,705 pointsBadges:
  • Web development project with streaming video

    Hello All. I have a site. Now I want a give a option to visitor to put their video on my web site. For this I have three options. Put a their video URL Put their video Embed Code. Admin put a video. End user can have option 1 and 2. and the video URL or Embed Code directly save in to my database....

    Sssintu5 pointsBadges:
  • MySQL database: Total number of fields in tables

    We have a pretty big MySQL database that has millions of records and we have to figure out the total fields (columns) defined in all of the tables. How can we do that? Is there a SQL query for this?

    ITKE976,705 pointsBadges:
  • Convert BGL data to MySQL table

    Would there be a way for me to convert BGL data to a MySQL table? Can I export it to CSV first, and then to MySQL? Thanks.

    ITKE976,705 pointsBadges:
  • How long does a MySQL query take?

    When I'm running a specific query in MySQL - I want to see how long it's running for. Is that possible? Basically, just the time takes. Thank you so much.

    ITKE976,705 pointsBadges:
  • Would MySQL handle a 50 GB file?

    I'm wondering if my MySQL database can handle a 50 GB file efficiently? It's only text too. If not, is there another type of database I should use?

    ITKE976,705 pointsBadges:
  • Do Businesses still need SQL Server?

    With all the upgrades to MySQL, has SQLServer needed to step up its game or do you think business still needs SQLServer?

    ITKE976,705 pointsBadges:
  • What are the basic parameters needed to assist an automation tool?

    My concern is what are the basic key parameters to be considered for assisting an automation tool. In my company we are automating database (MySQL - Queries) part using 1st approach: Using stored procedures. 2nd approach: Using Excel VBA Macros.  For that we need to assist some basic parameters...

    VijayVardhan5 pointsBadges:
  • Remove numeric characters from MySQL string column

    In MySQL, is there a way for me to remove all the numeric characters from the string (in a column)? Thanks so much

    ITKE976,705 pointsBadges:
  • Reset MySQL stop words for full text search

    For MySQL, can I reset the stop word list for full text search? WAMP Server is already installed so that phpMyAdmin allows me access to MySQL. But I can't figure out how to reset it. What's the process?

    ITKE976,705 pointsBadges:
  • Store .TXT files to MySQL server

    Would I be able to store files (TXT files) to my MySQL server? Is there a code for this? I appreciate the help.

    ITKE976,705 pointsBadges:
  • How to get exact count of MySQL database rows

    Is there a way for me to get the exact count of all my MySQL database rows? I tried using the code below but it's not working because the tables are InnoDB. SELECT SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'Tables'; What should I do? Thank you so much.

    ITKE976,705 pointsBadges:
  • Removing unique constraints on MySQL table

    I recently created all of the unique constraints I needed for a table in MySQL database. But how can I show them? And, if possible, can I remove them if need be?

    ITKE976,705 pointsBadges:
  • Change MySQL database timezone

    For a MySQL database, is there a way for me to change timezone? We need to change it from EST to GMT. Is there a certain code I can use for this? Thank you.

    ITKE976,705 pointsBadges:
  • How to check if SQL row exists using PHP?

    How can I check if a SQL row exists using PHP? I'm currently using MySQL. Could I use PDO (PHP data object) to do this? Thank you so much.

    ITKE976,705 pointsBadges:
  • How to reset MySQL field to default value

    Does anyone know if there's a MySQL command that would reset a field to its default value? Basically, I don't want to write my default value several times in code in the database. Thanks!

    ITKE976,705 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following