alternative to intersect in mySQL

I know that intersect does not work yet with mySQL. I am selecting data from two tables. Results of one select would be 1, 2, 3, 4 . Results of other select 1, 2. Want to print 1, 2. Are there any nice workarounds using PHP or SQL? thanks, -tom

calculated fields

Hello folks! Does MySQL support calculated fields? Maybe this isn't the right name (I don't really know the database theory), so let me explain by example: CREATE TABLE pricelist (product VARCHAR(255), price DECIMAL(10,2), price_with_vat = ROUND(price * 1.22, 1)); Now, the column

row id

Do anyone know how to select or get the row id of a row in MySQL? thank you Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: calculated fields

Hi, SELECT product, price * 1.22 AS price_with_vat WHERE price_with_vat 1000; mysql select price * 1.22 as pricevat from pricelist; +--+ | pricevat | +--+ |12.81 | +--+ 1 row in set (0.02 sec) mysql select price * 1.22 as pricevat from pricelist having pricevat

Re: alternative to intersect in mySQL

Hi, I know that intersect does not work yet with mySQL. I am selecting data from two tables. Results of one select would be 1, 2, 3, 4 . Results of other select 1, 2. Want to print 1, 2. Are there any nice workarounds using PHP or SQL? You could use a temporary table to store the

Pre-release of MySQL 3.23.50

Hi! 3.23.50 is basicly just a bug fix release compare do 3.23.49a There is however two things one should be aware of regarding 3.23.50 (both only affecting our Linux x86 binaries (normal and RPM's): - We have switched to a new updated glib library, because we found a critical memory

table lock - which connection id own's it

Hi! Lopez == Lopez David E-r9374c [EMAIL PROTECTED] writes: Lopez AntiSpam - mysql, sql, query Lopez Version: 3.23.49a, MyISAM, NT, Solaris Lopez My app is 150 daemons writing logs to mysql. The main Lopez table is of fixed size but depends on four other tables Lopez for foreign keys (hash

Multiple FULLTEXT searches

sql,query Hi, how one can do a FULLTEXT search from multiple tables? SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database'); above format works for one table but how I need to alter it for it to search multiple tables? JAri Mäkelä

Mysql.sock missing

Hello all, I am facing very strange problem I am not having mysql.sock in /var/lib/mysql But it is showing its status to be running. How could it be? Clearance needed. -- Regards, Charitha. - Before posting, please check:

Re: Mysql 4.0.x enough stable to be in production ?

I've been running 4.0.1-alpha on a development server for our new internet bookstore. Holds around 1.3million books, 100k bookcovers and a lot of other information. I haven't experienced any crash/problems except for one bug that brings down MySQL: using two 'match-against' in fulltext search

Help needed on query

I have a table like this one: +-+---+---+ | uid | username | query | +-+---+---+ | 1 | someuser | %qu1% | | 2 | anotheru | bla% | +-+---+---+ I get a string from external source, let's say the string is 'blahblah'. Now I need a query

Re: Mysql.sock missing

Heya! Perhaps because its mysqld.sock ? Check your my.cnf file to see how your configuration is configured (what file and what path the socket file is) [mysqld] socket = /var/run/mysqld/mysqld.sock EG Hello all, I am facing very strange problem I am not having mysql.sock in

Re: Having lots of tables

Hello Agustín, Monday, April 22, 2002, 11:50:44 PM, you wrote: AF I have a question on a project i am currently on. I am adapting Phorum AF (www.phorum.org) to my own portal and have a doubt about MySQL. Phorum AF creates a table for each discussion forum. However, in the portal i work AF for,

Mysql.sock missing

The entry in my.cnf file is /var/lib/mysql/mysql.sock only I am having two machines. In one thing it is working fine And in another one i stop it manually and trying to start it through my script It is starting i suppose and the status showing is running but due to the socked file missing i am

trying to cpmpile mysql with hebrew

I try to compile mysql with hebrew and did not success. I compile it on solaris 5.6. When I configure it with: ./configure --prefix=/usr/local/mysql-3.23.49 --with-low-memory --with-extra-charsets=complex --with-charset=hebrew --enable-assembler or When I configure it with: ./configure

Checking if a table exists?

Hi! How do check if a certain table exists? I have to know if the table exists and then make a query in that table. I mean to use it in a function so the SHOW TABLES is not an option... I have tried the sysobjects solution but it comes back with: table 'lve.sysobjects' doesn't exist. Thanks

Re: Help needed on query

Hi, Now I need a query which will take the values from column 'query', treat them as patterns for matching and return row(s) which match the given string 'blahblah'. In this example, the matched data is obviously in second row. (bla% matches blahblah) Do I make any sense? Is

many small queries or one big one

sql,query HI, which one would be best for performance, many simple queries or one complex? jari mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: super-smack on FreeBSD

Hi List I know super-smack was writing for Linux but I am trying to get it to work on FreeBSD. Has any one done this or is there a another many threaded bench mark software out there for MySQL ? Thanks Simon - Before

Re: Help needen on query

Hi all !! This is just great ! Sometimes things seem to be more complicated than they actually are. I needed (and still do) a similar solution to check if an IP adress exist in a table. And sometimes the argument in the query is a whole subnet like 192.168.0.% I guess this will do the job for

Re: Question about mysql++ and g++

Mike Holmquist writes: Ok, i downloaded the mysql++-1.7.8-1.i386.rpm ftp://ftp.rpmfind.net/linux/MySQL/mysql++/mysql++-1.7.8-1.i386.rpm rpm file from RpmFind.net. I have mysql installed already on my machine, o ya and im running linux. I have gcc installed, version 2.96, i think

Re: Cant connect using socket ''(111) for Mysqlgui on linux

Krishna Kumar Sundara Moorthy writes: Hello All Is there any installation instructions for Mysqlgui1.7.5 on linux. Also i have installed it and while trying to connect it says couldnt connect using Socket''(111) and also can some one throw light on sql command on connet or Socket dialog

Further Question with -- table lock - which connection id own's it

Hi ... just wanted to added another question to this one... you suggested to use LAST_INSERT_ID() , but the question is if there are concurrent access to the database, how will you get the last id without locking the table. Because what I've been doing is also: 1. lock the table 2. get the id

read only tables

Dear all, When I try to update or create a record to a table, there is an error saying the table is read-only. How can I change it to read-write? I have chmod 777 to all the tables in the mysql data directory. I have also restarted the mysql engine. This happened only after I copy the tables

database design approval

i understand that this is a bit of an ask. but. I was wondering if someone could look over my database design. i've got a diagram. and text document of all my create table syntax. It's my first mysql database, and it's kind of important that i get the thing right. So if anyone could

Re: Cant connect using socket ''(111) for Mysqlgui on linux

Verify if your MySQL server is running and the user and password when entering Mysqlgui1.7.5 I have the same on Linux and it's running fine. Hisseine - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002

Re: Mysql.sock missing

Don't worry if it's running then you can find that file else where on your system; try to look for in /tmp Hisseine - Original Message - From: Charitha [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 4:58 AM Subject: Mysql.sock missing Hello all, I am facing

Re: Pre-release of MySQL 3.23.50

On Tue, Apr 23, 2002 at 10:26:04AM +0300, Michael Widenius wrote: : : Hi! : : 3.23.50 is basicly just a bug fix release compare do 3.23.49a : : There is however two things one should be aware of regarding 3.23.50 : (both only affecting our Linux x86 binaries (normal and RPM's): : : - We have

Re: Pre-release of MySQL 3.23.50

Hi. I'm running on linux box 6.2 with glibc 2.1 and i compiled from src.rpm mysql. The compiler is gcc 2.95.2. So, the new version of mysql 3.23.50 can i complie with it (2.95.2) or i must upgrade to gcc 3.0.4 ??? Regards, irek. - Original Message - From: Michael Widenius [EMAIL

Re: Mysql 4.0.x enough stable to be in production ?

What table types are you using? Anthony I've been running 4.0.1-alpha on a development server for our new internet bookstore. Holds around 1.3million books, 100k bookcovers and a lot of other information. I haven't experienced any crash/problems except for one bug that brings down MySQL:

Re: sub selects

Try the following: SELECT leads.* FROM leads LEFT JOIN blacklist ON leads.refnumberid = blacklist.leadid WHERE blacklist.leadid IS NULL AND ... The LEFT JOIN will give you a row for every row in leads; blacklist columns will be null if there's no matching blacklist, so the WHERE

MySQL start

Can you help me in the following problem? OS: Linux Slackware 8.0 Source: mysql-3.23.42.tar.gz I can't start mysql after installing the source file. I did it step by step according guidance from Install-Source file. My OS is generating such messages: root@serwer:/TEMP# mysql ERROR 2002:

SUMMARY: Inserting a BLOB using MySQL++

All, First of all, thanks to everyone(Sinisa, Opus) who gave input into the resolution of my problem. What I ended up doing was escaping any character that would be interpreted as a special character in an STL string. These included , \0, and '. So, basically I armored the binary data and

Re: New Setup

Ian, Tuesday, April 23, 2002, 12:41:40 AM, you wrote: Egor By default user 'root' has all privileges... Egor Show me the output of following: Egor SHOW GRANTS FOR 'root'@'localhost'; IP mysql show grants for 'root'@'localhost' IP - ; IP

Re: Mysql.sock missing

Charitha, Tuesday, April 23, 2002, 11:58:37 AM, you wrote: C REALFROM: Charitha [EMAIL PROTECTED] C HOUR: 2002042312 C Hello all, C I am facing very strange problem C I am not having mysql.sock in /var/lib/mysql C But it is showing its status to be running. C How could it be? Check path

Re: ERROR 1045: Access denied for user: 'root@localhost'

Tewfic, Monday, April 22, 2002, 10:07:06 PM, you wrote: Hello, i'm having a problem accessing mysql database. I don't recall setting a password for root, but when i try to set that password. This is happening right after i run mysql_install_db [root@omsrh etc]# mysql -u root -p Enter

Re: MySQL start

Samuel, Tuesday, April 23, 2002, 4:04:20 PM, you wrote: SM Can you help me in the following problem? SM OS: Linux Slackware 8.0 SM Source: mysql-3.23.42.tar.gz SM I can't start mysql after installing the source file. I did it step by step SM according guidance from Install-Source file. SM

Re: Further Question with -- table lock - which connection id own's it

*** REPLY SEPARATOR *** Hi ... just wanted to added another question to this one... you suggested to use LAST_INSERT_ID() , but the question is if there are concurrent access to the database, how will you get the last id without locking the table. Don't worry about

MySQL with Delphi 5.0

I've installed MyODBC and then I've set up ODBC and I saw the driver for MySQL DB, when I try to create a new alias wiht MySQL it does not apear to select the DB, acording a book wich is guiding it should has to appear. Can anybody help to set up the ALIAS with MySQL Thanks José Haroldo

unable to build mysql-3.23.49 on Solaris2.6

Description: I am unable to build mysql-3.23.49 on Solaris2.6 using gcc 2.95.3. Build fails with following error in mysql-3.23.49/sql. Rest of project builds successfully. . . . Making all in sql Making all in share make[3]: Nothing to be done for `all'. /bin/sh ../libtool --mode=link

Re: trying to cpmpile mysql with hebrew

Afgin, Tuesday, April 23, 2002, 1:14:17 PM, you wrote: AS I try to compile mysql with hebrew and did not success. AS I compile it on solaris 5.6. AS When I configure it with: AS ./configure --prefix=/usr/local/mysql-3.23.49 --with-low-memory AS --with-extra-charsets=complex

How to update/insert to a blob?

HI Gurus, I am very in need of dealing object serialization in / out a database, but I want to do it independent of any dbm such as ADO, ODBC etc, and I believe there is a sql statement to do it(though may not implemented in sql92), can you tell me? Thanks a lot!

Re: problem with libmysqlclient_r.so

äÏÂÒÙÊ ÄÅÎØ. program crash in my_fopen this is stack of program : (gdb) bt #0 0x180ef7f2 in my_fopen () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 [skip] Hi! First of all,

Re: Pre-release of MySQL 3.23.50

Philip Molter [EMAIL PROTECTED] writes: On Tue, Apr 23, 2002 at 10:26:04AM +0300, Michael Widenius wrote: : : Hi! : : 3.23.50 is basicly just a bug fix release compare do 3.23.49a : : There is however two things one should be aware of regarding 3.23.50 : (both only affecting our Linux

Re: MySQL with Delphi 5.0

Hi, Haroldo Is it first time to develop Database Application with Delphi? Do you know how to use DataAccess Component(e.g., TDatabase) and BDE(or BDE Administrator)? I suggest to use Delphi6 Pro/Ent. It contains dbExpress Component which help you to develop Database Application very

Re: Further Question with -- table lock - which connection id own's it

Hello, Depending on how many people are updating this db should ultimately determine your decision to remove the table locks. If hte db is only experiencing one person updating it then it is not necessary. However if multiple people are updating it, then you will want to keep the locks. Here

Re: Checking if a table exists?

At 04:58 AM 4/23/2002, you wrote: Hi! How do check if a certain table exists? I have to know if the table exists and then make a query in that table. I mean to use it in a function so the SHOW TABLES is not an option... I have tried the sysobjects solution but it comes back with: table

Update

mysql update contact set alternatepreference='C' and AltContactID='1' where con tactid=2; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 any ideas why the UPDATE did not perform an update? Thanks Rich

Re: Checking if a table exists?

Hello, PHP has a function call that will return the table names within as an array. The function name is mysql_list_tables() Shaun - Original Message - From: BD [EMAIL PROTECTED] To: Bo Mellberg [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 10:38 AM Subject: Re:

RE: Update

For one of two reasons (probably) - and I think you found a bug: 1. The syntax in your set clause is wrong. It should be set alternatepreference='C',AltContactID='1' *Notice the use of a comma instead of and* 2. The row that matched the conditions in the where clause may already be set to

Re: Help needed on query

You should be able to just use something like this: Select uid, username From tablename Where '$externalstringvar' like query; That's PHP syntax. You'll have to use whatever makes sense for your scripting or programming language in place of the $externalstringvar variable. The single-quotes

mysqldump

Dear group members I did a mysqldump on my machine at home to backup a database. I saved the file to the /home/backup folder at my work and am trying to restore the database using mysql databasename /home/backup/backup_databasename.sql I get the following error: Cannot connetc to local mysql

Re: mysqldump

- Original Message - From: Harpreet Kaur [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 5:44 PM Subject: mysqldump Dear group members I did a mysqldump on my machine at home to backup a database. I saved the file to the /home/backup folder at my work and am

Re: problem with libmysqlclient_r.so

Andrey Kotrekhov writes: my program crash in another plase (gdb) bt #0 _db_enter_ (_func_=0x280fe4dc mysql_ping, _file_=0x280fdd48 libmysql.c, _line_=2248, _sfunc_=0xbfa87d3c, _sfile_=0xbfa87d40, _slevel_=0xbfa87d44, _sframep_=0xbfa87d48) at dbug.c:712 #1 0x280eceae in

Re: mysqldump

The mysql is working now and i can get into it. But when i type mysql databasename /home/backup/backup_databasename.sql To restore a database do i need to have the database created first. i get an error message error 1044: access denied for user @localhost to database databasename If i log

Re: Update

I'd have to guess that MySQL is interpreting the set clause this way: Set events_ID = ( 512 AND ( term = 'changed' )) That is, a logical AND, so a zero result makes sense. Still, it seems a bit odd. - Original Message - From: Salada, Duncan [EMAIL PROTECTED] For one of two reasons

Re: mysqldump

Dont worry. It worked. Yes i was supposed to create the database before using the restore command as it couldnt find the database. Thanks neways, Regards, Harpreet kaur From: Harpreet Kaur [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: mysqldump Date: Tue, 23 Apr 2002 16:08:23 +

RE: alternative to intersect in mySQL

If it is in a multi-user environment, this is undesirable. Any other thoughts? I was thinking of doing arrays in PHP and then using array_intersect PHP function, but would prefer a cleaner way. -Original Message- From: Aleksandar Bradaric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April

UDF's Under Windows

Does MySQL 4 support udf's under Windows? Mike.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

REPLACE() wildcards

Hi, When using the REPLACE() function in a query, are there any wildcards allowed? If so what are they? Also are regular expressions only usable for matching or can one also do a regular expression substitute in some way? Thanks Gavin

RE: Further Question with -- table lock - which connection id own's it

* Shaun Bramley Depending on how many people are updating this db should ultimately determine your decision to remove the table locks. If hte db is only experiencing one person updating it then it is not necessary. However if multiple people are updating it, then you will want to keep the

Re: MySQL with Delphi 5.0

Several ways to do this, MyODBC, ZEOS, ASTA. dbExpress has issues, these can be confirmed in the Borland News groups. ZEOS works well and is free, MyODBC works but the BDE must be installed on the Client if the native database componets id D6 - D5 is used, ASTA is fast and excellent for Internet

Re: MySQL with Delphi 5.0

I tryed to use Delphi 6.0 and dbExpress, but I didn't got. What component and what property I have to set for use correct?? Regards Alexander -- Mensagem Original -- Hi, Haroldo Is it first time to develop Database Application with Delphi? Do you know how to use DataAccess

Re: MySQL with Delphi 5.0

I tryed to use Delphi 6.0 and dbExpress, but I didn't got. What component and what property I have to set for use correct?? Regards Alexander -- Mensagem Original -- Hi, Haroldo Is it first time to develop Database Application with Delphi? Do you know how to use DataAccess

Prerelease of MySQL/InnoDB-3.23.50

Hi! InnoDB is a MySQL table type which adds transactions, row level locking, hot backup capability, and foreign key constraints to MySQL. Version 3.23.50 of InnoDB features an auto-extending data file, better support for InnoDB Hot Backup, and better support of foreign key constraints,

LAST_INSERT_ID()

query, table When I run the query: SELECT LAST_INSERT_ID() as id FROM myTable; It returns the last inserted Id, but why does it return that value for every row in the table. for example. if there are 5 total records in the table. and the last inserted Id is 9, if I run the above query I get:

Re: LAST_INSERT_ID()

On Tuesday 23 April 2002 1:10 pm, destr0 wrote: query, table When I run the query: SELECT LAST_INSERT_ID() as id FROM myTable; This query really makes no sense. It is almost the same as: SELECT LAST_INSERT_ID() as id; It returns the last inserted Id, but why does it return that value

Re: Strange behaviour with SQL vars and order by

I see no column named Site.nome showing that it is wrong. ds wrote: Hi, I'm having a strange problem using SQL vars (@variable) and an order by expression. I have a query that returns a record for each day. Each record has a date (data), a column with the daily total value (uv_views) and

RE: table lock - which connection id own's it

Monty BTW, it's a thrill to hear from the CTO. The procedure for locking a table is more complex but will attempt to describe it further for you. Any of the 150 daemons can insert to the hash tables. The data in the row can be used by all 150 daemons. The primary key in hash table is the id

Re: row id

Hi. Please start a new thread next time instead of replying to an existing one with a different topic. Mailers supporting threading will put your mail under the original thread. Thank you. On Tue, Apr 23, 2002 at 03:23:04PM +0800, [EMAIL PROTECTED] wrote: Do anyone know how to select or get

RE: table lock - which connection id own's it

Lopez David E-r9374c writes: Monty BTW, it's a thrill to hear from the CTO. The procedure for locking a table is more complex but will attempt to describe it further for you. Any of the 150 daemons can insert to the hash tables. The data in the row can be used by all 150 daemons. The

Re: Prerelease of MySQL/InnoDB-3.23.50

There is no download for Windows at the moment, isn't it? Andrew - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 1:12 PM Subject: Prerelease of MySQL/InnoDB-3.23.50 Hi! InnoDB is a MySQL table type which adds

RE: alternative to intersect in mySQL

* Thomas Moore I know that intersect does not work yet with mySQL. I am selecting data from two tables. Results of one select would be 1, 2, 3, 4 . Results of other select 1, 2. Want to print 1, 2. Are there any nice workarounds using PHP or SQL? [temporary table] If it is in a

Re: Prerelease of MySQL/InnoDB-3.23.50

Andrew, unfortunately it usually takes 7 days for the Windows binary to appear. Regards, Heikki - Original Message - From: Andrew Chan [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 8:43 PM Subject: Re: Prerelease of

Re: MySQL start

Victoria Reznichenko Samuel, Tuesday, April 23, 2002, 4:04:20 PM, you wrote: SM Can you help me in the following problem? SM OS: Linux Slackware 8.0 SM Source: mysql-3.23.42.tar.gz SM I can't start mysql after installing the source file. I did it step by step SM according guidance

I thought MySQL Supported Relationships

Hello Everyone. I'm still fairly a newbie to MySQL, but I could have sworn I read somewhere that MySQL supported relationships just like Access. I've searched the entire manual, and cannot find anything on the subject. Does MySQL support relationships, and if so does anyone know where I can find

RE: mySQL dump

* On-Site I'm very new to mySQL and have what is probably a simple question. I've created my database using mySQL and it resides on my local PC. I want to upload it to my hosting service's server. They tell me You would dump the content of your mysql database on your local machine and then

RE: I thought MySQL Supported Relationships

Actually, no. The addiction to MySQL has caused many relationship break-ups. There's probably even a database with that information out there somewhere. Probably a MySQL database, too. Meanwhile Access supports relationships because it blows so hard that people can't wait to get away from it and

RE: I thought MySQL Supported Relationships

* Andrew Kuebler I'm still fairly a newbie to MySQL, but I could have sworn I read somewhere that MySQL supported relationships just like Access. I've searched the entire manual, and cannot find anything on the subject. Does MySQL support relationships, and if so does anyone know where I can

Demande d'inscription à mysql-france

Bonjour, Vous avez récemment demandé à vous inscrire au groupe mysql-france. Comme vous êtes déjà membre de ce groupe, votre demande ne sera pas prise en compte. Pour toute question sur l'envoi de messages à ce groupe, veuillez envoyer un e-mail à [EMAIL PROTECTED] Cordialement, L'équipe

Re: I thought MySQL Supported Relationships

On Tue, 2002-04-23 at 14:35, Andrew Kuebler wrote: Hello Everyone. I'm still fairly a newbie to MySQL, but I could have sworn I read somewhere that MySQL supported relationships just like Access. I've searched the entire manual, and cannot find anything on the subject. Does MySQL support

Slow Shutdown with NET STOP MYSQL

I have version 3.23.41-max-debug running on Windows 2000 SP2. I have MySQL installed as a service and can use NET START MYSQL and NET STOP MYSQL to start and stop the server. One unusual item is that it takes about 30 seconds for the NET STOP to finish executing. The NET START is very fast as

Circular replication

Hi, We're doing something weird (what else is new). We're hoping to use MySQL as the base of a distributed database with peer replication. Most of the peering and control mechanisms will be in the core application code, but we're counting on MySQL's ability to replicate for some of the

Re: LAST_INSERT_ID()

At 02:10 PM 4/23/2002, you wrote: query, table When I run the query: SELECT LAST_INSERT_ID() as id FROM myTable; It returns the last inserted Id, but why does it return that value for every row in the table. for example. if there are 5 total records in the table. and the last inserted Id is

insert for datatype of set

I couldn't find this in the documentation. What is the propoer sql to insert into a field with a data type of set? My field has the following set of acceptable values: GA, TN, SC, NC, AL Assume I am inserting multiple values, such GA, TN, SC. If I separate them with commas, mysql will assume

Re: insert for datatype of set

http://www.mysql.com/doc/S/E/SET.html On Tuesday 23 April 2002 1:45 pm, Jim Philips wrote: I couldn't find this in the documentation. What is the propoer sql to insert into a field with a data type of set? My field has the following set of acceptable values: GA, TN, SC, NC, AL Assume I am

Re: insert for datatype of set

Yes. I found that page earlier. I still don't see how it answers my question. What is the proper syntax for an insert statement? On Tuesday 23 April 2002 03:54 pm, Christopher Thompson wrote: http://www.mysql.com/doc/S/E/SET.html On Tuesday 23 April 2002 1:45 pm, Jim Philips wrote: I

Re: Intermittent 1049 error in MySQL 3.23.49

Hello again, I've now been on the list long enough to determine it's not an inactive list ... So, I'm hoping that means that someone (perhaps one of the MySQL team I've seen active on the list today) may be able to address this problem, as it is quite a serious one. Is there a reason that it's

Re: insert for datatype of set

insert into mytable ( id , myset) values ('1', 'GA,SC') , ( '2', 'TN,NC,AL') ; Jim Philips wrote: Yes. I found that page earlier. I still don't see how it answers my question. What is the proper syntax for an insert statement? On Tuesday 23 April 2002 03:54 pm, Christopher Thompson wrote:

SET row dynamic?

Short question: Is there a way to update SET-options without alter table? e.g. if one user is registered in table1 he is allowed(means registered in set-row options) to write his id into table2 ? Thanks, Jan P.S.: For the filter: I want to do a sql query which does something.

Re: insert for datatype of set

When I use this syntax, the first state gets inserted into the field and the others are ignored. Here is my exact SQL: mysql insert into contr - VALUES( - , 0, Hammer Whackers, Bob Hammer, - 3390 Peachtree Rd., , Atlanta, - GA, 30326, , 404-326-0200, - , [EMAIL PROTECTED],

3.23.50 client needs IP addresses

Description: mysql client from 3.23.50 won't connect to older servers running on remote hosts unless you specify the host as an IP address: ERROR 2005: Unknown MySQL Server Host 'xxx' (2) Submitter-Id: submitter ID Originator:Rob Steele Organization: FatKat, Inc. MySQL support: none

(Newbie) Apachie-PHP-MySql

Greetings all. A bit of history, I have a small.no actually...TINY website. :-) I am using PHP and mySql there without any problems. But uploading and testing each PHP page/program was a pain in the . so i installed Apache,MySql and PHP on my WINDOWS 2000 machine for testing before

MySQL datetime GMT time handling

I have a question, or maybe it's a feature request. Or maybe it's a question and a feature request ;) We would very much like to be able to store time on the server in UTC. The TIMESTAMP type seems close, but has baggage due to its desire to update itself as a timestamp on updates. MySQL

Re: (Newbie) Apachie-PHP-MySql

You have to update your seession-path in your php.ini (usually located in %%systemroot%% eg windows) to a valid windows-path like c:\windows\temp Jan - Original Message - From: r [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 11:19 AM Subject: (Newbie)

How to Install as non-root user in Unix system?

I have an account on our Dec Unix system and I can't find any directions on how to make MySQL work without root privileges. Can it be done? pj -- Paul E. Johnson email: [EMAIL PROTECTED] Dept. of Political Sciencehttp://lark.cc.ukans.edu/~pauljohn University

compile problem with 3.23.50

Description: I get the following error: c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr\ - DDATADIR=\/var/lib/mysql\ -DSHAREDIR=\/usr/share/mysql\ -DHAVE_CONFIG_H -I../bdb/build_unix -I../innobase/includ e

RE: alternative to intersect in mySQL

The issue has to do with relating a PRODUCT table and ATTRIBUTE table so that one product is related to multiple attributes. In the shopping cart, I want to show multiple select menus. After a user selects all of them, only the parts related to those attributes will be displayed. Example:

Erwin Vs Mysql ....

Has anyone got Erwin working with mysql. I guess all directly non-supported DBs by Erwin are suppose to work via ODBC but I have not been able to find ODBC driver (either generic or for mysql). thanks Vivek - Before

Re: How to Install as non-root user in Unix system?

I think the general procedure is the same, just a couple things you have to consider. 1. The mysql daemon will have to run under your user name. 2. You might not be able to use port 3306, you'll have to check with the sys admin for this. 3. You'll have to install it into your home directory (

  1   2   >