Re: Storage of UTF-8 char in MySQL

r. Rather, when the characters is sufficiently weird then UTF8 will use 2 or 3 bytes for that specific character only. Only if your entire message is weird, will each character consume 3 bytes. Wkr, Werner,- -- http://werner.yellowcouch.org/ signature.asc Description: OpenPGP digital signature

Re: How to deal with 96 Dimensional Points ?

Geert-Jan Brits wrote: > Perhaps you could give us a (generalized) description of your use-case, so > we can better grasp what you want to achieve, and how you want to use it. > i.e: since I can't imagine/ envison a real 'eucledian distance' over 96 > dimensions I bet you're talking a generalized d

Re: How to deal with 96 Dimensional Points ?

Hello Chris, The use case I' m talking about is actually a typical usecase for GIS applications: give me the x closest points to this one. E.g: give me the 10 points closest to (1,2,79) or in my case: give me the 100 points closest to (x1,x96). A query like yours might be possible and might be

Re: How to deal with 96 Dimensional Points ?

ing to define a distance measure based on each individual point. I'm not sure this is feasable. In general: KD-trees are quite good tools to deal with such large dimensional spaces, but I see no possibility to use them in mysql, Wkr, > > > On Tue, Mar 30, 2010 at 11:39 AM, Werner Van

Re: How to deal with 96 Dimensional Points ?

Geert-Jan Brits wrote: > You're most likely talking about something like consine-similarity on > N-dimensional vectors. > http://en.wikipedia.org/wiki/Cosine_similarity > http://stackoverflow.com/search?q=cosine+similarity > Cool links ! Although it is not why I need it for. I'm really talking abou

How to deal with 96 Dimensional Points ?

Hello, I have been pondering this for a while, but never really looked deeply into the problem. I have 96 dimensional points and I would like to pose queries such as: 'give me all points that are within such a radius of this one'. The gis extensions to mysql might support such type of query. The

Source-Install 5.0.85 on Debian Lenny: MySQL-Client segfaults

eciated. Thank you, Werner PS: Here is the strace of the mysql-Call corleone:/usr/local/mysql/bin# strace /usr/local/mysql/bin/mysql -u root execve("/usr/local/mysql/bin/mysql", ["/usr/local/mysql/bin/mysql", "-u", "root"], [/* 15 vars */]) =

MySQL-Client Segfaults

eciated. Thank you, Werner PS: Here is the strace of the mysql-Call corleone:/usr/local/mysql/bin# strace /usr/local/mysql/bin/mysql -u root execve("/usr/local/mysql/bin/mysql", ["/usr/local/mysql/bin/mysql", "-u", "root"], [/* 15 vars */]) =

Re: LOAD - failure for a non-admin user

Reyna.Sabina schrieb: > Hi, > > I am using MySQL 5.0.45, for redhat-linux-gnu (x86_64). > > I created a new database called HYDRO (user: admin). I created a new user > called 'hydro' in the 'localhost' ([EMAIL PROTECTED]) without a password. > User 'hydro' has given all provileges except the ' Gr

Re: Using Flush Hosts in cron

Hank schrieb: > On Tue, Sep 9, 2008 at 11:48 AM, Werner D. <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > Hank schrieb: > > I have the blocked connection problem between three of my servers, all > > behind two firewalls and on one switc

Re: Using Flush Hosts in cron

on these > mysql servers? better solution: increases max_connect_errors if you are sure, that there ist really no network-problem e.g. --max_connect_errors=10 Werner -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need Help Migrating DB from MySQL 5.0.x to MySQL 4.0.x

] > --password=[PASSWORD] --host=[HOST] [TARGET DB] > > > > ERROR MESSAGE RETURNED > > ERROR 1193 (0) at line 23: Unknown system variable > 'character_set_client' > > mysqldump: Got errno 22 on write > try the mysqldump-option --compatible=mysql

Re: MySQL-Backup incremental Backups in a Master/Slave Environment

that point you were doing the comparison and not just to the next full backup? Could it be that i need to execute a "FLUSH TABLES" before doing the mysqldumps on the Slave to force Data in the Cache to be written into the DB ? Thank you, Werner -- MySQL General Mailing List For li

MySQL-Backup incremental Backups in a Master/Slave Environment

hen in the Dump from yesterday with applied binary logs :-( Why do I miss some ROWS? What is wrong within my recovery procedure? Any hints are greatly appreciated :-) Thanks, Werner -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Matching subtables

Sebastian Mendel wrote: Werner Van Belle schrieb: Hello, You might find the following challenging -or- you might now the answer :-) Table Q Subtable, field, val, ID A 1 a42 A 2 b42 B 1 a78 B 2 t78 B 3 o78 C

Matching subtables

the return value Subtable, field, val, ID A 1 a42 A 2 b42 C 1 u23 Is there anybody that bumped into a similar query and was able to solve it satisfactory ? -- Dr. Werner Van Belle http://werner.sigtrans.org/ -- MySQL General Mailing List For

Re: write lock and sql_cache

TABLE foo WRITE; > > thread 2: > SELECT * FROM foo ; > I have the result of the select; that was not 'locked' :( > > the only way I found to avoid that is use the SQL_NO_CACHE (then SELECT > SQL_NO_CACHE FROM foo) > > is that correct?! there is a way to avoid to speci

Re: How to extract data from the show table status?

matted table. Here is an example showing a few columns: $ mysql -u root -p -e "SHOW TABLE STATUS FROM world" | awk '{print $1, $2, $5, $6, $12}' | column -t Name Engine Rows Avg_row_length Create_time City MyISAM 4079 67 2008-01-14 Country

Re: group_concat display limit

ble to a higher value which is constrained by max_allowed_packet. Werner -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: importing a single table from mysqldump

VARCHAR(128)); LOAD DATA LOCAL INFILE 'imports/ensgdescriptions.csv' INTO TABLE EnsgDescriptions; Wkr (don't write this in your script :-), -- Dr. Werner Van Belle http://werner.sigtrans.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: Connect To Foreign Tables

been nice if I could just use various databases through the same local server. Are there any solutions for this kind of problem ? Werner,- -- Dr. Werner Van Belle http://werner.sigtrans.org/ signature.asc Description: This is a digitally signed message part.

Re: mysql on tmpfs

ystem. However, even though there is plenty of free memory linux makes weird decisions from time to time, temporarily killing performance, swapping in/out to make room. Without more information it's difficult to say what's causing it. How do you check swapping activity? Werner -- MySQL

Does mySQL support Pascal/C++ like Unions

Hello! Does mySQL support a thing like Pascal/C++ unions for attribute types, i.e. an attribute can be of two types at the same time. Thanks in advance. Florian

DB Structure

Greetings, I've got two tables that I want to join on building and room. Right now I'm doing it on Building Name, but I was wondering if it would be better to have a column for the building number in each table and do the join on that instead. Is it better to join on numbers rather than stri

Werner Meyer/L4A/EAGA/EAG/AT ist außer Haus.

Ich bin vom 15.08.2003 bis 01.09.2003 außer Haus. Ich werde Ihre Nachrichten nach meiner Rückkehr beantworten. Während dieser Zeit erreichen Sie meine Vertretung Fr. Renate Trummer unter: Tel. 0316/8056-514 Fax 0316/8056-400 E-Mail [EMAIL PROTECTED]

problem with Mac OS X install

0.1 3306' I checked to see if mysqld was running and it was/is. Can somebody tell me what is going on here and how I can solve this? Kind Regards Werner van Mook

Re: Trying to do a set difference

ql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Herzlich Werner -- MySQL in Deutschland: Anpassung, Unterstützung,

Re: myODBC?

TECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Herzlich Werner -- MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/

Re: Mailing labels

:33:00: > Hi! > Does anyone know the correct tag sequence to produce Mailing labels with > the 1.7.5.1 version of mysql, I try every wich way to produced them, but > I had to resort to export the data to excell or word in order to produce > them. > Bruno Herzlich We

Re: Tourn off Errors displaying

please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.co

Re: Select statement didn't return results though there should be results

'% asia %' > AND subject NOT like '%winter%') > OR etc. > > The user states that these are logically equivalent - and I think > he is correct. But the result sets are different. Sinisa writes: They are NOT logi

Re: joins with concatenated keys

his should be. You should have more constraints like AND a.name LIKE 'joe%' or something or you use SELECT DISTINCT See also http://www.mysql.com/doc/S/E/SELECT.html http://www.mysql.com/doc/D/I/DISTINCT_optimization.html Herzlich Werner -- MySQL in Deutschland: Anpassung, Unt

Re: database action

but if I do, I would write some functions which do the job. For example, this function retrieves the address of a client from the client ID: function getAddr($id){ ... } In these functions, you are not limited in any way except by your skills and fantasy. Herzlich Werner -- MySQL

Re: store and display image with java

the images sitting somewhere on your disk. You will save yourself much aggrevation in the long run. http://conf.php.net/pres/index.php?p=slides%2Fintro&id=or2001 Herzlich Werner -- MySQL in Deutschland: Anpassung, Unterstützung, S

Re: Encryption of Data

people have answered this one without knowing anything about the job at hand - and I guess this can go on like this for a while. Herzlich Werner -- MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Dr. Werner Stürenb

Re: Encryption of Data

know if you must have root access to be able to do that - if so, your ISP won't give it to you. Normally, you should be quite seasoned in Linux to work with cron ... Herzlich Werner -- MySQL in Deutschland: Anpassung, Unterstützung, Sch

Re: shadow tables?

ays. Again, this is 3.23.39, compiled from source, running on OS X > Server (details below). > Another question: I'm trying to remove some unused databases, but this > command: > ./mysqladmin -u root -p drop ac > (where 'ac'

Re: Select statement didn't return results though there should be results

AND NOT data2 like '%winter%') OR (data3 like '% asia %' AND NOT data3 like '%winter%') OR (see_also like '% asia %' AND NOT see_also like '

Re: Quoting in Queries

it begins and ends easily, but not good with strings and the like for the same reasons. -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\

Re: LAST_INSERT_ID()

manipulated. So you always know which last_insert_id you have. -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MyS

Re: Encryption of Data

and credit card numbers. -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\_

Re: Virtual Server?

the domain names, and he knows them from ther directory tree already. Same principle: you don't have access except to your own. -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /

Re: LAST_INSERT_ID()

he original author but this takes the Id from first insert in you put > it after it and then you can use the $lastID in following inserts, works fine. Why not use mysql_insert_id(); -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___

Re: Mysql Installation

f this applies to NT as well, but I should think so and you can find out immediately. -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\

Re: Looking for Info on

[EMAIL PROTECTED] schrieb am Dienstag, 21. August 2001, 21:07:24: > Also I am looking for and examples on building a MySQL Manager in Delphi as well. There is one out there already: http://mysqlfront.de See also http://anse.de/ -- Herzlich Werner MySQL in Deutschland: Anpass

Re: Startin MySQL upon boot in Win2k

7;path'. You can also create a c:\\my.cnf file that holds any default options for the MySQL server. - If you have problems installing mysqld as a service, try starting mysqld with the full path: 'C:\mysql\bin\mysqld --install'. If this doesn't work, you can get mysqld to

Re: LAST_INSERT_ID()

s, you won't get what you want or rather run into big trouble :-( You play safe if you stuff the first number you are interested in into a variable of your program and use this one for all subsequent inserts. -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterst

Re: How to get all of mysql error message

shell, use perror number, i.e. perror 127 gives Record-file is crashed -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /_

Re: Setup own DB for each user?

;t lead somewhere. Users cannot access databases of other users unless set up this way, they only have names. The names usually correspond to the subdirs of those users, and every user can see these as well using telnet or ftp. So what's the point? -- Herzlich Werner MySQL in Deutschland:

Re: mysql becomes slow

ion of a second. And if it is not, something weird is going on and I would like to see this problem really understood and solved. It may turn out to be not a problem of mysql proper, but who knows at the time being? -- Herzlich Werner Stuerenburg __

Re: Backups from Server to localhost

tp%3A%2F%2Fwww.koehntopp.de%2Fkris%2Fartikel%2Fwebtune%2F&Sequence=core machine translations are sometimes fine, but often incomprehensible - seems like much work is left to be done there. His point is that _nothing_ coming from out

Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #1

escribed in http://linux.oreillynet.com/pub/a/linux/2000/06/29/hdparm.html and since then things went back to normal without any other tuning. Oh, one more thing: I changed pconnect to connect in php. So it looks as like we had load problems at times due to poor hd performance which gave trouble to

Re: naming feilds

t; table? I would say: not without some magic on your behalf. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pfer

Re: Formatting Price Field in my Table so 0.20 does not become 0.2....

(the manual) >http://lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg

Re: Problems with the unique properties...

/lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg

Re: Error altering column name

MAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683

Re: SQL underscore character question

To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, T

Re: synchronisation (replication)

rt/delete/update the web database, I insert/delete/update some data locally for testing and later addition to the web. I don't see any way to automate such a two way communication, and it is certainly not possible with the replication mechanisms at hand. --

Re: case sensitivity issue

table syntax make any mistakes, so I think it is phpMyAdmin, but I don't know - I didn't care to check. Check the tablename(=filename) and rename the table or change the name in your scripts. -- Herzlich Werner Stürenburg ___

Re: imigration of db from server 2 localhost as backups

PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 52

Re: Replication

web site to a new file (a snap with my editor), paste it to the sql textarea and click the go button. If it is more than a few records, this is not feasible either, so I upload that file via ftp and feed it like above into mysql. If somebody knows an easier way, I'd be glad to learn. -- Herz

Re: 2008 : MySQL client run out of memory

ause ? >> > I tried a debugger called Body but It is so slow that I could die before. >> > >> > Thank you >> > >> > Patrice >> > >> > ----- >&

Re: 2008 : MySQL client run out of memory

-- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTE

Re: error codes ??

> I don't have root access to my server, and also can't find a list of what any of the >errcodes mean. > Looking for help > Peter -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdis

Re: mysql-php mailing list

about 300 email out of 3000. And the > browser said page not found. > Any ideas? Yes. It timed out. You adjust it with set_time_limit(0);//indefinitely -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverd

Re: Logging connections

le unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fa

Re: Truncated User List

can still > recreate the original problem & still do not understand it. You are correct, in my understanding it should have worked ok. So I am interested in a solution to this, too. -- Herzlich Werner Stuerenburg _ ISIS Ver

Re: "Got an error reading communication packets"

rouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > ----- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > To r

Re: "Index length too long", but no index specified!

se check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscri

reading error

ssive problems and I found out about it in hostname.err. Any ideas where I can look at or test? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-99

Re: '/tmp/mysql.sock' (111)

f closing mysql during shutdown - otherwise you have to do it yourself, and if you don't, you may damage your tables. Get yourself WinMySQLadmin from http://mysql.com Also, make sure you read all readmes and install guides and docs that came with the installation. -- Herzlich Wern

Re: How to add an excel file directly to MySQL database using PHP?

sv or txt. This looks like you are only interested in the plain ASCII and structure and don't want to conserve anything that adds on that. In this case it will be a good idea to convert xls to any of these formats, because you will save a lot of space. --

Re: Query Acting Weird

ysql does when running wild. I did this to test queries that seemingly produced errors, but when reproduced, they did not, so this was proof that neither the query nor the data had problems. -- Herzlich Werner Stuerenburg _ ISIS Verlag,

Re: Help selecting something that occurred in past 5 minutes

only want outputted a number >> that corresponds to how many uniq.id's have been accessed in past X >> time period. >> >> SELECT postcard.uniq_id, (now() - accesstime) as smalldiff, >> recipients_last_name, accesstime >> FROM postcard >

Re: Databases on Removable Media?

n this question in the manual. How about giving it a try? You will find out immediately. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeit

Re: Crazy Threads

he old ones and start new ones. Data from an hour should be easy to manage. Hence you will see exactly what mysql does and what kind of errors occur, if any. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdi

Re: How can try to recover the data from mysql

Rupak schrieb am Dienstag, 10. Juli 2001, 10:27:47: > I think my mysql database carsh but I hope there are some utility to > recovered the data crash. read on myisamchk or recovery in the manual. -- Herzlich Werner Stuer

No Database Selected /weird behaviour

he machine. Previously, I had another site on the same machine which produced much more load. Back then, I experienced similar problems with processes hanging. Is this a clue to something? What kind of questions could be asked in this situation? -- Herzlich Werner S

Re: Searching in a mysql table

address like "%" Omit it and you will be just as fine. If you have an index an name, that is. Otherwise mysql will have to read all records. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntr

Re: generate database script from existing table?

; on another machine and currently I have no way of doing so. get yourself phpMyAdmin and set it up (you need your username and such). Then it's a snap. Good tool for all sorts of things. Loog in google for it. -- Herzlich Werner Stuerenburg _

Re: importing text files using phpmyadmin

nd fix the problem. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeit

(Got an error reading communication packets)

hostname.err says (Got an error reading communication packets) (Got an error writing communication packets) I had to shut down the server. What does this mean? This relates to SHOW PROCESSLIST Id Command Time State Info 6 Query 81 Locked SELECT * FROM staticStrings

Re: hostname.err

Sinisa Milivojevic schrieb am Mittwoch, 1. August 2001, 16:04:45: > Werner Stuerenburg writes: >> To track down problems, I downloaded hostname.err, hostname.log >> and hostname-slow.log and, as these were quite big (log = 350 >> MB), I deleted them on the host. >>

hostname.err

files hostname.err, hostname.log and hostname-slow.log yesterday and find that .err and .log have been written to, which may be normal. In addition, .001 has been written to also recently. Any explanation to what is happening here? My ISP says they didn't do anything with MySQL. -- Herzl

Re: account?

be, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0

Fwd: RE: Re: msg from MAILER-DAEMON@web.mysql.com

Dies ist eine weitergeleitete Nachricht Von: Adam Douglas <[EMAIL PROTECTED]> An: "'Werner Stuerenburg'" <[EMAIL PROTECTED]> Datum: Mittwoch, 1. August 2001, 00:40:33 Betreff: msg from [EMAIL PROTECTED] ===8<==Original-Nachricht==

Re: Writing 100+ fields with Perl DBI

from what I've seen I > probably can't carry over the iteration through the (up to) 100 > actual survey questions. I named the MySQL fields 'q1', 'q2', > anticipating some way to do a loop, but I can't see it. > Does anyone have any sugges

Fwd: Re: msg from MAILER-DAEMON@web.mysql.com

ge - From: "Werner Stuerenburg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 31, 2001 8:10 PM Subject: msg from [EMAIL PROTECTED] > This is one of several similar messages I received today. Someone > to take care of it? > > Hi. This is the qmai

Re: msg from MAILER-DAEMON@web.mysql.com

e- >> From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, July 31, 2001 12:11 PM >> To: [EMAIL PROTECTED] >> Subject: msg from [EMAIL PROTECTED] >> >> >> This is one of several similar messages I received today. Someone >> to

Re: Database Security

o unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 52

msg from MAILER-DAEMON@web.mysql.com

t work out. <[EMAIL PROTECTED]>: Sorry, message has wrong owner. (#4.3.5) I'm not going to try again; this message has been in the queue too long. --- Enclosed is a copy of the message. -- Herzlich Werner Stuerenburg _ ISIS V

Re: How to know which row was affected with a querry ???

an I know > precisely what was the number (auto increment primary key) > given by MySQL to this new inserted row ??? You may presume > there are many simultaneus users adding rows, so I need a > accurate information. > Thank you for your kind help, > Ziggi --

Re: howto insert an image as blob?

>http://lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg ___

Re: Parsing text file into mysql database.

ving to cycle through each individual entry > into the table to do error checking to check for existing users, etc. > Thanks, > Kit > Original Message Follows > From: Werner Stuerenburg <[EMAIL PROTECTED]> > Reply-To: Werner Stuerenburg <[EMAIL PROTECTED]>

addition for manual section 24.5.1

"memory_limit", "16M"); -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de

Re: reindexing tables

.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg ___

Re: Parsing text file into mysql database.

FROM autoren; Here you see already that you can specify exactly how you want the records to be written. The result looked like this: 1,"Werner Stürenburg","[EMAIL PROTECTED]" 2,"Priv. Doz. Dr. med. Th. Rommel","" 3,"Regina Steinkrauss","[EMA

Re: Parsing text file into mysql database.

am in need of some extra assistance on this topic. I kinda know what's > going on here, but just need to see it to understand it, you know? So if > you could, extra assistance would be greatly appreciated. > Thanks, > Kit > Original Message Follows > From: We

top reports Status D

che status, but neither showed anything valuable. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-9

Re: not null

manual.php (the manual) >http://lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner St

  1   2   3   >