I have a MySQL table where all the data in one column was entered in UPPERCASE, but I need to convert in to Title Case, with recognition of "small words" akin to the Daring Fireball Title Case script. I found this excellent solution for transforming strings to lowercase, but the Title Case function seems to have been left out of my vers...
Hey all people :-) I think i did some nasty crap today... I deleted the user (admin root) in phpmyadmin (XAMPP) now I can't create new users. Any idea how to fix, or should I just try re-install the hole XAMPP packet :-/ I use Leopard iMac. /Willy ...
I'm tying to execute a query in phpMyAdmin. The query takes approximately two minutes to load, but at the top of the query results it says that the "Query took 0.2768 sec". How is this possible? ...
Is it possible for me to write an SQL query from within PhpMyAdmin that will search for matching records from a .csv file and match them to a table in MySQL? Basically I want to do a WHERE IN query, but I want the WHERE IN to check records in a .csv file on my local machine, not a column in the database. Can I do this? ...
Apologies if this has already been answered many times, but I was unable to find the answer and I was flummoxed. I have a mysql query which seemingly outputs the result I want when I run it in the database - however when I run the query through PHP, it does not output correctly. In the database, dates are stored like this: 2009-08-13T...
I run XAMPP, a few days back i had set up a password for the root password through phpmyadmin I am not able to access phpMyAdmin ever since that moment I followed help on this link but everything seems fine there (in config.inc.php). I even tried unistalling xampp fully, restarting windows and then reinstalling xampp, but still pointing...
This is a sample of the data im working with 24701||37.279788||-81.229023||WV||BLUEFIELD||MERCER as you can see its double pipe delimited. phpmyadmin is asking me for the following Fields Terminated By Fields Enclosed By Fields Escaped By Lines Terminated By what do i put to correctly import my data? ...
I've been a PHP Dev for many years now, and it just dawned on me that maybe I could be using better development tools. For example, my typical setup for development is Notepad ++ Dev WAMP Server (local machine usually) CodeIgniter framework (lately I've fallen in love with it, as it speeds up deployment for me, big time.) PHPMYADMIN ...
Hi I've recently started developing my first serious application which uses a SQL database, and I'm using phpMyAdmin to set up the tables. There are a couple optional "features" I can give various columns, and I'm not entirely sure what they do: Primary Key Index I know what a PK is for and how to use it, but I guess my question wit...
I must say, I'm bored of phpmyadmin. We are in 2009 and have to work with this usefull tool and to wait everypage to reload after every action. Are any ajaxed alternatives outhere? Maybe phpmyadmin himself is going to be ajaxized? ...
I'm stumped. Why would a query work in phpMyAdmin but not in a MAMP environment? I've echoed out the query, which returned 0 results in MAMP, copied it and pasted it into phpMyAdmin and the same query returns the expected result. select c.id from (select id, business_id from coup where match(name) against ('$search')...
I am doing development work on a site with a strange server set up where sessions basically don't work. It's kind of a long story, but the main crux is it's a cluster of servers that are syncronized from an FTP server every few minutes. And for example, anything written to the filesystem in PHP gets deleted within 5 minutes. So this mea...
I am looking for web based tool like phpMyAdmin, but for SQL Server. Any suggestions? ...
I create new database with utf8_general_ci collation, create test table also with utf8_general_ci collation, and then i click on my database(structure) and this is what i get: Why is that "latin1_swedish_ci" showing up? Edit: Ok how to change this, it is in phpmyadmin in "Variables" tab, under "Server variables and settings": Thi...
By default, phpMyAdmin shows me 30 rows whenever I load a table (the query contains "LIMIT 30"). I generally want to see (up to) a few hundred rows. Is there a way to change that default setting? ...
I have a project that includes a copy of phpMyAdmin. I do development locally and use subversion for version control. When a new release of phpMyAdmin comes out I have to take all of the files from the new phpMyAdmin release and move them into the exiting files in my project. If I copy the entire directory I get errors the next time I...
Hi all, I have a problem with the MySQL root user in My MySQL setup, and I just can't for the life of me work out how to fix it. It seems that I have somehow messed up the root user, and my access to databases is now very erratic. For reference, I'm using MAMP on OS X to provide the MySQL server. I'm not sure how much that matters thou...
Hi, I'm new to working with web servers and need some assistance. I have downloaded the most recent Wamp server and did a bit of database design and querying, but there ws always a warning at the bottom of the admin page about setting up a password. I tried doing this for the root user, but ended up doing something wrong and I no longe...
I need to replace more than 20 000 names with new names i created given the CodeID. For example: I must update all rows that contain "dog" (which has a CodeID of 1) with "cat", and update all rows that contain "horse" (which has a CodeID of 2) with "bird", etc. 1st SQL statement: UPDATE animalTable SET cDescription = "cat" WHERE Code...
Is there a python equivalent of phpMyAdmin? ...