MySQL Database Forum

Dear All, I am having a bit problem with a simple development. I am not into Queries but I need this. Lets follow the example below tble1 --------------------------------- | ID | Name --------------------------------- | 1 | johny

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

I would like to create a database of music. An album has many values for the fields: mood, style etc. How would I structure my tables for this situation? Is it possible to have a field with many values?

I am trying to create a table to allow Canadian Postal Codes as of now the site only takes Zip Codes and that limits the site to only allow people from the United States to register would anyone know the sql i would add to the database to allow Canadian postal codes to register or the table i would use to create it in phpmyadmin Thank...

Hi everybody, I am trying to make a EER diagram using mysql workbench to start with a database. This is a vehicle parts database dat im trying to design. i have following five tables: 1. Make 2. Model 3. Year 4. Body

My table is set up like this Field Type name varchar(50) setting varchar(50) userid int(11) value text Now im trying to get the userid from the database where the name = name and setting = month the value = 6 and the setting = day and the value = 7

Hi, I'm currently trying to fix this db, it gives me sintax error all the time, I checked it from down to up, nothing worked. Could anyone please give me a little hand? :) CREATE TABLE IF NOT EXISTS `#__huruhelpdesk_categories` ( `category_id` bigint(20) NOT NULL AUTO_INCREMENT, `cname` text NOT NULL, `rep_id` bigint(20) NOT NULL,...

The following query produces a very slow running failure. (Usually time out). I am not sure about the syntax. Any ideas? UPDATE `table1`,`table2`,`table3` SET WHERE `tables1`.`id` = '20439'

hey, i have created a table called book_table mysql> describe book_table; +-----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+----------------+ | bookid | int(15) | NO ...

Hi, I'm struggling to narrow down on what is causing LockAcquisitionException in my program. Today I got this exception while reading from a table. My program connects to a remote db. More than one process access this db concurrently. How do I know which process contains the bad code that keeps a table locked and prevent other processes...

Hi All, just wondering someone out there could help me solve a little problem in my mysql database: Table 1 Name: wp_wpsc_product_files Fields: ID, Name, Description, Additional_Description Table 2 Name: wp_wpsc_productmeta

I have to delete all entries other than specified using a IN statement. If my Mysql query is SELECT * FROM `service' where id in (122,123,124,125); I want to select all the other entries with ids other than 122,123,124 and 125 and delete them. Thanks in advance.

Hello Everyone, In my database I found few special character,these special character were get stored even after using proper function for striping out these character,like mysql_real_escape function in php. I found these characters in my database Sipsâ„¢ should be Sips™ There’s should be There’s Rosé: should be Rosé: ’...

hi i m having an table named users. the column names are id,name,referalID,amount etc... each user has an referalID. so when a new row is inserted i need to update the amount of the referalID by an percentage and their referalID amount by an percentage upto 5levels..

hi, I am trying to set Master-Server Replication.I followed the following steps,even though slave can't able to connect the master. master ip : 10.93.210.133 slave ip : 10.93.210.211 Steps in Master Server: 1. Changes in my.cnf file

Hi Team Am using Asp.net and mySql in my project. I need to display the id number by using month and year. the format should by MMYY. Please help me in this regard.

Hi All, I have a requirement in which, i upload excel sheets to sql server database. The business logic is executed and display as reports in php. It is working fine till yesterday. Today i tried to upload excel files. It is throwing an error message stating:- The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" could not...

I have an excel sheet or a table which looks like following(3 columns or field), Part-----Assembly----Avg 5------- 12.5------- 15 4------- 20--------- 5 2------- 35--------- 30 1------- 14--------- 16 3------- 18--------- 21 (It is an example, May be I will have thousands of records)

I have tables defined with pk's and fks. What system table contains the foreign key column name? I see the table called information_schema.referential_integrity that contains useful information but it does contain the fk column name, only the foreign key table name. What I'm trying to accomplish is, generating a script of "alter table"...

We have a table with 2 million plus records and we need to paginate through it at 100 records at a time. What is the best way to approach this while keeping server load and overhead cost down? Looking for any solution: different query types caching mysql settings hardware recommendations indexing

Hello, I've been looking at this for probably five hours now and I'm loosing my mind. I'll start by just showing my end result of this query of mine, since it illustrates the problem. Here is my Database structure: http://a.imagehost.org/0195/untitled_12.jpg

My website used Godaddy host before.and last month I can not visit it.and the support answer me that they had nothing can help me.So I asked refund. and then I bought the ixwebhosting host. But I found I can not import my mysql data from godaddy. it is about 21mb. the phpadmin just let me import < 2 mb. my website: wltip.com ust have the...

I was trying to establish a DSN using myodbc 5.1 to a live website's mysql database. I could finally get the DSN connection to successfully connect to the remote MySQL server using the hostname, username and password only . It succeeded, but when I use the database name in the DSN configuration it fails to connect the username to the database....

Hi, By mistakenly,i added three UNIQUE index on a single column.Out of three,i removed one UNIQUE index from a table.Now,i want to remove remaining unique index from a table. mysql> show index from uniqueindex; +-------------+------------+----------+--------------+-------------+-----------+...

What is the best sql join method to use when i want to join upto 4 tables that all have the same columns?