how to test if strings are numeric ?

Hi everybody, I looked for a function to test whether a string is numeric (having characters 0..9 only). I found in the 5.0 manual Cast() and Convert(), but I don't think these do what I need. Any suggestion what function to use ? Thanks in advance, Cor

Re: Moving databases from backups not working . . .

Go this man http://www.silisoftware.com/scripts/?scriptname=backupDB the power scripts which back up your db mysql in minute and you can download throught ftp. Please feel free to reply to this email if you have additional questions or concerns ??? 01-7499093 ?

Re: mysql on OS X tiger

Brent, I believe I am experiencing the same problem when trying to run the CocoaMySQL client... When I run CocoaMySQL v0.7b2 and try to connect to a database, I get the following error: Unable to connect to host localhost. Be sure that the address is correct and that you have the

Re: CocoaMySQL v0.7b2 Connection Help, Part II

Michael, I would still appreciate it if someone could tell me what the default port number is because I need that to set up a local JDBC connection. Kindest regards, Unnsse On Dec 2, 2005, at 11:05 PM, Michael Stassen wrote: untz wrote: Hello there! This is a continuation of a previous

/etc/init.d/mysql hangs

Hi, I'm on Debian system. I tried to modify /etc/mysql/debian-log-rotate to set KEEP-BINARY-LOGS from 0 to 5. After doing so I attempted to let the change register by stopping and restarting the server by running /etc/init.d/mysql stop. However this command hanged. I rebooted the system and but

Re: CocoaMySQL v0.7b2 Connection Help, Part II

Unless you specified --skipn-etworking (which turns off TCP/IP sockets) or specifically declared a different port with --port=, the default port is 3306. http://dev.mysql.com/doc/refman/4.1/en/server-options.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine untz [EMAIL

Re: /etc/init.d/mysql hangs

Hello. Check if you're able to start server manually using mysqld or mysqld_safe commands. Research error logs. See: http://dev.mysql.com/doc/refman/5.0/en/starting-server.html Timothy Wu [EMAIL PROTECTED] wrote: Hi, I'm on Debian system. I tried to modify

Re: what happened to error log in MySQL 4.1x/Windows XP

Hello. See: http://dev.mysql.com/doc/refman/5.0/en/windows-start-service.html http://dev.mysql.com/doc/refman/5.0/en/program-options.html [EMAIL PROTECTED] wrote: Hi, I haven't admin'd MySQL in a couple of years, and I have forgotten and lot (and probably never knew even

Re: Moving databases from backups not working . . .

Hello. Login as root though mysql command line client and check if new tables exist and if you're able to work with them. Under what user are you working in phpMyAdmin? Does he have some privileges on just created databases or 'SHOW DATABASES' privilege. See:

Re: how to test if strings are numeric ?

Hello. Possible solution is to use REGEXP: mysql select '911' regexp '^[1-9]*$'; +-+ | '911' regexp '^[1-9]*$' | +-+ | 1 | +-+ mysql select

Re: CocoaMySQL v0.7b2 Connection Help

Responses intermixed. See below... untz [EMAIL PROTECTED] wrote on 12/02/2005 10:43:41 PM: Hello again, I am using OS X Tiger and MySQL 5 Community Edition with the CocoaMySQL v0.7b2 client (see: http://cocoamysql.sourceforge.net/beta.php ). Am a MySQL newbie so please pardon my

Re: CocoaMySQL v0.7b2 Connection Help, Part II

ROFLMAO!!! I mean to type --skip-networking - HA ha ha!!! [EMAIL PROTECTED] wrote on 12/03/2005 09:50:19 AM: Unless you specified --skipn-etworking (which turns off TCP/IP sockets) or specifically declared a different port with --port=, the default port is 3306.

MySQL 5.1.3-alpha has been released

Hi, MySQL 5.1.3, a new version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/mysql/5.1.html and mirror sites. As we're

Re: how to test if strings are numeric ?

This is very useful. Can you please also show how this can be used to validate user input like for example: We have this query currently: select id from users where id like 'user_enterred-value%'; Now I want to validate that the user-enterred-value is only a numeric value... (the major problem

Re: how to test if strings are numeric ?

C.R.Vegelin [EMAIL PROTECTED] wrote: Hi everybody, I looked for a function to test whether a string is numeric (having characters 0..9 only). I found in the 5.0 manual Cast() and Convert(), but I don't think these do what I need. Any suggestion what function to use ? Thanks in advance, Cor

Re: how to test if strings are numeric ?

Anoop kumar V [EMAIL PROTECTED] wrote on 12/03/2005 11:59:10 AM: This is very useful. Can you please also show how this can be used to validate user input like for example: We have this query currently: select id from users where id like 'user_enterred-value%'; Now I want to

Auto_Increment Value

Hi all, I have a simple table with an Auto_Increment column. I insert NULL to this column each time I insert a row to have an automatic unique value. The problem is that I want to have new automatically generated value back to insert it to another table. How can I have new

Auto_Increment value

Hi all, I have a simple table with an Auto_Increment column. I insert NULL to this column each time I insert a row to have an automatic unique value. The problem is that I want to have new automatically generated value back to insert it to another table. How can I have new

Re: Auto_Increment value

http://dev.mysql.com/doc/refman/4.1/en/odbc-and-last-insert-id.html | | Cal Evans | http://www.calevans.com | Danesh Daroui wrote: Hi all, I have a simple table with an Auto_Increment column. I insert NULL to this column each time I insert a row to have an automatic unique value.

Compare Tablets by Key1 and Remove Duplicates

I have just moved over to a new job and been given the task of trying to sort out historic client databases (MS-Access). I have exported everything to CSV, then into MySQL 5.0.15 no problems at all. However due to the way the original system was developed i have so much duplicated data it is

recording time of data entry

hi all, can anyone tell me if we can anywhere find out what time that data was entred in the database i was actually checking if we can find out what time that record got created into the database can anyone help!! regards prao -- MySQL General Mailing List For list archives:

Re: Compare Tablets by Key1 and Remove Duplicates

Subqueries. select * from ClientJune2005 where customerCode = (select customercode from ClientAug2005); http://dev.mysql.com/doc/refman/4.1/en/subqueries.html =C= | | Cal Evans | http://www.calevans.com | VaioLord wrote: I have just moved over to a new job and been given the task of trying

Re: recording time of data entry

No way to do it post-insert. However, if you are designing a new database, checkout a timestamp field. =C= | | Cal Evans | http://www.calevans.com | prathima rao wrote: hi all, can anyone tell me if we can anywhere find out what time that data was entred in the database i was actually