• How to duplicate MySQL table

    I'm trying to duplicate a MySQL table - but the new table has to be empty. After that, then I have to copy the data structure from the existing table to the new one. How can I go about doing that?

    ITKE435,925 pointsBadges:
  • When does MySQL database view get updated?

    I currently have this view in MySQL: CREATE VIEW blah AS SELECT columnA FROM tableA But I need to see this specific view gets updated. How can I see that? Appreciate the help.

    ITKE435,925 pointsBadges:
  • Convert MySQL string to date

    I have a MySQL string column that is currently acting as a date and I have to select it as a date too. How can I do that? In simplier terms - I need to convert it over to a date.

    ITKE435,925 pointsBadges:
  • Updating MySQL column with NULL value

    In MySQL, is it possible to update a column with a NULL value. I tried several different times and all I have gotten is an empty string. Do I have to use a syntax?

    ITKE435,925 pointsBadges:
  • Merging two MySQL tables

    I need to merge two different MySQL tables (that have the same data structure). The biggest difference is that the primary keys are different on each table. What's the process here?

    ITKE435,925 pointsBadges:
  • How to SELECT last MySQL table row

    Would I be able to SELECT my last row in a MySQL table? I'm currently adding data and have to retrieve a value from the previous row. Appreciate it!

    ITKE435,925 pointsBadges:
  • Allow MySQL remote connection

    I recently installed MySQL on my own machine (not my company's) and I'm looking to allow remote connections. I have to connect from an external source. What's the best way to do it?

    ITKE435,925 pointsBadges:
  • MySQL error message: Server has gone away

    Our office server processes many files and sends the reports to our remote MySQL server. But over the past week, it's been stopping halfway through with this error message: 2006, mysql server has gone away None of us have seen this before. What changes to we have to make on our end?

    ITKE435,925 pointsBadges:
  • Properly remove a MySQL database

    Our department has noticed that one of our MySQL databases is becoming unusable due to constant errors (sometimes manual errors). What's the process to remove it? One key - we would like to use the foreign keys again but if we can't, then we can't.

    ITKE435,925 pointsBadges:
  • Clear MySQL query cache

    My partner and I can't seem to figure out how we can clear the MySQL query cache without restarting our server. It's a SQL Server too. Thanks for the help!

    ITKE435,925 pointsBadges:
  • Export and import .SQL file using MySQL command line

    A coworker wants to me send me a .SQL file and I have to export / import that file to / from our MySQL database using the command line. What's the command to do that? Could I possible use mysqldump? Quick note: The file might have several constraints too.

    ITKE435,925 pointsBadges:
  • Determine disk space on MySQL table

    Can I figure out how much disk space my MySQL table is using? The table is in InnoDB. What can I do?

    ITKE435,925 pointsBadges:
  • Backup single MySQL database table

    Is there a chance I could backup just one single table in a MySQL database? I tried mysqldump but that backed up the entire database. Thanks.

    ITKE435,925 pointsBadges:
  • How can I enable the MySQL query log?

    Would I be able to enable the MySQL query log function so each SQL query statement that we received from our clients is logged correctly (including time)? Can I use phpMyAdmin to do this? Thank you.

    ITKE435,925 pointsBadges:
  • Import MySQL database from terminal

    Can my partner and I import out MySQL database from terminal? For some reason - we can't come up with the right syntax.

    ITKE435,925 pointsBadges:
  • How to log MySQL queries

    How can I turn on my audit logging for a MySQL database? My boss asked me to monitor all of the queries that come in every hour, followed by dumping the log into a file. Is that even possible?

    ITKE435,925 pointsBadges:
  • 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?

    ITKE435,925 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?

    ITKE435,925 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?

    ITKE435,925 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.

    ITKE435,925 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