MySQL Database Forum

This has been discussed before back in 2002, and then in Feb of 2003 when I did a search on Google Groups for MySQL Table Sizes. Back then, people said go here: http://www.mysql.com/doc/en/Table_size.html However, people have posted replies at the bottom of this page saying that this information is severely out of date. Okay, so has...

------=_NextPart_000_0008_01C3600F.7D6CBCC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Shut down my Linux PC running MySqld and rebooted this morning and = cannot get mysqld up. In services when I click on mysqld I get the = message "Mysqld dead subsys locked" when i restart the server it...

We've run out of disk space and would like to move either the entire MySQL = system or if possible move the databases. Can this be done without any = difficulties? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au

Hi! >>>>> "Bennett" == Bennett Haselton <bennett@peacefire.org> writes: Bennett> Is there any way to do a long update/delete on a table such that you can Bennett> view the progress as the command runs, so that long before it's over, you Bennett> have some idea of what the total running time will be? Bennett> The way I did it was to...

Hi out there, I have problems finding a way to warn a user that another user intends soon to update the same specific row. Let me explain. User 1 get to a JSP "update customer record" page. - The page does a read of the existing record and loads it into the gui fields for edit.

Hi all, For a project I m working on I am looking for a database with all current car-makes & models from post-WII till now. With all the car websites around I am sure this information should be available somewhere so that I can import it into my MySQL database, but I simply can't find it. Does anybody know where I can get my hands on...

Hello guys, I need your help with this. I have a table that ,say, has 10 rows in it. One of the columns is called ID and has an integer number. I would like to change the ID number of all the rows by ascending numbers starting from 5. For example, row number 1 has ID number 5 , row 2 has 6, row 3 has 7 and so on: 5;.;.;.;.; 6;.;.;.;.;...

Hi, Does anyone know how I can store files (mostly pictures) into a mySQL table? I have tried the load_file function but it seems to not work. i just get NULL as the value. Any examples would be most appreciated. I am using RH9 and the latest version of mySQL. I know I should be storing the links on disk and the save a pointer in

Is there a way to do this in mysql 5.0? in mssql they have the EXEC function for this purpose.

Can anyone give me an example of calling a stored procedure with parameters and getting back the results? I can't find anything in the docs that talks about calling stored procedures. Ted

Hi Anybody has implemented View for MySQL? I think it can be done outside of Database if query transformation approach is used. CREATE VIEW Model SELECT * FROM Model_CA, Brand

I am having a problem with 2 sql statements in 1 batch file. Only the last statement executes. If I separate the statements into individual files they work fine. Are you only allowed 1 statement per file? Here is the contents of the batch file: insert into monlog (monlog_locno, monlog_custno, monlog_time, monlog_inputdate,...

I'm trying to perform a search that I can't find any information about in MySQL's manuals, discussion groups, or on the Web. I'm used to using BerkeleyDB's Btree, so I can browse to find the alphabetically next match against a query. If I query "faction" in a BDB btree database and use DB_SET_RANGE as one of the parameters, I can get...

First of all, I apologize in advance if this is covered somewhere in a FAQ. I did a Google search, but really couldn't find anything. I'm having a problem with a simple select query. I've got users uploading data into a database. I want to do something that seems as if it should be really simple, but it isn't so far. Basically, I want...

If I select from a table and, for example, group by the month or day to determine how much activity there is day to day or month to month, it will only return months and days with a record and leave out any month or day without any records making it apear at a glance that every day or month has activity which forces me or whoever to have to...

Is my understanding of the MySQL license correct for this situation? If I write software that uses MySQL as in client/server. I can distribute both together commercially so long as I make it clear that the source is available and maybe changed ie propagate the GPL license? TIA -- Mike W

I'm using PHP and found it unreliable when using the time() function passed to a variable and then inserted in to the database - I can't understand why, but I think the best solution would be for me to use the timestamp function in MySQL. How do I do this though? What is the syntax if I have a table called mytbl and a column name called t...

Hello, I have a table containing integer counters associated with particular datetime like this: CREATE TABLE `counters` ( ... `when` datetime NOT NULL default '0000-00-00 00:00:00', `counter` smallint(5) unsigned NOT NULL default '0', ...

Folks, I find it useful for browsing to dump each table of a DB, i.e. psuedo-code like foreach table mysqldump --add-drop-table DB table > table This produces a file per table, and that file has the DDL and data.

Hi; I have installed suse 8.2 a short while ago and at my first attempt to connect mysql (via shell and a perl dbi script) i get following error: can't connect to mysql server through socjet '/var/lib/mysql/mysql.sock'. i know this looks like a common error and I am terribly sorry if this kind of subject has been posted before but I'll...

Hi, In the C API, is there any way to execute a query, store all the results, and somehow find the maximum realized width for each of the fields before fetching each row? Otherwise there is no way to efficiently retrieve string data. The best you can do is either allocate a static buffer of 64K (max size for a blob) or some smaller buffer...

>Description: I've recently compiled mysql 4.0.14 on redhat 8.0. The installation fails, however, when running mysql_install_db. I've attached a transcript below. I gather from searching the 'net that this isn't an entirely unusual thing to happen, and is likely the result of some misconfiguration on my part, or perhaps a version...

I'm doing some experimentation with MySQL to see if we can support it with our next version of our application under VB.NET. I'm trying to use the .NET MySQLDriverCS set of libraries but I seem to be struggling with some of the syntax. I'm trying fill a dataset using the following SQL command: Drop Table If Exists `Temp0`; Create...

using mysql 4.0.21 is this the best way to get distinct names from both tables where shift is 20031007: SELECT m.user_full_name FROM press_maint m WHERE shift_date = 20031007 UNION SELECT p.user_full_name FROM press_prod p WHERE shift_date = 20031007

Unable to connect to any hosts due to exception: java.security.AccessControlException: access denied (java.net.SocketPermission localhost resolve) CAN ANYONE HELP?? What is causing this error? is it a MYSQL or JAVA/JSP Problem, i cant seem to work this out ?