• 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!

    ITKE413,315 pointsBadges:
  • Export MySQL database in phpMyAdmin to PC

    I have a MySQL database in phpMyAdmin that has over a million records. I have to export it to my other PC but when I tried, it's only adding roughly 250,000 records into a .SQL file. What happened to the rest of the records? How can I do this efficiently?

    ITKE413,315 pointsBadges:
  • MySQL: How to create InnoDB database

    In MySQL, I recently tried to create a InnoDB database type. This is the query I tried but didn't work: CREATE DATABASE "mydd" ENGINE = InnoDB My configuration says InnoDB is enabled. What else can I do? Thank you.

    ITKE413,315 pointsBadges:
  • Delete duplicate records in MySQL database

    One of our clients asked us to delete duplicate records in a SQL Server database and a MySQL database. We did it in SQL but MySQL is giving us issues. It says the format of the query is not correct. Does anyone know of a way to do this? Thank you so much!D

    ITKE413,315 pointsBadges:
  • MySQL command to find table in database

    For MySQL - does anyone know of a command that I can use to help me find one particular table in all the databases? I hate to admit this - I forgot where the table is. Thank you so much.

    ITKE413,315 pointsBadges:
  • Change MySQL database to read-only

    For my MySQL database, I have to change one of my tables to read-only to every single user. What's the process to do that? Thanks!

    ITKE413,315 pointsBadges:
  • Storing an image in MySQL database

    I'm trying to store an image in MySQL database but I can't figure out the process. I already have a table (with BLOB datatype) but that's how far I have gotten. Can someone help me out?

    ITKE413,315 pointsBadges:
  • Connect Visual Studio 2013 with MySQL database

    I'm currently using Visual Studio 2013, but for some reason, I can't find MySQL database in the choose data source dialog window. I have MySQL connector and installer installed. Do I need something else?

    ITKE413,315 pointsBadges:
  • Finding relations between MySQL tables

    How can I find the relations between all of my MySQL tables? My database has roughly 100 - 200 tables and I need to find out their relation. Is this actually possible? Thanks!

    ITKE413,315 pointsBadges:
  • Where can I find the SQL file after MySQL dump?

    After successful connection using SSH and entering right login credentials, I'm not able to find out the backup SQL file. Any help would be really appreciated.

    AjitK292,400 pointsBadges:
  • Convert MySQL syntax to PostgreSQL

    Does anyone know if there's a tool that can help me convert a MySQL syntax to PostgreSQL? Would mysqldump be an option for me? Thank you.

    ITKE413,315 pointsBadges:
  • Check MySQL databases using Command Line Client

    I'm fairly new to MySQL - specifically creating new databases. I've created several tables using MySQL WorkBench but I need to check them using the Command Line Client. How can I use the command line? Thank you so much.

    ITKE413,315 pointsBadges:
  • How to store a MySQL database in source control

    My department is currently working on an application and we have to store our MySQL database in source control. What's the best way to do that? We were thinking of having two different files: Script for the tables Inserts for the sample data Would that be a good way to do it? Thank you very much.

    ITKE413,315 pointsBadges:
  • Deleting views from MySQL database

    I'm trying to delete all views from my MySQL database. How can I do that? I'm stuck. Is there a query I can use? Thank you so much.

    ITKE413,315 pointsBadges:
  • Storing XML data in MySQL database

    How can I go about storing my XML data into a MySQL database? It's pretty complex data so I want to make sure it's done the right way. Do I have to use foreign keys?

    ITKE413,315 pointsBadges:
  • How to import MySQL database dump file in Java

    Is there a way for me to import my MySQL database dump file programmatically in a Java program? I've tried the below code but nothing is working. Connection conn = dbConnectionSource.getConnection(); Statement stmt = conn.createStatement(); stmt.execute(FileUtils.readFileToString(new...

    ITKE413,315 pointsBadges:
  • MySQL: Get last deleted ID

    In MySQL, is there a way for me to get the actual last deleted ID after a row has been deleted? Perhaps a command / query that's similar to getting the last inserted ID. Thanks.

    ITKE413,315 pointsBadges:
  • Error when accessing MySQL database through web admin console

    For the past week, I've been trying to access a MySQL database through the web admin console. But I keep getting this strange error message: SQL select table_schema,table_name from information_schema.views where table_schema = ? failed : Got error 28 from storage engine. What should I do?

    ITKE413,315 pointsBadges:
  • Loading image into MySQL database from Excel file

    I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

    Wlm49hv5 pointsBadges:
  • Partition MySQL database by date automatically

    My colleague and I have a MySQL database that we need to partition by date (especially the month / year). But when we add new data, we don't want to update the database manually. How can we do it automatically? What's the process? Thank you.

    ITKE413,315 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