Re: Math Computations
I agree with the suggestion below strip the character and typecast it if necessary. In JSP I think you can convert it to a number and then typecast it. In PHP, I think the principles might be the same. In addition, it might be a good idea to restrict the columns that require computation to a numeric value rather than a string because you can always add the comma later when totalling it for display. It might also be more efficient for sorting and doing sums, totals etc from your select statements.(i.e. select sum() total()) since computers are inherently better at handling numbers than strings (though I could be mistaken) So if its possible for you to redeclare the table definition then that will be great. Good luck [EMAIL PROTECTED] wrote: > It could be best to parse and remove ',' from both of them first before > calculation... > > R.B.Roa > PhilCom Corporation > Tel. No. 858- > Mobile No. (63) (919-xxx) > > -Original Message- > From: delz [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, April 18, 2002 1:50 PM > To: [EMAIL PROTECTED] > Subject:Re: Math Computations > > Hi All, > > How do I make calculations in php or mysql if the value has a comma > like > 2,000 + 32,000 = 34,000. I have a problem > calculating if one of my values has a comma. It doesn't display the > right > output. I'll appreciate anyone who can > help me with this. > > Thanks. > > Delz. > > - Original Message - > From: "Adam Alkins" <[EMAIL PROTECTED]> > To: "delz" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, April 11, 2002 5:44 PM > Subject: Re: Math Computations > > > Something like > > > > > > > $db = mysql_connect("localhost","database_user","password"); > > mysql_select_db (database_name); > > > > $query = "SELECT * FROM table_name"; > > $result = mysql_query($query); > > > > > > echo "Computers | Department | Price Per PC | Total Amount"; > > > > while ($row = mysql_fetch_row($result)){ > > $subtotal=$row[0]*$row[2]; > > $total+=$subtotal; > > echo "$row[0] | $row[1] | $row[2] | $subtotal"; > > $comptotal+=$row[0];} > > } > > echo "$comptotal $total"; > > > > ?> > > > > Obviously format it into a table would make sense, e.t.c. > > > > Adam > > - Original Message - > > From: "delz" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, April 11, 2002 5:29 AM > > Subject: Math Computations > > > > > > > Hi, > > > > > > I have this table that looks like this > > > > > > Computers | Department | Price per PC | TotalAmount | > > > 15 | Marketing | $500.00| > | > > > 5 | Purchasing | $ 300.00 | > | > > > > > > I want this table to display the total price wherein Computer * > Price > Per > > PC > > > = TotalAmount > > > and want to display the total no. of computer and the OverAll > TotalAmount. > > > > > > I want the output to look like this > > > > > > Computers | Department | Price per PC | TotalAmount | > > > 15 | Marketing | $500.00| $ 7500.00 | > > > 5 | Purchasing | $ 300.00 | $ 900.00 > | > > > - > --- > > > 20 $ > 8400.00 > > > > > > Can anyone help me how to do this in mysql or php. I will surely > > appreciate > > > any help I > > > can get. > > > > > > Thanks. > > > > > > Delz > > > > > > > > > > - > > > 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, e-mail > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > > > - > > 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 un
Re: Encrpt/Decrypt
Just want to add a few more things here that might spark your brain cells. All in all I agree with the suggestions presented. Use an encrypt function in your code, for something simple I've created a very basic encryption function in perl using Crypt::Blowfish modules and then I have control of the key to encrypt and decrypt it. Then you can process your request over SSL (if possible) just run the script over https if supported and then store the encrypted value in the database as a string. I think you can even run SSL on MySQL so that you can secure your connections further especially if you're replication your database etc. The MD5() function in PHP might also do the trick for you. http://www.php.net/manual/en/function.md5.php Good luck JM Gregory Junker wrote: > and it's all-around better to encrypt the password BEFORE you transmit > it over an unsecure connection, or even between processes on a > potentially unsecure machine. This means using, for example, the MD5() > function in PHP... > > > -Original Message- > > From: Matthew Smith [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, April 18, 2002 1:51 AM > > To: mysql > > Subject: Re: Encrpt/Decrypt > > > > > > > > > > Manish Mehta wrote: > > > > > Hi > > > > > > I can Encrypt password in mysql using password() command. > > what is the way > > > to decrypt the password. > > > > > > Manish > > > > > > > Hi Manish / All > > > > > > Somebody correct me if I'm wrong, but I think that what happens is > > what's called one-way encryption. This is how stuff is done in the > > world of Unix (and its clones) and others. > > > > > > Authentication is done by taking the password provided, > > encrypting it, then comparing against the encrypted key in > > the database. > > > > > > Cheers > > > > > > M > > > > -- > > Matthew Smith | _ ASCII Ribbon Campaign > > IT Consultant | ( ) - No HTML/RTF in e-mail > > Kadina, South Australia | X - No Microsoft docs in e-mail > > http://www.kbc.net.au | / \ - No vCards > > Ph: +61 888 212 395 | > > > > > > - > > 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, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > - > 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, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MANY to MANY] relationship with MySQL ???
I guess You could write Your query with JOIN statements to to get all information by one single query, not having to store things in PHP arrays. a simpe one could look like this... /* depending on what criteria is beeing used */ $match = "artist.name = $submitted_artist"; $match = "songs.name = $submitted_song"; /* axs = artists_x_songs */ $SQL = "SELECT artists.name, songs.name FROM artists, songs, axs WHERE "; $SQL .= "artists.id=axs.artist AND songs.id=axs.song AND $match"; I'm sorry but I haven't time to test this in practice but i'm 97% that it works... ofcource You have to modify the query to match Your DB layout =d0Mi= - Original Message - From: "Matthew Smith" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 8:04 AM Subject: Re: [MANY to MANY] relationship with MySQL ??? > Hi Robbie > > Reading what I wrote wasn't very clear to me either ;-) > > > > How does song_x_artist reference the other databases? Is there a way to set > > up a field to always be a reference to another table? > > > I think you may be talking foreign keys here - something yet to come in > MySQL AFAIK. > > > > > > I am not quite sure what you mean... but here is my take anyways. Is this > > going around my elbow? Or is this just how you do relationals in SQL? > > > > This is a standard way of doing many-to-many relationships in SQL; there > may be others. > > > > (For each relationship you may want to have in a system, you must set up a > > table to house that relationship?) > > > For each M2M, basically, yes. > > > > Table::"song_x_artist" > > * > > PrimID (can't duplicate) > > SongID (can duplicate) > > ArtistID (can duplicate) > > > Yep - I don't use the primary key when I do it, but by using one you can > obviously avoid unwanted duplications. > > > > > > (PHP) & MySQL > > * > > $songID = (the id of the song the user selected to sample) > > $artistsOnSong = Select * from "song_x_artist" where "songID" = $songID > > while ($artistArray= mySQL_Fetch_Array ($artistsOnSong)){ > >$currentArtists = Select * from "Artists" where artistID = > > $artistArray[ArtistID] > >while ($artistInfo= mySQL_Fetch_Array ($currentArtists)){ > > file://start to build the html table of the related artists for the song > > here. > >} > > } > > > > Would that work? And if it does... I am not so sure about how to write it > > out, so if you have any suggestions on better syntax, please advise. > > > 'Ang on - I'm not a PHP man so I've got to think my way through the > code... Yep - if I read that correctly, should be OK. Assuming that > we're starting with a song, the steps are: > 1) Grab the song ID (primary key) from the songs table. > 2) Select all the Artist IDs from the song_x_artist (x-reference) table > and push them into an array. (This is why we want sub-selects in MySQL 4!) > 3) Pop each value from the array and use it as the criterion to select > all the details that you want from the artists table - what comes back > is your final results. > > So, yes, what you've done looks right. Only one way to find out ;-) > > Cheers > > > Matthew Smith > > > > - > 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, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table full with InnoDB
Well, it will NOT let me add more ibdata files: Any ideas?? Thanks, Spiros Here is hostname.err (On a 2GB RAM, 2x1000 CPU, ) InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 3 751045500 020418 0:50:33 InnoDB: Started /usr/sbin/mysqld: ready for connections InnoDB: Assertion failure in thread 40971 in file trx0trx.c line 228 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402649088 record_buffer=2093056 sort_buffer=2097144 max_used_connections=1 max_connections=10 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer) *max_connections = 434131 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x807db7f 0x823d60a 0x8179eac 0x80d50b7 0x80cd82d 0x807798d 0x807d88a 0x8082515 0x824f1b8 0x823d383 0x823ab69 0x807d905 0x8084403 0x823baa7 0x826c1ca New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at (nil) is invalid pointer thd->thread_id=2916 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 2916 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 020418 14:01:56 mysqld restarted InnoDB: Warning: operating system error number 2 in a file operation. InnoDB: Cannot continue operation. # Example mysql config file for very large systems. # # This is for large system with memory of 1G-2G where the system runs mainly # MySQL. # # You can copy this file to # /etc/mf.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port= 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= max_connections=10 set-variable= tmp_table_size=400M set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= thread_concurrency=4 # Try number of CPU's*2 #set-variable = myisam_sort_buffer_size=64M set-variable= myisam_sort_buffer_size=4M innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdata 3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdata 7:2000M;ibdata8:2000M;/usr/ibdata/ibdata9:2000M;/usr/ibd ata/ibdata10:2000M #Comment works ok with: #innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdat a3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdat a7:2000M;ibdata8:2000M # Also adding ibdata9:2000M to /var/lib/mysql does not work log-bin server-id = 1 #set-variable= open-files-limit=8192 #ulimit is 1024,hard 8192 set-variable = innodb_buffer_pool_size=750M set-variable = innodb_additional_mem_pool_size=400M # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=384M #set-variable = bdb_max_lock=10 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname [mysqldump] quick set-variable= max_allowed_packet=256M [mysql] no-auto-rehash #safe-updates # Remove the comment character if you are not familiar with SQ
Re: regular backup database in mysql
hi i do this on windows2000 like that first I create directory Archive on local disk and in that dir some subdirs like mon,tue ... for every weekday then you should create ms-dos batch file e.g. "back0.bat" in root of disk c:\ and put commands in it: rem BACKUP mysqldump -h192.168.1.1 -uroot -pxxx --opt databasename >c:\Archive\%1\arch.sql arj m arch arch.sql rem END BACKUP then you call this batch file from scheduled task in control pannel with syntax "c:\back0 Mon" and set scheduled task to run every monday at 9:00 pm which will then create a backup of this database in dir c:\Arhive\Mon\arch.sql first line do mysqldump of database "databasename" into archive on local filesystem c:\Arhive\arch.sql second line (if you have utiliti ARJ) do a move of arch.sql into arj arhive with name arch.arj with this aproach you can setup backup with scheduled tasks for every day in a week or even once a month etc I do backup in this way on several PCs in my firm so I have arhive for every day for past 7 days on at least 3 different locations nice day primoz - Original Message - From: "lorenzo.kh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 8:14 AM Subject: regular backup database in mysql > I am using MySql version 4.0.0-alpha in Windows 2000. > Everytime when I want to backup the database,i do it in MS-DOS. > Using this command: > >mysqldump --opt mydatabasename > mybackup.sql > Now,lets say i never shut down my pc and the MySql is running all the time. > How can i do a regular backup (ie.every evening 9.00 pm) automatically? > > > - > 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, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MANY to MANY] relationship with MySQL ???
Hi Robbie Reading what I wrote wasn't very clear to me either ;-) > How does song_x_artist reference the other databases? Is there a way to set > up a field to always be a reference to another table? I think you may be talking foreign keys here - something yet to come in MySQL AFAIK. > > I am not quite sure what you mean... but here is my take anyways. Is this > going around my elbow? Or is this just how you do relationals in SQL? > This is a standard way of doing many-to-many relationships in SQL; there may be others. > (For each relationship you may want to have in a system, you must set up a > table to house that relationship?) For each M2M, basically, yes. > Table::"song_x_artist" > * > PrimID (can't duplicate) > SongID (can duplicate) > ArtistID (can duplicate) Yep - I don't use the primary key when I do it, but by using one you can obviously avoid unwanted duplications. > > (PHP) & MySQL > * > $songID = (the id of the song the user selected to sample) > $artistsOnSong = Select * from "song_x_artist" where "songID" = $songID > while ($artistArray= mySQL_Fetch_Array ($artistsOnSong)){ >$currentArtists = Select * from "Artists" where artistID = > $artistArray[ArtistID] >while ($artistInfo= mySQL_Fetch_Array ($currentArtists)){ > //start to build the html table of the related artists for the song > here. >} > } > > Would that work? And if it does... I am not so sure about how to write it > out, so if you have any suggestions on better syntax, please advise. 'Ang on - I'm not a PHP man so I've got to think my way through the code... Yep - if I read that correctly, should be OK. Assuming that we're starting with a song, the steps are: 1) Grab the song ID (primary key) from the songs table. 2) Select all the Artist IDs from the song_x_artist (x-reference) table and push them into an array. (This is why we want sub-selects in MySQL 4!) 3) Pop each value from the array and use it as the criterion to select all the details that you want from the artists table - what comes back is your final results. So, yes, what you've done looks right. Only one way to find out ;-) Cheers Matthew Smith - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Encrpt/Decrypt
and it's all-around better to encrypt the password BEFORE you transmit it over an unsecure connection, or even between processes on a potentially unsecure machine. This means using, for example, the MD5() function in PHP... > -Original Message- > From: Matthew Smith [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 18, 2002 1:51 AM > To: mysql > Subject: Re: Encrpt/Decrypt > > > > > Manish Mehta wrote: > > > Hi > > > > I can Encrypt password in mysql using password() command. > what is the way > > to decrypt the password. > > > > Manish > > > > Hi Manish / All > > > Somebody correct me if I'm wrong, but I think that what happens is > what's called one-way encryption. This is how stuff is done in the > world of Unix (and its clones) and others. > > > Authentication is done by taking the password provided, > encrypting it, then comparing against the encrypted key in > the database. > > > Cheers > > > M > > -- > Matthew Smith | _ ASCII Ribbon Campaign > IT Consultant | ( ) - No HTML/RTF in e-mail > Kadina, South Australia | X - No Microsoft docs in e-mail > http://www.kbc.net.au | / \ - No vCards > Ph: +61 888 212 395 | > > > - > 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, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Math Computations
It could be best to parse and remove ',' from both of them first before calculation... R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: delz [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 1:50 PM To: [EMAIL PROTECTED] Subject:Re: Math Computations Hi All, How do I make calculations in php or mysql if the value has a comma like 2,000 + 32,000 = 34,000. I have a problem calculating if one of my values has a comma. It doesn't display the right output. I'll appreciate anyone who can help me with this. Thanks. Delz. - Original Message - From: "Adam Alkins" <[EMAIL PROTECTED]> To: "delz" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 5:44 PM Subject: Re: Math Computations > Something like > > > $db = mysql_connect("localhost","database_user","password"); > mysql_select_db (database_name); > > $query = "SELECT * FROM table_name"; > $result = mysql_query($query); > > > echo "Computers | Department | Price Per PC | Total Amount"; > > while ($row = mysql_fetch_row($result)){ > $subtotal=$row[0]*$row[2]; > $total+=$subtotal; > echo "$row[0] | $row[1] | $row[2] | $subtotal"; > $comptotal+=$row[0];} > } > echo "$comptotal $total"; > > ?> > > Obviously format it into a table would make sense, e.t.c. > > Adam > - Original Message - > From: "delz" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, April 11, 2002 5:29 AM > Subject: Math Computations > > > > Hi, > > > > I have this table that looks like this > > > > Computers | Department | Price per PC | TotalAmount | > > 15 | Marketing | $500.00| | > > 5 | Purchasing | $ 300.00 | | > > > > I want this table to display the total price wherein Computer * Price Per > PC > > = TotalAmount > > and want to display the total no. of computer and the OverAll TotalAmount. > > > > I want the output to look like this > > > > Computers | Department | Price per PC | TotalAmount | > > 15 | Marketing | $500.00| $ 7500.00 | > > 5 | Purchasing | $ 300.00 | $ 900.00 | > > - --- > > 20 $ 8400.00 > > > > Can anyone help me how to do this in mysql or php. I will surely > appreciate > > any help I > > can get. > > > > Thanks. > > > > Delz > > > > > > - > > 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, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > - > 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, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Encrpt/Decrypt
Manish Mehta wrote: > Hi > > I can Encrypt password in mysql using password() command. what is the way > to decrypt the password. > > Manish > Hi Manish / All Somebody correct me if I'm wrong, but I think that what happens is what's called one-way encryption. This is how stuff is done in the world of Unix (and its clones) and others. Authentication is done by taking the password provided, encrypting it, then comparing against the encrypted key in the database. Cheers M -- Matthew Smith | _ ASCII Ribbon Campaign IT Consultant | ( ) - No HTML/RTF in e-mail Kadina, South Australia | X - No Microsoft docs in e-mail http://www.kbc.net.au | / \ - No vCards Ph: +61 888 212 395 | - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C API
Hi!! I want to know if there is any datatype in MySQL C API which is similar to a structure in C??? Thanks, Ritu Singla - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Math Computations
Hi All, How do I make calculations in php or mysql if the value has a comma like 2,000 + 32,000 = 34,000. I have a problem calculating if one of my values has a comma. It doesn't display the right output. I'll appreciate anyone who can help me with this. Thanks. Delz. - Original Message - From: "Adam Alkins" <[EMAIL PROTECTED]> To: "delz" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 5:44 PM Subject: Re: Math Computations > Something like > > > $db = mysql_connect("localhost","database_user","password"); > mysql_select_db (database_name); > > $query = "SELECT * FROM table_name"; > $result = mysql_query($query); > > > echo "Computers | Department | Price Per PC | Total Amount"; > > while ($row = mysql_fetch_row($result)){ > $subtotal=$row[0]*$row[2]; > $total+=$subtotal; > echo "$row[0] | $row[1] | $row[2] | $subtotal"; > $comptotal+=$row[0];} > } > echo "$comptotal $total"; > > ?> > > Obviously format it into a table would make sense, e.t.c. > > Adam > - Original Message - > From: "delz" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, April 11, 2002 5:29 AM > Subject: Math Computations > > > > Hi, > > > > I have this table that looks like this > > > > Computers | Department | Price per PC | TotalAmount | > > 15 | Marketing | $500.00| | > > 5 | Purchasing | $ 300.00 | | > > > > I want this table to display the total price wherein Computer * Price Per > PC > > = TotalAmount > > and want to display the total no. of computer and the OverAll TotalAmount. > > > > I want the output to look like this > > > > Computers | Department | Price per PC | TotalAmount | > > 15 | Marketing | $500.00| $ 7500.00 | > > 5 | Purchasing | $ 300.00 | $ 900.00 | > > - --- > > 20 $ 8400.00 > > > > Can anyone help me how to do this in mysql or php. I will surely > appreciate > > any help I > > can get. > > > > Thanks. > > > > Delz > > > > > > - > > 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, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > - > 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, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Encrpt/Decrypt
On Thu, 18 Apr 2002, Manish Mehta wrote: > Hi > > I can Encrypt password in mysql using password() command. what is the way > to decrypt the password. Like most other password functions you'll find in the unix world mysql's password function doesn't 'encrypt' a string, it generates a one way hash. Meaning that there's nothing unique to decrypt; there may be multiple strings which produce the same hash but the likelyhood of any two strings (even very similar strings) generating the same hash is microscopic. But in the context you're raising the answer is "there isn't one". -- TWZ +-+ | Copyright 2001 by Terrence W. Zellers. All rights explicitly reserved. | | email: [EMAIL PROTECTED] www.voicenet.com/~zellert/pub.key | |-| | A means of adding pith or humor to email: patent pending| +-+ - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Encrpt/Decrypt
Hi I can Encrypt password in mysql using password() command. what is the way to decrypt the password. Manish - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MANY to MANY] relationship with MySQL ???
> ...So the table song_x_artist contains references to all artists in a > song and vice-versa. (Field names correspond between tables.) How does song_x_artist reference the other databases? Is there a way to set up a field to always be a reference to another table? I am not quite sure what you mean... but here is my take anyways. Is this going around my elbow? Or is this just how you do relationals in SQL? (For each relationship you may want to have in a system, you must set up a table to house that relationship?) Table::"song_x_artist" * PrimID (can't duplicate) SongID (can duplicate) ArtistID (can duplicate) (PHP) & MySQL * $songID = (the id of the song the user selected to sample) $artistsOnSong = Select * from "song_x_artist" where "songID" = $songID while ($artistArray= mySQL_Fetch_Array ($artistsOnSong)){ $currentArtists = Select * from "Artists" where artistID = $artistArray[ArtistID] while ($artistInfo= mySQL_Fetch_Array ($currentArtists)){ //start to build the html table of the related artists for the song here. } } Would that work? And if it does... I am not so sure about how to write it out, so if you have any suggestions on better syntax, please advise. Thanks Robbie - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MANY to MANY] relationship with MySQL ???
This is the classic case for a junction table (aka bridge table, associative table). It sits between Artists and Songs; let's call it PlaysOn. Artists: ArtistID: autoincrement ArtistName: varchar DOB: date etc. Songs: SongID: autoincrement SongName: varchar Duration: in seconds, say etc. PlaysOn: SongID: FK into Songs ArtistID: FK into Artists Given this structure you can: a) add any number of players to a song; b) select any song and all its players; c) select any player and all the songs she played on; d) select a song title and see all the versions you have; e) add another layer atop this called Recordings without disturbing anything beneath (now the same song by the same artist(s) can appear on multiple recordings). You could add a ComposerID (FK into Artists) to the Songs table, but that corners you because what do you do about Lennon & McCartney, Rogers & Hammerstein and so on? To go to that level of detail you need another bridge table, SongComposers: SongComposers: SongComposerID: autoincrement SongID: FK into Songs ArtistID: FK into Artists With this table, you could add to the list of selects with a union that grabs any song Artist 123 either played on or helped compose. hth, Arthur - Original Message - From: "Robbie Newton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 17, 2002 10:25 PM Subject: [MANY to MANY] relationship with MySQL ??? > Hello all, > > [~~I guess I could do something like MySQL>select FROM "Songs" where > "artists" contains $currentArtist~~] > > I have a sampling section on a site that I am working on and am trying to > find out how to display a table of the artists featured in that song. The > sample section works as follows: > > Go to the samples page and choose an album to sample. > Returns the list of song names that result from the album you chose > click on one of the song names to open a new window with the shockwave file > that streams the song. > > The client has asked me to add the (one or many) artists featured in that > song in the window that loads up. I am not sure how to set this up. It would > be a many to many relationship I think... > > (one given artist could be featured on many different songs) > [many] > to > (one given song could have many featured artists) [many] > > My first thout of how to set this up is to just enter comma delimited data > into a field in the song database called, "artists". But when I query it I > don't know how I could make that work. I guess I could do something like > MySQL>select FROM "Songs" where "artists" contains $currentArtist< Would > that work? Is there a such thing as "contains". (kinda new to SQL). > > Thanks for your help, > > Robbie > > - > 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, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MANY to MANY] relationship with MySQL ???
Hi Robbie, all I have lots of things that need many to many - the way that I do it is this: create table artists ( a_ser int unsigned not null primary key auto_increment, artist_name varchar(64), other stuff... ); create table songs ( s_ser int unsigned not null primary key auto_increment, song_title varchar(64), more other stuff... ); create table song_x_artist ( a_ser int unsigned not null, s_ser int unsigned not null ); ...So the table song_x_artist contains references to all artists in a song and vice-versa. (Field names correspond between tables.) Hope this helps - let me know if not clear. It works for me... Cheers Matthew Smith Robbie Newton wrote: > Hello all, > > [~~I guess I could do something like MySQL>select FROM "Songs" where > "artists" contains $currentArtist~~] > > I have a sampling section on a site that I am working on and am trying to > find out how to display a table of the artists featured in that song. The > sample section works as follows: > > Go to the samples page and choose an album to sample. > Returns the list of song names that result from the album you chose > click on one of the song names to open a new window with the shockwave file > that streams the song. > > The client has asked me to add the (one or many) artists featured in that > song in the window that loads up. I am not sure how to set this up. It would > be a many to many relationship I think... > > (one given artist could be featured on many different songs) > [many] > to > (one given song could have many featured artists) [many] > > My first thout of how to set this up is to just enter comma delimited data > into a field in the song database called, "artists". But when I query it I > don't know how I could make that work. I guess I could do something like > MySQL>select FROM "Songs" where "artists" contains $currentArtist< Would > that work? Is there a such thing as "contains". (kinda new to SQL). > > Thanks for your help, > > Robbie > > - > 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, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication Oddity
Hi I am running MySQL 3.23.49a, installed from the "official" RPMs. The master is on a (Linux) machine with a permanent Internet connection and an routeable IP address. The slave is at another location with a *nearly* permanent Internet connection, behind a masquerading firewall. Due to restrictions on ISP firewalls, I have set the MySQL port on both machines to be a non-standard 119 - this is normally the NNTP port, but I have NNTP commented out in inetd.conf to free the port up. What I am finding puzzling is that replication is only working some of the time. There are no errors occuring in the error logs at either end. Master and slave stati show the same position. If I make a change on the master, the slave position always changes to match. *However*, the data on the slave does not necessarily change! All the transactions are updates and they have been tested in char and text fields on two different tables. Sufficient to say, this all worked fine when I tried it out in the lab (two machines on same LAN). Has anyone seen anything like this before, or can they give me any pointers as to what might be happening? Cheers M -- Matthew Smith | _ ASCII Ribbon Campaign IT Consultant | ( ) - No HTML/RTF in e-mail Kadina, South Australia | X - No Microsoft docs in e-mail http://www.kbc.net.au | / \ - No vCards Ph: +61 888 212 395 | - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[MANY to MANY] relationship with MySQL ???
Hello all, [~~I guess I could do something like MySQL>select FROM "Songs" where "artists" contains $currentArtist~~] I have a sampling section on a site that I am working on and am trying to find out how to display a table of the artists featured in that song. The sample section works as follows: Go to the samples page and choose an album to sample. Returns the list of song names that result from the album you chose click on one of the song names to open a new window with the shockwave file that streams the song. The client has asked me to add the (one or many) artists featured in that song in the window that loads up. I am not sure how to set this up. It would be a many to many relationship I think... (one given artist could be featured on many different songs) [many] to (one given song could have many featured artists) [many] My first thout of how to set this up is to just enter comma delimited data into a field in the song database called, "artists". But when I query it I don't know how I could make that work. I guess I could do something like MySQL>select FROM "Songs" where "artists" contains $currentArtist< Would that work? Is there a such thing as "contains". (kinda new to SQL). Thanks for your help, Robbie - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: conn.setAutoCommit(false) can't work
At 21:18 -0400 4/17/02, bin cai wrote: >Hi, >currently i got a problem which i am afraid to ask >your help. > >I am using javaservlet and mysql 3.23.49 with innoDB >table type . the code conn.setAutoCommit(false) >doesn't work giving me error message("can't disable >auto_commit"); >I am stuck here. anyone can give me some hint i will >really appreciated >bin Check to make sure your table type is *really* InnoDB. MySQL doesn't necessarily have the transactional table handlers enabled (for example, if it's not a MySQL-Max binary distribution, or if you compiled it from source but didn't specify --with-innodb). In such cases, you can specify TYPE=InnoDB in the CREATE TABLE statement, but MySQL will silently create the table as MyISAM. Use SHOW CREATE TABLE tbl_name to see what its type is. - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
conn.setAutoCommit(false) can't work
Hi, currently i got a problem which i am afraid to ask your help. I am using javaservlet and mysql 3.23.49 with innoDB table type . the code conn.setAutoCommit(false) doesn't work giving me error message("can't disable auto_commit"); I am stuck here. anyone can give me some hint i will really appreciated bin __ Find, Connect Date! http://personals.yahoo.ca - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: some good tutorial
Yeaheverything is open in MySQL environment ...u can read more info in the documentation side of MySQL website... R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: Ashish Joy [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 3:01 AM To: [EMAIL PROTECTED] Subject:some good tutorial hi everybody, i have just joined the list and wanted to know something about mysql. is there some really good tutorial you think might be good for a starter in mysql. i am a master's student and have some knowledge of databases like ms access, oracle. hope to get some good stuff. regards ashish See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201 /splash.asp - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
myodbc ihtml unknow database
Hello all, I'm running mysql 3.23.44-1, myodbc 2.50.39 compiled with --with-unixODBC", and unixodbc 2.0.7-3, and iHTML. mysql and unixodbc were installed via rpm. All running on the same RedHat 7.2 box. I have set up the necessary system dsn's in /etc/odbc.ini and made sure that all driver files are where they are supposed to be. I can successfully connect to the dbase using isql and the system dsn name from the command line and perform sql queries from isql. And to be sure, I tested using user dsn's as well, they work fine. iHTML on the other hand keeps getting "[unixODBC][TCX][MyODBC] unknown database "dbase-name". I have checked the datasource that the ihtml system is using and the dbase name and user name are correct. I have also inserted user dsn files (.odbc.ini) in places where I thought they might be seen... in the /usr/ihtml directory and under the admin directory of the ihtml system. Nothing, however, seems to work. If anyone can help me figure this out I would greatly appreciate it. If you need more info or example dsn's let me know. Thanks all, Bradley Brown - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Export
You can use C:\MySQL\Bin\MySQLDump -A > backup_file.sql R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: Manish Mehta [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 6:09 PM To: [EMAIL PROTECTED] Subject:Re: Export It can help to take backup on the basis of table . But I wants to take backup of complete database and store them in some particular file. Manish - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, April 17, 2002 3:23 PM Subject: RE: Export > Use MySQLDumpit can help make backups > > > > R.B.Roa > PhilCom Corporation > Tel. No. 858- > Mobile No. (63) (919-xxx) > > > > -Original Message- > From: Manish Mehta [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, April 17, 2002 5:45 PM > To: mysql > Subject: Export > > Hi, > > I am working on Mysql . I wants to take backup (export) of my > database from > dos prompt . Is their any way. > > Please Tell. > > Thx in advance > > Manish Mehta > > > > > > - > 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, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB or BDB & ON DELETE RESTRICT
If I create a table like this: CREATE TABLE depts ( ID Int AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30) ) TYPE=InnoDB; I add three Records to this table. THen I create this other table: CREATE TABLE employees( ID INT AUTO_INCREMENT PRIMARY KEY, name varchar(20), dept_id INT, FOREIGN KEY (dept_id) REFERENCES depts(ID) ON DELETE RESTRICT ) TYPE=InnoDB; Then I add 2 records to this table, one with value 1 on dept_id field and the other with value 2. I want: If I attempt to delete Record with ID 1 on table depts, that MySQL don't allows me to do so, or that it updates the records at table employees to be deleted or updated to value 2 on the field dept_id. i have InnoDB and BDB working on the System, but I don't know how to do this, every time I delete from table depts, nothing happens at the records at table employees, no warnings, no nothing. Any Idea ? I'm Using MySQL Max 4.0.1 on RedHat Linux Regards Yurais - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: print on top
Hi Jule, You need to sort your records with "ORDER BY" clause . I don't know what your table looks like and obviously don't know if you have suitable columd for it.. Say you have a newsid field defined with int datatype with auto_increment property, then you can issue your statement as "SELECT .. FROM table ORDER BY newsid DESC" to make the last inserted row at the very top. Likewise, if you have a inserted date/time column to keep track of the times that news are inserted , it may be used for the same purpose as well. Gurhan -Original Message- From: Jule Slootbeek [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 6:39 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: print on top Hey guys and gals, I'm writing this script for my new webpage, and i'm using MySQL to read and add news articles to a page, but everytime i add a new article it puts it under the older one, how can i get it on top? thanks Jule $Link = mysql_connect ($Host, $User, $Password); $Query = "SELECT * from $TableName"; $Result = mysql_db_query ($DBName, $Query, $Link); while ($Array = mysql_fetch_array ($Result)) { print (""); print ("\n"); print ("$Array[header]\n"); print ("\n"); print ("\n"); print ("$Array[article]\n"); print ("\n"); print ("\n"); print ("Posted by: $Array[name] on $Array[postdate]\n"); print ("\n"); print (""); -- Jule Slootbeek [EMAIL PROTECTED] http://blindtheory.cjb.net - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: print on top
In the last episode (Apr 17), Mike said: > use ORDER BY ASC or DESC > > $Query = "SELECT * from $TableName ORDER BY DESC"; "ORDER BY postdate DESC", you mean? :) -- Dan Nelson [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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: TZ setting
Can the TZ be set in my.cnf (my.ini) when the MySQL server starts up? I have read the manual on this, and tried various combinations, but haven't hit the right syntax. Gerald Jensen - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 17, 2002 8:14 AM Subject: Re: TZ setting DL, Wednesday, April 17, 2002, 1:37:15 PM, you wrote: DN> Manual References: A.4.6 Time Zone Problems, F Environment Variables, DN> and 4.1.2 my.cnf Option Files, but no examples or real explanation of DN> use. DN> Has anyone made use of MySQL's TZ setting? DN> Can the TZ setting be used to run a db in a different time zone to the DN> underlying OpSys? Run mysqld with --timezone=# option ... Look at: # mysqld_safe --timezone=EET & mysql> select now(); +-+ | now() | +-+ | 2002-04-17 12:59:06 | +-+ 1 row in set (0.01 sec) # mysqld_safe --timezone=GMT & mysql> select now(); +-+ | now() | +-+ | 2002-04-17 10:01:38 | +-+ 1 row in set (0.00 sec) DN> (Windows and/or Linux) DN> Please advise, DN> =dn -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: print on top
Sorry, I forget the column name for the ORDER BY > $Query = "SELECT * from $TableName ORDER BY column_name DESC"; Mike - Original Message - From: "Mike" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Jule Slootbeek" <[EMAIL PROTECTED]> Sent: Wednesday, April 17, 2002 6:45 PM Subject: Re: print on top > use ORDER BY ASC or DESC > > $Query = "SELECT * from $TableName ORDER BY DESC"; > > Mike > - Original Message - > From: "Jule Slootbeek" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, April 17, 2002 6:38 PM > Subject: print on top > > > > Hey guys and gals, > > I'm writing this script for my new webpage, and i'm using MySQL to read > and > > add news articles to a page, but everytime i add a new article it puts it > > under the older one, how can i get it on top? > > > > thanks > > > > Jule > > > > $Link = mysql_connect ($Host, $User, $Password); > > $Query = "SELECT * from $TableName"; > > $Result = mysql_db_query ($DBName, $Query, $Link); > > while ($Array = mysql_fetch_array ($Result)) { > > print (""); > > print ("\n"); > > print ("$Array[header]\n"); > > print ("\n"); > > print ("\n"); > > print ("$Array[article]\n"); > > print ("\n"); > > print ("\n"); > > print ("Posted by: $Array[name] > on > > $Array[postdate]\n"); > > print ("\n"); > > print (""); > > -- > > Jule Slootbeek > > [EMAIL PROTECTED] > > http://blindtheory.cjb.net > > > > - > > 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, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: One field or numerous datatype-specific tables?
Howdy - Am I missing something? Why would you have to create all of your columns as BIGINT? Whether the "has pool" column is a TINYINT, BIGINT, or whatever, the SELECT statement would be the same, wouldn't it? Won't "SELECT FROM HOMES WHERE HasPool = 1;" return houses with pools regardless of the underlying column type for HasPool? Even if you absolutely have to create the HasPool column as a BIGINT, you waste 7 bytes. Unless you are talking about a database of all houses in North America, I would really rethink worrying about the wasted space, anyhow. Especially versus the complexity of a multiple table solution. Ken Hylton Programmer Analyst IV LEC Systems & Programming Billing Concepts, Inc. 7411 John Smith Drive San Antonio, Texas 78229-4898 (210) 949-7261 -Original Message- From: Rob Emerick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 5:15 PM To: [EMAIL PROTECTED] Subject: One field or numerous datatype-specific tables? I am having a problem determining the best SQL DB schema to use. I have a table which stores attributes on homes, attributes such as "square footage", "price", or "includes pool". Now the problem I am having is how to store the actual value of the attributes. An attribute like "square footage" or "price" can simply be stored as a BIGINT. However, an attribute like "includes pool" is a boolean and I don't want to make a bloated table by storing a 1 or 0 in a BIGINT field. Plan 1 CREATE TABLE homes (id BIGINT UNSIGNED not null , fkey_attrib BIGINT UNSIGNED not null , value BIGINT UNSIGNED not null , PRIMARY KEY (id), INDEX (id), UNIQUE (id)) Let's say I wanted to show all properties that had a price of less than $200,000. Let's say that the price attribute is attribute number "32". I would execute the following: "SELECT id FROM homes WHERE (fkey_attribid=32 && value<20)" Now let's say I wanted to show all properties that had a pool and the "includes pool" attribute was attribute number 12. "SELECT id FROM homes WHERE(fkey_attribid=12 && value=1)" The problem I am having is in defining the field "value". Since it is going to store numbers that will be larger than the ranger for UNSIGNED INT, I have to use a BIGINT datatype. It just seems like a waste to me, however, to have a BIGINT datatype used for boolean attributes (such as "includes pool"). Plan 2 The alternative I came up with is to make the field "value" be relational. I would create several other tables such as: CREATE TABLE homes (id BIGINT UNSIGNED not null PRIMARY KEY (id), INDEX (id), UNIQUE (id)) CREATE TABLE homes_bigint(id BIGINT UNSIGNED not null , fkey_attrib BIGINT UNSIGNED not null , value BIGINT UNSIGNED not null , fkey_homes BIGINT UNSIGNED, PRIMARY KEY (id), INDEX (id), UNIQUE (id)) CREATE TABLE homes_boolean(id BIGINT UNSIGNED not null , fkey_attrib BIGINT UNSIGNED not null , value TINYINT UNSIGNED not null , fkey_homes BIGINT UNSIGNED, PRIMARY KEY (id), INDEX (id), UNIQUE (id)) Now it would fall on the responsibility of my script (which I am fine with) to determine which attribute pairs up with which table. Let's say I wanted to show all properties that had a price of less than $200,000. Let's say that the price attribute is attribute number "32". I would execute the following: "SELECT id FROM homes AS h LEFT JOIN homes_bigint AS hb ON homes USING hb.fkey_homes=h.id WHERE (hb.fkey_attribid=32 && hb.value<20)" Now let's say I wanted to show all properties that had a pool and the "includes pool" attribute was attribute number 12. "SELECT id FROM homes AS h LEFT JOIN homes_boolean AS hb ON homes USING hb.fkey_homes=h.id WHERE (hb.fkey_attribid=32 && hb.value=1)" So the question I am debating is if I should put everything in just one table (in which case boolean values would be stored in the same field as BIGINT values) or if I should have separate tables that are streamlined to particular datatypes. Would having everything in one table be faster? Or could I simply optimize the numerous datatype-specific tables in plan 2 and be just as fast? - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: print on top
use ORDER BY ASC or DESC $Query = "SELECT * from $TableName ORDER BY DESC"; Mike - Original Message - From: "Jule Slootbeek" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, April 17, 2002 6:38 PM Subject: print on top > Hey guys and gals, > I'm writing this script for my new webpage, and i'm using MySQL to read and > add news articles to a page, but everytime i add a new article it puts it > under the older one, how can i get it on top? > > thanks > > Jule > > $Link = mysql_connect ($Host, $User, $Password); > $Query = "SELECT * from $TableName"; > $Result = mysql_db_query ($DBName, $Query, $Link); > while ($Array = mysql_fetch_array ($Result)) { > print (""); > print ("\n"); > print ("$Array[header]\n"); > print ("\n"); > print ("\n"); > print ("$Array[article]\n"); > print ("\n"); > print ("\n"); > print ("Posted by: $Array[name] on > $Array[postdate]\n"); > print ("\n"); > print (""); > -- > Jule Slootbeek > [EMAIL PROTECTED] > http://blindtheory.cjb.net > > - > 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, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
print on top
Hey guys and gals, I'm writing this script for my new webpage, and i'm using MySQL to read and add news articles to a page, but everytime i add a new article it puts it under the older one, how can i get it on top? thanks Jule $Link = mysql_connect ($Host, $User, $Password); $Query = "SELECT * from $TableName"; $Result = mysql_db_query ($DBName, $Query, $Link); while ($Array = mysql_fetch_array ($Result)) { print (""); print ("\n"); print ("$Array[header]\n"); print ("\n"); print ("\n"); print ("$Array[article]\n"); print ("\n"); print ("\n"); print ("Posted by: $Array[name] on $Array[postdate]\n"); print ("\n"); print (""); -- Jule Slootbeek [EMAIL PROTECTED] http://blindtheory.cjb.net - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql unresponsive ....
Hi all, Last friday we found that mysql was unresponsive (all the SQL activities were on hold) but the daemon was still running. We shutdown the daemon and restarted and everything was OK. My questions: 1) What could cause this behavior ? 2) Is there any way to monitor such a behavior ? any commands, scripts that could test for inactivity etc. Needless to say that I am a newbie on mysql front. Vivek Chaudhary Database Administrator "IT" STMicroelectronics, Phoenix. Phone:(602)485-2271 Fax: (602)485-6402 Cell:(602)363-1492 Email: [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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
One field or numerous datatype-specific tables?
I am having a problem determining the best SQL DB schema to use. I have a table which stores attributes on homes, attributes such as "square footage", "price", or "includes pool". Now the problem I am having is how to store the actual value of the attributes. An attribute like "square footage" or "price" can simply be stored as a BIGINT. However, an attribute like "includes pool" is a boolean and I don't want to make a bloated table by storing a 1 or 0 in a BIGINT field. Plan 1 CREATE TABLE homes (id BIGINT UNSIGNED not null , fkey_attrib BIGINT UNSIGNED not null , value BIGINT UNSIGNED not null , PRIMARY KEY (id), INDEX (id), UNIQUE (id)) Let's say I wanted to show all properties that had a price of less than $200,000. Let's say that the price attribute is attribute number "32". I would execute the following: "SELECT id FROM homes WHERE (fkey_attribid=32 && value<20)" Now let's say I wanted to show all properties that had a pool and the "includes pool" attribute was attribute number 12. "SELECT id FROM homes WHERE(fkey_attribid=12 && value=1)" The problem I am having is in defining the field "value". Since it is going to store numbers that will be larger than the ranger for UNSIGNED INT, I have to use a BIGINT datatype. It just seems like a waste to me, however, to have a BIGINT datatype used for boolean attributes (such as "includes pool"). Plan 2 The alternative I came up with is to make the field "value" be relational. I would create several other tables such as: CREATE TABLE homes (id BIGINT UNSIGNED not null PRIMARY KEY (id), INDEX (id), UNIQUE (id)) CREATE TABLE homes_bigint(id BIGINT UNSIGNED not null , fkey_attrib BIGINT UNSIGNED not null , value BIGINT UNSIGNED not null , fkey_homes BIGINT UNSIGNED, PRIMARY KEY (id), INDEX (id), UNIQUE (id)) CREATE TABLE homes_boolean(id BIGINT UNSIGNED not null , fkey_attrib BIGINT UNSIGNED not null , value TINYINT UNSIGNED not null , fkey_homes BIGINT UNSIGNED, PRIMARY KEY (id), INDEX (id), UNIQUE (id)) Now it would fall on the responsibility of my script (which I am fine with) to determine which attribute pairs up with which table. Let's say I wanted to show all properties that had a price of less than $200,000. Let's say that the price attribute is attribute number "32". I would execute the following: "SELECT id FROM homes AS h LEFT JOIN homes_bigint AS hb ON homes USING hb.fkey_homes=h.id WHERE (hb.fkey_attribid=32 && hb.value<20)" Now let's say I wanted to show all properties that had a pool and the "includes pool" attribute was attribute number 12. "SELECT id FROM homes AS h LEFT JOIN homes_boolean AS hb ON homes USING hb.fkey_homes=h.id WHERE (hb.fkey_attribid=32 && hb.value=1)" So the question I am debating is if I should put everything in just one table (in which case boolean values would be stored in the same field as BIGINT values) or if I should have separate tables that are streamlined to particular datatypes. Would having everything in one table be faster? Or could I simply optimize the numerous datatype-specific tables in plan 2 and be just as fast? - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: What is Overhead?
sql,query Regardless of what you might call it, Overhead is what phpMyAdmin calls it. Matthew Walker Senior Software Engineer ePliant Marketing =20 -Original Message- From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]]=20 Sent: Wednesday, April 17, 2002 3:16 PM To: Matthew Walker; '[EMAIL PROTECTED] '; '[EMAIL PROTECTED] ' Subject: RE: What is Overhead? I would rather called that "fragmentation", and refere to overhead as job done which do not contribute to the task. -Original Message- From: Matthew Walker To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: 17-4-02 22:47 Subject: RE: What is Overhead? Overhead is 'wasted' space in the table. It happens if a table has variable length rows, and you delete one in the middle of the table. To fix it, OPTIMIZE the table occasionally. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.345 / Virus Database: 193 - Release Date: 4/9/2002 - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Number of records updated
Hi All, First, sorry my poor english I'm testing the pre-version of innodb (with on delete cascade) and when I delete some records, the number returned is only the records matched in the parent table. It erases the records in the child tables, but don't count them. This is because I'm using the 3.23.49 (with new code from innodb.com) ? or it's a bug? Mysql, SQL --- Luciano Barcaro - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: What is Overhead?
Overhead is 'wasted' space in the table. It happens if a table has variable length rows, and you delete one in the middle of the table. To fix it, OPTIMIZE the table occasionally. Matthew Walker Senior Software Engineer ePliant Marketing -Original Message- From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 9:22 AM To: [EMAIL PROTECTED] Subject: What is Overhead? Hi All, I am using phpMyAdmin to analyze my mysql tables in Linux. On some of the tables, I see "Overhead" marked in red. For example: Space usage : Type Usage Data 732 Bytes Index 1,024 Bytes Overhead 732 Bytes Effective 1,024 Bytes Total 1,756 Bytes Can anyone tell me what this means, and how I can fix it please? Thanks so much, Soheil - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.345 / Virus Database: 193 - Release Date: 4/9/2002 - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query problem with insert into....select
hi, i have 2 tables: currencyrates +-+++ | code char(3)|| currency char(3) | | name varchar(10)|| rate double| | bcurrency char(1) || ryear varchar(4) | | || rmonth varchar(10) | +-+++ I'm have a form, from which i pick 2 value "2000" and "february". I'm trying to insert fields form currency to rates, matching particular conditions in order to avoid data duplication. The rate table basically has the exchange rate for a particular currency in a particular year and a particular month. The trio currency,ryear,rmonth SHOULD be unique. My query is the following: insert into rates (currency,ryear,rmonth) select a.code, "2000", "february" from currency a, rates b where a.bcurrency="N" and a.code<>b.currency and b.ryear="2000" and b.rmonth="february" _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SV: a query from php doen't work
> Fra: savaidis [mailto:[EMAIL PROTECTED]] > Sendt: 17. april 2002 22:14 > Emne: a query from php doen't work > I get a "Query failed" error on this: > What could hapent? Try to alter this line: $result=mysql_query($buffer); to look like this: $result=mysql_query($buffer) or die($buffer."".mysql_error()); Then you will a) print the failed query, and b) print MySQL's own error-response. Then you cal probably figure out, what is wrong. - Carsten - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
a query from php doen't work
I get a "Query failed" error on this: What could hapent? I login as with MySQL-Front and pass the same query with no problem. Query's length is about 500 bytes. I need it to send my data to a remote MySQL server. PS I send this here becouse is more related to MySQL than to php. Thanks a lot Makis 0) { $result=mysql_query($buffer); if ($result==0) echo(" Query failed, line $i , length $l "); } } fclose ($fd); ?> - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: LOOKUP
Good point. Also, how would you capture the current enum list to add or substract from? Might have to hold that in an array or constant of some sort depending upon the language used. Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:32 PM To: Andrew Hazen; [EMAIL PROTECTED] Subject: RE: LOOKUP Hi, Your solution would work if the set of the values you'll get from one table is primary key.. If it is not a primary key, i.e. allowing duplicate values, then everytime there is an insertion to the table you will have to check to see if it is a new-added value or not. Gurhan -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:58 PM To: 'Gurhan Ozen'; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP That's what I thought too. A workaround occurs to me though, but I'm not sure if it would muck things up. At any point where you make a change to the table you want to reference as the "lookup" (as in Access), you could include another sql command to alter the table with the enum column to change the list of accepted values for the enum. Would this work Gurhan, or would the constant ALTER table commands mess things up? Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:46 PM To: Andrew Hazen; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP Ugh, I am being too goofy today.. Simon, the answer to the question is no, you can't do that in MySQL. You can, however, create a column with enum datatype and define set of valid values. In a case where you try to insert an invalid value to an enum field, it will insert an empty string for it. Sincerely, Gurhan -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:54 PM To: 'Gurhan Ozen'; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP Gurhan, I think Simon was looking for a way to make the enum dynamic from another table. ?? Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 10:22 AM To: Simon Tienery; [EMAIL PROTECTED] Subject: RE: LOOKUP Hi .. You can define ENUM datatype for a column while creating the table and along with the possible values, and if you are using phpMyAdmin to admin MYSQL, it will only give you the possible values for that ENUM column. See: http://www.mysql.com/doc/C/o/Column_types.html http://www.phpmyadmin.net/ Gurhan -Original Message- From: Simon Tienery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:50 AM To: [EMAIL PROTECTED] Subject: LOOKUP Dear Group, Could anyone help me please, I want to create an ENUM column in one table that lists the entries in another table. For example, the sales table to have a "staff" column that automatically gives a choice of the names of all staff listed in the staff table. I have been told that Access has a data type that does this called lookup, but I only want to use MySQL. I couldn't locate the answer in the manual and I'd appreciate it if someone can explain how this can be achieved / worked around. many thanks Simon T - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 P
RE: new to MySQL
This pages might be helpful: http://www.mysql.com/doc/T/a/Table_types.html http://www.innodb.com/ Gurhan -Original Message- From: Steve Bradwell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:06 PM To: [EMAIL PROTECTED] Subject: new to MySQL Hey Everbody, I am still pretty new to MySQL and I was wondering if somone can explain the difference between ISAM tables and MyISAM, HEAP, innodb and Merge? Thanks alot, Steve - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: LOOKUP
Hi, Your solution would work if the set of the values you'll get from one table is primary key.. If it is not a primary key, i.e. allowing duplicate values, then everytime there is an insertion to the table you will have to check to see if it is a new-added value or not. Gurhan -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:58 PM To: 'Gurhan Ozen'; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP That's what I thought too. A workaround occurs to me though, but I'm not sure if it would muck things up. At any point where you make a change to the table you want to reference as the "lookup" (as in Access), you could include another sql command to alter the table with the enum column to change the list of accepted values for the enum. Would this work Gurhan, or would the constant ALTER table commands mess things up? Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:46 PM To: Andrew Hazen; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP Ugh, I am being too goofy today.. Simon, the answer to the question is no, you can't do that in MySQL. You can, however, create a column with enum datatype and define set of valid values. In a case where you try to insert an invalid value to an enum field, it will insert an empty string for it. Sincerely, Gurhan -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:54 PM To: 'Gurhan Ozen'; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP Gurhan, I think Simon was looking for a way to make the enum dynamic from another table. ?? Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 10:22 AM To: Simon Tienery; [EMAIL PROTECTED] Subject: RE: LOOKUP Hi .. You can define ENUM datatype for a column while creating the table and along with the possible values, and if you are using phpMyAdmin to admin MYSQL, it will only give you the possible values for that ENUM column. See: http://www.mysql.com/doc/C/o/Column_types.html http://www.phpmyadmin.net/ Gurhan -Original Message- From: Simon Tienery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:50 AM To: [EMAIL PROTECTED] Subject: LOOKUP Dear Group, Could anyone help me please, I want to create an ENUM column in one table that lists the entries in another table. For example, the sales table to have a "staff" column that automatically gives a choice of the names of all staff listed in the staff table. I have been told that Access has a data type that does this called lookup, but I only want to use MySQL. I couldn't locate the answer in the manual and I'd appreciate it if someone can explain how this can be achieved / worked around. many thanks Simon T - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 <[EMAI
RE: Re[2]: sorting
Hi , I have resent another message and corrected that my solution wouldn't work because I oversaw the numbers with more than one digit, like you said. Roger Baklund posted the right syntax for it : -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:01 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: sorting Try this: SELECT ... FROM SP_rooms ORDER BY room_no+0,room_no; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:09 PM To: [EMAIL PROTECTED] Subject: Re[2]: sorting Hello Gurhan, Will it put 9a before 19b ? Wednesday, April 17, 2002, 4:51:14 PM, you wrote: GO> If you just do your query as "SELECT FROM SP_rooms ORDER BY room_no" it GO> will give you the results you want.. GO> Gurhan GO> -Original Message- GO> From: Dieter Munnik [mailto:[EMAIL PROTECTED]] GO> Sent: Wednesday, April 17, 2002 8:48 AM GO> To: [EMAIL PROTECTED] GO> Subject: sorting GO> Hi, GO> I'm looking for an easy way to select "room numbers" in a numerical/ GO> alphabetical sequence in Mysql GO> Ex : This is for a reservation system. Room numbers are stored in GO> table SP_rooms, column room_no. There are room numbers like GO> 1,2,6,9,5a,4,3,5b . . . ect. I would like them to be order in the correct GO> sequence like 1,2,3,4,5a,5b,6,7,8,9 . . . . . . GO> I want to just make a simple select that will do this for me GO> Kind regards GO> Dieter GO> - GO> Before posting, please check: GO>http://www.mysql.com/manual.php (the manual) GO>http://lists.mysql.com/ (the list archive) GO> To request this thread, e-mail <[EMAIL PROTECTED]> GO> To unsubscribe, e-mail GO> <[EMAIL PROTECTED]> GO> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GO> - GO> Before posting, please check: GO>http://www.mysql.com/manual.php (the manual) GO>http://lists.mysql.com/ (the list archive) GO> To request this thread, e-mail <[EMAIL PROTECTED]> GO> To unsubscribe, e-mail <[EMAIL PROTECTED]> GO> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Platforms for MYSQL
MySQL (server) will run on Win9X, WinNt and later platforms. I use it with Delphi on my Win98 laptop and on my Win2K desktop. You will need TCP/IP for your peer to peer network. Much better than Paradox M -Original Message- From: Colin Rooke [mailto:[EMAIL PROTECTED]] Sent: 17 April 2002 16:28 To: '[EMAIL PROTECTED]' Subject: Platforms for MYSQL Sirs, I am looking for a database replacement for Paradox. We have a variety of users of existing Delphi applications using a number of hardware configurations Can you please confirm whether or not MYSQL will run standalone and on a peer to peer network ? Thank you for your assistance Regards, Colin Rooke - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
new to MySQL
Hey Everbody, I am still pretty new to MySQL and I was wondering if somone can explain the difference between ISAM tables and MyISAM, HEAP, innodb and Merge? Thanks alot, Steve - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
some good tutorial
hi everybody, i have just joined the list and wanted to know something about mysql. is there some really good tutorial you think might be good for a starter in mysql. i am a master's student and have some knowledge of databases like ms access, oracle. hope to get some good stuff. regards ashish See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: foreign key on update cascade in mysql doesn't work
Hi! The brand-new source prerelease 3.23.50b-pre which you can download from http://www.innodb.com supports ON DELETE CASCADE and ON DELETE SET NULL. But does not support ON UPDATE CASCADE. Typically a foreign key refers to the primary key of another table, and it is not that common a primary key is updated. Thus I chose to write ON DELETE CASCADE first. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: "bin cai" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, April 17, 2002 9:13 PM Subject: foreign key on update cascade in mysql doesn't work > Hello, > I create innoDB tables database in mysql3.23.49. > i create foreign key constraints(On UPdate cascade) in > one table. but it seems doesn't work. the system just > refused to update. > I am wondering the innodb in mysql doesn't support the > feature like on update cascade or on delete cascade? > thanks > bin > > __ > Find, Connect Date! http://personals.yahoo.ca > > - > 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, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Weird MySQL thing
Well, I know how to do it manually, but it is annoying compared to using an interface like phpMyAdmin. But it begs the question as to why adding people to the mysql tables worked fine one day, and not the next. I've restarted/reloaded mysql, restarted my server, looked at permission, etc. Since I didn't mention this earlier, I should also mention that I am on a linux box (Cobalt RAQ4). Thanks, -Mike > -Original Message- > From: Petre Agenbag [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 17, 2002 2:48 PM > To: Mike At Spy > Subject: Re: Weird MySQL thing > > > Yes, I'd also like to see the exact way to manually add users etc, > specially to allow specific users access to specific tables from > specific host. > The best way I found to do this ( and the only one that works for me), > is to use the mysql_setpermission executable. It's a menu driven util > allowing you to do this amongst other things. Only thing is, you need to > have perl DBI, MsSql-MySQL and Data Dumper installed to use it ( all are > on the download page on mysql.com) > > Mike At Spy wrote: > > >I am having some trouble with MySQL. Seems I cannot add users. > Well, I can > >add them (through phpMyAdmin, but they are still not able to get into the > >datasbases. I flushed the tables, too. > > > >Current users are not affected. > > > >This started, rather suddenly, the day after I was able to do this. > > > >Anyone have any ideas? > > > >Thanks, > > > >-Mike > > > > > > > > > >- > >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, e-mail > <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: sorting
Hello Gurhan, Will it put 9a before 19b ? Wednesday, April 17, 2002, 4:51:14 PM, you wrote: GO> If you just do your query as "SELECT FROM SP_rooms ORDER BY room_no" it GO> will give you the results you want.. GO> Gurhan GO> -Original Message- GO> From: Dieter Munnik [mailto:[EMAIL PROTECTED]] GO> Sent: Wednesday, April 17, 2002 8:48 AM GO> To: [EMAIL PROTECTED] GO> Subject: sorting GO> Hi, GO> I'm looking for an easy way to select "room numbers" in a numerical/ GO> alphabetical sequence in Mysql GO> Ex : This is for a reservation system. Room numbers are stored in GO> table SP_rooms, column room_no. There are room numbers like GO> 1,2,6,9,5a,4,3,5b . . . ect. I would like them to be order in the correct GO> sequence like 1,2,3,4,5a,5b,6,7,8,9 . . . . . . GO> I want to just make a simple select that will do this for me GO> Kind regards GO> Dieter GO> - GO> Before posting, please check: GO>http://www.mysql.com/manual.php (the manual) GO>http://lists.mysql.com/ (the list archive) GO> To request this thread, e-mail <[EMAIL PROTECTED]> GO> To unsubscribe, e-mail GO> <[EMAIL PROTECTED]> GO> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GO> - GO> Before posting, please check: GO>http://www.mysql.com/manual.php (the manual) GO>http://lists.mysql.com/ (the list archive) GO> To request this thread, e-mail <[EMAIL PROTECTED]> GO> To unsubscribe, e-mail <[EMAIL PROTECTED]> GO> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Weird MySQL thing
I am having some trouble with MySQL. Seems I cannot add users. Well, I can add them (through phpMyAdmin, but they are still not able to get into the datasbases. I flushed the tables, too. Current users are not affected. This started, rather suddenly, the day after I was able to do this. Anyone have any ideas? Thanks, -Mike - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: transaction with MySQL
* Andrew Chan > Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports > transaction. You are wrong. :) 3.23.*-max binaries support BDB and InnoDB tables, both support transactions. http://www.mysql.com/doc/B/D/BDB.html > http://www.mysql.com/doc/I/n/InnoDB.html > -- Roger - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: transaction with MySQL
> Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports > transaction. If I remember correctly, BDB has transaction support and was released during 3.23 development. Sincerely, Craig Vincent - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: transaction with MySQL
Andrew, MySQL-Max-3.23 also supports transactions, and that is a stable release. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: ""Andrew Chan"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, April 17, 2002 8:57 PM Subject: transaction with MySQL > Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports > transaction. > > Thanks. > > Andrew > > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > - > 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, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
foreign key on update cascade in mysql doesn't work
Hello, I create innoDB tables database in mysql3.23.49. i create foreign key constraints(On UPdate cascade) in one table. but it seems doesn't work. the system just refused to update. I am wondering the innodb in mysql doesn't support the feature like on update cascade or on delete cascade? thanks bin __ Find, Connect Date! http://personals.yahoo.ca - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: LOOKUP
That's what I thought too. A workaround occurs to me though, but I'm not sure if it would muck things up. At any point where you make a change to the table you want to reference as the "lookup" (as in Access), you could include another sql command to alter the table with the enum column to change the list of accepted values for the enum. Would this work Gurhan, or would the constant ALTER table commands mess things up? Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:46 PM To: Andrew Hazen; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP Ugh, I am being too goofy today.. Simon, the answer to the question is no, you can't do that in MySQL. You can, however, create a column with enum datatype and define set of valid values. In a case where you try to insert an invalid value to an enum field, it will insert an empty string for it. Sincerely, Gurhan -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:54 PM To: 'Gurhan Ozen'; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP Gurhan, I think Simon was looking for a way to make the enum dynamic from another table. ?? Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 10:22 AM To: Simon Tienery; [EMAIL PROTECTED] Subject: RE: LOOKUP Hi .. You can define ENUM datatype for a column while creating the table and along with the possible values, and if you are using phpMyAdmin to admin MYSQL, it will only give you the possible values for that ENUM column. See: http://www.mysql.com/doc/C/o/Column_types.html http://www.phpmyadmin.net/ Gurhan -Original Message- From: Simon Tienery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:50 AM To: [EMAIL PROTECTED] Subject: LOOKUP Dear Group, Could anyone help me please, I want to create an ENUM column in one table that lists the entries in another table. For example, the sales table to have a "staff" column that automatically gives a choice of the names of all staff listed in the staff table. I have been told that Access has a data type that does this called lookup, but I only want to use MySQL. I couldn't locate the answer in the manual and I'd appreciate it if someone can explain how this can be achieved / worked around. many thanks Simon T - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
transaction with MySQL
Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports transaction. Thanks. Andrew _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql+jdbc+international character support
Hello, Thank you for your immediate reply. What database version have you used these drivers for? Do you have a preference for either? Thanks again. jm "TAKAHASHI, Tomohiro" wrote: > Hi, > Both gweMySQL and MM.MYSQL support Unicode-Nativecode conversion. > > [gweMySQL Driver] > http://www.t3-jpn.com/jdbc/jdbcmysql.html > i.e. > String url = "jdbc:mysql://server:3306/dbname?characterEncoding=EUC_JP"; > > [MM.MYSQL Driver] > http://mmmysql.sourceforge.net/ > > Jan-Michael Ong wrote: > > > > Greetings, > > > > This will be my first post to this mailing list so please bear with me. > > > > We need to setup a database that is capable of handling "international > > characters" similar to Oracle. We plan to use MySQL and the latest JDBC > > drivers for MySQL. I've searched Google to see if MySQL has dedicated > > support for international characters but was less than satisfied with > > the results. > > > > So the question is: > > > > What version (if any) does MySQL support international characters? > > Does the latest JDBC driver support this as well? > > If it does support it are there resources that perhaps you can recommend > > that I can read up on? > > If it does not support international characters are there plans to in > > the next few releases? > > > > Thank you in advance and I look forward to your reply. > > -- > I love Borland. > Borland Japan / Consulting Group > TAKAHASHI, "KEN", Tomohiro > > - > 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, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: LOOKUP
Ugh, I am being too goofy today.. Simon, the answer to the question is no, you can't do that in MySQL. You can, however, create a column with enum datatype and define set of valid values. In a case where you try to insert an invalid value to an enum field, it will insert an empty string for it. Sincerely, Gurhan -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:54 PM To: 'Gurhan Ozen'; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP Gurhan, I think Simon was looking for a way to make the enum dynamic from another table. ?? Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 10:22 AM To: Simon Tienery; [EMAIL PROTECTED] Subject: RE: LOOKUP Hi .. You can define ENUM datatype for a column while creating the table and along with the possible values, and if you are using phpMyAdmin to admin MYSQL, it will only give you the possible values for that ENUM column. See: http://www.mysql.com/doc/C/o/Column_types.html http://www.phpmyadmin.net/ Gurhan -Original Message- From: Simon Tienery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:50 AM To: [EMAIL PROTECTED] Subject: LOOKUP Dear Group, Could anyone help me please, I want to create an ENUM column in one table that lists the entries in another table. For example, the sales table to have a "staff" column that automatically gives a choice of the names of all staff listed in the staff table. I have been told that Access has a data type that does this called lookup, but I only want to use MySQL. I couldn't locate the answer in the manual and I'd appreciate it if someone can explain how this can be achieved / worked around. many thanks Simon T - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql 4.0.1 crashing in fulltext search with some words..
I'm not sure if this has been reported earlier, but my mysql-server goes down if I run a query with two 'match against' where one of them contains/matches the word 'think'... It terminates after the first query, but when I change the word 'think' to 'excel' or any other word it works flawlessy. I have written the queries like this since '... against ('+windows +excel' IN BOOLEAN MODE)' doesn't work in the 4.0.1 version of MySQL. I find this pretty strange >From mysql consol: mysql> SELECT count(*) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST ('windows' IN BOOLEAN MODE) AND match (tittel) against ('think' IN BOOLEAN MODE); ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:1 Current database: DB_GNIST ERROR 2013: Lost connection to MySQL server during query mysql> SELECT count(*) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST ('windows' IN BOOLEAN MODE) AND match (tittel) against ('excel' IN BOOLEAN MODE); ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:1 Current database: DB_GNIST +--+ | count(*) | +--+ | 149 | +--+ 1 row in set (0.17 sec) mysql> mysql> SELECT count(*) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST ('windows' IN BOOLEAN MODE) AND match (tittel) against ('excel' IN BOOLEAN MODE); +--+ | count(*) | +--+ | 149 | +--+ 1 row in set (0.16 sec) Regards Erlend Stromsvik - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: database security
I just bought this book, it's really good so far for MySQL but not sure how indepth the security content is http://www.webmasterbase.com/article/225 Steve. -Original Message- From: Paras Mukadam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:19 PM To: MySQL Subject: database security Can anyone suggest some book on database security. I plan to study some features like Schema-less logins, single sign on, preserving user identity and like in light of MySQL. Regards, Paras. - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC
Sounds like a user permission problem. Make sure you're allowed to connect from that ip. ( You can check in the 'user' table in the 'mysql' db. ) -- sh On Wed, 2002-04-17 at 09:34, Jim Bahr wrote: > Hi Gang, > > Im trying to set my remote xp pc to connect to my server databases using > MS Access. I have loaded and configured Myodbc21.50.39 (win95) and my > DNS but get the following error message when I try to connect in Access. > [TXC][MyODBC] Host'hxxx-xxx-xxx.ip, Alltel.net is not allowed to connect > to this MySQL server (#1130). > > > > The x above = my dsl ip address. > > > > Any idea what I need to do next? Am I getting close? > > Jim > > > - > 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, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
security
Can anyone suggest some book on database security. I plan to study some features like Schema-less logins, single sign on, preserving user identity and like in light of MySQL. Regards, Paras. For live cricket scores download Yahoo! Score Tracker at: http://in.sports.yahoo.com/cricket/tracker.html - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can't init my database for innoDB in mysql
Hi! Autoextend is only supported by versions >= 3.23.50. I heard a rumor that a binary of .50 could be out in 2 days. At http://www.innodb.com you can download a source prelease of .50. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Original Message - From: "bin cai" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, April 16, 2002 10:13 PM Subject: can't init my database for innoDB in mysql > Hi, > currently i got one problem really need your help. > I removed mysql3.23.41 version and install mysql > 3.23.49. and it works fine with myisam table. > Now i am trying to create innobd tables. > so i edit my.cnf file like that( window 2000): > > [mysqld] > basedir=F:/mysql > #bind-address=129.128.207.59 > datadir=F:/mysql/data > #language=F:/mysql/share/your language directory > #slow query log#= > #tmpdir#= > #port=3306 > #set-variable=key_buffer=16M > > > # i add these lines > innodb_data_home_dir = F:/mysql/ibdata > innodb_data_file_path > =/ibdata/ibdata1:100M:autoextend:max:2000M > set-variable = innodb_buffer_pool_size=150M > set-variable = innodb_additional_mem_pool_size=20M > innodb_log_group_home_dir = F:/mysql/iblogs > innodb_log_arch_dir = F:/mysql/iblogs > innodb_log_archive=0 > set-variable = innodb_log_files_in_group=3 > set-variable = innodb_log_file_size=20M > set-variable = innodb_log_buffer_size=16M > innodb_flush_log_at_trx_commit=1 > set-variable = innodb_file_io_threads=4 > set-variable = innodb_lock_wait_timeout=50 > #end bincai add > > > > [WinMySQLadmin] > Server=F:/mysql/bin/mysqld-nt.exe > user=system > password=password > > but i when i run mysqld --standalone --console in DOS > prompt it give me such error message: > > InnoDB: syntax error in innodb_data_file_path,020416, > can't init databases. > > I will really appreciate any help. > Thanks in advance > bin > > > > > > > > __ > Find, Connect Date! http://personals.yahoo.ca > > - > 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, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: LOOKUP
Gurhan, I think Simon was looking for a way to make the enum dynamic from another table. ?? Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 10:22 AM To: Simon Tienery; [EMAIL PROTECTED] Subject: RE: LOOKUP Hi .. You can define ENUM datatype for a column while creating the table and along with the possible values, and if you are using phpMyAdmin to admin MYSQL, it will only give you the possible values for that ENUM column. See: http://www.mysql.com/doc/C/o/Column_types.html http://www.phpmyadmin.net/ Gurhan -Original Message- From: Simon Tienery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:50 AM To: [EMAIL PROTECTED] Subject: LOOKUP Dear Group, Could anyone help me please, I want to create an ENUM column in one table that lists the entries in another table. For example, the sales table to have a "staff" column that automatically gives a choice of the names of all staff listed in the staff table. I have been told that Access has a data type that does this called lookup, but I only want to use MySQL. I couldn't locate the answer in the manual and I'd appreciate it if someone can explain how this can be achieved / worked around. many thanks Simon T - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
security
Can anyone suggest some book on database security. I plan to study some features like Schema-less logins, single sign on, preserving user identity and like in light of MySQL. Regards, Paras. For live cricket scores download Yahoo! Score Tracker at: http://in.sports.yahoo.com/cricket/tracker.html - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC
Hi Gang, Im trying to set my remote xp pc to connect to my server databases using MS Access. I have loaded and configured Myodbc21.50.39 (win95) and my DNS but get the following error message when I try to connect in Access. [TXC][MyODBC] Host'hxxx-xxx-xxx.ip, Alltel.net is not allowed to connect to this MySQL server (#1130). The x above = my dsl ip address. Any idea what I need to do next? Am I getting close? Jim - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql+jdbc+international character support
Hi, Both gweMySQL and MM.MYSQL support Unicode-Nativecode conversion. [gweMySQL Driver] http://www.t3-jpn.com/jdbc/jdbcmysql.html i.e. String url = "jdbc:mysql://server:3306/dbname?characterEncoding=EUC_JP"; [MM.MYSQL Driver] http://mmmysql.sourceforge.net/ Jan-Michael Ong wrote: > > Greetings, > > This will be my first post to this mailing list so please bear with me. > > We need to setup a database that is capable of handling "international > characters" similar to Oracle. We plan to use MySQL and the latest JDBC > drivers for MySQL. I've searched Google to see if MySQL has dedicated > support for international characters but was less than satisfied with > the results. > > So the question is: > > What version (if any) does MySQL support international characters? > Does the latest JDBC driver support this as well? > If it does support it are there resources that perhaps you can recommend > that I can read up on? > If it does not support international characters are there plans to in > the next few releases? > > Thank you in advance and I look forward to your reply. -- I love Borland. Borland Japan / Consulting Group TAKAHASHI, "KEN", Tomohiro - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Changing international charset for ORDER by sorting
Hi! Anybody knows how can I change the character set, when MySQL is running, to be able to do ORDER BY using international strings? I would need to do this without changing config, while I run my perl script. I would need to do sortings for different languages. So locale definition should be changed right from within MySQL. (changing locale in config is not solution, because I need to change more times for different languages) How it is possible to change character set dynamically, or to set different character sets for different tables within the same database? Thanks in advance. Best regards, Webmaster33 - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database security
Can anyone suggest some book on database security. I plan to study some features like Schema-less logins, single sign on, preserving user identity and like in light of MySQL. Regards, Paras. - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Export
Use MySQLDumpit can help make backups R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: Manish Mehta [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 5:45 PM To: mysql Subject:Export Hi, I am working on Mysql . I wants to take backup (export) of my database from dos prompt . Is their any way. Please Tell. Thx in advance Manish Mehta - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SV: Problem with query
select * from MEMBERS,FEE_PAYMENTS where FEE_PAYMENTS.price < '1' and MEMBERS.memberID = FEE_PAYMENTS.memberID; am I getting close? :o) Mark >The FEE_PAYMENTS table does not have one line corresponding to each line in the >MEMBERS table. > >The members table can look like this: > >MEMBERS >ID | NAME | BIRTHDAY | etc... >1 | Art Garfunkle | 1940-05-02 | >2 | Torkil Johnsen | 1980-05-26 | >3 | Bill Clinton | 1956-02-12 | >4 | Madonna | 1962-08-02 | >5 | Rune Araber | 1954-12-17 | > >And the fee_payments table can look like this: > >FEE_PAYMENTS >ID | MEMBER_ID | PRICE >1 | 2 | 500 >2 | 4 | 750 > >So as you can see, only "Torkil Johnsen" and "Madonna" has paid their fees, 500 and >750 respectively. > >Now I want to list the people that have not paid their fees... How would you do this? > > >- Torkil :) > >- Opprinnelig melding - >Fra: Mark Dale <[EMAIL PROTECTED]> >Til: Torkil Johnsen <[EMAIL PROTECTED]> >Kopi: <[EMAIL PROTECTED]> >Sendt: 17. april 2002 11:17 >Emne: Re: Problem with query > > > > > > select * from MEMBERS,FEE_PAYMENTS where FEE_PAYMENTS.PAID = '0' and MEMBERS. >MemberID = FEE_PAYMENTS. MemberID; > > > > assuming you have a field PAID, with values 0 or 1,or even YES or NO > > > > cheers > > > > Mark > > > > >I am having a small problem with a small mysql query... > > > > > >I want to make a list of: > > >"WHO HAS NOT PAID THEIR MEMBERSHIP FEE". > > > > > >I guess I could maybe solve this one myself, its not too hard ... > > > > > >I have one table with members > > > > > >MEMBERS > > >-- > > >| MemberID | Name | etc. > > > > > > > > >One table with fee payments > > > > > >FEE_PAYMENTS > > >-- > > >| MemberID | date | price | etc... > > > > > > > > >Now: How would I make a query that would list all members that have not paid >their fee? > > >How would I make a query that would list all members that have paid their fee? > > > > > >I'm just too tired to think it out myself :) > > >Forgive me :) > > > > > >- > > >Med vennlig hilsen, > > >Torkil Johnsen > > > > > >[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 <[EMAIL PROTECTED]> > > >To unsubscribe, e-mail <[EMAIL PROTECTED]> > > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Export
Hi, I am working on Mysql . I wants to take backup (export) of my database from dos prompt . Is their any way. Please Tell. Thx in advance Manish Mehta - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Alter Table and Replication
I've issued an ALTER TABLE query on a table controlled by my master in a replication to add a column to a table. Since I did this, replication of all tables in the only database being replicated has stopped. Do I have to take a snapshot of the DB and restart replication as per day 1 or is there something I can do to kick it along? Regards, Mark. - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C API - intermittent problems with insert
Hello, I'm using the Suse-provided binary of 3.23.47 on Suse7.3 Linux, and I'm having a funny problem with my program, which uses the C API, on this database. The database I'm accessing is using only the BDB table type. The host system is a relatively low powered IBM 300XL, (PII-233, 96MB RAM, 2GB WD EIDE disk). Every so often, (under heavy load?), the database appears to miss an INSERT operation. This happens intermittantly, so is not predicatable. It also doesn't happen very often, (< 1%), but even so it's darned annoying when it does happen (sigh!). Has anyone out there in MySQL land got any ideas on how I can track this down? I was going to enable the ascii log and see if an actual INSERT is being issued, (in which case I've got a MySQL bug) or not (in which case my code is defective in some way - more likely methinks). Any opinions welcomed, and feel free to take this off the list, so as not to annoy everyone else with my stupidity. Regards Bob Cross. (filter bypass: mysql database table sql query). - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Multiple Inserts
Hi all Thanks for your replies to my question about multiple updates in one query. I think Kittiphum Worachat is right in that I have designed it wrong. I couldn't get it to do what I wanted, so I reverted to single update queries. cheers Mark --- Summary of replies -- from Paul Wilson I'd guess that $job_number = 'AA3' or something similar. To update all 3 records inserted as above, try : update mytable set jobdate='$job_date' where job_number like 'AA_'; --- from DL Neil However if you look at the template for the INSERT command notice that after the VALUES clause there is an ellipsis - something like: VALUES(expression [,expression]...) [,(expression, etc)...] thus you can add as many rows' worth of data as you like - each row within its own set of parentheses: insert into mytable (id,name,job_number,job_date) values ('1','Mark','AA1','2002-04-15'), ('2','Mark','AA2','2002-04-16'), ('3','Mark','AA3','2002-04-17') Kittiphum Worachat - Your problem is misused of form transfer data please notify that by GET method the data transfer to server with name and equa sign (=) and then value each data seperate by & so id=1&name=Mark&job_number=AA1&job_date=2002-5-19 mean the data have 3 elecment id,name and job_date as your data you send 9 element but use the same name so finally it only have 3 element and the value id the last assign so you will got at last id=3&name=Mark&job_number=AA3&job_date=2002-5-25 the first and the second set has over write so when you update data you got the last data (id=3) update only how to solve this problem you shoul declare the name seperate like this id1=1&name1=Mark&job_number1=AA1&job_date1=2002-5-19 &id2=2&name2=Mark&job_number2=AA2&job_date2=2002-5-21 &id3=3&name3=Mark&job_number3=AA3&job_date3=2002-5-25 and update 3 time $sql = "UPDATE mytable set job_date='$job_date1' where job_number ='$job_number1'"; @mysql_query($sql, $connection) or die.; $sql = "UPDATE mytable set job_date='$job_date2' where job_number ='$job_number2'"; @mysql_query($sql, $connection) or die.; $sql = "UPDATE mytable set job_date='$job_date3' where job_number ='$job_number3'"; @mysql_query($sql, $connection) or die.; Original question -- That the thing see, the form(using GET instead of POST) sends data with the new dates like this:- id=1&name=Mark&job_number=AA1&job_date=2002-5-19 &id=2&name=Mark&job_number=AA2&job_date=2002-5-21 &id=3&name=Mark&job_number=AA3&job_date=2002-5-25 and the UPDATE query like this:- > $sql = "UPDATE mytable set job_date='$job_date' where job_number > ='$job_number'"; > $result = @mysql_query($sql, $connection) or die.; just updates the last record. Can the query be written so that it updates each of the three records? --- - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with query
Depends on how the fee paymnents are defined. At its simplest: SELECT Members..Name FROM Members WHERE NOT(Members.MemberID = FEE_PAYMENTS.MenmbersID) would select members that have no fee payment records. You could build on it from there... For the mySQL gurus, sorry about the syntax guys, I've been with Access to long but I'm coming over quickly :-) Pierre Torkil Johnsen wrote: > I am having a small problem with a small mysql query... > > I want to make a list of: > "WHO HAS NOT PAID THEIR MEMBERSHIP FEE". > > I guess I could maybe solve this one myself, its not too hard ... > > I have one table with members > > MEMBERS > -- > | MemberID | Name | etc. > > > One table with fee payments > > FEE_PAYMENTS > -- > | MemberID | date | price | etc... > > > Now: How would I make a query that would list all members that have not paid their >fee? > How would I make a query that would list all members that have paid their fee? > > I'm just too tired to think it out myself :) > Forgive me :) > > - > Med vennlig hilsen, > Torkil Johnsen > > [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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 "If it feels good, do it!" - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with query
select * from MEMBERS,FEE_PAYMENTS where FEE_PAYMENTS.PAID = '0' and MEMBERS. MemberID = FEE_PAYMENTS. MemberID; assuming you have a field PAID, with values 0 or 1,or even YES or NO cheers Mark >I am having a small problem with a small mysql query... > >I want to make a list of: >"WHO HAS NOT PAID THEIR MEMBERSHIP FEE". > >I guess I could maybe solve this one myself, its not too hard ... > >I have one table with members > >MEMBERS >-- >| MemberID | Name | etc. > > >One table with fee payments > >FEE_PAYMENTS >-- >| MemberID | date | price | etc... > > >Now: How would I make a query that would list all members that have not paid their >fee? >How would I make a query that would list all members that have paid their fee? > >I'm just too tired to think it out myself :) >Forgive me :) > >- >Med vennlig hilsen, >Torkil Johnsen > >[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 <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with query
I am having a small problem with a small mysql query... I want to make a list of: "WHO HAS NOT PAID THEIR MEMBERSHIP FEE". I guess I could maybe solve this one myself, its not too hard ... I have one table with members MEMBERS -- | MemberID | Name | etc. One table with fee payments FEE_PAYMENTS -- | MemberID | date | price | etc... Now: How would I make a query that would list all members that have not paid their fee? How would I make a query that would list all members that have paid their fee? I'm just too tired to think it out myself :) Forgive me :) - Med vennlig hilsen, Torkil Johnsen [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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LOOKUP
Dear Group, Could anyone help me please, I want to create an ENUM column in one table that lists the entries in another table. For example, the sales table to have a "staff" column that automatically gives a choice of the names of all staff listed in the staff table. I have been told that Access has a data type that does this called lookup, but I only want to use MySQL. I couldn't locate the answer in the manual and I'd appreciate it if someone can explain how this can be achieved / worked around. many thanks Simon T - 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, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php