updating columns with numbers only
Hi all What command do I use to strip an sql table column of everything but numbers? Let's say I have values in my column such as "NX-383_H" and I only want the number portion "383" in the column but want to discard the other junk? What command do I use? thanks J __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
theoretical row/record limit of mysql?
Hi all: Does anyone know the maximum number of rows/records that mysql allows? thanks __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem loading text files into table
Hi all: Got a problem/question. I am trying to load a tab delimited textfile into my table and it keeps saying file not found. I am confident I am doing everything correct (the pathname, text extension, syntax, etc.) But it keeps saying file not found (error 1105 and errcode:2). What could I be doing wrong? I am using the mysql client to send queries. thanks __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP program for sql queries?
Hi: Does anyone have a simple PHP program that will enable SQL queries to be executed and displayed with MySQL? thanks __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
phpmyadmin screw up
Hi all: I was trying to use phpmyadmin for the first time and messed up when trying to give the [EMAIL PROTECTED] a password. I did that because phpmyadmin told me something about lax security using "root" with no password. Anyhow something went wrong. Now I can't do anything with phpadmin or mysql client. The message is - "Error 1045: Access Denied for User: (Using Password:No). Grateful for anyone's help. Thanks __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
phpmysql(which array function?)
Hi all: Trying to solve a phpmysql array problem. Let's say I have a table in mysql format Column1 Column2 dog brown cat white cat black cat mixed pig black pig brown What kind of (query, array function, loop, etc...) should I use to produce an html output like this: 1. column1:dog column2:brown 2. column1:cat column2: white, black,mixed 3. column1: pig column2: black, brown Thanks in advance J __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
newbie question on data accumulation
Hi all Curious as to what happens after data is repeatedly selected from a mysql table overtime. Does it accumulate as junk data, stored at some location and eventually slow down the database/program/server? Does any purging have to take place? Thanks J __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
max_user_connections clarification
Hi all: Need some clarification on this because the books and articles don't make it clear. Let's say I have a program in php or whatever language that contains the username and password for access to mysql and the program executes once anyone visits the site. Can multiple visitors to my site make connections and access the database through that username and password which is in the program code. Is that what max_user_connections is about, connecting using the same username and password? Secondly for the purpose of SAFE public viewing could I have in my settings blanks for username and password,etc. user name: '' password: '' hostname: localhost and then invoke a GRANT SELECT option? Would that be safe? Thanks for your patience. J __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question about column names
Hi all: How does one get away with creating a column name that is more than one word -let's say a column named John Smith? I know John_Smith is an option but I'd like two separate words. Thanks J __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
strings of variables, php, mysql
Would appreciate in anyone can help me. Let's say I do a query in php, eg. $query = "select shed from structure"; With the mysql_fetch_array function and a loop I could see all the values stored in the column, shed, using the command: echo $shed; Let's say now that I am carrying over a variable from a form called $form where $form = shed. I can still say $query = "select $form from structure"; because $form = shed. The problem I have now is with the strings and how do I see my column values. Using echo $$value; or echo $($value) or echo \$$value or echo $"$value" does not give me the values stored in the column shed. Help anyone? thanks __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
administering database on server
Hi all: Anyone know a RELIABLE software program for administering to a mysql database on a webhosting unix server? Thanks __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: administering database on server
wow! thanks all for the superquick response. J __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql command to rename database
I am ashamed to ask this but I really did not see this in the manual or elsewhere. What is the command to rename a database? __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]