Questions & Answers

  • Duplicate record deletion using SQL/400

    Hi, How do I delete duplicate records using SQL/400 with SQL query please? Thanks!

    6r1,850 pointsBadges:
  • RPG indicators

    Pls tell me how to pass values to a group of indicators at once in a single statement in RPG and RPGILE with example..thanks

    ten20081,150 pointsBadges:
  • Linux script to see what data has been changed in the past day

    My department is running a MySQL server on a Ubuntu machine. We noticed that someone changed some data in the past day but not sure of who did / what was changed. Is there a Linux script that could tell us what's been modified? This includes file names and file sizes. Thank you.

    ITKE436,055 pointsBadges:
  • Skills sets for DevOps engineer in cloud computing

    What are the skill sets that a DevOps Engineer requires in cloud computing?

    TarunTrivedi5 pointsBadges:
  • Select SQL date without time

    When I'm trying to select a date in SQL, it keeps giving me this: 2016-06-05 20:17:33:933. Here's the thing: I actually only need the date (not the time). Is there a SQL command for this?

    ITKE436,055 pointsBadges:
  • Creating Linux file through Terminal Window

    My apologizes for the short question but what's the best way to make a file in Linux from the Terminal Window? Thanks!

    ITKE436,055 pointsBadges:
  • Convert .DOCX file to .RFT file

    How do I convert a .DOCX file to a .RFT file?

    k2bethany5 pointsBadges:
  • Drop user on MySQL

    Hello again experts! Can I check if one specific user exists in MySQL and then drop him. The user doesn't work at the company anymore. I'm not sure if there's a way. Thanks.

    ITKE436,055 pointsBadges:
  • Open connections on MySQL database

    I currently have administrative privileges in MySQL for my job. For one of our databases on the server, is it possible for me to see all of the open connections?

    ITKE436,055 pointsBadges:
  • When was MySQL table last updated?

    For one of my MySQL tables, I'm looking to add a 'footer' at the bottom of the page saying when it was last updated. Is there a way to do that? Thanks.

    ITKE436,055 pointsBadges:
  • How can I install SSMS 2012 Express?

    I recently installed SQL Server 2012 Express on my local machine. I'm able to access my database using VS2012RC. Everything is working great but when I tried to install SQL Server Management Studio 2012, the unpack installer has stopped. Why is this happening?

    ITKE436,055 pointsBadges:
  • image segmentation

    define or what is meant by color image segmentation?

    Lakshmiswetha5 pointsBadges:
  • Query database sizes in SQL Server 2008 R2

    I'm using SQL Server 2008 R2 that has over 500 databases. What would be the easiest and most efficient way to query databases of all sizes. The output should have the following columns:DatabaseNameDataFilesSizeLogFilesSizeThanks for all the help!

    ITKE436,055 pointsBadges:
  • Cleaning MySQL InnodB storage engine

    I have a friend who needs to clean his MySQL InnoDB storage engine because it's still storing data from deleted tables. Is it possible to do that? Does he have to create a new database every single time? Thank you.

    ITKE436,055 pointsBadges:
  • How to export / import MySQL databases

    For my job, I have to make sure to backup all of our MySQL databases (there's over 100). For this, can I export all of them at the same time, followed by importing them into the server? Is that possible?

    ITKE436,055 pointsBadges:
  • Is a MySQL primary key indexed automatically?

    Hello experts, Would anyone know if a primary key is automatically indexed in MySQL? Do I actually have to create the index? Also - would this be possible in InnoDB too? Thanks!

    ITKE436,055 pointsBadges:
  • MySQL database export using Command Prompt

    I have a pretty large MySQL database and I need to export it ASAP. Can I use the Command Prompt to do this? Or is there another way?

    ITKE436,055 pointsBadges:
  • 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?

    ITKE436,055 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.

    ITKE436,055 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!

    ITKE436,055 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