Re: Experience with MySQL 5

ly, on that box, I keep everything as the latest binaries available. I haven't worked with it through PHP, but I certainly have through JDBC, and the ODBC. No issues to date, really. Martin C.F. Scheidecker Antunes wrote: Hello, Does anyone has experience with MySQL 5.x? How reliable is it? I

Odd rounding errors with 4.1

cimal places? Anyway, any help is appreciated. Martin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Odd rounding errors with 4.1

Huh, you know. Now that I'm not at work and therefore don't have my numbers to check against, you're right. Man, I must need more coffee. Never mind me. :) May be back tomorrow, though, when I have the numbers in front of me. I know they didn't add up earlier... Martin Ha

Re: Odd rounding errors with 4.1 [Duh, me!]

Yeah, I checked the math after another responder. Either I was smoking crack at work today (a state likely induced by too much/too little caffeine) or I mis-noted my numbers. I'm going to check again when I get back there tomorrow. But thanks :) Martin Dan Nelson wrote: In the last ep

AES Encryption

g the most reasonable thing here to use the AES encryption? And a question I always had is where to store the keys? Currently I'm thinking somewhere in the webapplication source code, but I'm not so sure about this. Any help would be greatly appreciated, Thanks, Martin

RE: AES Encryption

ite strange, but so far I solved it by limiting the number of characters by 256 in my application, but ofcourse that's not ideal... Thanks, Martin -Oorspronkelijk bericht- Van: Gleb Paharenko [mailto:[EMAIL PROTECTED] Verzonden: woensdag 15 juni 2005 14:31 Aan: mysql@lists.mysql.com

Reorder a table

table into a new one and in this new table: 2) order the datasets by timestamp 3) change the primary key (an integer) for all datasets, so that the oldest datasets gets id 1 Many thanks Martin -- Geschenkt: 3 Monate GMX ProMail + 3 Top-Spielfilme auf DVD ++ Jetzt kostenlos testen http://www.gmx.net/d

Re: Reorder a table

the primary key (an integer) for all datasets, so that the oldest datasets gets id 1 Thanks, Martin > > Michael > > Rhino wrote: > > > - Original Message - > > From: "Martin" <[EMAIL PROTECTED]> > > > >>Hi all, > >> >

ORDER BY DESC order different when using LIMIT

*** 4. row *** ImgId: 3 CreatedDate: 2002-11-22 4 rows in set (0.00 sec) >Fix: Don't know >Submitter-Id: >Originator:Martin Gillstrom >Organization: >MySQL support: none >Synopsis: ORDER BY DESC order different when using LIMIT >

installation problem on XP again...

Okay I have installed mysql on windows XP-home, and cannot get round the Error cant connect to mysql server on localhost <10061>. I have read the manual again and again and again...I have read the public mailing list again and again and again...I have tweaked the `ini` file using the winmysqladmin

mysql-test-run

/cygdrive/g/mysql/mysql-3.23.55-pc-linux-i686/mysql-test $ mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases ../bin/mysqld: 1: Syntax error: "(" unexpected Error: Could not install master test DBs What is the cause of this error? Thank Y

Re: can't start safe_mysqld

Andreas- I have similar problem (bash shell) $ mysqld ./mysqld: 1: Syntax error: "(" unexpected Do I use the same solution or different solution? I would give anything to understand what Syntax error: "(" unexpected is trying to say Thanks, Martin - Original Message -

Re: Migrate mysql from SunOS 5.8 to Windows 2000

Not if 0)strong processor (at least 2GHz) 1)you have enough RAM (1GB will do) 2)have enough SCSI or RAID Drives (with hopefully 1GB Free) 3)gets tricky with Process Management as Win2k process Management utilities are sparse (no cron or kill utilities) -Martin - Original Message - From

Re: A question about using C API in mysql (linux platform)

AGS += -pthread else # Assume Linux LDLIBS += -lpthread endif # This works for simple one-file test programs sources := $(wildcard *.c) objects := $(patsubst %c,%o,$(sources)) targets := $(basename $(sources)) all: $(targets) clean: rm -f $(targets) $(objects) *.core Keep us apprised, Mar

Re: control center

Which command are you running? Martin - Original Message - From: "ruchir dhar dwivedi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 04, 2003 1:22 AM Subject: control center > Hello > 1.I am having problems in connecting my mySql Control cen

Re: About JDBC

Hsu Where did you acquire mysql-connector-java-3.0.6-stable.zip ? Martin - Original Message - From: "®}¸S¬F" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 05, 2003 7:05 AM Subject: About JDBC Sorry~ I have a problem about JDBC now, I us

CREATE TABLE adds ZEROFILL

, revised datetime NOT NULL default '-00-00 00:00:00', approved datetime NOT NULL default '-00-00 00:00:00', score int(11) NOT NULL default '0', type int(11) NOT NULL default '0', locked datetime NOT NULL default '-00-00 00:00:00&#x

Fwd: Re: MySQL 3.23.52

Forwarded Message: > To: Martin Brülisauer <[EMAIL PROTECTED]> > From: [EMAIL PROTECTED] > Subject: Re: MySQL 3.23.52 > Date: Tue, 3 Sep 2002 14:15:42 +0200 > - > Your message cannot be posted to [EMAIL PROTECTED] because it did not > follow the format expected b

stupid install question

shots look great - this will really help the productivity! Regards, Martin = | e-mail: [EMAIL PROTECTED] | | website: http://www.powerhouseu

FreeBSD V4.3 - install from port top shows mysql daemon using 25.7MB

Hello. Just installed on FreeBSD. No database created yet, just a straight install I was surprised at the amount of memory the daemon is taking 25.7MB - Is that correct ? - Before posting, please check: http://www.mysq

CREATE from a mysqldump won't CREATE a table in 3.23?

MARY KEY (file_id), KEY version(product,platform,version_num) ) TYPE=MyISAM; ERROR 1064 at line 11: You have an error in your SQL syntax near 'version(product,platform,version_num) ) TYPE=MyISAM' at line 34 What gives and is this a bug? How can it REJECT something it gave me as a mysqldump? Curi

Re: Compile error

Actually the function is called sprintf() rather than snprintf(), to the best of my recollection, and it's probably defined in either stdio.h/stdlib.h or string.h. Change snprintf to sprintf() and see what happens. - Original Message - From: "John Markunas" <[EMAIL PROTECTED]> To: <[EMAIL

CREATE TABLE randomly adds ZEROFILL for INT

int(11) zerofill | | | 000 || | revisor | int(11) zerofill | | | 000 || | revision | int(11) zerofill | | | 000 | >Fix: Don't know. >Submitter-Id: >Originator:

Cant connect

Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in setup.php on line 92 I am sure that all information is correct as far DB name user name and password any ideals

Re: what is this? --> errno=2006 errmsg=Server gone

ble to further dig into the cause of this problem? regards, martin Martin Olsson wrote: Hi, I get this weird error message: ErrNo: 2006 Error: MySQL server has gone away. What does it mean? I couldn't find anything useful on google and the error message isn't exactly &qu

Re: what is this? --> errno=2006 errmsg=Server gone

tly which parameters can I tweak to fix this error (i.e. errno=2006 errmsg=Server gone)?? At this stage _any_ help/hint/guess would be really appreciated. regards, martin Dilipkumar wrote: Hi, If this is related to mysql please let us know what version you are using (Mysql) and which OS. This err

Problems when compiling the source

mpiler options since the gcc 2.95.2 days... maybe it was about time to get some updated info about the mysql crews favorite compiletime options. regards Martin Jespersen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems when compiling the source

n Tuesday 20 June 2006 12:02 pm, Martin Jespersen wrote: ./configure --prefix=/opt/.mysql-4.1.20 --enable-assembler --enable-thread-safe-client --enable-static=all --with-gnu-ld --with-mysqld-user=mysql --without-debug --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-charse

Re: Just need script for creating tables

--no-data should do the trick, try to do mysqldump --help and read the output Xiaobo Chen wrote: Hi, all If I use 'mysqldump', I will get the script to create the tables and those 'insert' statements to insert the data. I am wondering if I just want the first part, i.e, the script to create t

assembler not found or what?

me that it isn't going to use assembler functions, even tho /usr/bin/as is in the path. anyone have any idea why? Regards Martin Jespersen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Field list error in Stored Procedure

State` = 0, `Title` = var_a; until b = 1 END REPEAT; Close MemType; END; Many thanks in advance Martin -- -- [EMAIL PROTECTED] -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Field list error in Stored Procedure

', var_a ,'\';'); PREPARE populate1 from @Populate; EXECUTE populate1; DEALLOCATE PREPARE populate1; end; And that works! Again, many thanks for putting me onto the right track. Regards, Martin On Tue, 27 Jun 2006 15:03:28 -0500 Dan Buettner said: >DB- Martin, do you n

is there a way to optimize like '%..%' searches ?

irly large read_rnd_buffer (32M) and sort_buffer (32M) but this query is still slow as hell... Any hints as to how i can optimize the query? or tune my server settings to produce faster results? Regards Martin Jespersen -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: is there a way to optimize like '%..%' searches ?

Indeed fulltext searches was the cure i was looking for. Queries went from over 116 seconds to less than half a second thx for the tip ;) Dan Buettner wrote: Martin, currently there is not a way to optimize that particular type of query. You might consider changing to fulltext indexes and

Re: is there a way to optimize like '%..%' searches ?

I was too fast there it seems fulltext searches doesn't help after all since i can't use leading wildcards to words :( too bad i loved the speed :/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Using a SP return value

the return value from SP2 into an SP1 variable which I can then continue to use in SP1?? Thanks in advance. Martin -- -- [EMAIL PROTECTED] -- -- MySQL General Mailing List For list

Re: is there a way to optimize like '%..%' searches ?

levance (relevance could become handy at a later stage tho, but i dare not even think about it atm) Dan Buettner wrote: Bummer, Martin. What more can you tell us about your specific application? What are you storing and searching on, exactly? Any chance you can filter on another column to reduce

Re: Full Text Search across 2 tables.

Maybe something like this: select ft.topic, fm.message from forums_topics ft, forums_messages fm match (ft.topic, fm.message) against (...) if topic is null then the hit is from fm and vice versa... haven't tried it, so might not work :) Steffan A. Cline wrote: I have 2 tables which have

Re: Backup questions

Jesse wrote: my editor forces a hard line break at column position 16384, which, of course, corrupts the restore. I don't know if there are other text editors that will not do this, Funny, i've never seen one that does? What system/editor are you using? or even better, if there is a way to

Re: Backup questions

Jesse wrote: Funny, i've never seen one that does? What system/editor are you using? Multi-Edit version 8.0i. This is an older version of the editor. Maybe a newer one wouldn't, but for the most part, it does a very good job for me. Ok never heard of multiedit... if your system is window

space usage

the maintable instead of a seperate table so i can avoid slow joins. what will be better for queryspeed/size: adding them with NULL using NULL as default or with NOT NULL using 0 and '' as defaults? Regards Martin Jespersen -- MySQL General Mailing List For list arch

Re: very basic questions

1: .sql files are usually textfiles with sql statements in them delimited by ; 2: do the following 1) start the client - /path/to/mysql -u -p 2) select your database (if nescessary) - use 3) import the sql file - source /path/to/fill_help_tables.sql [EMAIL PROTECTED] wrote: Hello, I'm new

Re: 3.23.58 -> 5.0.22 upgrade

I recently upgraded from 3.23.58 -> 4.1.20 without any hickups. I simply dumped my databases with mysqldump on the 3.23.58 installation and imported them again from inside the mysql client by using the "source" command. Dan Trainor wrote: Hi - I know we've rolled this around the list a fe

Re: 3.23.58 -> 5.0.22 upgrade

, but you say you want to go to 5.0). I'd go direct to 5.0, using mysqldump'd data as Martin did. If you're all-MyISAM then it might also work to simply upgrade your binaries and keep your data files, though you'll want to watch for the fix permissions script and also be mindfu

Re: 3.23.58 -> 5.0.22 upgrade

Using dumps are almost always the way to go, upgrading the datafiles themselves is something you should avoid unless you are into heavy wizardry and/or pain. Dan Trainor wrote: Martin Jespersen wrote: Dan has a very good point, be mindfull of the changed password algorithm, that actually was

Re: database back up

You can usually find the database files under the "var" subdirectory under your installation, unless another datadir was specified at compiletime. ;) Martin Joko Siswanto wrote: Dear All if myqsl service can't start, where can i found the file and back up it? [under wi

Re: How to query on part of a date column?

As long as backticks are used around fieldnames, spaces and/or reserved words are fine, tho it does tend to create more work for the user ;) mos wrote: At 12:02 PM 7/20/2006, you wrote: I've got a table of people who registered for a convention. Each person has a registration date, kept in a

Re: Select Query taking time

Ratheesh K J wrote: Hello All, I run a select query to see its speed. It took around 5 seconds. Now i run the same query simultaneously twice usng two instances of the client tool. It took 10 seconds for both the queris to complete. Its not 5 secs + 5 secs. Both the queries were running til

Re: Searching through an alphabetical range

Depending on the size of your table, it can be faster using SELECT lastname FROM employee WHERE lastname BETWEEN 'm' AND 'z' GROUP BY lastname; On a table with 2,5 Mill. records the speed diff is over 1000% on my system. ViSolve DB Team wrote: Hello Paul, You can try this: SELECT DISTINCT

Re: Struggling with the logic

As mentioned before you really should sue the date data type in mysql, or alternativly use an int and store the date as seconds since the epox, so that you can do simple math for this type of query. Any other way of storing dates is basically shooting yourself in the foot. That said, if you ch

Re: Checkboxes

Looks like more of a php question that a mysql question ;) anyway, the mysql part: use either an unsigned interger (tinyint, if less than 256 possibilities, smallint if over 256 but less than 65565, etc) or use a set or enum. Using a varchar is not really the way to go. If you choose to use

Re: MySQL performing too badly under heavy load - urgent hlp needed

I doubt apache is to blame. 5 seconds for a query on a website is extremely slow, so if that is your "normal" results, then you have a problem there already. I've been building database driven websites for around 11 years and i don't think i can remember a single time i went into production wit

Re: optimize mysql geometric query

Try to run an explain on the query to see how mysql optimizes it. Also have a look at your system resources while the query runs to see if you have a problem with memory/swapping. I am not sure (since i've never used union), but my guess is that mysql uses temporary tables for this, so maybe t

Re: What does "optimize" mean?

read the manual: http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html Jesse wrote: Seeing posts about mysqlcheck on the list prompted me to check out that utility. A lot of it I can see is very useful, and I understand what it does. However, what does the "optimize" command mean? What d

Re: Problems with WHERE clause

Do the right thing(TM) and don't use an alias that is the same as a field that exists (this was mentioned before by someone else). Since there is a field in your join named "fee", using "fee" as an alias, is bound to cause your trouble. Also, trying to call sum(p.fee) twice is a waste of cputime.

swapping column values in update

I just ran the following sql (on mysql 4.1.20): update tbl set col1=col2, col2=col1 To my surprise, mysql updates col1 via col1=col2 before reading it for use in col2=col1, so I end up with the same value in both columns, which, of course, was not my intention. Thinking about it, this behavi

Re: swapping column values in update

it's a frequent operation based on a where clause Barry Newton wrote: At 06:35 PM 8/1/2006, Martin Jespersen wrote: I just ran the following sql (on mysql 4.1.20): update tbl set col1=col2, col2=col1 To my surprise, mysql updates col1 via col1=col2 before reading it for use in col2

Re: Doing a join

select g.GROUP_NAME, count(mg.MEM_ID) as NUMBER_OF_MEMBERS from GROUPS g left join MEM_GRO mg using(GRO_ID) group by g.GRO_ID John Meyer wrote: I have two tables: MEMBERS: MEM_ID ... GROUPS: GRO_ID: ... And one joiner MEM_GRO: MEM_ID, GRO_ID I want to print out a list like this GROUP_N

Re: FULL TEXT SEARCH ALTERNATIVES...

You can tune the fulltext search in a few ways using the config, try read up on the various server variables that has to do with fulltext indexing. Other than that there is always the option of upgrading the hardware :) [EMAIL PROTECTED] wrote: Hi! I'm getting a lot of pushback on using mysq

Re: Multiple single column indexes

It depends what you need and how your data looks. Say you have a table with 4 columns: col1 has 1000 dictinct values col2 has 1 dictinct values col3 has 100 dictinct values col4 has 10 dictinct values In this case: select col1,col2 from tbl where col1=... and col2=... Having a single

Re: Fatal error

Looks like drupal had an error when doing the backup - mysql is complaining over the fact that your backup.sql file contains a html formated fatal error message. Kaushal Shriyan wrote: Hi ALL I have taken backup of http://mydomain.com/?q=admin/database through drupal 4.6.3 by selecting all t

Re: Table analysis - Help required urgently

If i was you i'd start reading the manual. Look under the optimization chapter. Also, brush up on database normalization and look into how exactly the tables are being used - run explains on the sql statements that are used with the tables and see how you can optimize index usage. Ratheesh K J

Re: Fatal error

, Martin Jespersen <[EMAIL PROTECTED]> wrote: Looks like drupal had an error when doing the backup - mysql is complaining over the fact that your backup.sql file contains a html formated fatal error message. Kaushal Shriyan wrote: > Hi ALL > > I have taken backup of http://mydomain.com/?q

Re: Another question on Cardinality??

Have you considered reading up on basic database management? There are plenty of good material on the web for you to read where you can actually learn how to manage databases, so you don't have to ask others about every single detail. Ratheesh K J wrote: Hello all, Another question on card

Re: FW: How do I find all the users that are new since my last login (repost)

You could add an extra field called last_login_date which you'd set only once per session - at login time. At login time you'd set this to the value that exists in login_date. Then use that for comparison against created_on. Daevid Vincent wrote: I have a SQL challenge I'm not sure how to sol

Re: How to utilize 16 logical CPUs

Your mysql db is only using 496Mb of ram? i have a server with 1GB ram where mysql uses more mem than yours does - you should probably tune your server system variables a bit to utilize your memory better. Christian Hammers wrote: On Tue, Aug 22, 2006 at 10:20:47AM -0600, Michael Loftis wrote:

Re: How to rewrite query

Hi! Try: set engine_condition_pushdown = on; explain select ip from ipaddr where pool='INTERNET' and stype='S' and ls_id=3 and allocated is null limit 1; to see if you can push the predicates to improve performance. BR -- Martin Mindaugas wrote: Hello, For the Radiu

Choosing a value in a query

single query that returns all of the values required? Many thanks for your help! Martin -- -- [EMAIL PROTECTED] -- This email, and any attachments, has been scanned for virus contamination usin

Re: What is a schema?

ain multiple schemas. -Jason Martin -- I'd love to, but I have to rotate my crops. This message is PGP/MIME signed. pgpjwHryLEUmW.pgp Description: PGP signature

password(), sha1() and md5()

problem with Panther) and MySQL 4.1.12-standard. First I thought the problem lies in text encoding of the terminal. But using Java and the JConnector 3.1.10 didn't help. Trying on WinXP produced a correct behavior using PASSWORD(), but SHA1() and MD5() failed also. Any suggestions? Kind rega

'ODBC'@'localhost' instead of 'root'@'invalid_hostname.com' ?!??

back that it tried to connect to localhost as user "ODBC" when I asked it to connect to an invalid hostname as user "root" ?!?! sincerly, martin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Weird delete behavior on mysql 4.0 - rows not disappearing....

ntil you finish the > transaction in Window B. See the manual for details > <http://dev.mysql.com/doc/mysql/en/innodb-consistent-read.html> > >Is this a known bug? > > It's not a bug. Oracle works in a similar fashion. -Jason Martin -- Never eat anything bigger

Re: Recommendations on new hardware

they provide decent defaults. If you've ever used Fink on OS X, you might already be familiar with apt-get. -- Chris Martin Web Developer Open Source & Web Standards Advocate http://www.chriscodes.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Joins Tutorial Anywhere?

ds in such a manner: No, names do not have to overlap. -Jason Martin -- Reduce Carbon Dioxide emmissions - STOP Breathing This message is PGP/MIME signed. pgpoEeMSujkX4.pgp Description: PGP signature

Compiling a MySQL Client using Apple's xCode

need to include some libs with this client, but which libs and how can I do that in xCode? Thank you, Bruce Martin The Martin Solution PO Box 644 Delaware Water Gap, PA (570) 421-0670 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: String insertion

treichardt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Bruce Martin The Martin Solution PO Box 644 Delaware Water Gap, PA (570) 421-0670 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Oracle DMP to mySQL -- Possible???

On Tue, Oct 25, 2005 at 04:22:01PM -0400, sheeri kritzer wrote: > What you need is the table schemas and the data. Oracle doesn't have > SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't The oracle-supplied DBMS_METADATA package can do this for you. -Jason Marti

Trouble running mysql_install_db

of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! I then checked the permissions for the /usr/local/mysql/data/ directory and it shows: drwxr-x--- 13 mysql wheel What am I missing? I installed MySQL using the installer package. Bruce Martin The M

Permissions for the install

What should the permissions be for the MySQL 5 install on Mac OS X. By default it was Owner = System Group = wheel. Could someone give me a list of directories and what owner:group settings I should have? Bruce Martin The Martin Solution PO Box 644 Delaware Water Gap, PA (570) 421-0670

mysql_library_init()

har **argv, char **groups) Can someone explain what the 3 parameters are and what they need for info? The docs are a bit light on this subject and it says it is synonym for the mysql_server_init() function, but that function is not listed and is not linked to in the on-line docs. Bruce Martin

Re: MySQL table growth monitoring via RRDtool and histographs?

On Tue, Nov 01, 2005 at 02:38:29PM -0800, Kevin Burton wrote: > Gangla and Cacti seem to do similar tasks (if you stretch them) but > they really fall down fast. Can you elaborate on 'fall down fast'? It should be a really simple operation to do this in cacti. -Jason Martin

Add New User

Query OK, 0 rows affected (0.00 sec) Why is this not working? To test it further I try to log in as testUser but it tells me access denied for user [EMAIL PROTECTED] Even if I grant the testUser @ localhost. I can look in the user table and sure enough user [EMAIL PROTECTED] is there. Bru

Re: Add New User

database? or should it have been 'test' no quotes of course. Is there a way to update the database access without deleting the user and redoing it all? Thanks for the help. On Nov 6, 2005, at 12:23 AM, Michael Stassen wrote: Bruce Martin wrote: When I log in as root using: mysql -u

Re: Add New User

Ok thank you, I think I have it now. Now to get my Client application working. On Nov 6, 2005, at 1:16 PM, Björn Persson wrote: söndagen den 6 november 2005 18:39 skrev Bruce Martin: However, even though I specified 'test.*' my test user can access the mysql database. That'

libmysql.dylib & libmysqlclient.dylib on OS X

Hello This is Martin Brooks at National Research Council Canada, in Ottawa. I am working on OS 10.4.3 on a G4 PowerBook. I have installed mySQL 5 from binaries. The open source code I am trying to build expects to link to libmysql.dylib and libmysqlclient.dylib. (This code, CLSQL, allows

Re: libmysqld as shared library

]: Leaving directory `/home/pgroen/projects/mysql-5.0.15' make: *** [all] Error 2 I'm quite desperate at the moment because our first demo is due next week What am I doing wrong? Regards, Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

Re: Best Fieldtype to store IP address...

ecome > soon in the near future. Maybe you'd better choose a field type that can > accomodate those as well as the traditional 123.123.123.123 type I believe both 14v6 and ipv4 can be expressed as decimal numbers too. -Jason Martin -- This Charlie Brown must have been a very wise

mysql_init(&m) changes values of variables

fter I first set it up the length is 23 which is correct. I then call mysql_init(&m), then I check the length again, well the value of the int I set earlier, and it is 0. What's the deal? why would mysql_init() change the value of my int? Bruce Martin The Martin Solution PO Box 644 D

Re: mysql_init(&m) changes values of variables

Ok I have an update. I fixed my problem by passing a NULL parameter to mysql_init() to do this I did this: MYSQL *m; m=mysql_init(NULL); connection=mysql_real_connect(m,cStrdbServer,cStrdbUser,cStrdbUserPass,c StrdbName,0,NULL,0); On Nov 12, 2005, at 7:44 PM, Bruce Martin wrote: Hello all

Duplicate Insert Crashes Client

Hello again, Ok new problem. If for some reason, my client tries to INSERT something to the database that is identical to a record already there, my client crashes. Is there an error I can trap for this? The DB does insert the new record. Bruce Martin The Martin Solution PO Box 644 Delaware

Re: Anyone use Snort and Acid?

On Sun, Nov 13, 2005 at 08:56:12PM -0800, Ed Kasky wrote: > Snort v2.4.3 > ACID v0.9.6b23 I seem to recall hearing that ACID is deprecated; you might want to look around if there is a newer equivalent. SQUIL (http://sguil.sourceforge.net/) is supposed to be really good. -Jason Martin -- I

Re: Duplicate Insert Crashes Client

the 'CREATE' statement for you table and sample data. Provide information about operating system and MySQL version. Bruce Martin wrote: Hello again, Ok new problem. If for some reason, my client tries to INSERT something to the database that is identical to a record alre

Re: using dinamic table name inside stored procedure

I'd really suggest looking at the data model that requies you to dynamically select which table to read from, and find another way. If there are several tables that have the same column that differ only by name, why not make the name a column? -Jason Martin On Sat, Nov 19, 2005 at 02:28

Re: How to index a table with many fields?

or *all* > fields? You woudn't want one index that contains all fields, as there is no efficient way to search it for a field that isn't on the 'leading edge' of the index. You'd be better off with a seperate index for each field. -Jason Martin -- If you don't li

Re: Hijackers?

it any rights I believe using bind variables whenever possible also helps prevent this attack. -Jason Martin -- S met ing's hap ening t my k ybo rd . . This message is PGP/MIME signed. pgpBcno4Qf3S7.pgp Description: PGP signature

Help crafting an SELECT

Hi List! Please forgive me if I'm asking the wrong list (and please guide me to the right place). I have two tables (simplified for this example) "pics" and "tags" like so: pics: picid photo 1Mustang 2Apple 3Rock 4Beetle tags: tagid picidtag 11 Car 2

Re: Help crafting an SELECT

On 1/11/06, Gordon Bruce <[EMAIL PROTECTED]> wrote: > I assume you are looking for both red and car. > You can not use IN because that is implicitly an IN. > You hae to join the tags table to itself using 2 different aliasis. > {If you required 3 things then you would join it 3 times etc..} > > SEL

Histogram from tables.

I have a large table of filenames and creation dates from which I want to produce a histogram. SELECT year(date), quarter(date), count(0) FROM pics WHERE date(date) > '2000' AND date(date) < ' 2005' GROUP BY year(date), quarter(date) Gets me close, but to simplify plotting, I want to include

Social Network, linking members

Hi, I'm trying to find the most efficient way of "linking" members to one another in a social networking application. Currently I link them using 2 separate fields for the members: id1, id2. So, to find people in your network you would do: WHERE id1=%ID OR id2=%ID This uses indexes inefficientl

RE: Social Network, linking members

be flagged as 1: MYID, REQUEST_USER_ID, 'family', 1 Using 2 tables would help the indexing problem, but it's definetly NOT how I want to achieve this. -Original Message- From: Jad madi [mailto:[EMAIL PROTECTED] Sent: 07 April 2006 15:00 To: Martin Gallagher Cc: mysql@lists

  1   2   3   4   5   6   7   8   9   >