I dont use SQL very much. I am trying to get all the columns for all my tables in a specific schema. I can get my query to print for all my tables, in all my schemas, i just dont know how to...
I made a website where all content are stored in a mysql table "pages".
I'd like to make a search function that are somewhat "intelligent", so that when a user searches for a word or phrase...
the environment is:
database: mysql
web server: tomcat
development language: java 1.6
The scenario of exception: The system has 30 to 100 concurrent thread running on
backend, and...
Is it possible to have a create table query that is based on the existence of another table?
So if TABLE_1 exists then TABLE_2 will be created but if TABLE_1 does not exist then TABLE_2 wil...
I used the MySQL migration tool to extract data from a SQL Server database, into MySQL.
However, MySQL is not importing non-ASCII characters into the new database.
I looked at the SQL scri...
Cannot connect to MySql Server remotely
I am doing volunteer work at a non-profit. We have a Suse Linux 10.0 box ip address 192.168.0.100, with MySql Server 5.0.15, with Apache2 running a ...
I need to write a mysql query that pulls data from 2 different tables, and place them within the same result set (using PHP). My 2 tables are named "products" and "products_states"
-------...
i have only two differenet values in status column
example
status
-----------------
1
1
1
2
2
1
1
1
2
do i have to give index to this column. for this column it is necessary ...
I'm using Debian (Lenny 5.0) and I've just installed mysql and php5 using apt-get. During installation I was prompted to enter a root password, which I did.
Trying to start mysql with the c...
I have the below queries, which are exaclty the same but with a different PlayerId. They display the correct result for the playerid specified.
Is there someway I can combine them though s...
I've got the below query which displays the correct values.
The problem is though is that it doesn't show 0 for the Dismissals.DismissalsFull that don't have a match in MatchPlayerBatting.
...
Hi,
I have a mysql timestamp field, it looks like:
YYYY-MM-DD HH:MM:SS
I need to check if a given timestamp is the 'same day'. For instance, I need to know that:
2009-09-27
...
Hi there
I have a big problem. I want to migrate from my 32-bit Windows 2003 server to 64-bit Windows 2008. I use Plesk control panel but I have upgraded the mysql databases on boh servers ...
user
id email password
user_details
id user_id name city state zip
speciality
id user_id speciality_info_id
speciality_info
id speciality_info
1...
Good day everyone,
I'm developping a web based application for products/inventory management, which will also be used by an e-commerce application. In sumary, I have the following tables:
...
Hi
its not a HOw to Question.. its actually advise type question ....
i have asked this question : http://www.experts-exchange.com/Database/MySQL/Q_24804191.html
its similar to this o...
Following on from this question http://www.experts-exchange.com/Database/MySQL/Q_24747970.html
This query gives me Runs by year:
SELECT PlayerName, YEAR(MatchStartDateTwo) Year, SUM(BatR...
Hi experts,
How to insert a english and japanese character into mysql database using servlet?
for example the data like below:
"This is japan ÅLh¿n¯êÃ×-ÅL¿ " "
Hi: I have a spring, hibernate application. Data base is MySQL. In O-R mapping, I have a table associated with a view. Now I want to add a sequence to this view. How to add a sequence to this ...
Hi,
my server is fine all this time, but somehow in the last 5 hours there are so many mysql sleep process apear. because of this apache web server get to the max client and it can't receiv...
hello there..
a few days ago I got an email from my hosting company saying that the hard drive was about to die so they need a new one and fresh os install..
so they installed the new os and...
I use the following command to alter a single table in mydb:
ALTER TABLE mydb.Table1 ADD COLUMN `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER ...
I am a new MySQL user. I am trying to use the MySQL Migration Toolkit to import an access MDB file containing numerous tables. The process appears to finish properly, however, some of the ta...
Hi
i m using vs 2008 and 2005
backend is sql server. all project is going smooth.
I need to upadate a table (which is in MYSQL database) from a table in SQL server
i have no connectivity i...
Hi,
I have an issue with a script's SQL query that I've written.
It looks for software items in the database similar to the current page.
The current page is identified by a string like...
