Display :
Category: MySQL Server

I want to use the wizard that is used for import and export operations to import csv files. Hence in MySQL workbench import csvusing wizard.

Category: MySQL Server

I am using MySQL to execute SQL queries to obtain data from multiple databases and I am continually getting this error MySQL ignoring query to other database. How to prevent this error?

Category: MySQL Server

Explain the Functions and Procedure to write Date formats in SQL servers?

Category: MySQL Server

What are the Difference between Sybase and SQL based on their working and key features?

Category: MySQL Server

Hello! Please help me with the following:

I have a table dle_post id autor date short_story full_story xfields title descr

How can I get the piece of code from full_story and change it for mine? For example I need to change <img border=”0” to <img

Also for example I have news under ID 1 to 1000 and I need to set date in the same field like that

one value for 1 to 100, the other one for 101 to 200 and etc. How can I do that?

Category: MySQL Server

Why can’t I connect to remote MySQL from virtual private server? I use ocentOS 4 virtual server that was set up with plesk. I have been trying to connect to remote MySQL from VPS but the connection was not established. I allow remote MySQL from host and also allow outgoing transmission protocol (TCP) port in cof.conf. What other methods can I use in troubleshooting?

Category: MySQL Server
Hi there, I'm new to WordPress and just forgot my admin password... 
 
Is it possible to execute some MySQL statement in order to reset the password?
 
I do have access to phpMyAdmin.
 
Thank you for your help.
Category: MySQL Server

Recently, I installed MYSQL server on my machine which runs on Windows operating system. I started having problems with MYSQL so I decided to uninstall all programs relating to MYSQL. So far, I have been able to uninstall everything except one stubborn program called MYSQL Connector Net 6.8.3. For some unknown reason this particular program has refused to uninstall when I use the normal procedure for uninstalling programs in Windows OS. What is the most likely cause of this issue? What alternative way can I use to uninstall this program?

Category: MySQL Server

What is System R? What is its connection to the SQL programming language? What are its two major subsystems? How is System R different from the relational structure in terms of its data structure? Are domains supported in System R ? How does System R help in achieving data independence?

Category: MySQL Server



I am thinking of designing a very large database that can handle close to a million people. What best policies do I need to consider when designing such a system? Which potential bottlenecks does such a large systems present to designers and coders? How do I resolve the common bottlenecks associated with this kind of project?