• What data type should I use for storing currency values in MySQL?

    I'm using MySQL and I'm wondering what's the best data type if I want to store currency values in it. Is there a certain command?

    ITKE409,400 pointsBadges:
  • See indexes on MySQL database

    Specifically for MySQL, can I see if my database has any indexes? If not the database, can I see on a particular table? Appreciate the help.

    ITKE409,400 pointsBadges:
  • Select all MySQL columns except for one

    Is there a statement in MySQL that would select all of my columns (except for one specific column) in a table? Please note that there's roughly 50 columns in total. Thanks for the help!

    ITKE409,400 pointsBadges:
  • Trace MySQL queries on Linux server

    I'm using my Linux server and I was hoping there's a way to trace all of my live MySQL queries. Is that possible? I have a listener set up already (if that helps).

    ITKE409,400 pointsBadges:
  • Show last MySQL queries on servers

    How can I show the last queries executed on all of my servers in MySQL? Is there a specific query to do this?

    ITKE409,400 pointsBadges:
  • Find current SQL Server database transaction level

    How can I find the current SQL Server database's transaction level? Thank you very much

    ITKE409,400 pointsBadges:
  • Best way to create a flat file

    Is there a format I can buy or can I convert an Excel spreadsheet into a flat text file?

    CJSDOYLE5 pointsBadges:
  • Apply an archive policy to all databases in a folder?

    How do I apply an archive policy to all databases in a folder?

    Brad Harris5 pointsBadges:
  • Replace MySQL word string

    For MySQL, I currently have a column that contains URLs. In the URLs, I need to change a word - from update to news. How can I do that? Using a script?

    ITKE409,400 pointsBadges:
  • Help me please, how open damaged MDB?

    Hi. I've stored my old email messages in an access database (MDB). Now I want to transfer those messages with attachments to Outlook or another email program so I can browse and search my messages with ease. There is an option in Outlook to import messages from an access database, but it's...

    stephangoldschmidt5 pointsBadges:
  • Backup and restore SQL Azure database

    I have a SQL Azure database that's roughly 40 GB and when I'm backing it up and restoring it, it takes roughly 6-8 hours. Is there a way to make it faster? If so, what's the process?

    ITKE409,400 pointsBadges:
  • MDX File not automatically linked to DBF

    USUALLY when you create an MDX on a DBF, that MDX will AUTOMATICALLY be used when one uses the DBF. However I am experiencing one DBF that will NOT link to its MDX when the DBF is used. I have to alter my programs to "SET INDEX TO" the MDX followed by "SET ORDER TO" For Example: USE PARAMS ORDER...

    Thanbor5 pointsBadges:
  • Copying SQL Azure database to development machine

    I'm looking to copy my SQL Azure database to my local development machine. I already have a development database in the cloud but don't want to pay for it anymore. I have copied by production database to the new development database but I need that same one on the local machine. How can I go about...

    ITKE409,400 pointsBadges:
  • Is it possible to restore MySQL database from FRM MYI and MYD files only?

    I accidentally deleted  my database while testing mysql work bench. As its a relatively new DB on a new server, I had no back up running. Luckily I can see some FRM, MYI and MYD files. Afaik I had both innodb and Myisam tables and some stored procs. So is there any chance at all recovering the DB...

    FrankKelly5 pointsBadges:
  • Crystal Reports database connector error

    I exported few Crystal Reports from Raiser's Edge. The exported reports include addresses. After I made a change to the Record Selection Formula and save the change and close the formula Editor, the "Unknown Database Connector Error" appears. The interesting thing is that this error only does not...

    swei1235 pointsBadges:
  • Export Oracle SQL Developer query to CSV file

    I'm currently using Oracle SQL Developer and I need to export one of my queries to a text file. I would like it to be a CSV file. But I'm not seeing any export options at all. Even double clicking on the query itself didn't work. What should I do here?

    ITKE409,400 pointsBadges:
  • Easy way to identify DB file for specific data on screen (AS/400)

    I am trying to identify where a specific line of data is coming from when I am in a session. I've tried Shift+ESC+3+14, and all I get are active DB files. Is there a way to focus the search to one specific line of data and identify the source DB?

    mssanwo15 pointsBadges:
  • How to use Data Replication features with using MySQL Replication

    How can I use Data Replication features with using MySQL Replication?

    Rahul235 pointsBadges:
  • Best way to run a program in Microsoft Excel or Access

    Good day, I would like to find out what is the best way to run a 'program' in Microsoft Excel or Access (at the moment, I am used to Excel only but I'm willing to learn about Access if that's what it takes) that will allow me to type in one or two letters and it produces a word in the particular...

    asphaltanimal5 pointsBadges:
  • IDB and MDB files?

    How do I change an IDB file into a MDB file?

    MarthaCoake6510 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