• 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

    ITKE1,052,280 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?

    ITKE1,052,280 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.

    ITKE1,052,280 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.

    ITKE1,052,280 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?

    ITKE1,052,280 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.

    ITKE1,052,280 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.

    ITKE1,052,280 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!

    ITKE1,052,280 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?

    ITKE1,052,280 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.

    ITKE1,052,280 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

    ITKE1,052,280 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.

    ITKE1,052,280 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!

    ITKE1,052,280 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?

    ITKE1,052,280 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?

    ITKE1,052,280 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!

    ITKE1,052,280 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,475 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.

    ITKE1,052,280 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.

    ITKE1,052,280 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