From MS Access to WinNT-MYSQL-Server

now: 1) how to transfer the database from MS Access to the SQL server; 2) how to make the webpages that people use to search our online database. The servers are Windows NT server with MySql support. I thank you for any answer you may give me. Ciprian

SQL Syntax list

*This message was transferred with a trial version of CommuniGate(tm) Pro* Anybody knows where I can find a list with all SQL syntax -es. Eventually explained. Thanks - Before posting, please check: http://www.mysql.com/man

RE: Aborting a greedy querry from the command line

> On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote: > > Hi Chris, > > > > I've noticed that a Ctrl-C will also leave the query > running (5.0.22 - > > Linux) and I've had to use the kill from mysqladmin or > mysql client to > > get rid of it. > > Huh, that's odd, it should a

Re: Error with PHP: undefined function: mysql_connect()

In PHP 4.1 you have to include the mysql.so extension. To do so, you have to modify php.ini, extensions section "sheeri kritzer" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Sounds like the binary you used did not have PHP compiled with the MySQL libraries. If you make a phpinfo()

Re: Error with PHP: undefined function: mysql_connect()

This solution is valid, but not advisable. If you run your server in a production environment, you shouldn't allow the dl function, as your users could activate any extension > Or better, add that extension runtime because otherwise it will just consume > computer resources, and maybe not every PH

Re: Date increment

SELECT DATE_ADD(expiredate, INTERVAL 17 DAYS) http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html ""Peter Lauri"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Best group member, I have a field called expiredate of type 'date'. I would like to add 17 days to the ex

Limit queries

I have 2 tables: currencies and quotes currencies == id currency - quotes == id date id_currency value --- Index (date, id_currency - UNIQUE) In order to find the most recent value for a currency I use the following logic: 1. SELECT m

Dillema: LIKE vs MATCH - AGAINST

I'm building a financial-like web site (PHP - MySQL). I was requested to build a search engine for IT. Everything works OK, w/ the exception of a certain component. The owner of the web site will write, each day, a report for the customers. I use TEXT fields to record each section of the report (t

String functions for GROUP BY clause

Is there a way to use a string concatenating function in connection with a GROUP BY clause? I mean, for a one-to-many relation (like firm-stockholders relation), to "catch" a structure like: firm | stocholders f_1 | s_1; s_2; s_3 f_2 | s_4; s_5 f_3 | s_6 instead of firm |

Best practice on table design

| P| | 4 | Madrid | C| | 5 | Berlin | C| --- where central_data.type is P for people and C for cities. Do you think it is a good ideea ? -- Best regards, Ciprian Trofin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Best practice on table design

re of. Wouldn't be better (maybe more efficient ?) to put all the 2-field tables in only table, with a separate ENUM field to separate the records on categories ? -- Cip CRD> Hi Ciprian, CRD> OK, I'm by no means a DB guru, so a) take this with a grain of salt CRD> and

Self Join on temporary tables in MySQL 3.xx

f the temporary table and use it together with the "original" temporary table to execute the join ? -- Ciprian > Ambition is a poor excuse for not having enough sense to be lazy. - Before posting, please check: ht

Bug or am I missing something ?

0 1 0 3 0 5 0 2 0 This works: SELECT R.id, U.user FROM users U, ring R WHERE R.user = U.id; iduser --- 1gogu 2alex 3gogu

Re[2]: Bug or am I missing something ?

`, `user`) VALUES >>('1','cip'), >>('2','gogu'), >>('3','alex'); >> >> >> >>Now, the problem: >> >>This doesn't work: >>SELECT R.id, U.us

Re: How to do regular backup in MYSQL

>>mysqldump --opt mydatabasename > mybackup.sql KHC> Now,lets say i never shut down my pc and the MySql is running all the KHC> time. How can i do a regular backup (ie.every evening 9.00 pm) KHC> automatically? -- Ciprian -

Optimization

te here is: what if a new player registrate himself between step 4 and 5? His table won't be included on step 6. I see the following solution: LOCK stock.users and players.* in one step, but I can't / don't know how to lock an entire database. Suggestions here? Thanks -

Re: Max 127 records

`) VALUES ('', 'fsd', 'sfdg', 'sg', 'fdsg', 'sfg', HO> 'sg'); HO> MySQL returnerede: HO> Duplicate entry '127' for key 1 -- Ciprian > There is no such thing as an underestimate of average intelligence.

Re: returning top two values

mily and curEntry.score <= R> greaterEntries.score R> group by curEntry.family, curEntry.member R> having orderstatistic < 3 R> order by family, orderstatistic; -- Ciprian > Ambition is a poor excuse for not having enough sense to be lazy. ---

Join or smth.

uot;s3"); INSERT INTO products VALUES("7","p3","100","s1"); INSERT INTO products VALUES("8","p3","120","s2"); INSERT INTO products VALUES("9",&q

Re[2]: Join or smth.

t;p2","300","s3"); >> INSERT INTO products VALUES("7","p3","100","s1"); >> INSERT INTO products VALUES("8","p3","120","s2"); >> INSERT INTO products VALUES("9",&qu

Problems with the unique properties...

*This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I have a table in my database that has one field named design_name. The design_name is varchar(200) unique. After I created the table the need appeared to have duplicates in this field. So I tried to remove the uniqu

MySQL vs Microsoft SQL

me with this. Thanks, Ciprian A. - 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]&

Mysql vs ....

me with this. Thanks, Ciprian A. - 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]&

Problems choosing....

me with this. Thanks, Ciprian A. - 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]&

Re: MySQL, PHP, Apache: /usr/libexec/ld.so: httpd: libmysqlclient.so.6.0: No such file or directory

*This message was transferred with a trial version of CommuniGate(tm) Pro* I can't get through posting a message on the mysql mailing list! any idea why??? At 12:45 PM 3/23/2001, Shell Hung wrote: >*This message was transferred with a trial version of CommuniGate(tm) Pro* >Colonel Panic wrote

The opposite of where column_name LIKE "%string%"

*This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I need to select from a table all the records that do not contain a certain string. Any idea how I can do this? For example if I want to select all the fields that contain the string "my_string" I type: $ select * f

Matrix Logic System...!!????

Hi, I am supposed to build a Matrix Logic System (or something like this) for merging to databases. I have no idea what so ever of what is a Matrix Logic System. Can anyone tell me with what this can be eaten? Thank you very much, Ciprian A.

"quantum effects" on MySQL 5.0.27?

Hi everybody, We've been badly hit by a very interesting problem: an index gets into a "disabled" state if, during the filling up of a table containing a column having the said index, one only *looks* at the data which is being loaded! =:-o In other words I start with "DROP TABLE" after which I

group multiple queries.. if one fails all fail

ld be run? Thank you, -- Ciprian I. Acatrinei <[EMAIL PROTECTED]> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thr

group multiple queries.. if one fails all fail

ld be run? Thank you, -- Ciprian I. Acatrinei <[EMAIL PROTECTED]> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thr

mysql overhead

overhead have on a table? Thank you, -- Ciprian <[EMAIL PROTECTED]> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thr

Relations between tables....

products and the customers. How can I set up table1 to lock all the entries that are used in table2 for reference? I appreciate any answer Thank you, Ciprian - Before posting, please check: http://www.mysql.com

MySQL vs Microsoft SQL

me with this. Thanks, Ciprian A. - 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]&

Re: MySQL vs Microsoft SQL

Is there something that you can do with MS SQL and you can not do with MySQL? At 04:01 PM 3/23/2001, Jeremy D . Zawodny wrote: >*This message was transferred with a trial version of CommuniGate(tm) Pro* >On Fri, Mar 23, 2001 at 01:09:47PM -0500, Ciprian I. Acatrinei wrote: > > *

unique

Hi, I am having a hard time removing the unique property from a field... I set up a field as unique now I need to allow multiple values in that field. How do I take out the unique property of that field... PS: I couldn't figure it out from http://www.mysql.com/doc/en/ALTER_TABLE.html Thank you,

Not unique table/alias

Hi, mysql> INSERT INTO f_baldai_seq (seq, nextval) SELECT seq, nextval+1 FROM f_baldai_seq LIMIT 1; ERROR 1066: Not unique table/alias: 'f_baldai_seq' Please help. Thank's. - Before posting, please check: http://www.mysql.