MySQL Database Forum

Hi, New to SQL. I need to reverse the signs, for example I have an amount of -1,500.00 and I need to change the the Amount to 1,500.00 and all positives amount to a negative amount also. Thank you Stephen

Hello I want to know about mysqlcump and mysqlhotcopy . Which is better and why ? If mysqldump is there then why mysqlhotcopy is developed ?

With MySQL is it possible to have indexes or tables held in RAM? If so how do I ensure that updates are copied to disk? Regards, Dave.

What are the differences between LOAD DATA INFILE and LOAD DATA LOCAL INFILE ? I found some web hosting company do not allow using LOAD DATA INFILE but allow LOAD DATA LOCAL INFILE. The reason is for the sake of security. What does that mean ?

requirement 1 -------------------- present data:12000.00(in database) required data:12,000.00(display format) requirement 2 -------------------- there are some decimal data in database. i have to print the total value in the same format (i.e. 12.00). but i am getting the value as 12.

I have a client database in my db dev server environment I need to create, but the client name contains a dash "-". This blows up upon attempting to do create database my-site; How then do I create this database, simple as that? Thanx Phil

hello, i would like to write a batch file with all sql commands necessary to create a database, its tables, and populate them with initial data. would the experts please help me with these problems: 1. how to programmatically, in sql script, check if a known database already exists on the server, and drop it if it does? 2. similarly,...

I am getting the following error on inserting into my MySQL DBase. My child table has a foreign key of the parent table. But while creating the table, i have used 'on delete cascade'. I dnt know what the problem is. Pls help com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign...

Where is Foreign key in phpmyadmin

I used SQL Studio to build 2 queries: 1. in SQL, it's working fine: SELECT * FROM my_tab WHERE my_tab.START_DATE between '2006-01-01' and '2006-12-31' 2. but if I build the same thing in visual query, it complains there's an error and highlight "d '2006-12-31'" Appreciate anyone could comment on MySQL's complaints. So far, MySQL is quite...

Hi my question is that what is the difference between mysql and mysql enterprise edition our client has demanded the if we will use mysql enterprise edition because in future he wanted to shift the db to oracle and the stored procedures in the mysql enterprise would be working as is for oracle too now what should i recommend to them , does...

Hi all. I have to write an app that interacts with mySQL (I really must have done some evil, evil stuff in a previous life to be landed with this!) I need to work out the difference in days between values in the database and the current date. "No problem," thought I , "I'll just use the SQL DATEDIFF command." Heh! Well, the user...

I have been tring to connect to my database using godaddy i keep getting an error#1064 you have an error in your SQL syntax check the manual that corresponds to your MYSQL server version for the right syntax to use near <?php // connect to database $hostname = 'h41mysql47'.secure.net'; How can I fix this?

I hired someone to develop a web application for classified Ads using MYSQL as the database. When I requested them to implement a way so that the webmaster can compact the database, their reply was that, there was no need to compact the database. I strongly think that the database should be compacted once in a while since there are lots of...

Hai to all, this is senthil... i'm now working in the field of VC++... i want to connect a mysql database... just now tried to retrieve rows from a simple mysql database by using VC++ My database is like this...

Hai, I have a simple query fired on click of a button. i.e., update table_name set column1='20' , column2='15' where id='1'; Even through the query browser it is giving Lock wait timeout exceeded; try restarting transaction ,this exception. The same was working a couple of days before. what might be the reason for this exception.

Hi, I have a mysql db with with autoincrementing primary keys in each table. I want to allow a user to add a record using a php webpage. Once the page is added how can I re SELECT that record (for the user to verify) if I don't know what the primary key was when it was inserted? Is the only way to not use autoincrement and choose the...

Gotta post because this is driving me nuts. Trying to DELETE orphans. I can successfully: SELECT GroupID FROM Groups LEFT JOIN Users ON UsersID = UserID WHERE UsersID IS NULL; but when I try: DELETE FROM Groups LEFT JOIN Users ON UsersID = UserID WHERE UsersID

Hi, Can anyone advise how to execute multiple statements in a single query batch. For example- update customers set customer_name = 'Smith' where customer_name = 'Smyth'; select * from customers; I can execute each statement individually but get the 'you have an error in

CREATE TABLE `test`.`buildings` ( `building` VARCHAR NOT NULL DEFAULT '', `location` VARCHAR(45) NOT NULL DEFAULT '', PRIMARY KEY(`building`) ) ENGINE = InnoDB; MySQL Error Number 1064

I am trying to set up an ODBC DSN to our company MySQL database so that I can use a MS Access front end. I am using the MySQL ODBC 3.51 driver. The database is running off of Apache on our Windows 2000 server (call it 'foobar'). The host is 'localhost', the user is 'root'. To access the database via a web browser on a PC on our network, I use...

hello. i am running mysql5 on mac osx 10.5. i am new to both of these. i have created a sql script file and i am trying to use it with the sql SOURCE command. when i execute the command: SOURCE mySqlScript.txt; i get the error: Failed to open file 'mySqlScript.txt', error: 2. i have placed this file in the /usr/local/mysql/bin directory. i...

Hello, I just installed version 4.0.21 on a Mandrake 8.2 system. I cannot get the MySql daemon to run. I am using the following commands, and receiving these errors: $mysqld_safe --user=mysql Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/lib/mysql/JBrain.pid 040921 09:01:55 mysqld ended

I am connecting to my database using Object oriented PHP. My query is returning results but at the end of my table,at the bottom of the page I keep having this error when I run my program: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\mysql_class_2.php on line 45. Can anyone help me? ...

Is is possible to construct a SELECT statement that contains a WHERE clause that uses the value from a column in the "next" row? ie. given a table with a single field named "myField" with the following values I want a SELECT statement that selects the rows "WHERE myField='1' and myField = '2' ": 5 6 1