• Store MySQL query in Microsoft Excel

    I have a MySQL query and I need to store it in Excel. Here's the query I have: SELECT * FROM document WHERE documentid IN (SELECT * FROM TaskResult WHERE taskResult = 2429) How can I go about doing this? Thank you very much.

    ITKE829,015 pointsBadges:
  • How do I get to my MySQL server?

    I'm just learning "MySQL," and I understand that you have a server that I can use to practice with. Where is this server, and how do I get to it?

    kevbeard5 pointsBadges:
  • Issues connecting to MySQL database server

    I'm having an issue with connecting to my database server (This is in MySQL). I'm looking to query my database in MySQL workbench and I keep getting this error message: Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:Can't...

    ITKE829,015 pointsBadges:
  • Database error message when deleting it from MySQL

    I'm having a ton of trouble deleting a database from MySQL. Here's the error I keep getting every time I try: ERROR 1010 (HY000): Error dropping database (can't rmdir '.\oro', errno: 41) So I'm not sure what to do here. I tried to using phpmyadmin but I'm getting the same error.

    ITKE829,015 pointsBadges:
  • Web project setup

    I am new the Linux servers but will be using CentOS servers. I have a web application that was created in Java using a NoSQL database. This application will give users the ability to create there own drag and drop web sites. Very similar to , Web.com, wixs.com, suarespace.com and weekly.com. We...

    sstepky60 pointsBadges:
  • 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:
  • 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?

    ITKE829,015 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:...

    ITKE829,015 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?

    ITKE829,015 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?

    ITKE829,015 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!

    ITKE829,015 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!

    ITKE829,015 pointsBadges:
  • MySQL: Threads showing in freeing items state

    I've been running SHOW PROCESSLIST in MySQL and there are a bunch of threads in the 'freeing items' state. A friend of mine told me that this is because of the query cache. But mine is set to zero so it should be disabled. What's happening here? Thanks!

    ITKE829,015 pointsBadges:
  • Export / import database in MySQL using command line

    Can I import / export my database in MySQL using the command line? I already have MySQL system configured and WampServer is installed. Thank you so much.

    ITKE829,015 pointsBadges:
  • Monitor progress of SQL file

    I'm trying to import a pretty large SQL file (roughly 6 GB) to my local database. Here's what I'm using: $ mysql -h localhost -u root 'my_data' < foobar.sql $ mysql --version /usr/local/mysql/bin/mysql Ver 14.12 Distrib 5.0.96, for apple-darwin9.8.0 (i386) using readline 5.1 So, I'm wondering if...

    ITKE829,015 pointsBadges:
  • Moving MySQL database to another server

    We have a MySQL server that is using a InnoDB table and the size is right about 30GB or so. Now, we actually need to move to our new server. How can we go about doing this?

    ITKE829,015 pointsBadges:
  • Disable replication on MySQL database

    For the past month of so, I've been running dual master MySQL replication but now I need to move to just one database that doesn't have a replication. Is there a way to completely disable replication on each database? Thank you

    ITKE829,015 pointsBadges:
  • Can I mysqldump specific tables in my database?

    In MySQL, is there a way I can dump a specific table / tables without including the remaining database tables? I would appreciate the help.

    ITKE829,015 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