Save newsletters in DB

Hi there, I have an urgent question: Because of server restrictions (and unwilling administrators) i have to change a newsletter section for a site from xml/ xsl/ dom (in PHP) to database driven. I have tried the LONGTEXT in mysql. The problem i have now is the rendering of this text. If i use

Cannot Create New Database

Hello, I am new to My-SQL... and I have installed MySql under Windows 2000 SP3. I am using WinMySQL 1.4 for administration but I am not able to get the option to add a new database when everything seems to be working alright ( no errors in the err file) Version of MySQL: 3.23.55-max-nt OS: Win

Start MySQL along with a update statement.

I need to start MySQL using a script which does the following: 1. login to MySQL 2. use a specific database 3. run a update statement 4. exit I have been able to achieve 1 & 2 by doing the following but not the others. mysql -D test Can anyone help me please ? Thanks. __

Re: MySQL Grant issue

On Tue, Feb 25, 2003 at 06:12:26AM +0800, Jon Miller wrote: > I had asked in the past the following: > In MySQL I need to create a user that has limited privileges (I figure the GRANT > command can handle this), just need to know how to make sure they can > only view what they have access to, or do

Re: Select based on related date

Assuming that you *don't* want ALL purchases made prior to the range, but only those of subjects not purchased recently, the following query appears to work: -- First gather info about recent purchases Create TEMPORARY Table recent SELECT B.id, B.date_purch, S.subj FROM subj as S INNER JOIN book

Re: Help to install Mysql on Macos X 10.2

On Monday, February 24, 2003, at 10:57 AM, [EMAIL PROTECTED] wrote: By default, even on OS X servers, you do not have the C compilers. You need to install the Developer Tools which may have come on a CD with your Jaguar CD sets. Otherwise, it's a free download from Apple (http://www.apple.com/deve

Re: How to Read MySQL codes???

Hi, I do not understand what you mean with "where are the different ..."? Build it once with Visual Studio and use the tools provided there. It takes some time to understand the way it is done. Erich DiAnNe iRiS aLeRta wrote: i have downloaded the source code for mysql but had a hard time read

MySQL codes

i am to make a feature for mysql which is horizontal aggregation for our thesis. is this existing already? if not, is vertical aggregation existing? can you show me the codes for it? i need it to have a basis for developing the horizontal aggregation. horizontal aggregation is collecting values

How to Read MySQL codes???

i have downloaded the source code for mysql but had a hard time reading it. i mean, where are the different functions for different features found? how can i read it? or how can i know that that function is for such feature? thanks very much! hope to get answers from you soon i need it for

RE: Maximum Table Size Reached

Hi, Would anyone be able to confirm that mysqld-max-nt.exe does not have a 4 GB limitation. I'd like the DB to go up to 40GB and 330 million rows. I am flexible, I'll use the biggest DB I can create. ISAM seems to be the obvious choice but would INODB perform better on inserts for a large DB, s

Continuing problem

After emailing with Mark Mathews, who had some very good suggestions, I pulled down a copy of mysql and compiled just the libraries locally. That went fairly well. I was able to create the libraries and include files and succesfully link with them under CygWin. I'm running the Windows mysqld ap

RE: MySQL & ZeosDBO - A newcomer question

I assume that you are using Delphi? I would recommend that you create a data module and drop a ZMySQLDatabase component on the data module, configure your connection to your MySQL database using this component. Add a ZMySQLTransact component and point the database property to the ZMySQLDatabase c

Select based on related date

I'm having trouble with a query that I thought would be pretty straightforward. To simplify, I have a database of books that has, say, two tables: CREATE TABLE book ( id INT, date_purch DATE ) CREATE TABLE subj ( book_id INT, subj TEXT ) Each book can h

ampersand in match against

iH how do i properly escape the ampersand character in a mysql select match against statement> mysql> select * from logbook where match(username,body) against ('AT\&T'); does not find a match although it should thanks - hcir -

Re: Help with a putting a slash into a record in mysql...

try using a double slash "\\" - the first one acts as the escape character. also works for the ' - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 6:52 AM Subject: Help with a putting a slash into a record in mysql... I have mysql ins

Re: Help with a putting a slash into a record in mysql...

Try prefixing the \ (the ***x escape character) with a \, i.e.: update test set f2 = 'c:\\temp' where f1 = 'location' HTH, Tore. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 5:52 PM Subject: Help with a putting a slash into a reco

Re: Select from multiple tables

First, you need to perform a JOIN on the two tables, otherwise you will get all combinations of rows from the two tables. But that is not what you are asking about. Using SELECT * is considered a bad programming practice. Always specify the select list (the columns you want to see/need to work o

Re: Dumping a database

yes mysqldump database name >filename.sql where database name is the name of the database to dump and filename.sql is the file to dump it into including a valid pathname.. it will dump everything into the text file as valid mysql statements that will let you run the script again.. actually when yo

Dumping a database

Hi all, I've seen that it is very easy to export an entire database using mysqldump. Can I export any database using this program? Will it export the sql statements for creating indexes, and the binary fields? Can I restore any database exported with this method without any problem? Thank you.

RE: Very poor Solaris benchmarks

> I admit that I scanned your message very quickly (I am in the middle > of a few critical tasks right now) - I just noted that you had > received no answers and wanted to see if I could get more > details and > work up some interest in your question at the same time. :) Thanks > Have

Help with a putting a slash into a record in mysql...

I have mysql installed on Red Hat 7.3. I have created a table like the example below: create table test(f1 char(30), f2 char(30)) Here is my problem I am trying to update this table with this: update test set f2 = 'c:\temp' where f1 = 'location' There is already a record with location in f1, bu

Re: mysql or pathon date question

In the last episode (Feb 24), Vivian Wang said: > mysql, > The question is: > > If I use unix date Command like: date -date=20030220 +%j > I will get 051 which is Julian date. > > I like to know how I can get Julian date if I use mysql or Python. Mysql's date_format function supports the same es

mysql or pathon date question

mysql, The question is: If I use unix date Command like: date -date=20030220 +%j I will get 051 which is Julian date. I like to know how I can get Julian date if I use mysql or Python. Thanks. - Before posting, please check: ht

Select from multiple tables

Hi, I got the following query: SELECT * FROM t1,t2 In the result I get as column just the column name only, but I like to get the table name with it, just I must use it in the where clause. How can I do this? Thanks in advanced, Frank de Bot --

Re: Unknown table in field list

You are getting two rows not because there is one in parcels and one in building, but because one of the tables has two rows and the other has one that matches according to the WHERE clause and the join criteria. To see the "source data", do separate selects on the two tables: select * from parce

Re: MySQL Grant issue

I had asked in the past the following: In MySQL I need to create a user that has limited privileges (I figure the GRANT command can handle this), just need to know how to make sure they can only view what they have access to, or does the GRANT command handle that also? Thanks -- Jon Miller <[EMAI

Re: several newbie problems

At 21:23 19.02.2003 +0100, you wrote: Or you could configure this in your c:\windows\my.ini configuration file: [mysqld] ... skip-innodb (In this case, you have to restart the server for the changes to take effect.) Nice, thanks. mysql>> use nick > Reading table information for completion of table

RE: getting NULL in auto_increment column

It does not sound like your data is properly normalized. You might want to take a look at the way you have things set up, this sounds like it cause problems later on. -Original Message- From: Danny [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 1:54 PM To: [EMAIL PROTECTED] Sub

4.0.10 rpm doesn't include POSTIN script

The 4.0.10 MySQL-server rpm's don't include the POSTIN script. I'm guessing this is because of moving the server to a subpackage and the POSTIN scripts being spec'd for the main package. It's easy to see this by running: rpm -qp --qf "%{POSTIN}\n" MySQL*4.0.9*.i386.rpm rpm -qp --qf "%{POSTIN}\n"

Re: Cardinality for FULLTEXT-indexes MySQL 4.0.10

Hi! On Feb 24, Tobias Lind wrote: > Hello! > I never got any comment on this one... > Have noone else observed this behavior? > I'm a bit worried to use this in my production site without knowing if it's > and indication of some problem with FULLTEXT indexes... :) > > Regards, > Tobias Lind It's

Re: getting NULL in auto_increment column

gerald_clark writes: >Danny wrote: > >>Can you update an auto_increment with NULL in MySQL? Obviously if you >>try and put a NULL in directly it will increment to the next integer. >>Is there some way to actually get a NULL in there instead of the >>integer? >> >> >No. >Why would you want to? B

RE: case expression

Makes sense. Thanks for the help! Rik Forgo JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 > -Original Message- > From: Jon Wagoner [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 4:51 PM > To: R

RE: case expression

Consider the CASE statement to be a function, that can only return values. Aliases would go outside the CASE STATEMENT, as follows: SELECT CASE WHEN CHARACTER_LENGTH(system) > 65 THEN CONCAT(LEFT(system, 60), " ...") ELSE system END AS system, wsh_year, id

Re: SQL question - no CREATE VIEW in mysql

Luca, > In Oracle I could create a view from the initial table, what about MySQL? MySQL will support views as of version 5.1. I cannot find it in the todo (http://www.mysql.com/doc/en/TODO.html) but I saw it elsewhere. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH

RE: case expression

Thanks, that works fine. If I wanted to create an alias for the column, how would I do that? The first select statement (before the Else) is the current column name. When I add 'AS system' to the end of the string, it fails. Ex. SELECT CASE WHEN CHARACTER_LENGTH(system) > 65 THEN

RE: case expression

Put the other fields after the CASE statement: SELECT CASE WHEN CHARACTER_LENGTH(system) > 65 THEN CONCAT(LEFT(system, 60), " ...") ELSE system END, wsh_year, id FROM wsh The CASE statement just returns 1 field. -Original Message- From: Richard For

RE: Unknown table in field list

Jon and Tore, thanks so much for your kind help. I greatly appreciate it. I still have one bit of confusion about this whole thing. I'm reading through the manual as I type this so maybe I'll find the answer. If someone can help clarify, I'd appreciate that as well. Running this query: mysql>

Re: Question mark becomes NULL

sql, query I'm not sure about perl, but I know in JSP you can substitue ? for values to avoid getting SQL syntax errors from variable values that have funky characters, apostrophes and the like. I'm not sure if Perl implements the same SQL statement syntax but with php and stripslashes - it's not

analyzing mysql general query log

Hello, Can anyone recommend a script to analyze a mysql server general query log. My goal is to determine which users are putting the most load on the server. Any other methods to achieve this same goal would be appreciated as well. Thank you. __

case expression

Hello all ... be gentle, I'm new at this: I've got a simple case query. One works (the top one), but when I try to add additional columns to the query it fails. I reckon it's a pretty simple mistake I'm making, but I don't know what. Any help is appreciated. ---

SQL question - no CREATE VIEW in mysql

Hi People. SQL problem: given a table where each column is a number, let's say that I wish to create a second table where columns are the sum of specific columns of the first, i.e.: col_1 + col_2 + col_3 + col_4 > col_1 of second table col_5 + col_6 + col_7 + col_8 > col_2 of se

Re: # of Business Days?

If you truly want only business days - i.e. you don't want to count Holidays - the only solution is to have a tables with all the business days. You'd populate this periodically with future dates as required, and a human may be required to mark off the holidays (unless you can create an algorithm t

Re: Question mark becomes NULL

At 15:45 24-2-03 -0500, Keith C. Ivey wrote: On 24 Feb 2003, at 21:07, Daneman wrote: > INSERT INTO MyTable (MyFields) VALUES ($val1, $val2, etc); > > Question marks are no longer replaced with NULL values in the text > column this way, still, when I enter question marks into the charvar > fields,

Re: Question mark becomes NULL

If you want to insert question marks into a character field, then you must surround them with quotation marks as you would with any string. I don't see you entering any questionmarks. I see you defining an insert command that uses placeholders for the values entered in the execute statement. You

Re: getting NULL in auto_increment column

Danny wrote: Can you update an auto_increment with NULL in MySQL? Obviously if you try and put a NULL in directly it will increment to the next integer. Is there some way to actually get a NULL in there instead of the integer? No. Why would you want to? ---

Re: Question mark becomes NULL

On 24 Feb 2003, at 21:07, Daneman wrote: > INSERT INTO MyTable (MyFields) VALUES ($val1, $val2, etc); > > Question marks are no longer replaced with NULL values in the text > column this way, still, when I enter question marks into the charvar > fields, the record is not taken into he database. I

Re: getting NULL in auto_increment column

> Can you update an auto_increment with NULL in MySQL? Obviously if you > try and put a NULL in directly it will increment to the next integer. > Is there some way to actually get a NULL in there instead of the > integer? No that's why you declare it NOT NULL when you create it. ---John Holm

Re: # of Business Days?

Where I work: 1) We created a table for holidays (projected data for the next few years). 2) Created a function for the day of the week. 3) If M-F and not Holiday, then perform routine. We had to go this route because there are way too many bank and market holidays to keep straight with just code.

Re: Question mark becomes NULL

At 14:25 24-2-03 -0600, gerald_clark wrote: And you still have not shown us how you are entering the question marks. Like this: $sql = qq{ INSERT INTO main (id, categorie, achternaam, voornaam, aanspreektitel, straat, huisnummer, postcode, plaatsnaam, telefoon, mobiel, email1, email2, tekst) VAL

getting NULL in auto_increment column

Can you update an auto_increment with NULL in MySQL? Obviously if you try and put a NULL in directly it will increment to the next integer. Is there some way to actually get a NULL in there instead of the integer? - Before postin

Cardinality for FULLTEXT-indexes MySQL 4.0.10

Hello! I never got any comment on this one... Have noone else observed this behavior? I'm a bit worried to use this in my production site without knowing if it's and indication of some problem with FULLTEXT indexes... :) Regards, Tobias Lind Hi! I have a question regarding "Cardinality" for FUL

Re: Question mark becomes NULL

And you still have not shown us how you are entering the question marks. Daneman wrote: At 10:06 24-2-03 -0500, Keith C. Ivey wrote: On 24 Feb 2003, at 13:42, Daneman wrote: > I use a perl script & DBI to insert records into a mySQL database. > This database holds 1 text-column. Now when this

Re: # of Business Days?

Hello This is not correct, see this at example: From friday to mondey there are 4 days (or 3, depends on how you count ;-). your calcs: $day = 4 $weeks = 4 / 7 = 0 $weekend_day = 0 * 2 = 0 $business_days = 4 - 0 = 4 If you have 100 weeks, then it will be quite correct. here is my solution: $day

ÄãÔõÑù²ÅÄÜÉÏÍø׬Ǯ³ÉΪ¸»ÎÌ£¿

小小投资你将迈向百万富翁的行列 小小投资,巨大回报网络时代营销新观念,网络赚钱首选 ★告诉你一个好消息★：一套让中国人迅速富起来的赚钱方案，真的很容易让你赚到钱的网络营销系统，一个月赚万元的创业机会现在就摆在你的面前。据统计，仅在10月份一个月里，全国就有5341人在网络的淘金中，月收入超过3000元。目前月收入最高者为天津的罗国柱147570元/月；上海的林勇139132元/月，而这一切都是在工作之余在家或在网吧中完成。 该系统无风险投资：一次性买断属于你自己的网站行销系统。 操作轻松简易：系统自动生成，您只要会打字即可。 管理安全可靠：拥有属于您自已的个

Re: Question mark becomes NULL

At 10:06 24-2-03 -0500, Keith C. Ivey wrote: On 24 Feb 2003, at 13:42, Daneman wrote: > I use a perl script & DBI to insert records into a mySQL database. > This database holds 1 text-column. Now when this text-field holds any > question marks, they appear in the record as`NULL`. Post the Perl co

RE: # of Business Days?

use Date::Manip http://www.perldoc.com/perl5.6.1/lib/Date/Manip.html -J -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 1:33 PM To: 'Lucas Cowgar'; MySQL Mailing List Subject: RE: # of Business Days? >>Can anyone out there help me w

Problems returning a row count with rows() function

Greetings - I have a simple CGI script written in Perl (using v5.8) that seemed to work well under MySQL 3.23.49. However, after recently upgrading to version 3.23.55 I am running into the following problem. Previously, I used the rows() function to return the number of rows ret

Re: MYSQL 3.23.55 Install Issues

At 17:43 24/02/2003 +, Simon Tyler wrote: Hi, Hi, I've been trying to get the 3.23.55 version of mysqld-nt.exe working with our product (GMS Mail) and I'm running into install\service related issues. I've read through the various threads on this list and nothing seems to solve my problem.

RE: # of Business Days?

>>Can anyone out there help me with a SQL query? I need to find the number of business days between date a and b? >>Obviously finding simply the number of days is easy, but I have no clue how to find the number of business days. >>TIA! Here's some ropey perl I wrote a ages back to calculate workin

Re: Question for the GRANT statement

Ian, Yes, you can put a wildcard but I would advise against it if you are going to be inside any kind of secured environment. If soneone were trying to hack your database, the could do it remotely because MySQL wouldn't care where the connection was coming from, for example, someone could log

RE: Question for the GRANT statement

The % wildcard works for granting permission over the network. When you are working on the localhost, you are using mysql.sock to connect to the server. Try this (I believe it should work) /bin/mysql -u iz3 ip'iz' -h'youripaddress' This should allow you to connect using the network and not mysql

Visual Basic Embedded VC++ DLL

Hi! Has anyone created a DLL in VC++ the uses the embedded mysqlserver.lib library? Is it possible to do this? Is there any special settings that are needed? I have compiled a DLL that does this, but then I run a function wich encapsulates mysql_server_init(), I get a memory error and my VB pro

Re: Question for the GRANT statement

Thank you Lucas. But why I have to put localhost at the end? The manual says that I can put a wild card "%", like iz3@"%". Or if I did not put anything, it will automatically assume localhost. Thanks again. Ian Zhang [EMAIL PROTECTED] wrote: Try this: GRANT ALL PRIVILEGES ON izdb.* TO iz2

Re: Question for the GRANT statement

Try this: GRANT ALL PRIVILEGES ON izdb.* TO iz2@'localhost' IDENTIFIED BY 'iz'; Lucas Cowgar Information Technologies Department Eldorado Services Group Inc. http://www.eldoserv.com [EMAIL PROTECTED] (330) 861-3009 "All your base are belong to us" - Original Message - From: "ianhzhang

Question for the GRANT statement

Hi, I am new to MySQL and SQL in genreal. I just installed mysql 3.23.55 on my Red Hat Linux 7.1. I tried to GRANT user in the following way: CREATE DATABASE izdb; GRANT ALL ON izdb.* TO iz1 IDENTIFIED BY 'iz'; GRANT ALL ON izdb.* TO [EMAIL PROTECTED] IDENTIFIED BY 'iz'; GRANT ALL ON izdb.* TO

Re: redirect mysql output to file

Mike, > How do i redirect a mysql output to a file from the command line? > For example, I want to save DESCRIBE test_table > test_table.file > without doing a MYSQLDUMP. To have the mysql client write a protocol, start it, and then do: mysql> tee myoutfile.txt Logging to file 'myoutfile.txt'

Re: # of Business Days?

Here's a link to a solution that Oracle came up with: http://dco-proxima.dco.pima.edu/oracle/tfts/PRE00136.HTM You should be able to adapt it to MySQL and PHP (or whatever language you are using). Basically, the script gets the start date and end date, then steps through every day counting only b

Re: Directory structure

Depending on how you plan to use the data, you may be interested in the "Nested Set Model". There are articles listed at searchdatabase.techtarget.com if you search for that string, but you may need to register there (can't supply links as they contain user ID...). Or if you have Joe Celko's SQL

BUG: Format function fails when query ordered

Hello, I am reporting a bug. The format number function fails when a query is sorted. I have included an example page to look at (the error is reproduced here): http://www.meetscoresonline.com/test_format.asp You'll see there are 2 result sets, the first is not ordered and the 2nd is ordered.

Re: redirect mysql output to file

On Mon, Feb 24, 2003 at 10:50:53AM -0700, Mike Doanh Tran wrote: > Hi, > > How do i redirect a mysql output to a file from the command line? > For example, I want to save DESCRIBE test_table > test_table.file > without doing a MYSQLDUMP. Use the mysql command line client from your command lin

Re: Unknown table in field list

Just what it says. Your first query attempts to list a column from a table that is not selected from (building). Your second query attempts to assign the alias "building" to both the parcels table and the building table, and then subsequently does a join on the building table. Use the following

help starting replication across platforms

I am trying to start replication from a 4.0.9 solaris master to a 4.0.8 linux slave. I am already sucessfully replicating this master to another sun slave. I followed the same procedures on the linux box but no joy. The error log keeps saying : 030221 10:08:56 mysqld started 030221 10:08:56 Inno

RE: # of Business Days?

I'm not sure of an exact query, but if you can get the total number of days you can mathmatically get the biz days with the following math (in psuedo code): $days = total_days_between_a_and_b; $weeks = ($days / 7); $weekend_days = $weeks * 2; $business_days = ($days - $weekend_days); Hope this he

RE: redirect mysql output to file

In *NIX you could do this: $ echo "sql commands here" | mysql -uroot -ppassword -hhost database > /path/to/file For extra scripting fun you could backup tables using this: for i in `echo "show databases" | /usr/local/mysql/bin/mysql -uroot | grep -v "Database"` do mysqldump -uroot $i > /path/t

Re: redirect mysql output to file

At 10:50 AM 2/24/2003 -0700, Mike Doanh Tran wrote: >How do i redirect a mysql output to a file from the command line? >For example, I want to save DESCRIBE test_table > test_table.file >without doing a MYSQLDUMP. >From the command line: $ echo 'describe test_table' | mysql {dbname} > test_ta

# of Business Days?

Can anyone out there help me with a SQL query? I need to find the number of business days between date a and b? Obviously finding simply the number of days is easy, but I have no clue how to find the number of business days. TIA! Lucas Cowgar Information Technologies Department Eldorado Services

optimizing large InnoDB table

I have a couple of questions here. This table currently contains about 12 million records. This table is mostly read from, but several times thoughout the day there will be inserts or updates of batches of about 30,000 rows, and there are periodic purges of old rows, which could be up to sever

redirect mysql output to file

Hi, How do i redirect a mysql output to a file from the command line? For example, I want to save DESCRIBE test_table > test_table.file without doing a MYSQLDUMP. thanks, MT - Before posting, please check: http://www.mysql

Directory structure

Hi, I am trying to figure out the best method for creating a directory with mySQL (Lasso). Let me first say that I am new-ish to SQL, so might be jumping into the deep-end. I am building this for a site and am looking for a fast method of displaying where users are in the directory, or where a

Re: BUG Mysql 3.23.54

On Mon, Feb 24, 2003 at 10:19:01AM +0100, G. Hesen wrote: > When using the client library with php: Have you also changed versions of PHP? > Earler(earler mysql version) mysqllib: > SELECT userfield.*,user.* FROM . > [1] =>123 > [userid] => 123 > > Now with MySQL 3.23.54 mysqllib:

MYSQL 3.23.55 Install Issues

Hi, I've been trying to get the 3.23.55 version of mysqld-nt.exe working with our product (GMS Mail) and I'm running into install\service related issues. I've read through the various threads on this list and nothing seems to solve my problem. The situation is that we include MySQL with our pro

RE: Unknown table in field list

Change the query to: SELECT parcels.DXF as 'record', building.ADDRESS as 'results1', parcels.relname as 'results2' from parcels INNER JOIN building on parcels.DXF = building.DXF where parcels.relname LIKE '%jones%' order by parcels.relname desc; For tables in the from list, the next word after a

INSERT INTO table1 VALUES (DEFAULT): Auto_increment colums do not count up

== INSERT INTO table1 VALUES (DEFAULT): Auto_increment colums do not count up == I am trying to insert values via PHP into a table with an autoincrement f

Re: mysqld got signal 11; This could be because you hit a bug ....

Mariella Di Giacomo writes: > Hi, > > I would prefer the debug version which the latest I believe is the 4.0.10. > The same error I get it when I run ALTER TABLES or I try to insert data > into tables. > > > I will try and let you know. > > Thanks, > > Mariella > 4.0.11 will be quite soon, b

Unknown table in field list

Hi again. I've tried searching the list archives for this all morning, but they don't seem to be working (never get any results, page times out). I found one report of this on google but the guy said he figured out the problem but didn't say what he did to fix it! I just added a table to my data

Re: mysqld got signal 11; This could be because you hit a bug ....

Hi, I would prefer the debug version which the latest I believe is the 4.0.10. The same error I get it when I run ALTER TABLES or I try to insert data into tables. I will try and let you know. Thanks, Mariella At 06:31 PM 2/24/03 +0200, you wrote: Mariella Di Giacomo writes: > Hi, > > I will in

Re: AUTO_INCREMENT and INDEX feature?

* Julian > MEDIUMINT takes only 8 bytes, but BIGINT takes 20, so the whole DB No, MEDIUMINT occupies 3 bytes, BIGINT 8 bytes. http://www.mysql.com/doc/en/Storage_requirements.html > > grows, moreover in Mysql documentation I read about indexes and column > optimization and thay sad: medium int i

Re:Re: AUTO_INCREMENT and INDEX feature?

On 24 Feb 2003, at 17:44, Julian wrote: > MEDIUMINT takes only 8 bytes, but BIGINT takes 20, so the whole DB > grows, Where did you get those numbers? According to the documentation (http://www.mysql.com/doc/en/Storage_requirements.html), MEDIUMINT is 3 bytes and BIGINT is 8. And why are you

Re: Large table or several tables ?

4 million rows is a large table, but not a huge table. 400 is a large number of tables. Does the data in the 400 arrays describe the same type of entity or do they provide *generic* attribute info for different types of entities? If so, they would logically belong in a single table, otherwise no

Re: mysqld got signal 11; This could be because you hit a bug ....

Mariella Di Giacomo writes: > Hi, > > I will install the 2.8 debug version. > > The reason why I set > setting sort and record buffers to 1K > is because with a few tests I have noticed that I was getting a better response > time for queries. > > The limit for the core file was unlimited. > > I

Re: mysqld got signal 11; This could be because you hit a bug ....

Hi, I will install the 2.8 debug version. The reason why I set setting sort and record buffers to 1K is because with a few tests I have noticed that I was getting a better response time for queries. The limit for the core file was unlimited. I will look into customer support. Mariella At 06:17

Re: mysqld got signal 11; This could be because you hit a bug ....

Mariella Di Giacomo writes: > Hello, > > I have followed your suggestion. > I have installed mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit on the > Solaris 8 (Machine with 8 cpus, 32GB of Memory and 64 of swap) server. > I have started the mysqld program as root > I have specified the > cor

Re: mysqld got signal 11; This could be because you hit a bug ....

Hello, I have followed your suggestion. I have installed mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit on the Solaris 8 (Machine with 8 cpus, 32GB of Memory and 64 of swap) server. I have started the mysqld program as root I have specified the core-file in the /etc/my.cnf file. Other info t

Re: Large table or several tables ?

Depends on in which manner you are going to be using the dB I'd suggest, i.e. just for storage for the arrays or querying the data while it is in the dB. If the data is all related and you are going to be running queries across the whole data set I'd put it all in one table, if the quires that you

Re:Re: AUTO_INCREMENT and INDEX feature?

No, you understood me wrong. MEDIUMINT takes only 8 bytes, but BIGINT takes 20, so the whole DB grows, moreover in Mysql documentation I read about indexes and column optimization and thay sad: medium int is always better than int - in context of that article. I would like to do as small as pos

Re: Speed improvement with packet proceeding!?

It sounds like you're suggestion something like Oracle does with PL/SQL, which I think is the better way to go. Then it's really up to the user to decide how to optimize multiple steps by creating a batch of commands to be run. On Sunday, February 23, 2003, at 03:57 PM, Julian wrote: I'm not

Re: Heiki, InnoDB crash #2 (update)

Michael, this is further evidence that the corruption last time was not a bug in the insert buffer, but this is general Linux table corruption. I already suggested that you should upgrade to Linux-2.4.20 or some other recent kernel. Please send me the full .err log. If you can keep the old corrup

Re: Question mark becomes NULL

On 24 Feb 2003, at 13:42, Daneman wrote: > I use a perl script & DBI to insert records into a mySQL database. > This database holds 1 text-column. Now when this text-field holds any > question marks, they appear in the record as`NULL`. Post the Perl code you're using for the insert query. It so

Large table or several tables ?

Hye the list, There is my problem. I have to register about 400 large arrays (~1 lines each) in my MySQL database and I don't know which of the following choices is better. Either create a large tables as a stack, which contains all arrays Either create as many tables as there are arrays and

Re: MySQL on windows

As I said, all depends on what you are used to , as to which is going to be the least painful path. Jerry - Original Message - From: "KH Chiu" <[EMAIL PROTECTED]> To: "Jerry" <[EMAIL PROTECTED]>; "Simon Windsor" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 1

  1   2   >