MySQL Database Forum

Hello, I have the folowing table: ----------- | content | ----------- |id | |parentId | |title | -----------

Hi I have mysql, php and apache all hosted and am trying to use phpmyadmin to connect to the database however I get a user access problem, it says access denied. Any help would be greatly appreciated. Cheers Shaz

I am making an order system and I have 20,000 orders and 100,000 line items. I keep track of the status for each order so there will me more then 1 status for each order. I want to check to see if the status ID is not equal to 12 when ordering by the status date. I am not check for the 12 value and it's taking for ever to load. Do you know...

setting up LAMP server. on old server with single Intel PII 450 MGHz, 64 MG Ram and two 9.1 GB Hard drives. How much RAM do I need to run MySQL efficiently?

Hi @all i try to create a ssh public key database on a mysql-5.0.16 DB the problem is the size of the varchar, i want a size 1024... mysql> create table sshkeys ( absid integer unsigned zerofill NOT NULL auto_increment, rsa varchar(1024) UNIQUE NULL, dsa varchar(1024) UNIQUE NULL, PRIMARY KEY(absid) ) ENGINE=InnoDB DEFAULT...

I'm new to MySQL. I have a copy of MySQL on my PC but it appears the only way to create a database is through a shell. I have a copy of MySQL-Front but I can't get it to connect to the database. I've used localhost and root and no password but it gives the error "Cannot connect to MySQL Server on "localhost"! Any ideas or is there...

I recently upgraded to mysql version 4.1.13 (server is SuSE linux 9.3) and attempted to re-install the Perl DBD::mysql module, which kept failing because it couldn't open /tmp/mysql.sock. After spending way too much time trying to figure out why it was trying to find that socket (my.cnf specifies /var/lib/mysql/mysql.sock), I finally realized...

i figured one of the gurus in here could tell me if/how this is possible already: i like simple, singular table names. For example "user". I bet you know the problem already: USER is a keyword, and when I query this table i get errors. Is there a way to make mysql's keyword-watching case-sensitive? so it would leave "user" alone but catch...

Hi, Newbie question... We have an online catalogue running off a mysql database, which we can back up. When we back it up, it creates a file online called "database.sql" which, when opened in Notepad starts... DROP TABLE IF EXISTS store_category; CREATE TABLE store_category ( category text NOT NULL,....etc

Hi All Is it me or is it sooo difficult to find what has been implemented between versions of the MySQL Administrator tool? I've looked all over the MySQL site and I simply can't find a simple version history page to let me know: a) What are the differences between the last v1.0 minor update and the one I have now, ie v1.0.21?

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

OK, I mucked up... My ROOT user has NO priviliges on ANY table... I, however only have INSERT and SELECT priviliges on the MYSQL table and SELECT on other tables... Can I create a new user that can then fix ROOT? Carl

my question is can i just install the new version of mysql, stop the old, point the data directory for the new one to the data directory and just start up mysql 5? or do i need to take some extra steps int eh process. also is there any data corruption possible in the process i described

I have three tables, containing information about three people and the cars that they own. One table lists people, one lists cars, and one uses the id's from the other two to compile a list of which models of car each person owns. Bob owns a Ford, Paul owns a Toyota, and Dave owns both a Ford and a Toyota. Simple. How do I create a...

I have two tables recording the sales transactions with purchase_id the common key Table 1 (Recording total amounts and customer info) Purchase_Id (Primary Key) Sales_Total (Total sales amount) Customer_Id ..... (Other fields)

The idea I'm trying to get at is that I want the tag info for the tag "photography", and I want the date, and I want a count of any comments a tag may have. This following query gets back all the info I want, provided the tag has at least one comment. If It doesn't have any comments, it doesn't show up in the return. But if it has a count of...

HI Please let me know what is the best way to generate reports for Mysql db. Please name the software or application. Thanks Roshan

Hello experts, I have a little group by problem, hope you can help me. I have a lot off records which I want to group by "HOUR(timefield)" example: 01-02-2005 13:28:00 25.0 01-02-2005 13:11:01 24.0 01-02-2004 13:10:03 23.5

Hi Newsgroup Hipe you can help me, I have a problem with a nested select. I have two tables; one with products and one with prices of these products: product - id, name price - pro_id, price, time (pro_id relates to product.id) Each product gets a new prices during time and I would like to join the

I know how to do this in SQL Server, but need the equivalent query to determine if a database exists in MySql. In SQL Server, the query is: Select 1 From Information_Schema.Schemata Where Catalog_Name='whatevermydatabaseisnamed' I'm not that familiar with MySQL, but betting the statement is different.

I'm using mysql databases. Presently, I'm working in MS Windows environment. Any scenario of how mysql and work in Windows?

8Zcc ----uMyItidGBFcIxNvn7Ubo Content-Type: text/html; Content-Transfer-Encoding: quoted-printable <html><head><style type=3Dtext/css>.eyebrow { FONT-WEIGHT: bold; FONT-SIZE= : 10px; TEXT-TRANSFORM: uppercase; COLOR: #ffffff; FONT-FAMILY: verdana,ar= ial,helvetica,sans-serif; TEXT-DECORATION: none } A.eyebrow:link { TEXT-DE= CORATION:...

Can i have a MySQL query which checks the table containing a list of names? I might have the following names on the table Sony Compaq Logitech Cabinet Fedora Angel

Hi, With mysql-4.0.20, I have a problem inserting data with foreign key references, MySQL saying ERROR 1216: Cannot add or update a child row: a foreign key constraint fails The message is confusing because a parent record in parent table exists !? The "show innodb status; " command prints :

Hi there I've noticed some very weird things happening with my current MySQL setup on my XP Laptop, a development machine. For a while, I have been trying to get the MySQL cache to work. Despite entering the required lines to "my.ini" (the new my.cnf) through notepad AND MySQL Administrator, the cache does not work. So, today I took a...