MySQL Database Forum

I am curious about the internal representation of VARCHARS. I cannot find any documentation on it in the mySQL manual. Will a VARCHAR(10) take up less space then a VARCHAR(80), even though they are variable? Thanks in advance, Dan --

I've read through the archives and spent hours on Google but I still can't figure this out. I must extract the data from a SQL Server *.DB file. Viewing the raw text, I can see that there views, grants, etc. at the top of the file, but this is a process that could not possible be done by hand. I've tried using Crystal Reports and SQLyog but...

Hello, I would like to know the status of the UTF8 support in MySQL 4.1. I tried to create a table using utf8 charset, and inserting hebrew text into it. it seems like it still treats this text as binary - for example the length() function returns 8 on 4 chars string, or when cretting a column using varchar(4) i can only insert 2 letters...

What is the better approach in MySQL from a performance point of view? I have approx 1000 stock market fond titles that I want to insert in MySQL on daily basis and keep them in there for some years, I'll then use the data for presentations, analysis,… the data I save is the name, the date, the lowest, highest and last value and the volume....

Hello, I would like to know the status of the UTF8 support in MySQL 4.1. I tried to create a table using utf8 charset, and inserting hebrew text into it. it seems like it still treats this text as binary - for example the length() function returns 8 on 4 chars string, or when cretting a column using varchar(4) i can only insert 2 letters...

Hi, ID_LOGIN is an integer Can anyone say me if this : WHERE index1=ID_LOGIN OR index2=ID_LOGIN must be slower than those 2 queries :

------=_NextPart_000_003E_01C34934.FBC032B0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hello, I'm looking for a solution to write a sql query that inserts a set of = data if the data id is not present and otherwise update the set.

I'm trying to help a friend with this. When I run this everything is fine SELECT * from clicks, urls WHERE clicks.url=urls.url AND urls.description IS NULL The clicks table has 31 instances of url that match 5 instances of url in the urls table. When I run the following I get a syntax error

I've tried this with both the RPM's and the source code and I have the same problem. I'm running Slackware Linux v8.1, and on the last attempt I built mysql from the source code by doing the following: (after unzipping the tarball) ../configure --prefix=/usr/local/mysql make make install scripts/mysql_install_db

We have the three tables below and for each customer, we need the following information; Result expected: Month | Sales total | Payment | Oustanding Jan | 1200.99 | 200.99 | 1000 Feb | 0.00 | 1000.00 | 0

We have the three tables below and for each customer, we need the following information; Result expected: Month | Sales total | Payment | Oustanding Jan | 1200.99 | 200.99 | 1000 Feb | 0.00 | 1000.00 | 0

This may be a silly question but what can be done to stop load-intensive MySQL processes taking down a server? Things like adding fulltext indexes to very large tables, or selects on very large (multi-million-row) tables just completely kill the box until they complete. I don't mind how long these things take but the box shouldn't become...

I have written a database for a quote of the day. When my php script pulls it into a table, it doesn't wrap. The cell that it is in is wrappable. To see what it looks like, goto twhs-physics.org. Any ideas? Thanks -- ------------------------ Erik Thompson ethomps2@columbus.rr.com http://twhs-physics.org

I am trying to figure how to make a single select query in one table between two fields to see if they are similiar. I need the second one to have a wildcard. I can easily do this with no wildcard to see if they are the same but I can't get anything to work when it should be LIKE. Example: Table: test Field1 = "testing 123"...

This may be a silly question but what can be done to stop load-intensive MySQL processes taking down a server? Things like adding fulltext indexes to very large tables, or selects on very large (multi-million-row) tables just completely kill the box until they complete. I don't mind how long these things take but the box shouldn't become...

Hi All, I want to bring back my mysql original database as well as root GRANTS as was during the installation because i installed an application that modified my root GRANTS and now I am not able to see my mysql database as I login from root account. I am not even able to create or delete any database when login as root. Is there any other...

I am trying to figure how to make a single select query in one table between two fields to see if they are similiar. I need the second one to have a wildcard. I can easily do this with no wildcard to see if they are the same but I can't get anything to work when it should be LIKE. Example: Table: test Field1 = "testing 123"...

Hi All, I want to bring back my mysql original database as well as root GRANTS as was during the installation because i installed an application that modified my root GRANTS and now I am not able to see my mysql database as I login from root account. I am not even able to create or delete any database when login as root. Is there any other...

Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) I changed the place for the socket file from "socket=/var/lib/mysql/mysql.sock" to...

Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) I changed the place for the socket file from "socket=/var/lib/mysql/mysql.sock" to...

Hi, I just joined this list and would like to search the archives before I ask a = question. I there a way to search. Thanks=20 -- MySQL General Mailing List

Hi, I just joined this list and would like to search the archives before I ask a = question. I there a way to search. Thanks=20 -- MySQL General Mailing List

I am trying to develop a web based database application to manage a Scout group. I need to control the level of access different visitors to the site are allowed to different parts of the database. I need to provide public information, including some contact details from the database, to unauthenticated (non-member) users and to provide a...

Hi MySQL Fans ;-) I would like to list all courses with have less than lets say 10 participants. Does anybody know how I would have to modify the code below to get this to work ? schedule_id is the course itself SELECT schedule_id,count(schedule_id) FROM attendance WHERE

I am trying to figure how to make a single select query in one table between two fields to see if they are similiar. I need the second one to have a wildcard. I can easily do this with no wildcard to see if they are the same but I can't get anything to work when it should be LIKE. Example: Table: test Field1 = "testing 123"...