MYSQL :: Quick PhpMyAdmin

Quick Join
I have two tables Matches (m_id, m_winner_id, m_loser_id) and Users (u_id, u_name). m_winner and m_loser_id are foreign keys.

Now I want the querry result to look like this: Match ID | Winner Name | Loser Name.

I did a join query:
Select matchs.id, users.name From matchs, users Where matchs.winner_id = users.id

How do I get the loser name?

Quick Fix 4 MySQL Pro
I will have a few instances like this and since I'm new to MySQL, perhaps a good example will help down the road. All I want to do is display a list of the first and last name of the names in my DB so they appear like so:

John Smith
Suzie Johnson
Etc...

first and last are two separate fields in the DB so I just need to join them together. The code I have now gives me this error:
PHP Notice: Undefined index: first in e:etc...

<?php
// Request the names in db
$result = mysql_query("SELECT artist.first, artist.last FROM artist");
if (!$result) {
echo("No artists posted at this time");
exit();

code...

Quick Join
I have a quick SQL question:
I have two tables Matches (m_id, m_winner_id, m_loser_id) and Users (u_id, u_name). m_winner and m_loser_id are foreign keys. Now I want the querry result to look like this: Match ID | Winner Name | Loser Name.

I did a join query:
Select matchs.id, users.name From matchs, users Where matchs.winner_id = users.id
How do I get the loser name?

Quick Query
this one shoud be easy, but I just can't think of the best way (other than writing a php script to do it). I have a CMS and need to change one word in the description field for 64 rows. For example, where we now have 64 entries with "Bilbo" in the middle of the data, we need to change it to say "Frodo" instead. (Actually, I need to replace a misspelled javascript toLowerCase() call...darned non-programmers! They used toLowercase() - note the lower case C)

Quick Queries
Is it possible to use a regular expression or similar in a mySQL query, to make 'fuzzy' comparisons, or is LIKE the best we can hope for?

QUICK AND EASY ONE
im fairly new to php/mysql so please bear with me
I am trying to upload a txt.file created from an excel spreadsheet using the following query:

LOAD DATA INFILE 'path/file.txt' INTO TABLE my_table;

im getting a syntax error!
what could be wrong? are there any other attributes i should be adding to this query? i also tried uploading a csv version of the same file and get the same error.

Quick COUNT()
The MySQL documentation says:

COUNT(DISTINCT expr,[expr...])

Returns a count of the number of different non-NULL values.
How do i get it to INCLUDE null values? I am using COUNT with the DISTINCT bit as well, and i want the NULL rows to count as one as well.

Quick Tip: Switching Field On/off
Ever wanted to change a database field (typically TINYINT(1)) from 1 to 0 or from 0 to 1 depending on the current value?

No need for two queries. I just thought of this 'clever' way to take care of it. Never saw that done this way before, and should have thought earlier about this.

UPDATE articles
SET published = ABS(published - 1)
WHERE id = x

How To Dump (quick) A Table Into Another One.
On MySQL, I've got a table I use as 'wild card'. I mean, I store
data into it and, at the end, I dump all the date into 'production'
table.

Until now, I perform it following these steps:
1) I empty 'production' table
2) I make a SELECT of every rows of the 'wild card' table and an
INSERT into 'production' table.
3) I empty 'wild card' table.

But I've got problem: during SELECT+INSERT time, 'production' table
is not full and there's a data lack.

Quick Ones To Speed Up Access
------=_NextPart_000_0032_01C35FC2.62884DE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I am querying from a table containing more than 40,000 records. Earlier =
when the records were 10,000 it was taking 9 sec and now after 1 year =
and 40,000 records its taking 30 sec. Code is the same.=20

I am pretty sure that it has something to do with database only. No body =
can think of spending 30 secs for retrieving values from tables unless =
it's very huge in the sense of millions of records. =20

I don know whether I have to modify my database or do some sort of =
restructuring or reindexing so as to make it fast enough.

Is there some methods or optmization which can be applied to this =
database which hasn't been touched since design to enhance the spped.=20

If there are some quick ones but valued alottttttt please let me know.

Dump (quick) A Table Into Another One
On MySQL, I've got a table I use as 'wild card'. I mean, I store
data into it and, at the end, I dump all the date into 'production'
table.

Until now, I perform it following these steps:
1) I empty 'production' table
2) I make a SELECT of every rows of the 'wild card' table and an
INSERT into 'production' table.
3) I empty 'wild card' table.

But I've got problem: during SELECT+INSERT time, 'production' table
is not full and there's a data lack.

I'm looking for a faster way. Does anybody know it? Thank you very
much.

PS: I was told about 'mysqldump', but I do not know if it's faster
than mine.

Quick Date Subtraction Question
When I do the following, I get the number of days in difference between two dates however for the dates that have expired, I get the number of days back negated, ie -3 for example?

What I actually want is that if there has been an expiration, I want the result for a given row to be 0. Anyone got an idea how to?

// timestamp is datetime creation of record
// expires is date in future, ie 7, 14, 21 or 28 days in that increments
mysql> select day( expired ) - day( now() ) as days from polls;
Here is an example of the data returned,

+------+
| days |
+------+
| 7 |
| 7 |
| -3 |
| 7 |
| 7 |
| 21 |
| 7 |
| 7 |
| 14 |
| 21 |
| 7 |
| 21 |
| 7 |
| -3 |
| 21 |
| -3 |
| 7 |
| 7 |
| 7 |
| 14 |
| -3 |
+------+

Quick And Easy Update Query? Or Not Possible?
I need to do a global change to a column in my database. I know this is poor planning on my part, but I recently made a change to all of my image extensions for speed purposes.

I have a column called thumbnail_path, and every value ends with .GIF. I would like to change them to all end in .JPG. How can I do this? Is this even possible to do in one update query? or will I need to select, parse w/ php and then update?

Quick Question - Id Mediumint(8) - Does The (8) Matter?
just a quick question really..

Just setting up 1 of my tables and just wondering if it matters if i set my id to mediumint(8) but i only ever get to 6, will this effect anything in anyway?

Same goes for - address varchar(50) and say that no address ever reachs 50?

Quick & Easy MySQL Sync?
Does anyone know of any quick and easy way to sync a local development mysql server to a remote server and back. I'd like to be able to optionally sync either direction?

Quick Mysql Auto_increment Question
i noticed that after adding some test data into my table the autoincrement is working fine. but after i delete them, even though the table is empty again the new data i put in will have primary key thats in auto_increment as if the old data was there.

for example i added in 2 rows. now i have an id 1 and id 2. i delete them and the table has no rows. but now i add another two rows after wards and they get assigned id 3 and id 4. is there anyway for me to make the counting start over??? thanks for any replies or thoughts on this.

Quick Question About Reseting Demo Database?
I would like to set up a cron job to reset my demo database on a regular basis. Is there a way to export an sql file via phpmyadmin, and run it as a whole via the PHP mysql commands? The only way I can see to do it, I have to split up the exported sql from phpmyadmin into individual queries. I'd like to just process the entire .sql file at once, as it would make maintenence much easier.

Multiple WHERE X='$x' In A Query. (Quick Answer Needed)
My query works when I only use one WHERE instance, but not with both, and i know I have data that matches both criteria. Is this the proper way to pull results that match 2 criteria?

$query = "SELECT * FROM Cartridges WHERE TYPE='$TYPE_Query' & PRINTER='$PRINTER_Query' ORDER BY ID ASC";

Quick "WHERE"
Part of a WHERE criteria I'm trying to construct needs to return only those records where a date field in my adkey table contains a date older than a user-specified date (submitted as variable {sRemoveDate} from a web-page form). The following works:
CODEWHERE
(adkey.D_RemoveDate < '{sRemoveDate}' Or
adkey.D_RemoveDate is null)

PhpMyAdmin
Hi, I was hoping someone could help me with setting up phpMyAdmin on my machine. I have had it running on here before, and used it lots, but have been in a hiatus from computing for some time, and am back at it agiain, but when I tried to access my test site or databases with phpMyAdmin, it simply wouldn't work for me, so I reinstalled mysql and phpMyAdmin. I can access mysql as root via command line, but when I enter the user root and password in the config.inc.php file, then try to log on to phpMyAdmin, it does not let me in, the password box just keeps re-appearing.

I have followed the instructions very specifically a number of times now and still nothing.

Anyidea on what dumb mistake I am making??

in the mean time, back to the command line... sigh

Getting PhpMyAdmin To Run
Iâ€™m new to MySQL and PHP and wanted to use phpMyAdmin on my PC. At the outset I had to reinstall MySQL because I lost the password. When I tried to run phpMyAdmin I got these two errors at various times:

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

#1045 - Access denied for user 'ODBC'@'localhost'

The thread http://forums.mysql.com/read.php?11,6400,8687 helped me a lot but didnâ€™t seem to solve my problem.

Finally I took the password off root@localhost and phpMyAdmin worked. My password had a number in it and that might have been the problem.

The other thing I learned that I had to restart Apache each time I change a password.

How To Use Phpmyadmin
Could anybody tell me how to use phpmyadmin?How would you know that it is already working with your mysql, php and apache as well as how to start using it like adding values and stuff.

My situation here is that when I go to http:localhost/phpMyAdmin-2.8.0.3 the index of phpmyadmin is appearing full of help and folders, does that mean that I am connected? If so how can I start a new database? When all that keeps on appearing is

Error
SQL query:
CREATE DATABASE ;
MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Phpmyadmin
when making a table with PHP my admin i press save and it gives me a javascript alert saying this is not a number most fields are varchar bar 2 which one of them is longtext (for descriptions) other is tinyint (for level) if you want more details of the table ill post them, i've also not put any length values in on any of them, should i?

Phpmyadmin
I'm doing a login/register form and i've created a database in mysql with Phpmyadmin. Well this database i've created doesn't have pass or username and it calls golo. I have this code:

<?

/**
* Connect to the mysql database.
*/
$conn = mysql_connect("localhost", "your_username", "your_password") or die(mysql_error());
mysql_select_db('your_database', $conn) or die(mysql_error());

?>

what do I have to change?

PHPmyadmin
When i open phpmyadmin i get this

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Phpmyadmin 2
first: i can access the phpmyadmin page without giving username ang password.so,how can i activate a username and a password to enter the page?

second: when i complete the database creation,how can i connect it with my index page?i think that i must extract it first as sql database,ok, and then?

PhpMyAdmin
I have just installed PHPMyAdmin on my SUSE 10.2 PC. When I address it in my browser I get the login but I do not know what the default pwd is. I have tried Root+<rootLogin> and blanks buit each time I get a blank screen.

PHPMyAdmin
I have mysql and php loaded on my apache server. (In house server, Linux). I created a new database by typing in the name in create a new database box in PHPMyAdmin. Well the first time I did that it created the database and went to the page where I add tables, which I did.

Now, when I load phpmyAdmin again the database does not show up on the left hand side where all the other databases are listed. What gives? But when I go back again to recreate the Database I get an error saying database already exists.

PHPmyAdmin
I've wanted to install phpmyadmin on it too since I've worked with it before. I want to install it on a Windows XP Home machine, and I just do what the instructions say, unzip all the crap in to a directory and change the config.inc.php file (I think that's what it is). But I keep getting the following error:

Warning: require_once(./libraries/grab_globals.lib.php) [function.require-once]: failed to open stream: No such file or directory in c:program filesapache groupApachehtdocsphpmyadmin.css.php on line 7

Fatal error: require_once() [function.require]: Failed opening required './libraries/grab_globals.lib.php' (include_path='.;C:php5pear') in c:program filesapache groupApachehtdocsphpmyadmin.css.php on line 7

How Do I See My DB In Phpmyadmin
Right i use cpanel, and im just wondering where do i save my DB to, and then how do i see it in phpmyadmin

PhpMyAdmin
I'm trying to set up wikimedia on a website. I've got the hosting set up. I've logged in to my acct. and set up the MySQL database (I've named it and created a password). I am following this tutorial (http://lifehacker.com/software/wikipedia/geek-to-live-set-up-your-personal-wikipedia-163707.php) except I'm using GoDaddy for a server rather than wamp. I'm at step 2 - changing the password. All of the helps say to click on the "privileges" link. I can not find that link.

lang=en-iso-8859-1&convcharset=iso-8859-1&collation_connection=utf8_unicode_ci&token=a2cc68777bb6f6ce4fc329edd4293657). What am I missing?

PhpMyAdmin
I have given root a password in MySQL, but now phpMyAdmin says "access denied".

I've put the following line in config.sample.inc.php:

$cfg['Servers'][$i]['password'] = 'password_goes_here';

but it doesn't seem to make any difference.

How do I get phpMyAdmin to recognise my root password?

PhpMyAdmin
I am trying to export one of my tables to back it up. And it keeps gettin truncated in the process.

I think my shared environment places limits on this, so it is only writing the text file until it runs out of memory set forth in the limitation, but the wierd part is I feel like the limits are all NOT being met.

I get 8 megs on download upload on the sql dbases...and this zip file that phpMyAdmin creates is about 1.6 megs now, and it contains one third of the data...so it would seem that the full file would only be 5-6 megs.

Phpmyadmin
The problem is my host cant get his phpmyadmin working and i need it to work for my script to work.

He says "when i click phpmyadmin url in cpanel it doesnt work" does anyone no how this problem can be fixed?

PhpMyAdmin - 2.8.0.2
I logged onto phpMyAdmin for my server and I am pretty sure cpanel has updated it to a new version.Anyway I went to import a csv file into my table as I normally do and now it won't allow me to have the option of "Fields enclosed by" as blank, I keep getting a error

"Invalid parameter for CSV import: Fields enclosed by"

Phpmyadmin
I have some problems with phpmyadim... when im in the home page (after i log in) i can't do anything ... appears the error that said that the page can be showed, like i dont have connection... How can i fix that?

PhpMyAdmin
Can phpMyAdmin be used to manage databases that are not local?

Phpmyadmin
I have a webserver running the latest stable apache/php/mysql, i tried to install a mail client (dovecot) but it installed mysql along with it. I reinstalled the mysql I had before and found that a bunch of tables needed repairing (had not been closed).

Now the problem is an odd one, all my sites work fine, but phpmyadmin says there are no databases. The dropdown still has a list of databases though. If I select one then it says there are no tables. I can run the query "Show Tables" and it lists the tables as a result (so it can see them).

Phpmyadmin
I hope it's ok to ask this question in this forum. I've configured phpmyadmin to view my MySQL database on the local server. I'm logging into phpmyadmin as root (same user/pwd as MySQL server). Whenever I click to browse a table, I'm unable too. Neither am I able to do a simple, 'select * from <tablename>;' to see data in the tables. I'm able to look at table structures, edit users, etc. I just can't view data in the tables.

PhpMyadmin
Quick one... is this program just for Linux?

PhpMyAdmin
Has anyone here had problems with phpMyAdmin and php5? It's the oddest thing, the queries end up all screwed up. For example, a table "test" with a field "test" of type double, try to alter it to an int:
Quote:
ALTER TABLE `test` CHANGE `test` `test` INT NOT NULL DEFAULT '0', CHANGE `test` `test` INT NOT NULL DEFAULT '0' See how it repeats column names? It doesn't matter what the query is, complex or simple, it does this.

This all happened when I upgraded from php4 to php5. Is phpMyAdmin not compatible with php5? Is this a known issue?

PhpMyAdmin
I upgraded my php version to v. 5.1.4 from v. 4, and now phpMyAdmin does the strangest thing. When using it's functionality to do anything at all (change a table structure, add a row, anything), it repeats part of the query which of course results in an error. See the example which involved trying to change the number of char in a varchar field.

This happens with all queries EXCEPT those I key in by hand...
At first I though, well, maybe my old version of phpMyAdmin doesn't work with php5, so I upgraded to the latest version. But it's still doin' it.

PhpMyAdmin
why cant we delete posts anymore?

Phpmyadmin
i have recently installed & config'd mysql all seems to be fine with command
line,
however i have installed phpmyadmin and keep getting complaints about

'cant connect to local mysql server through socket /..blah/..blah'

i have checked the php.ini file and everything seems to be in order
i have been using webmin with no complaints, but would prefer to use
phpmyadmin.

PhpMyAdmin
How do you get http' authentication to work with phpMyAdmin?? Every time I tried using that i can't login.

using
WIN XP PRO
Apache 2,
phpMyAdmin2.6.0-pl3,
php 4.3.10
mysql 4.1

PhpMyAdmin
I'd like to be able to setup a locally running copy of php myadmin and have it connect to a remote DB running on webserver. I've done this with our old server, and now want it to work with new one. However, when I try doing it, I get the following error.

Warning: Failed opening './libraries/auth/.auth.lib.php' for inclusion (include_path='.;c:php4pear') in c:phpdev5phpmyadminlibrariescommon.lib.php on line 617 Fatal error: Call to undefined function: pma_auth_check() in c:phpdev5phpmyadminlibrariescommon.lib.php on line 618

PhpMyAdmin
when I go to http//localhost/phpMyAdmin/ using my browser
I get the following error.
You don't have permission to access /phpMyAdmin/ on this server
I have installed and configured php 5.0.2 and apache 1.3 and MySQL 4.1.7 and phpMyAdmin .6.0. Does anyone know what exact changes do I have to make to my httpd.conf file?

Sql W/out Phpmyadmin
I am very familiar with using PHPmyAdmin for implementing SQL with php into web pages. How would one go about creating tables with out this kinda of a program? Is it possible to do it all in txt docs?I ask this question because I have server space with PHP installed on my schools server. However, they do not have a program like phpmyadmin.