MySQL Database Forum

I hope someone can help me with this one. For performance reasons, I have a denormalized database. There are two tables in the database we can call them table a and table b. Both of theses tables contain columns that are text with comma seperated values. example: TABLE A ---------- id - integer - primary key

Hello, MYsql and PHP If I want to extract data with todays date then it's 'where blab blah = current_date()' For yesterday it's 'where blah blah = current_date()-1' But can anyone tell me how to extract all data from the start of the

i have a sql script that i know works, as i've borrowed it. i would love to execute it, but i dont know how! a lil info... the db is on a remote server , not on my computer, i access it using putty (ftp) . anything else that will be of use? tia strawberry.

How do I calculate the memory needed by a webserver (APACHE) connecting to a mysql server (different box). Is this only related to the select() operations / data transferred to the webserver? On the mysql server I assume that I have to calculate the max tabel size X the number of connections.. but I'm not sure about the web server size.

Hi all, Have a small question. I'm trying to import data from MsAccess to MySql, it performs great except the Ole Objects. What is the MySql equivalent format of a MsAccess Ole Object? Using MySql server version 4.1.14 and Meastro Frontend version 1.9.5.1

Hello, I am using an SQL script to create a temporary database backup. While there may be "other" or "better" ways to do this - I am really only asking if the syntax (with tweaking) is possible - and if so what it is. Here is a very stripped down version of what I'm trying to attempt: set @backUpName = 'myBackup';

Hi, I want to share my experience with you. If you have large tables, and you are doing joins, be extra careful that the keys in the joins have exactly the same size (and type). Don’t mix mediumint and int for example. There is a huge performance hit if your join keys are not the same size. This IS documented on mysql.com, but not...

Here is the problem I create an prediction system for NBA games the idea is any of my users can come and predcit for the game (who will win and what is the scores ) and everytime one of my admins come and add the score the system calculate the points users get and store them in the database

Hi, So when I do an mysql -e "select * FROM test" test > mike.txt, in mike.txt I get \n and \t. how do I not get this text in my mike.txt file!!! -Mike

Hi, How do you determine if a Date field is blank. In my Sql statement I only want records who's date field is blank (i.e. checking for only open invoices where Date_Paid = '' ...still open ...it doesn't work when I use that syntax) Thank you

Hello, I need your help in order to do my job faster if possible... I have to migrate an old MySQL DB to a new structure. Problem Examples: - In the old DB there are 3 tables that in the NEW become 1 - New relationship tables have to be created... because the old database has no relationships at all.

Hi, I'm running a fulltext query on a ~50000 record mysql database and while performance is usually satisfying - about 0.02 secs per query, i get a critical performance deterioration when looking for popular keywords (words that appear in more than 50% of the data) - about 0.25 secs/query. I know that the standard fulltext engine does not...

How do I marry mysqlbinlog and "tail -f" on Linux (or similar approach) so I get a running echo of mysql statements in the binlog as they are executed? Thanks. -- Posted using the http://www.dbforumz.com interface, at author's request Articles individually checked for conformance to usenet standards Topic URL:...

Hi, I have a table with approx. 150,000,000 ++ rows. It should be approx 80byte for each row. Now I'm planning to use it with mysql/innodb. Can you guys suggest anything about this. I have many questions... Can Innodb work well with such tables? Will queries (select/update) be slow?

I have a query that seems to kill the db for our website (causes the 'Too many connections' error). I would like to avoid this! Is there a way to test the query before the db goes down? I do not have access to a staging environment. I can access the db via Linux command line, or phpMyAdmin - however I can only select, update, and delete. ...

I am looking to set up a fail safe site. My idea is to setup three _duplicate_ sites with three different webhosts. The DNS provider (Zoneedit) provides a distributed failover system; the DNS host tests the primary website, and if it fails to respond, the DNS record is altered to point to an alternate site. The problem that I face is...

I'm having some problems optimizing this query: select distinct l2.* from linetmp l1, linetmp l2 where l1.fname = "" and left(l1.id,3)<> "SUB" and l2.fname <> "" and (l1.n1 = l2.n1 or l1.n1 = l2.n2 or l1.n2 = l2.n1 or l1.n2 = l2.n2) when i use explain on this query i get: id, select_type, table, type, possible_keys, key, key_len, ref,...

I was hoping someone could confirm my understanding of how InnoDB handles deadlocks (error 1213) and timeouts (error 1206). The way I understand it, with AUTOCOMMIT=0, if I issue 3 SQL statements (updates), A, B, and C (in that order), and get one of the errors above while issuing statement C, InnoDB will have rolled back statements A and B....

I'm sorry, I had a couple of typos in my original post. Here is the corrected version: How can I make MySQL reject duplicate rows when inserting? The table is quite large: 100+ columns and millions of rows. MySQL doesn't allow me to create a UNIQUE INDEX for all the columns (16 columns is the max.)

How can I make MySQL reject duplicate rows when inserting? The table is quite large: 100+ rows and millions of rows. MySQL doesn't allow me to create a UNIQUE INDEX for all the rows (16 rows is the max.) The brute force method (selecting the new row and inserting only when not found) is way too slow.

Hi, I've been asked to transfert a database from a webhoster to another. I think the database is on a windows box but I'm not 100% shure. The webhoster says it provides combined hosting on NT/Linux Servers. After exporting the database with phpMyAdmin I tried to import it to a Linux server with the mysql>source file.sql command via a ssh...

hi, all I have a red hat 9 and looks like it had mysql 3.2.54 installed before, but, actually not, i can not find the install folder and I can not uninstall it. So I am trying to install/upgrade to 4.1, but, still can not get it work. Here is what I did: # rpm -Uvh MySQL-server-standard-4.1.14-0.rhel4.i386.rpm warning:...

If I have two separate times, which are stored as varchars, in HH:mm:ss, how can I obtain their differences? For example, is there a way to obtain the time difference between, say '21:10:00' and '03:59:59' ? Thanks, Ike

I have a form used to populate 2 tables: Provider and Contacts. Provider has a foriegn key column - Contact1ID - which has a foreign key relationship with the prmary key - ID - in the Contacts table. The form submits data to Contacts then Provider but I need the ID generated by the Contacts submission to be entered into the Contact1ID column...

I have a table in which the records a bunch of fields; for this query, I'm interested in three of them - let's call them Fld1, Fld2 and Fld3. For each record in the table, these fields may or may not contain data (a stock ticker symbol - like MSFT, for example). Different records may or may not contain the same symbol in the various fields. ...