RE: [PHP] Access to MYSQL via ODBC?

Yes I found it!!: http://www.cynergi.net/exportsql/ thanks you again!! mweb > -- Initial message --- > > From: "Andrew Hill" <[EMAIL PROTECTED]> > To : "mweb" <[EMAIL PROTECTED]> > Cc : <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Date:

RE: [PHP] Access to MYSQL via ODBC?

> apart from performance issues, is it possible in PHP to read/write a > MYSQL DB not directly, but via ODBC? The reason (as states in my other > message "MS ACCESS on Linux") is that it would make possible to test on > Linux PHP code that would eventually manage (wit xero or minimal changes) > an

why ever use TINYBLOB/TEXT -- isn't VARCHAR same size? (fwd)

Carsten H. Pedersen writes: > I assume that there is a small speed penalty in using TEXT/BLOB > fields, as compared to VARCHARs. I recall seeing some test where TEXT was actually faster, but it might have been in some special situation. On the whole, I think that being able to specify a length

RE: [PHP] Access to MYSQL via ODBC?

Mweb, This access to mysql conversion tool is availabe at the MySQL site - check the contributed software section for a couple of options. Alternatively, just run both MySQL and Access on Windows, and access it via ODBC. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Softw

RE: [PHP] Access to MYSQL via ODBC?

Andrew, thanks again for your lightning fast answers. However, I realize that I did not explain the problem completely. Part of it is that I don't have the possibility to network one Win computer and a Linux one. I only have either Linux or Windows, in any given moment:-(( Otherwise another

QUERY HELP - IF THEN ELSE

Hi... I want to output results based on the query from 3 tables ( described here ) TABLE 1 SUBID (SAME AS IN TABLE 2) ID FILE DATE DISCIPLINE (SAME AS IN TABLE 3) TABLE 2 NAME SUBID (SAME AS IN TABLE 1) TABLE 3 NAME EMAIL

RE: [PHP] Access to MYSQL via ODBC?

Mweb, Same --with-iodbc, just install a different ODBC driver. Use the OpenLink Multi-Tier driver, "piggybacked" on the MS Access driver. Install the Multi-Tier driver with Linux as your client, Win32 as your server, and Access as your db. Then: 1. configure a system DSN on the Win32 box using

RE: [PHP] Access to MYSQL via ODBC?

GREAT, THANK YOU! Now the only step left is how to convert (on Linux) the MS access database to MySQL...How? mweb > -- Initial message --- > > From: "Andrew Hill" <[EMAIL PROTECTED]> > To : "mweb" <[EMAIL PROTECTED]>, "phplist" <[EMAIL PROTECTED]>,

RE: [PHP] Access to MYSQL via ODBC?

Sure, this is entirely possible. Configure PHP --with-iodbc as per the HOWTO at www.iodbc.org and then install the MyODBC driver. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers

Re: it shows columns when it should only show tables ( mysql client )

Hi. It's been a while, but here it goes... As far as I know, the mysql command line client does not know about commands, i.e. the name completion feature (via TAB) is _not_ context sensitive and will just present all completions which fit to the word fragment you typed. So, without knowledge wh

Access to MYSQL via ODBC?

Hello, apart from performance issues, is it possible in PHP to read/write a MYSQL DB not directly, but via ODBC? The reason (as states in my other message "MS ACCESS on Linux") is that it would make possible to test on Linux PHP code that would eventually manage (wit xero or minimal changes) an M

Re: Can't connect via IP, but can via hostname

Carl Troein writes: > http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html Oops. That only convers the difference between 'localhost' and anything else. If whoever posted the question is interested in actually getting things to work, read the manual chapter on how the privilege system wo

RE: why ever use TINYBLOB/TEXT -- isn't VARCHAR same size?

> http://www.mysql.com/doc/n/o/node_357.html > > explains the different string data types and the storage requirements: > > Column Type Storage required > [...] > VARCHAR(M) L+1 bytes, where L <= M and 1 <= M <= 255 > [...] > TINYBLOB, TINYTEXT L+1 bytes, where L < 2^

Re: update from table x to table y

Hi, thanks dn, so, to confirm, there is no MySQL to represent the following?: update Raw,Unresolved_Duplicates_perm set Raw.Inactivate = 1 where Raw.Key_num = Unresolved_Duplicates_perm.MinOfKey and Raw.Peak1=0 Thanks Rich >From: "DL Neil" <[EMAIL PROTECTED]> >Reply-To: "DL Neil" <[EMAIL PRO

Re: Can't connect via IP, but can via hostname

Gerald Clark writes: > I notice you didn't have the time to look it up either. And neither did you. This is getting seriously silly. :-) To see the original question, look at the bottom (weird, I know) of this message. To see an answer, look here: http://www.mysql.com/doc/C/a/Can_not_connect_t

Re: Need to understand mysql mechanisms

Hello S! > I am sending this mail in order to get things straight > about table corruption which I am experiencing with > 4.0(as well as previous versions). > > 1)System specs: PIII x1000MHz, 1GB RAM, HD 37GB SCSI, > AHA29160N SCSI controller OK, so this is a possibly a 'fairly' new box, meaning

Re: order by, group by

Thank you for your responce, you have guessed it correctly the only difference is the usage of MAX which I cannot use (see my explenation on what I want to do in a seperate message) I'm not sure IF I can do it with sub-selects either, but when subselects is present in mysl, I could try that one..

Re: Can't connect via IP, but can via hostname

I notice you didn't have the time to look it up either. Rick Emery wrote: > Help the guy out by telling him WHERE in the manual to look. Answers, such > as "Please read mysql manual, your question covered by manual." are of no > help. > > -Original Message- > From: Abu @ Trabas Dot Com

Re: order by, group by

Im trying to make a "data" system that is language-independent, ie the data stored can have any language therefore the same information is stored several times but with different values (depending on language) lets say that I have this table.. articles(id,language,name,description) what I would

RE: Can't connect via IP, but can via hostname

Help the guy out by telling him WHERE in the manual to look. Answers, such as "Please read mysql manual, your question covered by manual." are of no help. -Original Message- From: Abu @ Trabas Dot Com [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 11:33 PM To: [EMAIL PROTECTE

Re: update from table x to table y

Duplicating values (cf keys) in tables involves de-normalisation and is therefore not recommended. Your observation row cf column is correct. I felt the question was sufficiently broad to risk interpreting "update" as wider than "UPDATE", sorry - the other response seemed to hit that nail on t

RE: Fulltext search variable

Hi Sergei and everyone... Thanks for the help... looking forward to 4.0.1!! best wishes Chris -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 1:30 PM To: Christopher Thorpe Cc: [EMAIL PROTECTED] Subject: Re: Fulltext search variab

RE: Hash Tables / Indexes

> From: Karl J. Stubsjoen > Hello, > > Can someone explain hash tables or hash indexes and if we can > take advantage > of them in MySQL? > > Thanks! > > Karl A few words on a meaty subject... Hashing is a search method based on an arithmetic or algorithmic transformation of the key. Hashing i

Re: update from table x to table y

thanks for that, but that will add a row as opposed to updating a column won't it? I don't want to insert a new row. All I want to do is update a value in table1 if it is present in table2 cheers Rich >From: "DL Neil" <[EMAIL PROTECTED]> >Reply-To: "DL Neil" <[EMAIL PROTECTED]> >To: "Richard D

Re: Fulltext search variable

Hi! On Nov 13, Christopher Thorpe wrote: > Hi Sergei > > Thanks for the prompt reply... I've just tried AGAINST ('Jonat*') but get > the same results... we've actually got the ft_min_length set to 2 as we have > a few authors whose surnames are Li (and we've found no major performance > issues).

why ever use TINYBLOB/TEXT -- isn't VARCHAR same size?

http://www.mysql.com/doc/n/o/node_357.html explains the different string data types and the storage requirements: Column Type Storage required [...] VARCHAR(M) L+1 bytes, where L <= M and 1 <= M <= 255 [...] TINYBLOB, TINYTEXT L+1 bytes, where L < 2^8 [...] These t

how do you find out which table fields are foreign keys?

I created the "persons" and "shirts" tables as described in the MySQL tutorial: http://www.mysql.com/doc/e/x/example-Foreign_keys.html such that the "owner" field in shirts is a foreign key referencing the "persons" table. However, "describe shirts" does not indicate that the field is a fore

Re: order by, group by

On Tue, 13 Nov 2001, Carl Troein wrote: > As far as I understood the original post, the question was if > there's a way to get MySQL to perform an ORDER BY prior to > doing the GROUP BY. Yes it was but "prior to" does not make much sense and that is why I asked the original poster for an example.

RE: Fulltext search variable

Hi Sergei Thanks for the prompt reply... I've just tried AGAINST ('Jonat*') but get the same results... we've actually got the ft_min_length set to 2 as we have a few authors whose surnames are Li (and we've found no major performance issues). I'd tried a few longer words before like 'genom*' fo

Re: order by, group by

DL Neil writes: > "All keywords used must be given in exactly the order shown above. For example, a >HAVING clause must come after > any GROUP BY clause and before any ORDER BY clause." As far as I understood the original post, the question was if there's a way to get MySQL to perform an ORDER

mysql 4 alpha

hi! is there anybody, who knows of a site or documentation about the new features of mysql? maybe also articles or whatever? or is there even someone who already made some testing with the new alpha version? greetings christian _ Do You

Re: order by, group by

mysql On Mon, 12 Nov 2001, Christian Andersson wrote: > Is it possible in myslq to do an order by before an group by? For me it is not clear why would you want to do that. Can you give an example? -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Cam

Re: update from table x to table y

> Hi does anyone know of a way of taking some data from one table and updating > another table with it? > > If MySQL doesn't support it i'm gonna have to go back to Access or > something! Rich =only "go back" to Access if you're a glutton for punishment! =try MySQL/HTMLmanual/manual_Referen

Re: order by, group by

> Looks like no one knows the answer to this question... =or we don't want to state the obvious/seem rude when saying "RTFM" 7.19 SELECT Syntax "All keywords used must be given in exactly the order shown above. For example, a HAVING clause must come after any GROUP BY clause and before any ORDER

Solution for testing PHP/MS Access on Linux

Hello, some days ago I asked help on this list because I have to develop and test on Linux/Apache some PHP pages that will have to run on on an IIS/NT box. On the real server the pages must manage a MS Access database via ODBC (this mixed setup cannot be changed: explanations in the original mess

Re: update from table x to table y

Rich, >Hi >does anyone know of a way of taking some data from one table and updating >another table with it? >If MySQL doesn't support it i'm gonna have to go back to Access or something! >thanks > >Rich Sinisa is right now writing a multi-table update to 4.0. Some updates can be handled alread

Re: Fulltext search variable

Hi! On Nov 13, Christopher Thorpe wrote: > Hi Sergei > > Sorry to post off list to you, not sure what else to do... I've posted to > the list twice but received no reply at all to my query. I'm doing a whole > load of MATCH AGAINST queries, but have no luck at all in using the > truncation opera

Re: Problem: myisamchk: error: Checksum for key....

Grzegorz Paszka writes: > On Mon, Nov 12, 2001 at 07:21:07PM +0200, Sinisa Milivojevic wrote: > > Before I wrote to this list I read manual. Especially chapter 4.4 . > > I've done what You suggested but it didn't help. (Stage 3: Difficult repair). > That's one problem. > > Another is as I wrot

Re: Problem: myisamchk: error: Checksum for key....

On Mon, Nov 12, 2001 at 07:21:07PM +0200, Sinisa Milivojevic wrote: > Grzegorz Paszka writes: > > > > Yes, I say more, that I created new database and filled it by perl script from >data source and I have the same situation. I think that is the best way of rebuild >index file :) > > See in our

Re: order by, group by

Looks like no one knows the answer to this question... - Original Message - From: "Christian Andersson" <[EMAIL PROTECTED]> To: "MySQL Mailing list" <[EMAIL PROTECTED]> Sent: Monday, November 12, 2001 10:30 PM Subject: order by, group by > I asked before, but got no answer, so I ask aga

update from table x to table y

Hi does anyone know of a way of taking some data from one table and updating another table with it? If MySQL doesn't support it i'm gonna have to go back to Access or something! thanks Rich _ Get your FREE download of MSN Explor

Re: innodb inserts/select crash

Hi! You are getting a lock wait timeout error, not a crash. In the newest version 3.23.44 code 101 has been replaced by a native MySQL error number 1205 and a descriptive message. >Hi there. > >Can anyone offer a solution to this problem. >CREATE TABLE `raw` ( > `cid` int(11) default NULL,

Re: Alphabetizing book titles

Hi. Try this: SELECT title FROM titles ORDER BY IF(SUBSTRING(title,1,4)="The ",SUBSTRING(title,5), IF(SUBSTRING(title,1,2)="A ",SUBSTRING(title,3), IF(SUBSTRING(title,1,3)="An ",SUBSTRING(title,4), title))); But in version 3.23.36 the next: SELECT title FROM titles ORDER

table corrupted after an error free load

Hi, Sorry to disturb, but I cannot find any answer in online doc and web archive. >Description: I insert 34000 rows in a simple table with all text fields, and myisamchk tells the table is corrupted, while a select into outfile does not give any error compared to the original file. >H

What's better with assumption

Hi, All I've CGI Application using C/C++ Assume that connection establishment by client and MySQL database server is very fast, what's better between : - Persistent Connection - Non Persistent Connection Because as CGI application it's difficult to use persistent connection, excep

<    1   2