• Access client’s WordPress database

    I scanned my customer's site for vulnerability in his site and I found the WP-CONFIG backup which contains all info about the site and database username and password. So how can I access my client's database using that username and password?

    mrchat5 pointsBadges:
  • Query pulling combo list box data

    I have a basic table in (column 1) list of individuals and in (column 2) lists the state(s) that the individuals hold licenses. Column 2 is a Combo Box Value List and several individuals hold multi state licenses. I am trying to figure how to pull out the states that require continuing education....

    emclean5 pointsBadges:
  • How to do a full outer JOIN in MySQL

    I'm fairly new to MySQL but I'm wondering if I could do a full outer Join in it? Does anyone know if that's possible? Is it actually supported?

    ITKE409,170 pointsBadges:
  • IIF function

    I have 2 tables: First table: 1- name 2- position 3- nationality 4- visa No. Second table: 1- Position 2- No of visas. 3- No of used visas. 4- No of remaining visas. But I want to use IIF function when add new position in first table increases the no of used visas in the second table automatically....

    khalid1155 pointsBadges:
  • MySQL or PostgreSQL for block storage volume

    I was wondering if I could have 2 VP MySQL servers and one SQL database located on a block storage volume. Then I can mount the same volume on both servers reading and writing to a singe database so I can have two VP MySQL machines access and running one database. Thanks

    sstepky60 pointsBadges:
  • MySQL 1093 error message

    In MySQL database, I have a table that have corrupt entries. Here's the query that returns the entries: SELECT * FROM story_category WHERE category_id NOT IN ( SELECT DISTINCT category.id FROM category INNER JOIN story_category ON category_id=category.id); So, here's how I tried to delete them:...

    ITKE409,170 pointsBadges:
  • MySQL server syntax error

    I have this SQL query below: INSERT INTO user_details (username, location, key) VALUES ('Tim', 'Florida', 42) But it keeps saying I have a Syntax error - it relates to the MySQL server version for the right syntax. What should I do?

    ITKE409,170 pointsBadges:
  • How to convert Excel file to CSV

    I currently have a Microsoft Excel that has characters in different languages. I have to convert it to a CSV file. But when I'm trying to save it, those characters are destroyed (FYI - those characters aren't ASCII characters). How can I go about doing this? Should I use UTF-8?

    ITKE409,170 pointsBadges:
  • Recordset in Excel spreadsheet

    I have table of counties and one query, I want to loop through the same query that produces a separate report for each county and export each one to excel spreadsheet

    karenMcCracken20 pointsBadges:
  • is there any process to store the data of dataqueue

    is there any process to store the data of dataqueue

    Siru15 pointsBadges:
  • How to reorder MySQL auto increment primary key

    I'm using MySQL and in my table, I have an auto increment primary keys. I already deleted several rows in the middle of the table. Now, I need to reorder the keys but I'm not sure how to do it. Can someone help me?

    ITKE409,170 pointsBadges:
  • How to open .tra file in R?

    I am trying to work with a .tra file in R studio. But I'm unable to open it. Can someone tell me how to open it or suggest me a code to convert it to a csv file?

    niveditha5 pointsBadges:
  • Run SQL query with CSV format

    I'm trying to run a SQL query from my Linux command line and getting the result in a CSV format. Here's what I have so far: mysql -u uid -ppwd -D dbname << EOQ | sed -e 's/ /,/g' | tee list.csv select id, concat("\"",name,"\"") as name from students EOQ And here's my issue: The columns that...

    ITKE409,170 pointsBadges:
  • SQL error message when creating procedure containing three cursors

    I have created a procedure containing 3 cursor. It gives me the below error and when I add @delimiter ++; at start and end it gives message that "command processed" but doesn't show output. Any suggestions? [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601,...

    rockstar185 pointsBadges:
  • Which tool is preferable to test and evaluate the MySQL and MongoDB databases?

    I have developed a small case study online application using Hibernate that can communicate with both MySQL and MongoDB database. Now I need to test the performance of both the databases against each other by supplying a large dummy test data to the developed application on various scenarios such...

    gunasingh105 pointsBadges:
  • Removing MySQL rows from a table using SQL Query

    In MySQL, I have a table that currently holds the following topics: id url title company site_id So I have to go in and remove the rows that have the same title, company and Site_ID. Can this be done using a SQL Query? Thank you!

    ITKE409,170 pointsBadges:
  • ASP.NET web solution: Should I store my images in a database or file system?

    I have an ASP.NET web solution, which includes thousands of images. I also get a pretty good amount of traffic to it too. But I'm worried about its performance and here's my question: Should I store my images in a database or a file system? Appreciate the help.

    ITKE409,170 pointsBadges:
  • Finding data from a table that is linked with another table using foreign keys

    I want to see all the customer names and their city who have an account in a specified bank. Problem is my customers are listed in one table and accounts are listed in another. But I do have another table called depositor where it only store account name and customer name. How can I see customers...

    Rezoan5 pointsBadges:
  • How do I connect to a MySQL database in Java?

    I apologize if this is a simple question but can anyone help me with connecting to a MySQL database in Java? Thanks so much!

    ITKE409,170 pointsBadges:
  • Linked Server Query Returns Incomplete Results

    I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I'm querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the query I'm using: select * from...

    Apickel350 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following