[mysql] Forum Topics

hi i have question . what data type of time ??

Hi i have a website hsoted on a shared server with a service provider and i am getting the below error at times while i am adding text in the database thru the CMS module provided to me by the developer. The developer says its a server issue and and …

hi I am learning mysql and have created a table for auditing purposes with fields below , but my problems is I dont know how to go about inserting data into it whenever an event ocurs on my primary tables.especially getting the oldvalue,newvalue,column and table name fields after updates are …

Hi there, Can someone please help me in optimizing a query. The query that I have is as follows: [CODE]CREATE TAbLE RED_WINE_TXN AS SELECT MEMBER_SEQUENCE, SUM(PURCHASE_VALUE) PURCHASE_VALUE, SUM(QUANTITY) QTY FROM PURCHASE_DETAILS a, RED_WINE_SKUS b WHERE a.PRODUCT_NO=b.PRODUCT_NO AND TRANSACTION_DATE>=20071101 GROUP BY MEMBER_SEQUENCE[/CODE] MEMBER_SEQUENCE: DECIMAL (INDEX) PURCHASE_VALUE: DECIMAL QUANTITY: DECIMAL PRODUCT_NO: DECIMAL …

I design a database on Mysql , one of the tables is call 'account' which contains user related information like username, email address etc. Due to large amount of user data running in millions of record, I have decided to partition the account table. The first partition should contain username …

I've got quite a slow query, that I need to get a random record from, however this is proving painfully slow, can anyobdy suggest ways to speed up the following query. SELECT * FROM people WHERE names like "%bert%" or names like "%john smith%".......... or names like "%eric%" ORDER BY …

Hi can someone shed some light on this problem I'm having please? 2 tables SHOWS_ARCHIVE (TABLE 1) ID SHOW_ID AUTHOR SHOWS (TABLE 2) ID When the member logs in they are a loud to see their shows because of the $author permissions; [code] if ($_SESSION['MEMBER_PERM'] == "2") { $author = …

Hello All, Can anyone help me how to insert html code in mysql database coloumn and also how to change the var char to 1000, for now it is 100. Please help me out thanks 7 regards Raj

Hi, I am in the process of grabbing information from a mysql database. I need to just grab the date that was imported from the xml sheet. Is there any commands that can just grab information listed below: [code]...<expiration-date>2040-12-1</expiration-date>...[/code] This is located in between all the other information from the …

Hi all, I using PHP & MySql. Here's the situation: 1. I have a website which is a meeting place for employees & employers. Employees can sign up for an account & select the skills they have. These skills list will be shown on their resume. I have an array …

Hello, About a week ago, I created a new DB (e...), put it on the server and edited. [B]ALL FINE THERE [/B] However, certain tables with the [I]same names[/I] on a [I]different DB[/I] (f...), on the [I]same hosting account [/I]were over written with the information from DB e.. [LIST] [*]The …

Hi, I have this problem to solve [quote]Create a set of tables to store data for an address book (contact) application. Bare in mind the following design criteria. * The application will be used by multiple people so the database should also store a list of users. * The people …

Hello all, lets say i have a table like this which has 3 columns and 3 rows; -----------------------------------------------------------+ COLUMN_A.....|.....COLUMN_B.....|...COLUMN_C | .........X............|...........X............. |.........X...........| .........X............|...........-...............|.........X...........| ..........-............|...........-...............|.........X...........| -----------------------------------------------------------+ So, now i have an input like; (user submits a form) ----------------------------------------------------+ ......X............|...........X............|..........-.......| ----------------------------------------------------+ now; the first column of row#1 is X so it is …

Hi I'm having trouble with a subquery and really need some help. I'm trying to count to count the number of beats sold by a particular producer. So the first thing I did was SELECT all the beats sold by that producer so I wrote the code [CODE] select name, …

Hi! I've got a table of, let's say, widgets. Each has a unique id (primary key) and a few other attributes such as widgetid (unique, number) widget_name (string) widget_price (varchar) widget_color (string) BUT, for each widget, I also want to list other widgets (that are listed in the same table) …

i get an excel report each month, There are two columns (person`s name and Salary) in this month report there was 99 persons. my question is , if in next month excel report there are less persons...say 75, and also 23 persons raised their salary.. how can i updatae this …

I need to get the 'customers_info_date_account_created' from the 'customers_info' table where the field 'customers_info_id' matches with the field 'customers_id' in the following query: [code=sql]SELECT * FROM customers WHERE customers_id NOT IN( SELECT customers_id FROM orders )[/code] I basically have all the information in columns from the query and need an …

hi all how to run the multiple sql statements same time in mysql querybrowser? for example i am write two sql statements, i want run the second statements in mysql query browser, how to terminate the first statement thanks

What i want to do is display all the customers data which is in the 'customers' table where their 'customers_id' is NOT IN the 'customers_id' field in the 'orders' table. I hope i made sense! Thanks, Billy

I'm quite knowledgeable with T-SQL and know a little VFP. I would like to code what I think would be a very simple program. I have an excel spreadsheet that has two columns, a date column and a system code column. One of the applications that I use on a …

Hi, I was wondering how I would enter something like a paragraph in MySQL if you declared it as type TEXT. So how would I enter something like: [COLOR="Red"] John 3:16 (New International Version) 16" For God so loved the world that he gave his one and only Son,[a] that …

Hi, For 2 lakh records, this works well but when the total number of queries is more than 5 lakh it does not . Actually i have 64 lakh records to work with and this gets forever. [code=sql]UPDATE tmp_yk_contributor set score_last_update = '$date' , ykscore = (IFNULL((select avg(score)*0.8 from yk_entity_score …

hi experts, Is it possible that i could get the 3 queries made into one single query.Any help could make me understand and correct myelf in better queries. Each query is taking long time and sometimes the first query crashes , with > show processlist showing status as 'copying to …

hi all, i have a auto suggestion box which displays countries when we type [B]a[/B] it will display all countries starting with letter [B]a[/B] like alaska,australia etc...,but i want to display every name which has letter [B]a[/B] in names like [B]a[/B]ustr[B]a[/B]li[B]a[/B],indi[B]a[/B], etc...

OK .. I was migrating an application from a staging server where the MySQL version is 4.1.10a to a live server where the MySQL version is 5.0.45. There apparently is quite a difference between query syntax on one versus the other. For example, in version 4, this worked: [CODE]SELECT uas.usr_id_users, …

I have 2 tables with the basic structure town, latitude, longitude postcode, latitude, longitude where latitude and longitude are both floats, and the town and postcode are just descriptive text. I want a query that will display the closest postcode to each town, is it possible?

I was wondering how do you countdown to a given date, like for and enevnt or something. Let's say you know the target date is let's say Christmas and you have the current date, how do I calculate how many days are between them?

Hi , Wishes! I am doing a iterative calculation and in the last iteration, i update few of my tables. What i am trying to do is , make this update more perfect. Is it possible for me to do updates in small steps with using LIMIT. i do not …

OK, now that I managed to insert data properly into a relational database using a linking table, I am now faced with pulling the data properly out of the database, a displaying it so it makes sense. As a recap, I have inserted user data into a data base that …

I'm working on a web app in which each user will have their own account. Each account would have its own data (duh) and this data needs to be kept separate from everyone else (either by putting it in another database JUST for that user or combining all data into …