MySQL Database Forum

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...

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...

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...

Where is Foreign key in phpmyadmin

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...

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,...

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.

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 ?

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.

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

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

hi, I got this definitions from mysql official site now() - returns the current date and time. SYSDATE() returns the time at which it executes This differs from the behavior for NOW(), which returns a constant time that indicates the time at which the statement began to execute. (Within a stored function or trigger, NOW() returns...

How do you get the current month - 1 month? (so not a particular day, but the whole month) Thanks, Gary

Hi, I am confused with the syntax for NOT in MYSQL where clause and wonder if an expert in MYSQL can enlighten me. There are possibly two places NOT can go in: select * from employee_data where NOT employee_id LIKE 'A%' select * from employee_data where employee_id NOT LIKE 'A%'

Hello members, I need help on creating a database in mysql, I installed XAMPP server which installed php5, win mysql ver 1.4, Apeche server, phpAdmin on my windows XP with SP2 but i'm a newbie and. I don't even know what the phpAdmin is for. I want creat A web site that is database driven with php and mysql but I don't know where to start. Pls...

Hello all, Looking for some help here. BTW, to e-mail me directly, should you prefer, take the *nomail*. out the reply address. I uploaded data from another program ( GNU R-2.2.0 @ www.r-project.org ) into a MySQl (4.1.X ) database. R generated the tables for me, naming the columns, setting field types, and inserting the records. This...

In MSSQL you can create a table with a computed column, like this... CREATE FUNCTION CubicVolume -- Input dimensions in centimeters. (@CubeLength decimal(4,1), @CubeWidth decimal(4,1), @CubeHeight decimal(4,1) ) RETURNS decimal(12,3) -- Cubic Centimeters. AS BEGIN RETURN ( @CubeLength * @CubeWidth * @CubeHeight )

Hi all, I got a quite strange problem when I tried to setup a database backup shell. I put it this way: "bin/mysqldump --opt --user=xxx --password=xxx DB > DB.bak" However, error 1045 came to me to say "Access denied for user 'xxx'@'localhost' (using password: YES) when trying to connect". None the less, I'm absolutely full of confidence...

Hi, Besides transaction capability, is there anything else about innodb tables that makes it superior to myISAM? I really don’t need transactions, but for example, I need superior reliability for index (too many index corruptions in the past). Is innodb better in that area, or any other areas? -- Posted using the...

I have installed mysql (under SuSE 8.1) and everything seems to work fine when I am logged in as root. However, with my normal user profile I can get a mysql> prompt but have no permissions to carry out any database operations. I would really like to work with my normal profile and am hoping that it is merely a question of setting...

my friend ever tell me that he have seen an update query without using SET , can anyone tell me how to use it in mysql thanks

Hi all, For a project I m working on I am looking for a database with all current car-makes & models from post-WII till now. With all the car websites around I am sure this information should be available somewhere so that I can import it into my MySQL database, but I simply can't find it. Does anybody know where I can get my hands on...

when I create a table, I always make the first column my unique-id, and make this primary key auto-increment. Does this mean that the table will be indexed by mysql on this key - or do I need to explicitly do this too? e.g. create table note ( note_id INTEGER(9) AUTO_INCREMENT PRIMARY KEY,

Is it possible to copy a table from one schema to another schema by just copying the frm file to the directory for the new schema? What is the best way to create a new database with all the tables in it automatically? I was hoping to have the tables (the frm files) included in a subdirectory and when required, just create a new schema...