• Show MySQL database schema

    I'm currently in my MySQL console and I'm looking to find the schema for a specific table. What's the process to do that?

    ITKE1,011,420 pointsBadges:
  • Changing MySQL data type for single column

    For MySQL, I'm looking to change the data type (in my columns) from FLOAT to INT. NOTE - there's no current data in there. Can someone tell me the best way to do it?

    ITKE1,011,420 pointsBadges:
  • Checking MySQL tables for storage engine

    One of our MySQL databases has several tables that have been using numerous storage engines (specifically InnoDB / MyISAM). Can we find out which table is using which engine?

    ITKE1,011,420 pointsBadges:
  • How to create DB file using C#

    Is there a way I can make a DB file using C#? I can't find it in the toolbox at all. Do I have to use SQL Express? Appreciate any help.

    ITKE1,011,420 pointsBadges:
  • 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.

    ITKE1,011,420 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!

    ITKE1,011,420 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.

    ITKE1,011,420 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.

    ITKE1,011,420 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?

    ITKE1,011,420 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?

    ITKE1,011,420 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.

    ITKE1,011,420 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.

    ITKE1,011,420 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?

    ITKE1,011,420 pointsBadges:
  • Compare two table schemas in SQL Server database

    Throughout my week, I have to do random checks between a SQL Server development and release database. Usually - this is a manual process but it's quite slow now. Would I be able to compare my different table schemas automatically? Thank you very much.

    ITKE1,011,420 pointsBadges:
  • Best format to store images in SQL Server database

    For my SQL Server database, what's the best format to store images? Would binary be the best bet? Thanks so much.

    ITKE1,011,420 pointsBadges:
  • How to get number of fields in SQL Server database

    Would I be able to get the number of fields in my SQL Server database with some sort of SQL statement? I'm talking about all the entries in my database. Thank you.

    ITKE1,011,420 pointsBadges:
  • Change data path for existing SQL Server database

    My SQL Server has between 15-20 databases running on it. Now, because I'm running out of space, I'm looking to move my data path to another drive. How can I go about doing this? What SQL command should I use?

    ITKE1,011,420 pointsBadges:
  • Will streaming media work in a motorhome?

    I am new to Streaming.  A couple of questions.  How are my computers, VCR, and TV connected to the provider.  We are planning to buy a motorhome and need to know if this is a good solution to use on the road? Rex Ralston netrex@aol.com

    Rnetrex20045 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?

    ITKE1,011,420 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