RE: Trouble with LEFT JOIN

Hi There, If I interpreted what you are trying to do is to return all the rows from Challenge and reference Patrocinio excluding those rows in Patrocinio where PTRN_ID is 1? Not sure if the below is possible in MySQL but I've used this in other places when doing a left join and needing to excl

RE: MySQL Roles and Groups

Hello Trimurthy, As far as I know, MySQL does not have such thing implemented as other database systems. -- Adrián Espinosa. Engineering Support, Wholesale Systems. Jazztel.com -Mensaje original- De: Trimurthy [mailto:trimur...@tulassi.com] Enviado el: viernes, 14 de diciembre de 20

RE: Get lowest value

Hi Neil, Check this documentation, I think you will have no trouble to adapt it to your code http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_min -- Adrián Espinosa. Engineering Support, Wholesale Systems. Jazztel.com -Mensaje original- De: Neil Tompkins [mail

Re: Looking for consultant

ditional production capacity >> then the terms you may want to investigate are 'scale out', >> 'partitioning', and 'replication'. All high-availability solutions >> require at least some level of hardware redundancy. Sometimes they >> require multiple layers in multiple locations. >> >> Several of those features of MySQL also help with meeting some >> high-availability goals. >> >> Are you willing to discuss your specific desired availability >> thresholds in public? -- Adrian Fita -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: How to quickly detect if there are any crashed tables

Indeed, I was thinking about scanning the log file as a last resort, but I'm thinking how can the daemon report that some tables are crashed and need repairing at startup so fast? Shouldn't it be possible to apply the same method after the daemon has started via an external command or

Re: How to quickly detect if there are any crashed tables

useable solution. Do you know if during the auto-repair at startup, the server with all the tables will be available and answering to queries? Or will it make the tables available as it progresses with the repair? -- Fita Adrian -- MySQL General Mailing List For list archives: http://lists.mysql.c

How to quickly detect if there are any crashed tables

utes, it hasn't finished. I am looking for a solution that will give me an answer in at least 3-4 minutes. I apreciate any sugestions you might have. Thanks, -- Fita Adrian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Getting mySQL to ignore case sensitivity of field names

o only talk about field values. Regards Adrian - Original Message - From: Scott Haneda To: Adrian Aitken Cc: mysql@lists.mysql.com Sent: Thursday, August 27, 2009 11:04 PM Subject: Re: Getting mySQL to ignore case sensitivity of field names http://dev.mysql.com/doc/refman/5.0/en/case-se

Getting mySQL to ignore case sensitivity of field names

tainly set any options. When I Google all I seem to get are hits about ignoring case in select query values not field names. Many thanks Adrian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

mysql query, min, max with where conditions

Hello there, What is the corect syntax for selecting something like: select a, b, (min(q) where date<100), (max(q) where date>100) from a left join b left join c group by a.p i need min() max() values each of them with other WHERE clause. How can I do that? Adrian. -- MySQL General M

Re: Large import into MYISAM - performance problems

You could load the data into several smaller tables and combine them into a merged table which would have no real effect on the schema. Ade Simon Collins wrote: I'm loading the data through the command below mysql -f -u root -p enwiki < enwiki.sql The version is MySQL 5.0.51a-community I've

Re: Query question.

you need to group the result sets by date, look at the manual link below: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html Richard Reina wrote: I have a database table paycheck like this. empno, date, gross, fed_with 1234 "2007-09-01" 1153.85 108.26 1323 "2007-09-01"

Re: query question

there should be no space between function name and () i.e. it should be group_concat(hosts.name) (unless you have the sql mode IGNORE_SPACE set) Andrey Dmitriev wrote: I knew I’ve seen this error before ☺ Thanks a lot. -andrey From: Peter Brawley [

Re: Pointers about replication

link for more info: http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html hope this helps Adrian Cabbar Duzayak wrote: Hi All, Would it be possible to provide some advanced pointers (articles/books/tutorials/sites) for learning more about replication? I am particularly

Re: Selecting just the first 2 values

add "LIMIT 2" to the end of the statement goose wrote: Hi All, I have the following SQL statement SELECT channel.channel_name, program_title, start_time, finish_time FROM program, channel WHERE program.channel_id='3' AND program.channel_id=channel.channel_id UNION SELECT channel.ch

Re: mysqldump slows to crawl

Try dropping the indexes first if you can, would save you about half the time and then re-build them after the dump finishes. Obviously you would need to do it at a quite time though when the DB is not being used. Is a binary backup not an option? at 29G is a large text file to write Ade D

Re: HELP!

Not the best start to the day, if you have a fairly recent backup and have enabled binary logging then you can recover up to the point before you screwed the data. Peter Lauri wrote: Hi, I did something terrible similar to UPDATE table SET testdate=NOW() And I kind of forgot the WHER

Re: Too many table-locks

could consider splitting the posts table and compressing the old threads, how you could implement something like this would depend greatly on your forums application however. Hope this helps Adrian Marco Simon wrote: Hi everybody, I've got a little problem with a web and mysql based bull

Re: Selecting Common Data

John I think you are saying you want the "Mode"? if you are then the following might work: SELECT col2 as val, count(col2) AS cc FROM my_table GROUP BY val ORDER BY cc DESC LIMIT 1; in your case this will retrun the value '2' Regards Ade John Nichel wrote: Running MySQL 4.0.20 on a RHEL3 b

Re: Replacing A Value

UPDATE Query Tip No. 1: Manuals, Google etc Tip No. 2: Posting a question like this may result in sarcastic responses and possibly mass flaming Ed Curtis wrote: I have a column in a table I need to replace a value of certain records in. The current value is /realtors/Value/. I need to ch

Re: Multiple engines in one DB a problem?

/en/storage-engines.html Regards Adrian [EMAIL PROTECTED] wrote: I'm trying to find a weird performance problem in a MySQL database. I use MySQL v5.0 but the db was migrated forward from a v4.1(?) system. Looking at the schema in a recent backup, I was surprised to find different engines

Certification examples

Hi I have bought the MySQL certification study guide (v 5.0) and am almost ready for the exams, does anyone know if the questions in the self study guide are very similar to the ones that you get in the exam? and is there anywhere else that i can get more questions like this for practice pur

Re: How to rename a DB

Stop the server, go to the MySQL data directory and physically change the name of the directory that corresponds to the database. Restart MySQL server and SHOW DATABASES to see the change take effect. George Law wrote: Hardi I rotate tables out on a monthly basis. The way I do it is: ren

Re: Coded fields

I would approach this in practically the same way as yourself but used an enum field in the student table (like what you were thinking). When a user wants to add or remove an enum value you can build an appropriate MODIFY statement like: ALTER TABLE my_table MODIFY my_col ENUM('K','X') NOT NU

Re: Determining if a trigger exists

syntax is not valid. Alternatively, you could try it yourself and see that it fails. -Sheeri On 4/7/06, Adrian Co <[EMAIL PROTECTED]> wrote: Hi, Sorry if I wasn't very clear with my question. I was hoping to obtain the functionality such that I could do something similar to

Re: Determining if a trigger exists

s the basic things like create database if not exists, create table if not exists, etc. I was hoping the same thing for triggers maybe? Is this possible? Regards, Adrian Co Jim wrote: There is a TRIGGERS table in the information_schema Eg. select Trigger_Name from TRIGGERS where trigger

Determining if a trigger exists

Hi, Whats the simplest way to determine if a trigger already exists? i.e. For tables you have: CREATE TABLE IF NOT EXISTS ... Is there a way to do CREATE TRIGGER IF NOT EXISTS I'm using MySQL 5.0 btw. Thanks! Regards, Adrian -- MySQL General Mailing List For list archives:

Re: LOAD DATA giving BIG mysql-bin files ...

I think this is normal as the binary log will contain a record of all changes made to the data, therefore if you are loading large files regularly- the bin logs will be quite large. If you do not want the binary logging, edit the my.cnf file, comment out the line log-bin (#log-bin) and restart

Re: Please help: recovering db from crash

not sure, but it may be worth trying the following run the script: mysql_install_db --user=root In the installation dir this should change ownership and make mysql recognise the data dir. good luck Ade Foo Ji-Haw wrote: Hi all, My Windows-based database server crashed (no fault of MySQL. pr

Re: query problem

one solution (may not be the best but would work) would be to use 'like' instead of '=' and then put wildcards %%$var % around the variable so that if it is not there then it wount effect the query. Ade [EMAIL PROTECTED] wrote: I am fairly new to sql and am now getting into the area of slight

Re: simple addition in a query?

I think the following should work, try taking a look on the net for help on MySQL queries that use aggragate functions, there is probably a lot of info on there. select exim.hour,sum(exim.count) from exim,servers where exim.machine=servers.id and servers.type='MX' and exim.date='2006-02-22' g

MySQL Certification Questions

Hi Does anybody know where i can get a load of sample questiosn for the MySQL certificate exams, i know there are a few on mysql's site but i was hoping to find quite a few to practice on. Thanks Ade -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

MySQL PDA Synch

hi I have an online registration system made with PHP and MySQL that i would like to make available for use with PDA's. We have a wireless network that covers only certain parts of our area and when the PDA's can connect there will be no problem as I have PDA style sheets set up. When the w

Re: Sudden Mysql Crashes - table damage?

Thanks for the reply yep mysqldump also causes the service to crash. i have a few innodb tables mixed in amongst the myisam, it seems that it is the innodb tables that may be causing the problems but i am not sure why ??? Imran Chaudhry wrote: On 1/31/06, Adrian Bruce <[EMAIL PROTEC

Sudden Mysql Crashes - table damage?

HI MySQL 5.0 (windows XP) I have a problem where i think some of my tables have somehow been corrupted, if i try to run a check table command against some tables the mysql service crashes and i have to restart it. I am not sure how this damage has occurred but has anyone got any suggestions

Auto-increment & indexes

Hi, im hoping to solve a problem that is bugging me! I just moved a database from a development server to production (test), several of the fields have auto-increment ticked but as it is mainly a data warehouse i thought nothing of it. I then found that a lot of my queries were running slow

Re: table missing

The table may be damaged and seemingly unavaible to languages like php(has your box crashed recently??), run 'SHOW TABLES' from the command prompt and it should appear.If it does try running 'CHECK table' to see if is damaged or not Jon Miller wrote: I've created a database with a table and

Re: Semi-complicated delete

IN MySQL 5 you could use a sub query( http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html). However, i would try using a left join between cart and products and then bring back the results where the products.id field is 'NULL'. There may be a better way of doing this but that

Re: Restoring mySQL dump

Hello, None of these lines describe the problem that you are having with syntax. Can you give us 5 lines either side of the line that includes 'DEFAULT CHARSET=latin1'? Yes, here it is: `user_id` mediumint(8) unsigned NOT NULL default '0', `group_id` mediumint(8) unsigned NOT NULL default '0', `quo

Re: Restoring mySQL dump

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */; Thanks very much. Best regards, Adrian. [snip] mysql -u root -p dbname < backupname.sql And getting: ERROR 1064 at line 20: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL serve

Re: Restoring mySQL dump

correct. The password for mysql root is probably not the same as the system root. ddh Quoting Adrian Cooper <[EMAIL PROTECTED]>: Hello, I need to restore a mySQL dump file but cannot find the right syntax. I have root access and have used: mysql -u root -p account_databasename < backu

Restoring mySQL dump

Hello, I need to restore a mySQL dump file but cannot find the right syntax. I have root access and have used: mysql -u root -p account_databasename < backupname But I am getting: Access denied for user '[EMAIL PROTECTED]' (Using password: YES) I have also removed the root password and got: Acces

Ordering rows whit a select from where in ( exp )

der as the in list of ids.Any ideas? Should I use order by? Whit witch option ? Thanks for your help. Adrian.

simple question on WHERE SELECT query

t to enter a row into a book table which uses author_id but you only know the name. I think the statement involves a WHERE followed by a SELECT but am unsure of the precise syntax. Regards Adrian -- MySQL General Mailing List For list arch

files stored in fields

field do I need for those and again how to insert? Regards Adrian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR ON INSERT DATA FROM FILE

Thanks for the answer - but I am already the root user and have phpMyAdmin using the root also (because this is just a single computer for testing work and there are not any bit security issues). - Original Message - From: "Remi Mikalsen" <[EMAIL PROTECTED]> To:

ERROR ON INSERT DATA FROM FILE

; instruction which phpMyAdmin creates. It refused to do it and returned the error message: #1148 - The used command is not allowed with this MySQL version I feel there must be a simple explanation May I ask if anyone can help??? Regards Adrian PS I am

RE: Load data: odd behaviour

o 6am, would you believe! So Friday 26th starts at 6am. 4am tonight is classified as 2003-09-25. It just helps to have the transmission order in place right from the start! Thanks Adrian -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: 25 September 2003 14:32 To: Adrian

Load data: odd behaviour

m start to finish. Anyone heard of this behaviour before? Maybe a mysql config blip? Adrian ** Granada Sky Broadcasting Limited ("GSB") Franciscan Court, 16 Hatfields, London SE1 8DJ Tel 020 75

Problem with data import from text file

see that I am doing anything different. I have MySQL 4.0.12 on Windows ME PC with a local Apache server and PHP. Any ideas please? Regards Adrian Greeman PS I sent a long message about this and a connection problem yesterday which was not succint enough. Apologies -- MySQL General Mailing Li

Subject: Re: Problem with data import from text file (part two) Thanks

those more knowledgeable. Regards Adrian Greeman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem with data import from text file (part two)

gards Adrian Greeman please also send a separate smaller message to tell me the other one is coming. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem with data import from text file

file? I do not know how to do that. Can someone explain what is probably a very simple matter or is something still not happening correctly? Or should I revert to version 3 for my fairly simple training purposes? I am puzzled because previously this did work. Thank you. Regards Adrian

Can't start up - access denied to root

is the reason.] So - please excuse what is probably a rather basic question but can anyone suggest what I should explore to get this going again? Or point me at an archive thread that deals with it? Regards Adrian G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Can't connect to MySQL server & Access denied for root

Hi, I removed an old mysql version and I installed a new one on a machine running Suse 8.1 Linux. shell>rpm -i MySQL-client-3.23.54a-1.i386.rpm shell>rpm -i MySQL-shared-3.23.54a-1.i386.rpm shell>rpm -i MySQL-devel-3.23.54a-1.i386.rpm shell>rpm -qa | grep -i mysql shell>reboot shell>safe_mysqld --

Replication error?

ould be able to act as a slave reading from B. However, whenever I start A it starts to skip large chunks of the update log. C doesn't seem to have this problem. Does anyone know what is making this happen? Using: 3.23.49a-Max kernel: 2.4.9-34enterprise Thanks, Ad

how to recover innodb tables

st do a "select into outfile" and my data, but it won't start (I've tried values of 4, 5 and 6). What else can I do to get at the data? Thanks! -Adrian uname -a: Linux db1f2 2.4.2-13-p1-psmp-4g #1 SMP Mon Aug 20 13:24:15 PDT 2001 i686 unknown Error log snippet: 021101

Using a query as a source for another query?

ndows 2000 (SP3) platform. Adrian [EMAIL PROTECTED] - 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 &l

RE: Interesting innodb activity with 3.23.52

Thanks Heikki, Is there an easy way for me to see which version of glibc a particular RPM was compiled against? Adrian Liang Em: [EMAIL PROTECTED] -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 21, 2002 1:34 PM To: [EMAIL PROTECTED

Interesting innodb activity with 3.23.52

ke to take advantage of all the changes made between .49a and .52. Adrian Liang Em: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

winSQLadmin stopped on Beta

son why > WinSQLadmin will not pull running information out of the beta version > > > > > Thanks > > > > > Regards > > > Adrian Greeman > > - Before posting, please check: http://www.mysq

winadmin stopped on Beta

elp - what might I have done wrong? Or is theresome reason why WinSQLadmin will not pull running information out of the beta version Thanks Regards Adrian Greeman Telephone +44 20 8672 9661 Mobile +44 780 329 7447 e-mail:- [EMAIL PROTECTED] or [EMAIL

3.23.51.make error: libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r'

local/mysql-3.23.51' make: *** [all-recursive-am] Error 2 mail:/usr/local/mysql-3.23.51 # i've done ./configure --prefix=/usr/local/mysql \ --enable-assembler \ --with-innodb Further details: OS: SuSE Linux 8.0 Pro PC: AMD 750, 30 GB drive, 384 MB Memory Many thanks i

Romanian translation of error messages

not present in the standard characters of the linux. In what character set must I save the files? My name is Stefanescu Adrian. e-mail: [EMAIL PROTECTED] the source is of the file is: /* Copyright Abandoned 1997 TCX DataKonsult AB & Monty Program KB & Detron HB This file is

Re: MySQL Replication

Dicky Wahyu Purnomo wrote: > > On Wed, 03 Apr 2002 18:53:00 +0800 > Adrian Hoe <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > My department is migrating our application from MySQL-3.22.x to 3.23.49. > > I am > > interested in the new replication f

MySQL Replication

? % show databases; Output: Database_A Database_B Thanks. -- +-++ | Adrian Hoe | [EMAIL PROTECTED]| | Procrastination prevents creativity | [EMAIL PROTECTED

MySQL on QNX6_10 (newest RTP)

Can anyone help me? gruß, Adrian Skupien -- Adrian Skupien Web-Entwickler E-Mail: [EMAIL PROTECTED] Friedrich-Ebert-Strasse 153 42117 Wuppertal Fon +49 (0)202 69 50 306 Fax +49 (0)202 69 50 299 Didn't take a look at http://www.ers

Re: how to get the correct result -- Thrid Time --

| | 8917 | Aegean Village | | 8122 | Aegeon | +--+-+ Thanks Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To r

Re: how to get the correct result -- Thrid Time --

he space (" ") will match if there are two spaces. I am not sure how may are there. Adrian > > > > On Fri, 19 Oct 2001, Adrian D'Costa wrote: > > | Date: Fri, 19 Oct 2001 10:43:31 +0530 (IST) > | From: Adrian D'Costa <[EMAIL PROTECTED]> &

RE: how to get the correct result -- Thrid Time --

| | 9757 | aegean village | | 7973 | aegean | | 8917 | aegean village | | 8122 | aegeon | | 8284 | aeneas | +--+-+ Atain 5208 and 3063 are the same so is 9757 and 8917. I just want only one of them to ap

RE: how to get the correct result -- Thrid Time --

If there's still a problem, >replace all tabs (\t) and carriage returns (\r) with a space, and repeat the above. >And from now on, make sure the data gets put in right :) Well that would only get the first two spaces. I do not know how many spaces are there Adrian > >

Re: why

On Thu, 18 Oct 2001, Jani Tolonen wrote: > Adrian D'Costa writes: > > > If you 'office system' is, for example, Sun Solaris, you will see only > > > 1 mysqld process with 'top'. The fact that in Linux 'top' shows > > > actu

Re: why

On Wed, 17 Oct 2001, Jani Tolonen wrote: > Adrian D'Costa writes: > > Hi, > > > > I have been using Mysql that was provided on my RH7.0 cd. It works on my > > office system and it shows only one process. The same thing I installed > > on m

how to get the correct result -- Thrid Time --

rtrim nothing works. Second, using the same data I get some of the hotel names in CAPS and I need to convert it to lower and then group by. How do I get these two done? Thanks Adrian - Before posting, please check: htt

Re: strange

gt; whereas you probably meant > > WHERE na.nid=nc.id AND (na.nid=1 OR na.nid=3 OR na.nid=9) > > which also can be written as > > WHERE na.nid=nc.id AND na.nid IN (1, 3, 9) Interesting. I never knew that I could you thi

RE: last week, this week (fwd)

> -Original Message- > From: Adrian D'Costa [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 21, 2001 12:56 AM > To: Mysql Mailing List > Subject: last week, this week > > > Hi, > > I have a table that hold a lot of information about pricing and da

last week, this week

Hi, I have a table that hold a lot of information about pricing and dates. I would like to list the of differnce of prices between last week and this week. Adrian - Before posting, please check: http://www.mysql.com

Problems with my.cnf

Hi, Could anyone tell my why from time to time, the file my.cnf (under Win2000 and MySql) is automatically renamed into my_cnf.bak? Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual

Problems with transactions on InnoDB tables

Hi, I'm a beginner with MySql. Could anyone give me an example how transaction isolation works on InnoDB tables under Win2000? (If you have any examples I'll be happy). Thanks in advance. Adi - Before posting, please check: h

MySQL with Redhat 7.1

quot;MySQL ends") without an error!! The user "mysql" exists (Created by the install). Are there any other actions I need to do before trying to start MySQL? Can anybody help? Many Thanks, =Adrian= Information in this message is confidential and may also be legally privileged. I

How do I do this?

display another sent of 7 >records but it just keeps displaying the same. > >+---+ >| version() | >+---+ >| 3.23.36 | >+---+ > >How do I do this. > >Adrian > - Before posting, please c

rand()

version() | +---+ | 3.23.36 | +---+ How do I do this. Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this t

RE: mysql error

Hi, Thanks. After sending my mail I found out that the mysqld was not running. Now it is fine. Thanks once again Adrian On Tue, 17 Jul 2001 [EMAIL PROTECTED] wrote: > as opposed to using safe_mysqld > try starting mysql using > /etc/init.d/rc.d/mysql start > and stopping

mysql error

mp/mysql.sock but I still get the error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) How do I solve this as I am in the middle of a web database project TIA Adrian --

Re: SQL query problem

our table hold any data less that 65000? Try select zip, city, county from zipcodes where zip>=68400 and zip<= 68500; Regards Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: MySQL stm

01-07-06 | 399| +--+---++++ 10 rows in set (0.08 sec) But again the vitofferta (price) reflects to the first row when counted. This is wrong I need it to take the price selected from the max(period) or max(id). Adrian ---

MySQL stmt

pro | 1211 | +--+---++---++ Perfect! But it the price the last inserted price?? I am not sure. Here I remove the periodo field as it wraps. Can you tell me how to do this to create the hotel t

RE: how do I do this

h.hotelname; This will just display the rows. I need to update the travel table with the id of hotel table based on the hotel names being the same. TIA Adrian > > -Original Message- > From: Adrian D'Costa [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 14, 2001 1:49 AM

Re: mysql and MyODBC

;-) That is my last option :-( Cheers Adrian - 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 <[EM

how do I do this

in the travel.nome_hotel. How do I do this. TIA Adrian - 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

mysql and MyODBC

em? TIA Adrian - 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,

Can any body supply "libmysqlclient.so" for Solaris 7?

Could anybody e-mail me a copy of "libmysqlclient.so" for Solaris 7 -or- let me know where I can get one? Many Thanks, =Adrian= Information in this message is confidential and may also be legally privileged. It is intended solely for the person to whom it is addressed. If you a

Re: Re: php/mysql question (fwd)

database,sql,query On Fri, 8 Jun 2001, Gabriele Bartolini wrote: > > >magic_quotes_gpc = On ; magic quotes for > >incoming GET/POST/Cookie data > > And, what about: magic_quotes_ru

Re: php/mysql question

On Fri, 8 Jun 2001, Rolf Hopkins wrote: > > - Original Message - > From: "Adrian D'Costa" <[EMAIL PROTECTED]> > To: "Mysql Mailing List" <[EMAIL PROTECTED]> > Sent: Friday, June 08, 2001 13:59 > Subject: php/mysql question > >

Re: php/mysql question

c_quotes_gpc= On > magic_quotes_runtime= Off I grep'ed php.ini, here it is magic_quotes_gpc= On ; magic quotes for incoming GET/POST/Cookie data > In this case, the urldecode is in *surplus*. You should remove it, and just > use strip

php/mysql question

I do the following: $tname =urldecode($name); $tname1 = stripslashes($tname1); $updtStmt = "update vusers set orgname='$tname1' where id=$tid"; This works fine, but suppose in by table I have a name "Adrian D'Costa" This starts all the problems. I copy the sql

RE: Need help on mysql/php

On Wed, 6 Jun 2001, Ian Ford wrote: > Name your config file config.inc and if any of the below situations > happen your password and username will not show up in plain text for the > casual browser. > (EXAMPLE: > > CONFIG.INC > $DBname = 'test'; > $DBuser

Linking libmysqlclient

ent.a", but I do see mention of a "libmysqlclient.so" in the MYSQL documentation. Would I need "libmysqlclient.so"? If so, form where would I get it? Many Thanks, =Adrian= Information in this message is confidential and may also be legally privileged. It is intended solely f

Re: sessions problems

Thanks, Will try that out. Adrian On Thu, 31 May 2001, g_gosho wrote: > You can try this link: http://www.bonev.com/s > > there is PHP session handling librarary and documentation how to use it > > - Original Message - > From: "Adrian D'Costa&quo

Can get safe_msqld to run in background!!

ssing something very obvious. Any Ideas? Many Thanks, =Adrian= Information in this message is confidential and may also be legally privileged. It is intended solely for the person to whom it is addressed. If you are not the intended recipient, please notify the sender, and then p

  1   2   >