MySQL Database Forum

Hi all. I have this table: CREATE TABLE sites_pages ( * id int(6) NOT NULL, * site_id int(4) NOT NULL, * name varchar(80) NOT NULL, * UNIQUE KEY site_id_name (site_id, name), * PRIMARY KEY (id, site_id) ) TYPE=InnoDB;

OK, I'm just learning MySQL, or at least trying to. I have a table with data as follows USER FIELDID VALUE 1 1 Bob 1 2 Smith 2 1 John 2 2 Smith etc.

I am new to mysql and would appreciate someone helping me out with this converting this statement from postgresql to mysql. INSERT INTO ossurjoinquestions SELECT *, RANDOM() as random_sort, trunc(1144355460, 0) as instanceid FROM ossurcommonquestions WHERE tid = '3'; So far I have INSERT INTO ossurjoinquestions( tid, question, ans1,...

The problem: I need to generate a 'unique string' for each row in a table. I already use auto_increment for system dependencies between tables. What is the best approach one of these or another? After generating a candidate 'unique string' the two strategies that came to mind are: 1. to then search the table's column to see if it is...

I've got a table located on my website and localhost. The table maintains a size of about 200MB. The table holds a running 4 weeks of data (50MB/week). I have a winapp that updates my localhost db each week and currently, I run a backup on the table using the MySql Administrator... then I run restore on my website's mysql server. This...

I am very new to MySQL- I currently have an VBA module using a VBSCript that will find different aspects of a text string that are a unique text string and turn it into a not so unique text string. Which allows for a more accurate count of text strings. example Item# Text string CountTExt 1 Now is the time to call me at 800-001-0055. 1 2...

I am new to databases and would like to know if there is a good book on databasde theory that would be worthwhile to read. The DB I have in mind seem to be complicated and I need help figuring out how to set it up. Thanks Don

Hi, Connecting to mysql using a secure connection is not a problem and I've configured it within a minute but now I've created a user which needs to connect to the server using "REQUIRE X509" and I can't find a solution to this problem. Does anybody of you ever got this working and can help me? Tom

Hi, I have recently decided to start using MYSQL instead of MS Access 2003. After reading through numerous articles i have learnt that i can use access as a GUI for making changes etc to the MYSQL databases. My problem is that i am unable to set this up correctly - would anyone be able to give me a set by set guide on how to do this...

Hi Guys, does anyone know how to export mysql so that i can set it up on my ISP windows server ??. i s there some sort of export command to do this ?? if there is a step by step guide on how to do this could someone please point me towards it.

I installed MySQL4.0. No for creating a databse the help says like go to "mysql>" prompt and then enter some commands. How do I get this prompt ??

hello everybody. i am new to MySQL and want to build some asp pages providing search facility where search result displays from database. i have successfully created database in MySQL 5.0, but i can't show them in asp pages. the browser gives me following error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Access...

Hi, I am new to MySQL. I want to create a script file which will include a number of commands and execute it, just like we do in Oracle. Can any one tell me how to do it? Suppose I want to create a script called "temp" that will contain say 4 create statement. I want someone to show me how to create that file and execute it. And how to...

Hi, I'm converting a desktop application Delphi/Paradox to a web server application PHP/MySQL What data type should I use in MySQL for the following paradox datatypes ? Boolean ? Currency ?

After 2day of trying and googling and...my problem still remains. I compiled udf_example.so from mysql sources CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example.so'; Error Code : 1126 Can't open shared library 'udf_example.so' (errno: 0) uname (Debian distributions): Linux 2.6.12-1-386 #1 i686 GNU/Linux

The following code does not select the appropiate fields, it select everything with in a zip code ( as an example)and so on. I have tried to modify but I am a rookie and everything I tried has failed. Help please $query = "Select xxx, xxx, xxx, xxx, xxx, xxx, xxx From `list_data` where (keyword like '$keyword%' and zip='$zip' or key2...

Is it possible to determine number of connections to a particular database in MySQL? If yes..can anyone show me the way to do it in DML or normal query form? ? Thanks for replying and helping out!!!

I have a table with about 100,000 records whose description is: +-----------------------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+----------------------+------+-----+---------+----------------+ | ID ...

I'm trying to install MySQL. During the security settings portion fo the setup. I keep getting a Connection Error. Error Nr. 1045 Access denied for user'root'@'localhost'(using password:YES) ........ I had Zonealarm running. Changed the trusted zone security setting to low(disabled) then selected "retry" Failed again.

My trying to paste CSV data into my dataBase sometimes the pasted data creates errors. After that my prompt looks like this: "> then I'm not able to enter any commands, the "> prompt keeps repeating every time I hit "enter" I have to shut the window and restart MySQL. Thanks, Greg Noss

Hi, I just downloaded MySql using Windows XP. It takes at least 30 seconds to open a recordset. What am I doing wrong? Thanks Joel

I would like to send my PHP or MySQL out and get the stock data I need for me. Can they do this? Don

Maybe this is something simple, maybe I just don't see it... I recently did a test upgrade from MySQL 4 to 5.0.19, and most everything seems to be working great. I also upgraded my PHP to 5.1.2 (and it's possible that the problem is in the PHP upgrade, not the MySQL upgrade... but I need a place to start). Most everything seems to be...

Hi, today I noticed by accident that our mysql server occassionaly runs out of connections. This is very bad and I did not notice it before. I have now increase the maximum connections from the default 100 to 500. To avoid other performance issues I was wondering, which settings I should also increase besides the maximum connection count?...

I can't seem to find my earlier post about my problem, so I'll post this here. I got the following error (with an 'x' in the 'Apply security settings' part on the final step of the wizard). Hopefully someone knows how to fix this: The security settings could not be applied. Error number 1045. Access denied for user 'root'@'localhost'...