MySQL Database Forum

Hi Anyone appreciate your help, I have a table with about 7 columns - one is a date column - I would like to update the table and change all dates starting from a certain key (the first column) from May to June - keeping the year and date just changing the month 05 to 06 note the dates are in random order -so e.g start at id 1001 col 1 (id#)...

Dear fellow members. In my workplace, we have an application using php MySQL which functionality is basically storing data from user input. The condition is like this, we have one computer act as the server which served about 10-20 clients. each clients is inputting data using PHP application that basically running "INSERT" SQL query...

hi all, im new to databases and im trying to build a small database for a small side project im working on. I was trying to optimize it by removing any dependencies and i was just wondering if i can query my database to find out whether functional dependency A → B holds, for example, on a relation R with attributes ABCD, or any other relation...

Microsoft Access can run queries on Oracle DB. Wondering if I can query SQLite through MySQL (join tables,etc) I could easily dump the sqlite db to mysql, but requirements changed and I can't do this anymore. Doing it with php (query one db, than another) takes too long, for one, and can't do pagination very well. Googled, but to...

The deign goes like this.. I have a Mysql database on a linux system. It will receive a file from a remote location through GPRS and that file is to be processed and will then be loaded in the database. So, I want to know how to achieve this? How can we forward the file received to the database? How can Mysql can get to process this data?...

Hi, I'm trying to get in my homepage the last 10 product-schedules inserted in my website. These I should get from different tables in my database, that have all the same fields but every table has a different kind of product. So, I should virtually join all the tables and then get of these the 10 tables with the most recent date. The problem...

Hi, Is there a way to exclude fields in a query . If there are 20 fields in a column and you want to see all but 4, and I try the below statement and for some reason I do not get the result I need select * from dbo.da_accounts where totals_group not like ('cre%','ame%','de%') select * from dbo.da_accounts where totals_group <>...

I have an equipment database that contains three tables: name, equipment and equipmentacitivity. The equipments are assigned and unassigned as used and return. Thus, each equipment, unless it is new, has been assigned (A) and unassigned (U). However, I need the query to pull ONLY the current status of all the equipment.

i have a table called statue and a field called name and sex respectively, i have two male and two female under the field sex i what to select them and COUNT the number of male and female in the table statue and field sex and display there number.

Hello, I have a query like this: SELECT jos_vm_orders.user_id, jos_vm_orders.cdate, sum( order_total ) AS total, count( jos_vm_orders.order_id ) AS ordercount, jos_vm_user_info.first_name, jos_vm_user_info.last_name, jos_vm_user_info.phone_1, jos_vm_user_info.user_email, jos_vm_user_info.city FROM jos_vm_orders LEFT JOIN jos_vm_user_info ON...

Hi DBA's I want to migrate from MS Server to MySQL. what tool should I use that can migrate tables with data? Many, Thanks Victor

I am trying to create a before insert trigger for a table called "bookorder" Table - "bookorder" 'order_id' contains numbers 'book' contains numbers 'description' contains text The trigger is for when there is a duplicate of order_id and book. If duplicate of both order_id and book then error message says "Error Duplicate order_id X Book...

This works fine, with 175 rows returned: SELECT id, NDB_No, min, max, final_amount, fz_units_id, fz_score, used_in_last_food_plan, meal_type, user_prefs_for_foods.FlavorZoom_Food_ID_No, brand_name, calories, carb_grams, date_added, description, fat_grams, gm, id_of_user_who_added_this, let_other_people_use_this_info, Long_Desc,...

Hi everybody, i'm doing a query where i want retrieve some records when i do the query without 'limit' the result returns me the correct number of rows, but when i use limit the result returns me the half of the rows. the query im using is something like this: SELECT WGI_TaxoName.ScientificName, WGI_Locality.Locality,...

Hello all, can anyone conver the following ORACLE query to MySQl equivalent query, $account_fields = $this->oracle("SELECT ROUND(SUM(TO_DATE(PAID_DATE) - TO_DATE(INVOICE_DATE))/COUNT(*)) AS AVGDAYS FROM INVO WHERE BILLTO_ABRV = '$focus->kp_code_c' AND IS_PAID = 'Y' AND STATUS <> 'Void' AND PAID_DATE > ...

I am trying to do a query in mysql which does: displays only the 'animalentry.animal_id' and 'animal.name' where 'animalentry.place' = 1 or 2 The tables and fields / columns are 'animalentry' - table 'animalevent_id' - column / field 'animalplace' - column / field

hi, is there a way to install mysql in such a way that even the os administrator cannot change or reset the mysql root password. the requirement is that i have an application which use mysql as the database. that application will be installed in clients machine. i want to make that database secure that users will not be allowed to directly...

Hi, I am a newbie to sql,I have a problem with querying the intended result.What i need is to get the SUM() of daily income,cost im my result set, but it gives me unintended result set hence it gets duplicated by GROUP BY clause.please correct my sql. Thank you. this is what i want +------------+--------+------+ | date | Income |...

I picked up the below code from some website and it is absolutely good working code except that the wrap text feature is not available. The value of field1 below do not go to a new line if the value is long instead it overlaps to the next column. Therefore, i would like to request if anybody could give me a piece of code to solve this issue. ...

I have a table called 'animal_prize' in a Myswl database. The columns / fields are: 'animal_event_id' contains numbers such as 1 'animal_place' contains numbers from 1 to 10 'animal_prize_money' contains numbers such as 10 I am trying to get the results so that it appears like the following: animal_event_id 1st 2nd 3rd 1 ...

I have a table called 'Animals' in a mysql database. The columns / fields are: 'name' 'animal' 'year born' I am having problems creating a stored procedure called 'animalscount_sp'. The stored procedure is meant to count the number of records in the 'Animals' table

I've got a ranking query that ranks the performance of teams in challenges. The hierarchy of data is as follows: teams have members members have activities activities have activitytypes challenges have activitytypes If I want to rank the performance all teams in a single challenge, this query works great:

Hi guys. Its very simple. I used in the past without any problems DBDesigner 4. If you used MySQL Workbench what would your recommendation be? Thanx

I have a table called 'Animals' in a mysql database. The columns / fields are: 'name' 'animal' 'year born' The 'year born' field / column only contains a year such as 2000 I need help for these 2 items: 1) I am trying to calculate the animals age.

I wish to find the 6 highest amounts in my Mysql database. The database name is employment The table name is jobs The columns / fields are: 'Job title' 'Company Name' 'Employment dates' 'Pay' The 'Pay' column / field contains only numbers such as 100