RE: Complete server lock

MySQL and DNS can be such a fun issue because it comes suddenly and leaves just as suddenly with --skip-name-resolve. For in-depth info on how MySQL uses DNS, and info about this potential DNS-related bug: http://codenode.com/mysql/dns -Daniel -Original Message- From: Ben Clewett

Re: Can I use the information from "SHOW STATUS" in a SELECT statment ?

Speaking of Perl scripts that do this: http://codenode.com/mysqlreport I almost never use SHOW STATUS directly anymore since most the values have to be transformed one way or another to really be meaningful. -Daniel Sid Lane wrote: I don't know if you can do it directly in a mysql shell

inf and -inf values

Hi all, I'm trying to INSERT values inf or -inf into a field (double) in MySQL version 4.1.13 but it has not been possible. MySQL deny the insertion. Can anyone give me any suggestions to solving this problem ? Thanks -- / (=\Daniel Guariz Pinheiro \=) /Laboratór

Re: Total newb at performance tuning mysql

. -Daniel Scott Haneda wrote: Unless I am totally off base here, the mysql docs tell very little in regards to how to performance tune mysql. So far I have found this article to help: <http://www.databasejournal.com/features/mysql/article.php/10897_1402311_3> But it still leaves me with a

Re: default my.cnf vs huge.cnf nearly same performance with sql-bench/run-all-tests

fit your server, then optimize your queries. -Daniel Matthew Lenz wrote: infact .. the default debian config (some of these are just explicit defaults but this is what debian provides): [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/

Re: default my.cnf vs huge.cnf nearly same performance with sql-bench/run-all-tests

a 16M key_buffer and 384M. -Daniel Matthew Lenz wrote: so the sql-bench stuff doesn't push the mysqld to its limits? - Original Message ----- From: "Daniel" <[EMAIL PROTECTED]> To: "Matthew Lenz" <[EMAIL PROTECTED]> Cc: "mysql" Sent: Sunday, Septe

Re: "Lost connection to MySQL server during query" when calling stored procedure

What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql, etc.? -Daniel Jasper Bryant-Greene wrote: I have a stored procedure defined as follows: CREATE PROCEDURE `album`.`getUser`( IN userID INT ) READS SQL DATA DETERMINISTIC SQL SECURITY INVOKER SELECT * FROM

Re: Interesting: maximum size of status variable

the max value for status variables? -- Martijn Yes, bytes_sent and bytes_received are type unsigned long (4 bytes), so max value is 4.2G. -Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query problem

On Tuesday 08 February 2005 08:09, Joachim Klöfers wrote: > Hi, all > > I hope somebody can help me. > > Many thanks in advance > Joachim That is a very thorny problem. May I observe that you will find things much easier, if you add unique primary keys to tables 2 & 3, thus: ALTER TABLE ADD p

Sub query again

I have worked out, to send that field to the where query, i have to select the outer table again !! i dont think this is very efficient ? select * from complaints, (SELECT IF (count(*) > 1,"Yes","No") AS count FROM complainant ccINNER JOIN complaints c ON cc.complainantID=c.complainantID WHERE c.

Re: Installation Instructions for MySQL for Mac OS X Panther

> Does anyone know where I can find in-depth, precise instructions to > install MySQL on Mac OS X Panther client? > > - Asad > Just get the binary for OSX and follow the readme its simple. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://l

Generating ticket/file numbers

Hi there is there any way at all that with a special field type mysql can generate file numbers like so AUD-01 then AUD-02 AUD-00010 etc ... Let me know. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL P

Re: Generating ticket/file numbers

x27;, '45' becomes > '45', etc ). Then shove the 'AUD' bit at the start. > Using an integer as the primary key you'll get faster joins, searches > etc than using a string fields as the primary key. > > -- > Daniel Kasak > IT Developer >

Re: Generating ticket/file numbers

> At 04:35 pm 2/16/2005, you wrote: >>Hi there is there any way at all that with a special field type mysql >>can generate file numbers like so AUD-01 then AUD-02 >>AUD-00010 etc ... Let me know. > You can get the 01, etc via something like SeqItem int(6) unsigned > zerofill auto_i

Re: Generating ticket/file numbers

> Daniel, > > It's really not clear to me exactly what you want. For example, what > do you mean by file numbers? Perhaps if you could tell us a little > more about your table, your query, and the result you want, we could > provide a solution. > File number = Job

Re: auto_increment not working?

I am not really experienced on this, but i have noticed that simply truncating an innodb table doesnt reset the autoinc key, u have to redump the table. I cant see what you are trying to do here ALTER TABLE users auto_increment = 590; set it to start @ 590 ? > Hello, > I am trying to get auto_

Re: Inner workings of a JOIN

scan all tables. But in general MySQL reads only what it has to, filters by the given conditions, and builds the final result set as it goes. -Daniel On Wed, 2005-05-25 at 21:01 -0700, James Tu wrote: > What does MySQL do internally when you perform a LEFT JOIN? > > Let's say y

RE: performance on single column index with few distinct values

Is there a composite index on (master_id, ticket_id)? Since your queries are selecting on a particular master_id, and ordering by ticket_id, along with the limit I think MySQL would be able to use such an index in an optimization. -Daniel -Original Message- From: Terence [mailto:[EMAIL

RE: performance on single column index with few distinct values

won't use it, trying forcing it to at least see what affect it has, like "... FROM helpdesk_tickets ht FORCE INDEX (comp_master_ticket), ..." -Daniel -Original Message- From: Terence [mailto:[EMAIL PROTECTED] Sent: Sunday, May 29, 2005 9:12 PM To: mysql@lists.mysql.com Subject

RE: Unauthenticated User (lots of connections problem)

going on. And how well or not do the resolvers in /etc/resolv.conf on the master server resolve the problematic slave's IP address, reverse and forward? Is the problem slave the one on the different network? -Daniel -Original Message- From: Michael Brown [mailto:[EMAIL PROTECTED]

Re: Seriously.. When are we going to get subqueries?!

I'm missing something, here; what earthly good is there, in having two fields in the same tuple being created so that they both automatically store exactly the same data... and if it was valuable, is there no way of more reliably building this behaviour into the external application? Okay, so I

Re: Production problem porting from PHP to ASP

Yes ODBC connections is considerably slower i have found, it could also be the native connections class you may be using for ASP, but why why why. Bad mistake. > Dear Members, > > For the last two years we have had a large software application written > in PHP 4.0.6 with a MySQL 3.23.56 database a

Mysql 4.1

Hi there, i was wondering when a possible release of 4.1 will happen ? I can see its in Alpha still, but i am trying to instigate across the board server upgrades, so its best to wait until then. Please let me know. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Re: Deleted all users from MYSQL. What to do now?

If it includes root, you will need to run the mysql_install_db script again then set a pass with mysqladmin > By mistake I deleted all users in MYSQL. So, how can I login to the > mysql? Is it possible to add a user to my.cnf file? > > Thanks > > __

Re: loading dates

> Hi, I've got a csv archive with a date field 15/02/03, how can I load > it to a date field with the mysql date format (ISO ? ) 2003-02-15 ? > > thank you > I wouldn't mind knowing this too, my work around is doing it in php using fgetcsv to extract the csv data, finding the right rows and colu

Re: Outer join question

> So, can somebody please correct the following query (and explain the > syntax) so that it will work please? (I haven't tried putting an outer > join in it because I don't understand the syntax.) > > Select > actr.name, > acto.name, > dvd.title > from > actresses actr, >

Re: Outer join question

> so soemthing like > > select * from dvd left join actresses actr on actr.actr_id=dvd.actr_id > left join actors acto on acto.acto_id=dvd.acto_id or by dvd.title > > totally forgot, to get a really good query especially when you use Innodb it doesnt like null values on foreign keys, i'd setup a r

Re: Outer join question

> > DVD_Actor: > dvd_ID REFERENCES DVD > actor_ID REFERNCES Actor > Is this how you setup a join table ? what exactly is the references keyword ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Outer join question

> [EMAIL PROTECTED] wrote: >>> DVD_Actor: >>> dvd_ID REFERENCES DVD >>> actor_ID REFERNCES Actor >> >> Is this how you setup a join table ? > > Yes. > > >> what exactly is the references keyword ? > > It indicates a foreign key. Full syntax is something like: > dvd_ID CONSTRAINT dvc_fk FOREIGN KEY

key constraint error on replace

Hi there, i am trying to use a replace, when mysql throws an error of "Cannot delete or update a parent row: a foreign key constraint fails" , is there any way to get more information like which key is having the issue, is there more detailed information i can extract ? -- MySQL General Mailing

Re: key constraint error on replace

> Hi there, i am trying to use a replace, when mysql throws an error of > "Cannot delete or update a parent row: a foreign key constraint fails" > , is there any way to get more information like which key is having the > issue, is there more detailed information i can extract ? > > > > -- It seems

Best way to join a table onto itself

Hi there i am designing a system where users can upload revised versions of a file, so therefore newer versions of the file will need to be joined with the older original file. I'd need to join the parent file id with the child file id, would using a join table work ? I have tried something that is

Re: ft_boolean_default

It would be good as spaces between words are taking OR as the default, i ave devised a system where the user selects the AND in the dropdown and if they select that is will add a + to every word. > Hi! > > On Feb 13, Heath, Brad wrote: >> Is this a legitimate variable? It seems like it'd be useful

Re: fulltext search always returns no results

Excuse if i'm not correct but this may be your problemo ? MySQL 3.23.55 running on my webhost's Linux box phpMyAdmin 2.1.0 I didnt think fulltext was in 3.23 wasnt this a Mysql 4 feature ?? > Summary: When I run a fulltext search, it always returns no results. I > have added a fulltext index

Re: Query optimization help

Maybe i'm wrong here, someone correct me, if its just int's you are gonna use set the field types to bigint it may search faster you are doing a character search, to get there quicker in a text search scenerio i'd suggest mysql4 and full text searching MATCH AGAINST > I've got a query that I can

Re: fulltext search always returns no results

i think u have to compile it in as an option, it doesnt as default, i wouldnt be suprised if Mysql 4 did a better job though, trying to convince work to upgrade all machines to Mysql 4 hopefully 4.1 is a task in itself. > > Hi, thanks for your reply, but it looks like: > > > As of Version 3.23.23,

Re: fulltext search always returns no results

> Hi Don, > > No, full-text search was added in MySQL 3.23.23, I believe (4.0.1 just > added boolean searches along with more speed overall). It doesn't need > to be compiled in or anything, it's there by default. Unless someone > compiled it and actually *removed* the full-text code or something

Re: 4.1 Stable Enough For Beginner To Use?

> MySQL Listers, > The ability to have utf-8 encoded data in my database is > important enough for me that I am considering upgrading to 4.1. I am a > beginner to MySQL, having only used it for not quite a year. My > question is whether or not MySQL 4.1 is stable enough for a beginner to > us

Re: Xserve G5

The benchmarks look good for opterons and mysql, i just scored a Sun Fire V100, still havent benchmarked that yet though. > Not to start a flame war, but just a question/suggestion... > > Do you specifically want a Mac (i.e. are you a Mac shop), or are you > looking for inexpensive 64 bit? > > If

Re: foreign key constraints are driving me crazy!

Some key in the table is null when it shouldnt be, or the type of the join keys isnt the same. i have had issues when importing data from a dump so i've had to do a FORIEGN_KEY_CHECKS=0 > > So I have made a table called 'uid' where on uid is the only field in > the table. Then I make another table

Drop and Add Functions in Mysql 4

Hi there, i happened to be peering into the Sybex book on Mysql4 , it was pretty expensive about 100 AUD is it a good one ? Anyway i had reference to be able to compile c code into Mysql to add functions into it. Is there anyway posible to avodi doing this and add it using queries ? Let me know tha

Re: indexes question

i have one multiple column fulltext index for 3 columns i join in a fulltext match statement > In the last episode (Jun 01), Daniel Rossi said: >> hi just reading up on optimising indexes, does it matter what order u >> set your indexes ? >> >> The first index part sho

Re: Table design suggestions?

> Table Group > id int auto_increment > name char > > Table Member > groupID int auto_increment > name char > > Table Relationship > group_id int > member_id int > i'd set it up like this Table Group id int auto_increment name char Table Member userID int auto_increment name cha

Re: open source shema relationship diagram tool

none of these are open source and its under windows http://www.minq.se/products/dbvis/images/screens/graph.html this is what i want to do , except its on myisam tables not inondb so there is no foreign key relations i join them in the query or can i still do this ? > Hi Daniel, >

Re: multiple mysql instances and virtualhosts

oh dear apologies , i meant virtualhosts in an apache server environment, as in different sites on the same machine > At 8:22 +1000 6/24/03, electroteque wrote: >>this has prob been bought up many of times but how would it be possible >>to setup different mysql source instances for each individual

Re: What's up with this GATOR crap?

same way. >> >>Comments >> >> > Please remain calm. > You must have gotten Gator on your computer all by yourself because it > certainly doesn't come with MySQL. > Search on Google for 'AdAware'. > Download it. Install it. Run it. Remove Gat

Re: Faster reindexing

umm say i reindex after a reimport i usually drop all the indexes first , then add indexes again one by one , seems to be quicker for me especially for fulltext indexes , doing it at once tends to be slower, must crunch the cpu a bit dont know > On Wed, Jul 09, 2003 at 11:51:01PM -0500, Paul DuBoi

Re: What is a good benchmark?

i got 0.96 on a dual XEON 2G 1G ram , its a dell box > On Tue, Jul 29, 2003 at 01:41:00AM -0400, Asif Iqbal wrote: >> Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any >> suggestion on how to improve it ? > > Get a faster CPU. > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux

Re: Converting Sequel to MYSQL

setup a dsn in odbc and you could import via a tool called sqlyog ?? > Hi all, > > Does anyone have any suggestion for converting a Sequel database to > MYSQL? I just want to copy a Sequel database data to a Mysql one. > > Thanks in advance for any suggestion, > > Mike > > -- > MySQL General Mailin

RE: MySQL field data type for ISBN numbers

the only thing i could think or is check the length of the varchar , is that value actually stored properly in the database ? > Hi Daniel, > > Here's what is echoed back. It looks valid to me. > > SELECT * FROM book_details WHERE ISBN = '1---1' >

Re: Converting Sequel to MYSQL

you could do that but as i've found out especially with freetext columns it wont work the first time takes heaps of times to get it right :\ > http://darkstar.ist.utl.pt/mysql/doc/en/LOAD_DATA.html > Pay particular attention to > > FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' > for the

Re: Advanced text search

i'd so select compid,company,phone from companies where MATCH (phone) AGAINST ('+27-21-*', IN BOOLEAN MODE); something like that is it your number in particular or stuff similar to that ? you could also try select compid,company,phone from companies where phone REGEXP "+27-21-" > Hi > > I'm try

efficient placement of fields

Hi is there any noticable efficiency is ordering the position of the field types?. Like say i place the join keys in a table at the end, and varchars and text at the top of the table does it really matter? Also when i do a query like select * from table where id IN (1), where 1 is usually a primar

Re: DB Performance - Celeron vs. P4

well the obvious difference between a celeron and a p4 is the cpu cache, celerons are good for home linux dev box's, i have 2 now but one only has 32meg and is really slow on the queries but they are cheap and do the job i i rebuilt one and built another box for about 180 AUD :D , i also have a dua

Re: Joins and Unions

I have also had this trouble before if there are say 5 results from the second table, the first table of results would be duplicated 5 times on a join, i would also like to know how to get around this. > G'day all, > > I'm pretty new to MySQL and very new to v4. > > This is probably going to sound

Re: Joins and Unions

well i'd like to join tables without duplicates, currently i cannot do this unless i select the category table in a second loop to list all the categories for that particular row/record > Hi Daniel and Kim, > > Isn't > >> product_name product_category >

Re: Joins and Unions

he is getting the same problem as me as i explained i use joins left join and inner join SELECT * FROM products p LEFT JOIN product_cat_join pcj ON p.productID=pcj.productID LEFT JOIN product_category pc ON pc.catID=pcj.catID; products productID product product_cat_join joinID productID catID

Re: Joins and Unions

how can it be confusing ? nobody ever experienced it before? simply when you join 2 tables together if you get 5 records from the second table the first table will display 5 times aswell > Hi Daniel, > > I am still not sure what exactly you are trying to achieve. > > If you sp

Re: error creating database

lol mysqladmin -u root -p create database desenv ?? > Hi, > > I was received a error when I was trying to create a new database on > freebsd 5.1, mysql 4.0.14. The "test" database is working well. > > COMMAND: > mysqladmin create desenv > or > mysql > create database desenv; > > ERROR: > mysqladmi

Re: DB Performance - Celeron vs. P4

scuse the ignorance are u saying high cpu usage is better used on one query or better be freed up for other queries ? ram is always an issue as the queries get buffered > Jonathan Hilgeman wrote: > >>Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm >>considering moving to a P4 2 Gh

RE: SELECT SPEEDS......

it doesnt work i tried it, case of follow the sheep :D > Paul DuBois [mailto:[EMAIL PROTECTED] writes: > >> At 15:18 -0700 8/20/03, Michael S. Fischer wrote: >> >This is trivial to benchmark yourself. Try: >> > >> >BENCHMARK(10, SELECT yada, yada FROM test WHERE id IN(1,2,3)) >> > >> >And com

Re: Sub queries

>> > The keyword UNION should ensure that all duplicate rows are removed > from the combined result set. If you use UNION ALL instead of UNION, > the duplicates are left in the result set. > Yeh right, funny, early versions of 4.0, UNION had in the docs this was only avail in 4.1, i am so sure i

Re: Sub queries

ee profilespage heheheh. Little bit about me, I am a PHP/Mysql/Java/Unix/Flash Actionscript 2 developer fora Tv station in Sydney building business level web applications. Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 5.0.2-alpha has been released

wow this is a massive feat, 5 will make many people proud, 4.1 has done the same aswell as 4.0.Well done, if you need testers for solaris or OSX lemme know. I also had a question thoughregarding INNODB and fulltext searching, when is this going to be made available or if ever ? I'vehad to do pat

Re: php-mysql RPM

you can get that on the mysql-client package On Wed, 30 Jun 2004 00:35:13 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi, > > I'm installing the php-mysql-4.3.6-1.3.i386.rpm and it's complaining about a > dependency libmysqlclient.so.10. My mysql server version is 4.0.20. > > Can an

Re: How to create a stop word file?

sorry to be vague but what is the ft_stopword_file i havent been able to be up to speed on that variable. > At 15:53 -0300 8/21/03, Cleber Hostalácio de Melo wrote: >>Hi, >> >>I need to change the stop word file used by the MySQL in fulltext >>seach. >> >>The documentation (www.mysql.com/doc/en/Fu

Re: How to create a stop word file?

ft_stopword_file The file from which to read the list of stopwords for full- text searches. All the words from the file will be used; comments are not honored. By default, built-in list of stopwords is used (as defined in `myisam/ft_static.c'). Setting this parameter to an empty string ("") will di

Re: Constraint Symbol

> SHOW TABLE STATUS FROM yourdatabasename LIKE 'departments' > which will show us the constraints for table departments..-Martin- Apologies constraint was missing, this works ALTER TABLE assets ADD CONSTRAINT FOREIGN KEY (end_dateID) REFERENCES end_dates(end_dateID) ON DELETE CASCADE +-

Re: key constraints

Really sorry about this i just worked out if i dont select the foreign key in an insert statement it will return this error i have to include this into the query, i have also noticed i usually dont add auto inc fields in the insert query but my departments table has a foriegn key join and is return

Re: key constraints

here is part of the create table CREATE TABLE `assets` ( `assetID` int(11) NOT NULL auto_increment, `barcode_number` varchar(20) NOT NULL default '', `asset_code` varchar(20) NOT NULL default '', `serial_number` varchar(100) NOT NULL default '', `asset_user` varchar(100) NOT NULL default

Re: Questions abou innodb

Hi i have just started to use them aswell to do proper relationships between tables to add data restrictions on deleting records. > > 1) can you join a MyISAM table to an innodb table in a select? This seems to work. > > 2) Under 'Restrictions...' in the manual, it says: > When you restart the M

RE: Questions abou innodb

InnoDB of course does not support > FULLTEXT indexes, and so forth. Which is a pain, because i want the foreign key relationships but fulltext indexing at the same time :\ As for transactions , is it simply by doing this? start transaction do query commit if error rollback ?? -- MySQL Gen

RE: Questions abou innodb

> start transaction > do query > if error > rollback > else > commit > > > -- Heh thats what i meant ;) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

maxDB

What is all this talk about max db, like why did they go and buy out SAP DB ? What is going to happen to different databases under the mysql banner or will the maxdb be implemented in mysql ? Because some of the features in sap, i think everyone would want into mysql, man i wish i could code c++ a

Re: Compling on RedHat 9

i'm about to do this tonight as i'm setting up a desktop system to do my local development on, all i can say is redhat and gnome is slow as hell !, i only have 160 meg ram on the machine and after loading a few apps it only has 4 meg ram left ! plus the apt package manager for redhat is slow as hel

Re: CocoaMySQL

is there such a gui tool for linux ? i like sqlyog alot so anything similar would be excellent. > Good news for OS X users. CocoaMySQL has just been updated and it now > supports CSV imports among other improvements. It's freeware too. > > http://www.MacUpdate.com/info.php/id/10573 > > > -- > MySQ

RE: Compling on RedHat 9

> OK, here are the last few lines from make. I configured using the > following: > > ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql > > errors: > > libmysql.c: In function `mysql_real_connect': > libmysql.c:1790: warning: passing arg 5 of `gethostbyname_r' from > incompatible point

Lock tables in myisam

Hi there i have a couple of projects which required fulltext searching so was unable to setup innodb on these. I was wondering if lock tables is a secure way to make the transaction on these tables and does this prevent being read upon aswell? -- MySQL General Mailing List For list archives: ht

RE: Lock tables in myisam

> > No rollback does not work on myisam Jeremy was stating that you don't > have to do what you suggested to implement a correct ROLLBACK in mySQL. > Use INNODB. > > http://www.mysql.com/doc/en/COMMIT.html > > Hmm if you got my other post i am trying to simulate innodb in myisiam for projects tha

Re: Lock tables in myisam

Righty, so if error unlock table hehe, i have found i need to produce my error first then do a rollback for an error to display in php as it wouldnt show a mysql error after a rollback, i guess i could add an unlock table in my trigger error function too. > At 11:38 AM +1000 9/18/03, electroteque

Re: Lock tables in myisam

> Hi, > > No, ROLLBACK doesn't work with MyISAM. Jeremy meant that you can add > logic/code between LOCK/UNLOCK to "simulate" ROLLBACK. e.g. queries > that "undo" what you did if something goes wrong. Of course this won't > cover you if mysqld dies, is killed, or you lose the connection etc. as > r

Re: Simple Stored Procedure Emulation with PHP/mySQL

> Have you seen this? > > http://www.sklar.com/page/article/myphp > Man this is a filth idea, there is potential here until stored procs come into effect, can it be used to create php stored procedure functions at all ? Like is there a better example than that, like its obvious its creating a fun

Re: Usage Monitoring

Mytop ? > Is there any way to monitor which databases are being used the most > heavily on a MySQL server? Thanks for any info! > > - John > > -- > > --- > John May : President > P

MySQL garbles some UTF-character such as capital swedish oe or cyrillic soft sign

>Description: The UTF-8 encoding for capital swedish characters ae aa and oe doesn't work. Some cyrillic characters doesn't work either. A lot of other utf-encoded characters work so the settings are not wrong. It seems like mysql looses some information when it stores these characters. At first

Re: XML support for MySQL

I dont know about going in, but i wonder if there is an extension module to do this for you. I currently have to use a class i built to extra the xml from a query in php :\ > Is it possible to direct xml support for queryiing a SQL statement and > get the result in also in xml? > > Prasad > > > >

Help obtaining DBI binaries

Please help, where do I download DBI module binaries thanks Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Please help! Trying to install DBI & DBD for mysql

I have downloaded perl 5.8.0 & DBI 1.38 & DBD Mysql 1.2219 I'm not too sure how to install from this point. I am running NT4 and have tried:-perl makefile.pl, and nmake makefile, and then nmake install but I keep getting error - can't locate DBI DBD.pm in @INC Please help thanks d.a. -- MySQL

Re: My Company DB Wars

> > My old Micro-Economics professor must be chortling in his grave... > > The bosses told me a few minutes ago to quit pusing MySQL for an > internal project and to move my proof-of-concept tables from MySQL > running on a Linux desktop with 512mb of ram and the bloody DB on an > external USB to a

Re: My Company DB Wars

> Hi, > > You could bring the attention to www.mysql.com - probably German > software company SAP would not integrate with MySQL, if there were any > kind of problems. > Sorry a bit off topic, speaking of the germans, it seems that PHP and MYsql is prolific in germany, as a widely used choice. I

Related articles query

Hi there, i was wondering how i could setup a query to get related articles for an article. How would it be possible to join these articles up. For instance i select an article, i has two related articles to it, i select one of the articles and it also has a related article back to the previous art

Re: Related articles query

> Hi there, i was wondering how i could setup a query to get related > articles for an article. How would it be possible to join these > articles up. For instance i select an article, i has two related > articles to it, i select one of the articles and it also has a related > article back to the pr

Re: Dillema: LIKE vs MATCH - AGAINST

Man, if you need a full boolean search, ie more than one word, use fulltext !, it crunches cpu so you need a beasty machine, use like if its just one string you are searching for in a varchar field, use fulltext if you are searching in wads of text. I highly recommend match against though, its the

Re: Audio / Video Files

> Can audio or video files be attached to a mysql table? > > VH Very short question, but personally, i'd store the filenames and its information into a media table rather than importing the binary data or it would get huge ! -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: How to do automatic backup?

cron schedule it ? > Hi, > > Is there any function for MySQL database to do automatic backup? > Let say, i can set the time, that MySQL will automatic backup > between 7.00pm-8.00pm everyday. > > Thank you very much. > > > regards, > > florence > > > Thank you very much. >

Re: Pricelist

They most probably got it from this list, i too have had virus emails sending emails with my email and name in the header !! but i dont have a virus !! > Sturgeon, Jon wrote: >> [EMAIL PROTECTED] wrote: >> >> Look it through >> >> >> Can the list administrator figure out who this moron is and

Re: Newbie Can't Add a User to MySQL

Nowhere have i seen that it tells u to do this ? mysql> INSERT INTO user VALUES('localhost','ForumUser',PASSWORD ('forum123'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); for a forum i would do GRANT SELECT,INSERT,UPDATE ON *.* TO [EMAIL PROTECTED] identified 'somepass' > Greetin

Need help finding months with entries

I have a MySQL table with a Date column in format \"-MM-DD\" and I\'m trying to figure out a query that would return a list of months that have an entry in the above table. With output like: Mar-01, Feb-01, Apr-01 etc... I\'m still pretty new to MySQL and the date functions are still a bit

Re: Fulltext index

I find doing this helps to reinitialize the indexes ALTER TABLE shotlist TYPE=MyISAM; REPAIR TABLE shotlist QUICK; > I am trying to add a second fulltext index to an already existing table > (named "articles"). > > The first index is for field(column name) "text" of type "longtext" > > I want to

Re: Storing App Settiings

>> >> --Bruce >> > > There are many different options. php-general list > might have something in the archives. > > Usually my preferred method is storing application > wide settings and commonly used functions in a file > that is included on each page. > > > > You might also take a look at parse

problems with foreign keys revisited

Hi there, I am having some issues between two tables and foreign keys. Here is the two tables I have setup. | complaints |CREATE TABLE `complaints` ( `complaintID` int(11) NOT NULL auto_increment, `ticket_number` varchar(20) NOT NULL default '', `complainant_name` varchar(100) NOT NULL defa

  1   2   3   4   5   6   7   8   9   10   >