Search results for query: *

okay well then you have a question about image compression and not databases. most common practice is to save images in your file directory and path to images in database. even if you store the images in database you have no compression options.

Buy more storage space is probably the solution.

Todd Did you mean to only select games where the home team is 'ARI'? If you need their away games too change the last bit to: AND (Home.tm_id = 'ARI' OR Opp.tm_id = 'ARI')

Join to the teams table twice.

MySQL Workbench is one, HeidiSQL another PHPMYADMIN a third. There are others. If you look at a SELECT statement in the manual you can see that you have the OUTFILE option to output your query to a file. Note that the user logged in to mysql must have FILE permissions to do so. Alternately...

change the my.ini file inside the mysql installed folder. you can specify temp directory in there.

why do you need to view the results from the client window? Can't you output them to a file if you have to view them? There are also many GUIs you can use for the front end that allow easier viewing of your results.

That isn't the server part that you are logging in to, it is the client. the error message means you are using a password but you are not using the correct password. if you are unsure of the password for root then see the manual for RESET ROOT PASSWORD. it allows you to start mysql without any...

your error message indeed confirms the server is not started. run LOCATE mysql or WHICH mysql to find out where it is installed. i'd then suggest you change directories so you are in the /mysql/bin directory wherever that is located. are you logged in to your system as root? if so you won't...

sql is the language, not the specific database. are you posting in the correct forum? this is for the mysql database. if you are using another application, the solutions may have different syntax and thus you should post in that forum.

MySQL would need to create the index in order to keep track of whether or not an item being added is unique. Why do you need to differentiate them? YOU should be adding them at the time you create your table or using an ALTER TABLE statement, there's no real difference whether it is created...

The backticks are unnecessary. Don't forget to run FLUSH PRIVILEGES after changing the password that way. If you don't the new password will not be recognized.

just create the table in your database. you can create it with a single column and have no data in it. then drop your database.

The word READ is a reserved word so you should change the column name to something else.

Use INSERT INTO tablename field1, field2, field3,field4, VALUES("value field1", "value field 2", (SELECT fieldname FROM tablename WHERE fieldname2="string"), "value field4"); as suggested above, don't worry about getting the author id ahead of time.

When you are in mysql client run this at the command line: SHOW VARIABLES LIKE 'datadir' and that will tell you where the mysql data directory is. Note that will work for any OS.

you have address in more than one table so you have to reference it by the tablename and then column name i.e. table1.address for example.

MAX(listing.address)

Do your query as usual and handle display issues in your front end application.

use a UNION ALL