MySQL Database Forum

i have a problem with a stored procedure. It works when i insert a new record but when i try to reinsert the same record again to test the "IF" statement, the server hangs and lost connection. CREATE PROCEDURE .... ( IN p_id INT, OUT p_status INT )

I want to create a pass through query in Access to get data from a MYSQL table. I need to do this using code so that sertain aspects of the query can be changed. When I look at the SQL version of a Select and a Passthrough query in access they appear to be the same. eg. "SELECT * FROM MYTABLE WHERE MYFILED = TRUE" What do I need to do to...

I have a question on a practice assignment that I can't solve. Can someone help me out? Question: The table Arc(x,y) currently has the following tuples (note there are duplicates): (1,2), (1,2), (2,3), (3,4), (3,4), (4,1), (4,1), (4,1), (4,2). Compute the result of the query: SELECT a1.x, a2.y, COUNT(*)

I would really appreciate some assistance with a query I need to make on my mysql db. I have three tables as follows: Orders order_id, order_date Pin_Orders orders_pin_id, orders_id(from the orders table), card_id(from the cards table) Cards card_id, card_name I would like to select the orders.order_id, cards.card_name for all

I have a user_account table consisting of an auto id, email address and password fields. The id is made the primary key. Is that a good idea or should i just discard the id and use email address instead? If I were to have the email address as a foreign key in another table, will the space consumed bigger that if i were to just use the...

I have to port a MS Access DB to anotherdatabase engine and I would like to use MySQL because I am familiar with it and is easy to integrate with the web and php what is the ned point of my 'quest'. However there are paramter queries in the access database and I would really like to keep the access database as a backup as long as I'm in the...

Hi there, Just how big a file can the Text data type contain (in kilobytes or Megabytes)? How big a file can a MediumText data type contain (in kilobytes or Megabytes)? Alan

Hi, I have the following table: CREATE TABLE user_account ( id.... email_address ...... password ....... activated...

Hi! I make a select with a select clause and I limit it to 5 results, but I need to know if there are more matches to enable a "next" link to see the others I've thought about not limiting it in the query but displaying only 5 results so I could know if there are more matches I don't display, but maybe it's slower. My question is: Is there...

Hi everyone, I input several commands into the command prompt such as SET @a = 'test'; I thought by deleting the database the variable will be destroyed but it turns out that doing a "SELECT @a", it lists a table consisting of 'test'. Does anyone know how to remove it and list several other variables that

I'm an ASP/M$ Access programmer who is leaving the Dark Side for PHP/MySQL. I'm used to adding, changing, deleting my Access database locally and then FTPing it up to my website. What are the ways I can make changes to an online MySQL database and how may I find out more about them? TIA Neill

I am attempting to import data from a text file. There are many records to be imported and the raw file format is: "1 |010-5502-502 |16H1-7-3 |CONTACT, ELECTRICAL, 7/8in. |356.0000 |0.0000" "1 |03-06-1062 |16H3-5-1 |RECEPTACLE,FREE HANGING 6 CON.|1.0000 |0.0000" "1 ...

What are the mechanisms to make words like a/an/the in text and varchar character fields ignored when performing SELECT and utilizing ORDER BY in SQL queries? I've done some hunting around into documentation on character sets (but they are geared mainly at character-by-character rules) and saw some reference to string collating and stop...

It is very interesting to me that most people in this group can't do simple SQL. Are you viewing MySQL as a simple file system?As long as you do that, you will not understand SQL in any dialect. So from now on: When you have a question about SQL. post the table structures. Uh, "With Create". Post some sample data in the form of INSERTS.

hi Hopefully this is simple enough. I'm running 3.23 and 4.1.7 mysql databases. I run a /usr/bin/mysqlhotcopy backup on a specific database name , and copy my.cnf and ib* files to the backup location. Is this all I need to do to restore? I did restore my mysqlhotcopy but I didn't try the whole lot yet...will do just want to check whether this...

I have a ~ 38 GB table (MyISAM) and am using myisamchk -r to recover it. Its been running for several days now (Win2k). When I go to check it, it seems to have slowed down (sometimes hangs without any CPU usage) and if I press the Enter key several times and just fiddle around on the screen (open task manager, etc.) it seems to "wake-up"...

Hi, I'm quite new to MySQL and quite impressed by its feature set. I've also been looking at Interbase and it has a feature that allows a multidimensional array to be stored in a single field. Does MySQL also have this feature? I was thinking about using MySQLs GIS data types but it only supports a two dimensional point, where as I need...

Hi, I am new to mysql and I want to ask a simple questions. I would like to initialize my InnoDB table space and I configure like below: innodb_data_file_path=ibdata1:1024M;ibdata2:64M:autoextend:max:1024M My questions are:

I am new to MYSQL (been working with Access for years and now seen the light). One thing I cannot get sorted is how to create relationships between my SQL tables. Can someone point me in the right direction. Alex

Hi all, I can't seem to change my max_connections variable in mysql. If I try to do it through the client I get this. mysql> set global max_connections=500; ERROR 1064: You have an error in your SQL syntax near 'max_connections=500' at line 1 Then put set-variable = max_connections=300

hi, could someone please tell me how do I get a query to show the (*) fields in table2 only when table2.field1 exist in table1.field1 thanks in advance. jenny table 1 contains -------------------------- field1

We have two main query types running against a table of some 2 million rows and have gotten query response down to well under a second by using the right indexes. Problem is that we are running an advertising campaign that brings a concentrated block of users to the site. When this happens one of the queries which relies on a particluar...

When the number of columns get large, it becomes increasingly difficult to view the results of a select in a small window (e.g. 80 line xterm) because of line wrapping. Can I have the results of the select query displayed rotated, e.g. like this: +------+------+------+------+ | | row0 | row1 | row2 | +------+------+------+------+ |...

Hi, I have a script running which fails when it tries to execute an Update query, but when i try to run the query from the SQLQueryAnalyzer it runs fine. Can somebody try and explain this phenomenon. Any kind of help will be appretiated. thanks,

How do I upgrade the standard version of mysql on FC3, 3.23, to 4.1 ? I already looked up some info on the internet, but it isn't quite clear to me. I can backup my data, it isn't that much, just personal stuff. Do i just rpm the client and server, first 4.0 and then 4.1 or do I have to give special options with the rpm command ? Will this...