Hi,
I have just set up a new installation of MySQL 5.0.63. I am reading some tutorials on securing the installation. The tutorials are referring to a main config file called my.cnf which I ...
Hi Im new to mysql and need to know how to write an output file from mysql stored procedure. I basically want to select some data from a table and write the result to an output file on the se...
This is my table...
INTERVENTION | Proj | Proj2 | Proj 3|
200 | 2 | NULL | NULL |
200 | NULL | 3 | NULL |
200 | NULL | NULL | 4 |
203 | 5 | NULL | N...
I am trying to import not just one but numerous flatfile csv files using LOAD DATA INFILE statement from the mysql command line. Using the code ive posted below i can insert a single .csv fil...
I am new to this SQL stuff. can any one spot why I am getting the following error?
Error code 1064, SQL state 42000: You have an error in your SQL syntax; check the manual that correspo...
Please refer my following query. In Line 3, I want to use:
B.Quantity * Item_MRP
Please note that Item_MRP is an alias name for a query in Line 2. How to use this way?
I also want to ...
Hi,
I'd like to rollback a Insert statement is my check in the BEFORE INSERT trigger don't satisfy a condition ...
I read somewhere that any exception during the trigger would prevent th...
Hello,
I've been using my local computer for development purposes. I have MySql 5.1 installed and till yesterday everything was working fine - I was able to connect to it.
From today morni...
In a MySQL database, I have a table already created with several fields. Let's say field1 and field2 make up my composite primary key. What command would I enter to add a third field to my c...
Hello folks.
I have developed a little program that, using an array of multiple mysql databases, I can choose one, create a query and get the result set displayed.
All databases have the sa...
I'm having an issue with locked tables and blocking I/O.
Is there a way to query the MySQL server first, asking if a particular table is locked, before trying to query the locked table?
...
My client needs to convert their survey questions and answers in different foreign languages mainly Chinese and Russian. Currently all are working well in English. If I try to store the chines...
Hi,
please let me know
how to connect to mysql using shell script?
when i run shell script ,it should connect to mysql DB
rgds
vijji
Hello Experts,
I am trying to insert a row in the database but I am getting data conversion error, it was working fine earlier.
Can someone please advise why it should not work?
I hav...
Dear Experts,
This isn't mega important but I figured I'd get your invaluable input just for my peace of mind. I have two ways of searching my database. The field searching aspect of my sys...
Hi,
I have two tables orders, and order_details. Now I want to write a query which will fetch the sum of order amount group by year and the sum total product quantity for that year from its...
Hi,
I got 3 tables called Customer, invoice and invoicedetails tables. Customer table has custid which should be a foriegin key in invoice table and invoiceid in invoice table should be a f...
Hi i'm trying to backup a mySQL database and i'm getting the following message at the bottom of this DOS text. I'm using windows 2003 server and mysql 5.0.
-----------------------------------...
Hi,
I am havibg trouble installing MySQL Windows essentials 5 on WinXP SP2. When I get to the end of the instance configurarion wizzard it gives me "The service could not be started. Error...
Hello,
How do I write a SELECT statement to show the time difference between two columns.
I want to show the difference in Double type, not in Time.
Mysql : How do I force drop/delete a database.
One of my developer wrote insertion scripts that are taking for ever to upload into our test datbase.I tried to drop the individual table (af...
Evening!
I have a question regarding the usage of condition logic in SQL statements.
Here is the scenario.
I have a table, mmproductcategory that records are inserted into/deleted fro...
hello,
in my table
i created columns like below
city_id smallint(11) unsigned,
user_id mediumint (11) unsigned,
message_id int (11) unsigned,
inside of parantheses what means 11 if...
I am trying to get MySQL replication going on two boxes. One master, one slave. I have found out that the compiled version I am configuring has a bug where the /var/run directory is being used...
i am passing country names to the procedure as comma seperated values.
i want to split and hold the input value for further logic.
how to do?
