MySQL Database Forum

My SQL query is --> SELECT sum(bookings),sum(invoices) FROM alaqary WHERE alasas="WQ" I am finding the sum of two fields . Is there any better way ?

I installed MySQL on a windows server 2003, in an acxtive directory domain and I get error 32 which is a sharing error. I do not understand this and I am also adding the first several lines of my .err log: InnoDB: The first specified data file D:\MySQL Datafiles\ibdata1 did not exist: InnoDB: a new database to be created! 070202 16:23:54 ...

When trying to start mysql, I get a message that 'The service is already installed. The current service installed is C:\mysql\bin\mysqld ". Then when I issue this command "mysqld -u root -p" and put in the password that I think is correct, I get a message error "ERROR 2003 Can't connect to Mysql server on 'localhost' (10061). Does this...

Hi * How can reset a auto_incremet collumn so it starts from 1 TIA

Hi, I'm trying to display a table of highscores, but I don't want to display more than one highscore from the same person aka duplicates in the name column. I tryed this: $sql = "SELECT DISTINCT name FROM scores INNER JOIN time, milliseconds FROM scores ORDER BY time, milliseconds ASC LIMIT 10;"; I was thinking maybe I need to first...

How do u set the line size in MySql????? i.e equivalent to set linesize 400; in Oracle........

Hi experts, I have 2 tables which goes as follows: tbl_item: {id, name, etc} tbl_votes: {id, item_id} Therefore each item has a certain number of votes. I want to be able to extract the item with the most number of votes. However there might be a case where top votes are at tie with each other, so 2 or more items have to be selected....

i need naming convention for mysql any one help me

I am using 5.0.26-NT on Windows 2000. I have need to use a reference in the outer from clause in a subquery in the select clause. Consider the following example: Select (select b.baitID from b where b.entrydate curdate()) as wantedBaitIDs from bait_tbl b; My actual need is more complex than this as part of it is a rough cross tab. If...

So I need to load lots of data into my database. So I discover LOAD DATA INFILE. Great! This little gem loads my CSV in blazing times (compared to parsing the file and doing INSERT for each row). Its still slow on large files, but just barely acceptable. Only one problem. It truncates fields to 256 characters, even on a text field.

Trying to create a table and insert records from a webform and I keep getting this message: "Successfully created the registration table. Unable to execute the query. Error code 1050: Table 'registration' already exists" Then after the table is created I re-run the query/webform and I don't receive the error message, but it...

In the result of a SELECT statement, how can you change cell values from NULL to BLANK? The following does NOT do it: SET fieldname = ' ' WHERE fieldname IS NULL Also, for colums with a DATE data type, I want to change 0000-00-00 to BLANK. For for colums with a numeric data type such as DOUBLE, I want to

How to clear mysql command prompt as cls in normal command prompt

Hi there, Been working on an evolving DB program for a while now. Suddenly I have come across a situation where I need to update a table based on a group by query. For example, I have a table called "students". I need to update a field called "status" on this table for all members that have never attended a class. Class attendance is...

Hi All ! is it possible to use variable table and/or field names in stored procedures i.e. construct the name of a table/field based on an input parameter as in : create procedure toto(in p_name char(5), out p_count int) begin select count(*) into p_count from table_'p_name' end

Hi All, I deleted few rows from a Table by mistake. Please could you write on the ways to rollback that data? I have still not commited any transaction. Please provide the steps / links / docs for this case. Thank You.

Hi, I have a field in a table called 'ShipDate'. This particular field has allow null set to no. So by default this sets all the records to show 00/00/0000 in the field for each record that has no data entered. In my .asp pages I am trying to test against this empty field. i.e.

I have a MySQL Server in a Windows Box. How can I connect to the server from another windows box using ODBC? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@freebsd.csie.nctu.edu.tw

Hi, Please help: select * from v_diff_id_group_type where id_group = '001' –> color_id from form (char) How can I convert the said query without changing the data type of the ID_GROUP Field (Varhar2).

how can i delete duplicate entry except one from a table in mysql. please send that query to me. thanks kunal

Hi, I've got a PHP and MySQL related problem, and it may sound like an amatuer's question. but any help on this will be greatly appreciated Basically, I have a php variable that i want to store in my database, however this variable contains a quote. and hence the presence of this quote in the query stops the sql query from being a valid...

Hello All, We are building an application that will dynamically choose and pre-pend short underwriting messages to the audio streamed over the web. We will use SMIL files. We need to decide if the short underwriting messages are better off stored in a the database (BLOB field?) or in a physical file with the references stored in the...

I'm running as mysql root user on my system. I can select load_file('/etc/passwd'); no problem But when I try to select load_file('/var/lib/mysql/mysql'); I get NULL as a result why? this file is good, I can cat it as root and view the mysql user data, why cant mysql load_file it? Its permissions are the default: -rw-rw---- 1 mysql mysql ...

Hi there, I'm not sure how to select the last 3 items in ascending order. This does the trick in descending order: select * from user_menu_main where deleted = 0 and hidden = 0 order by date desc limit 3

dear everyone, we installed a mysql vr standard-4.11.22a-pc on a machine with ubuntu breezy badger as os..after the installation we are trying to start the server by typing :bin/safe_mysqld...but it shows us a msg whch states Starting mysqld daemon with databases from /usr/local/mysql- standard-4.11.22a-pc-linux-gnu-i686-glibc23/data ...