MySQL Database Forum

Getting the following message when I click on the MySQL shortcut on my desk top: Error Starting Program The msvcrt.dll file is linked to missing export ntdll.dll:Rtlgetntversion numbers. A device attached to the system is not functioning. Have gotten both Dll's and stuck em in the system and program directory...

I have a new DB provided by my ISP don't know details of installation, setup etc. I can log in as anybody except root. mysql -h localhost -u mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 71 to server version: 4.0.16-log mysql -h localhost -u xxxxx

HI all, I want to ask whether I can do replication in the following case. innodb (master) --replication --> myisam (slave) Rgds, Ringo --

I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes. On one of the 7.3 and the 9.0 box, when I try to connect remotely, it takes about 45 seconds to connect, whereas the other 7.3 box connects almost immediately. The fast box has standard install of 7.3 with tomcat added. The 9.0 box is straight RH9.0 standard install. I can't...

This simple command always takes 0.30 seconds or longer: mysql> select foo from footable order by -foo limit 20; (get the 20 most recent foo's) This however, always takes 0.0 seconds: mysql> select foo from footable where foo>'2004-01-10' order by -foo limit 20;

Hello All, We are developing an application using PHP and MySQL 4.0.16, that we need to stress test. Can someone please point me to some testing tools we can use? Thanks. - Rajesh

Hello All, I'm wondering if anyone can tell me how to write an SQL statement that will select all records that are less than 10 minutes old, using a datetime column? Any help appreciated! Much warmth,

Hi all , can anybody tell me the differance between the innidb and myisam tables types . sanjay --

Based upon an article I read in http://archives.neohapsis.com/archives/mysql/2004-q1/0337.html I am trying to retrieve an "empty row" of fields from a table that may be empty. If I have this query: This will return 1 single row whereby I have the table columns within

how can I limit the number of databases a user can create? I wish to create an account in mysql for each site on my host computer and set the max number of databases each site can create. can this be done? AndiC

I'm just getting started and I already have a problem:( I inserted several rows by inserting an txt-file, but the tabs were not correct. So I want to delete all rows in the table. Unfortunatelly I can not find information about how to delete the rows. Who can help me?

I need to know how to add a column of numbers and get a total using my sql command. SELECT v.vid, title, purchdate, sum(cost) AS Total FROM Video v, Vidcopy vc WHERE vid.v = vid.vc I need to know how to add the cost column and get a total . Thanks for any and all help

I am trying to make a union query to join 4 tables. I have reduced the tables to just 5 fields and made sure that the field types and names are the same. I keep getting an error message ODBC call failed. I have tried various combinations of the tables and find that I can use any 2 of them but as soon as a third is included in the statement the...

Hi, I was using a 4.0.13-server and wondering about why LEFT() doesn't take advantage of an index, the way .. LIKE "X%" .. does. I was wondering if there would be any effort in implementing this optimisation, or if people should just be encouraged to use LIKE (as bug #747 mentions)? -- - Peter Brodersen

Hi MySQL fans ;-), I tried to get some experience with converting between the different password formats as describd here: http://www.mysql.com/doc/en/Password_hashing.html So I took this sample mysql> UPDATE user SET Password = OLD_PASSWORD('mypass')

hi there, I don't think it's possible, but I'll try the question. A friend of mine mailed me a access database (.mdb), but I only use Linux (RH 9.0) . Is there anyway that I can open the database in mysql? I googled the whole web. You are my last hope Thanks in advance.

------_=_NextPart_001_01C35BD2.6BADEC7D Content-Type: text/plain Hi, I am a Sun solaris 5.6 user. I do not have su or any other system permissions We have PERL5.005 on the box

Hi all, I want to get your opinions on how to increase available/free memory and performance on a heavy volume database server. I have MySQL 4.0.13 running on RH 7.2 replicated to another RH 7.2 using same MySQL version. Recently our master database server (2 AMD Cpu + 2Gb memory + 2Gb swap space) started to suffer from memory outages...

Hi all , can anybody tell me the differance between the innidb and myisam tables types . sanjay --

Hello. On MySQL, I've got a table I use as 'wild card'. I mean, I store data into it and, at the end, I dump all the date into 'production' table. Until now, I perform it following these steps: 1) I empty 'production' table 2) I make a SELECT of every rows of the 'wild card' table and an INSERT into 'production' table.

I have two tables ITEMS: items,description,mfg MANUFACTURER: mfg,full_name The items database has 230,000 records, the manufacturer, 493 records. I want to see how many records in the items table don't have a matching record in the

I've attempted to upgrade to MySQL 3.23 to 4.0. MySQL 4.0 server is working great, buy I couldn't get MySQL 4.0 client to install properly. Any help would be greatly appreciated. Here are the steps I followed: 1. Downloaded the server, client, and "Dynamic client libraries (including 3.23.x libraries)" rpms. 2. rpm -Uvh --nodeps...

I have a table I'm using for logging purposes with a schema like: create table results ( user varchar(255) .... ); Where user is not a unique field and I want to find out how many unique users there are in the table.

Hi My team has been assigned the work to manage the translation of Front Office Products of our company. The goal is to translate all the strings in different languages like French, Spanish, Italian etc. In order to automate the update/delete/addition/retieval of strings, we plan to use a database. Each strings will identified by unique ID...

HELP!!!! I want to test a VoIP billing platform that uses mysql RDBM and runs on linux. I know nothing about linux or mysql so I could use a little help. I got the OS installed and decompressed the distribution files for the billing system, but I can't work out how to administer mysql: From /usr/local/dataweb/voip-billing the install...