Trouble With NATURAL JOIN Between MySQL Versions
I have this query which works perfectly well in MySQL 5, but doesn't work in 4.1.
I know there were some changes made to join syntax between the versions but for the life of me I can't figure out exactly what I need to do to fix it:
SELECT Status, UserName, FontName, FontPath
FROM AccountInfo
NATURAL JOIN AccountPrefs, Templates.Fonts
WHERE AccountPrefs.HeaderFont = Fonts.FontID
AND UserID = '$userID'
works fine in v5, but in v4.1 I get the old "Column 'UserID' in where clause is ambiguous".
I'm trying to match the UserID in AccountInfo and AccountPrefs, I just left the font thing in there as well because I'm not sure if it's contributing to the problem.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
About NATURAL JOIN
currently i'm work with few table in one database. i use.. select * from tblA NATURAL JOIN tblB >> so, i not need to write select * from tblA, tblB WHERE tblA.ID = tblB.ID; My problem is ..i want to join more than 2 tables... but i don't want to use lengthy code like .. select * from tblA, tblB, tblC WHERE tblA.ID = tblB.ID and tblA.Name = tblC.Name; because this sql query will put in jsp and the number of table in the table will increase.. i don want to keep changing the query........ so, i tried .. >> select * from tblA NATURAL JOIN tblB NATURAL JOIN tblC; and >> select * from tblA NATURAL JOIN tblB and tblA NATURAL JOIN tblC ; but none of this can work!! both give me error msg.
Automatic Natural Join On All Foreign Keys
Is there any automated way (in MySQL 4.1.3) to get the results of a natural join on all foreign keys in a table? In other words, if I have a table T with foreign keys K1, K2, ..., Kn can I get a derived table that has T joined with all the these foreign tables? I am trying to do it now by parsing the CREATE TABLE statement to extract the foreign keys for a table, then using this to join T with these foreign tables. This works decently for 1 level deep (T and all its foreign keys), but I realized that it must work recursively (ie. I must join all the foreign tables on _their_ foreign keys). Even though I can theoretically do it with subqueries, it quickly gets to be a nightmare. Note: I cannot hard-code any table-specific stuff since this is a generic function that is given a table name as input and generates a SELECT statement as output (or returns the records, if I cannot create a SELECT statement).
Benchmarks Of Runtime Versions Of Mysql Or Other Sql Versions Sqlite Hsqldb
mysql vs sqlite vs hsql First of all i'm on a win32 platform using java. I also have mysql installed. My question isabout benchmarks and multiple inserts & selects SQLITE: http://www.sqlite.org/ HSQL: http://hsqldb.sourceforge.net I current have a mysql database of approx. 80mb. Each day I Insert approx .5mb of new records into this table, and I might also run mutiple Update, Delete, and Select queries as well. I'm trying to get an idea of how fast a sql database engine will run given that is is inside of the JVM. I know it's going to be slower than a db engine written in C and that's a trade off for being portable to different operating systems. What I want to know is how much of a trade off though - I don't want to have to wait 10 mins or deal with screen freezing... Right now on a windows platform using mysql things move really fast. Can anyone give me an idea of the time delay needed to do these Inserts in HSQL (ie: how much does the jvm slow things down).. Thanks in advance
Query Trouble With LEFT JOIN
My query as it echoes out in PHP... SELECT sales_reps.sr_id, sales_reps.order_id, sales_reps.name, sales_reps.job_number, UNIX_TIMESTAMP(shop_orders.date) as date, sales_reps.stage, sales_reps.status, ....
Having Trouble Optimising A Left Join
this is my first post regarding mysql although i'm a sortof regular in the php forums.... Allow me to try and explain my problem. An item sells. A cron job will pick this up and create a record in table sold_items with the item id, buyer, seller etc. Both the buyer and seller should leave feedback regarding the item in a table called feedbacks. An entry will be created for both buyer and seller as they leave feedback. For a high volume buyer/seller they can have perhaps hundreds of feedbacks to answer so pagination is a must. I am familiar with pagination although I hit a mental block when trying to use COUNT() with this particular query. This is the thing... I need to select all the sold items for the user, and then find out whether the sale has received feedback. PHP // QUERY RESULTS FOR PAGE $sql = mysql_query("SELECT * FROM sold_items s LEFT JOIN feedbacks f ON f.auction_id = s.auction_id WHERE s.seller = '$suid' ORDER BY s.close DESC LIMIT 10"); // $from, $max_results if (!$sql) { exit(mysql_error()); } while this seems to work it is super slow. Originally I thought the problem was including 2 other tables, the item details and user details, however removing this did not make a dramatic improvement. So for 10 results i'm looking at about a 20 second page load! One alternative I came up with was to loop through the sold items as i've used elsewhere which works very quickly, then run a query in the loop after retrieving the first row of results, to see if the item has received feedback - and then display the results only if feedback has not been recieved... but the problem here is i can't utilise count for pagination. So the solution I thought would be ok: sold_items - item definitely exisits feedbacks - item might exist LEFT JOIN sold_items.item_id ON feedbacks.item_id ok I hope my ramblings make some sense to someone,
I Am Having Trouble With A Left Join / Case
Is it possible to do this? CODESELECT files.aid, files.atitle, files.adesc, files.asize, files.aonline, files.adate, files.privemployee, files.privnotemployee, files.privuseprivs, privs.pid, privs.puid, privs.pfid, privs.priv1 FROM files LEFT JOIN on CASE WHEN files.privuseprivs=1 THEN privs.pfid=files.aid CASE WHEN files.privemployee=1 THEN privs.puid=1 CASE WHEN files.privnotemployee=1 THEN privs.puid=2 ORDER by aid DESC Limit 0,20
Always Use Surrogate Key, Or Use Natural When Possible?
Generally, I've been under the assumption that I should always use surrogate keys for all data, regardless if it has a natural key or not. However, this is starting to give me some trouble. In my code, I often refer to the primary key, or actually generally the natural key, but with having both a surrogate and natural key, I feel like I constantly have to keep the two updated and in sync. So, is there anything wrong with simply using the natural key, regardless what form that is in? I've heard arguments stating that it is less efficient, etc, but I am not sure. It just seems counterintuitive to almost be using two types of keys, when you only need to be using one. Are there any general rules of thumb to keep in mind for when to use a surrogate key, or when to use a natural if one exists?
Natural Sort
how is possible sort rows in table like php function natsort - http://php.net/manual/en/function.natsort.php Values in my table. - "35 - somethig" - "51 - somethig" - "06 - somethig" - "01 - somethig" - "02 - somethig" - "08 - somethig" - "ZC" - "BA" - "AA" I need this order - "AA" - "BA" - "ZC" - "01 - somethig" - "02 - somethig" - "06 - somethig" - "08 - somethig" - "35 - somethig" - "51 - somethig"
MySQL Versions
I am using MySQL 5 on my computer but the web-hotel I am contemplating to use only use MySQL 4.0xx. Can I use the database without modifying it? Or do I need to "convert" (downgrade) it for MySQL 4.0xx? If so, how do I do that?
Running Two MySQL Versions
Actually what I want to do is remove 4.1 because I downloaded 5.0 and installed w/o removing the previous version. I now have port 3307 for 5.0. Is this a problem and how can I change it back to 3306 so e.g. when I use Apache/PHP evrything works?
Two Versions Of Mysql On Same Unix Box
I have mysql 3.23.58 version running on my unix box. I installed a new application on it which need mysql version > 4.0 so I thought of having two mysql versions running on the same unix box. I have first installation in /usr/local/mysql and I untared the new version in /var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23. I am following instructions given in http://dev.mysql.com/doc/refman/4.1/en/multiple-servers.html I also created a empty file and named it as mysql.sock.new and stored it in /var/local. When I try to start this new version from /var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23 using ./bin/mysqld_safe --datadir=/var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23/data & it says "A mysqld process already exists". Please tell me where I am going wrong and how to configure it properly?
Row Select In Old Mysql Versions
We are using MySQL version 4.0.20-standard. Our application requires a query to do a row select. From what I have found this version does not support rownum. We are unable to update the version of MySQL. Can anyone give us some support.
Running Two MySQL Versions
It seems that my computer is running two different mysql versions. When I'm trying to login to the database it refuse my password and giving me access to the test configuration. This is what i get in the event viewer. Do you already have another mysqld server running on port: 3306 ? Event id 100. The problem occur when I changed my password for the database. I have turned off Mysql in local services but i think that that's the original version. When I start the xampp i think it starts the winmysqladmin version (not sure). How do I reconfigure the hole thing and how can I see what's running on my machine. I actually have another question to. I'm trying to run and open the shell mysqladmin which doesn't work. It's just a flash, which one of them am I supposed to run?? You have several options like mysqladmin, mysql, mysqld, mysqld-nt....etc. I opened the winmyslqadmin which i think wasn't that good.
Downgrade MySQL Versions
I need to move a MySQL database created with MySQL 4.1.22 on PHP 5.2.3 to a different server with MySQL 3.23.58 on PHP 4.3.8. Is it possible to convert the database to do this? Alternatively, is there a way to export from the newer version in a format that the older version will accept?
Can Run Two Versions Of MySQL In Windows 2000?
I have been running 4.0.13 for several weeks now and though I'd like to = test 4.1.0. 4.0.13 is under c:MySQL. I downloaded 4.1.0 under c:4.1 = AlphaMySQL. When I try to launch mysql it brings me to the old = version, how do I access the new one without killing the old one? (I = have also tried putting 4.1.0 on a totally different machine and linking = to it also.)
Previous Versions Of MySQL With XAMMP
I've downloaded XAMPP for Linux 1.5.1 for use on Fedora Core 4. I notice it only has the latest version of MySQL on it. I'm working on two web sites (for different clients) and they are hosted on different shared Linux hosting servers (with PHP), each with different versions of MySQL available, i.e: MySQL 4.0.25-standard MySQL 3.23.52 Is it possible for me to use older versions of MySQL with XAMPP? Could I just turn off MySQL in XAMMP and just run and older version of MySQL independently of XAMMP? If I can then how would I install multiple versions of MySQL in Fedora Core 4?
Symlinking Between Different Serveurs And MySQL Versions
I have a hosted server where we have both web and intranet share a same database. For interne reasons we need to migrate the intranet onto one of our servers and keep the web on the hosted server. We will thus have the database splited in two. Our intern server willl have MySQL5 and our hosted one will remain with MySQL3.23.39 at list for a while longer. I would like your advises on the faisability of using symlinking to access the tables on the hosted server from our intern server, knowing that MySQL version are different. The tables on the hosted side are MyISAM. The main idea is to avoiding using replication to access comon tables on remote servers.
Utility To Convert Between MySQL Versions?
My webhost downgraded from mysql 5 to 4 and I'm seeing errors in the forum I was running. All I can see that would have changed and given me this database error would have been this downgrade. Is there a conversion utility availaible that can change back and forth between MySQL versions? I've looked around for about an hour thru Google and on this forum, but I haven't found anything yet. I was getting password errors, but we seem to have resolved that issue, and now I'm left with this database connection error. Thanks for any assistance! P.S. The errors I get are: Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/clanloc/public_html/forum-old/db/mysql4.php on line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/clanloc/public_html/forum-old/db/mysql4.php on line 331 phpBB : Critical Error Could not connect to the database
Selecting Correct Versions Of MySQL
I have searched this forum and google to try and get a comprehensive answer to this question but i haven't found anything yet. I am looking to select the correct versions of MySQL, Apache and Php so that they all work together. I notice that there are alot of issues with various different versions sets being chosen and there seem to be instances where it can be very problematic if the wrong one is chosen. I am looking to use InnoDB and would like to use the latest versions of everything as possible but it doesn't really outline anywhere what works with what best. There are lots of cases that outline what can be problematic but i'm trying to avoid this if possible and find what isn't problematic.
Alternative To Group_concat For Early Versions Of Mysql
Is there an alternative to group concat, if you are using a lower version of mysql. If any one has any ideas it would be great, currently my code (thanks to some one from these forums) looks like this. SELECT c.clientID, group_concat(ci.interestID) as interests FROM Clients AS c JOIN ClientInterests AS ci ON c.clientID = ci.clientID GROUP BY c.clientID HAVING find_in_set(1, interests) AND find_in_set(3, interests) Is there any way of doing this on a lower version of mysql? Is it possible to wirte a function similar to group_concat?
How To Detect If Different Mysql Versions Are Installed/runing
from my InnoSetup setup :) I need to detect if any version of mysql is runing on my windows. Others sugested to check fo a mutex or a Class Name(dont know what are these) or Windows Names or Look for a mysql*.exe, so is there something common for mysql starting with v3 .. v5? I mean what is the thing that i have to search for, to know at least if mysql is runing. For mysql v3 there are the posible runing files: mysqld.exe mysqld-max.exe mysqld-max-nt.exe mysqld-nt.exe mysqld-opt.exe or on Win98 only winmysqladmin.exe? For mysqlv4 .. im not sure yet For mysql 5 seems to be more simple, only mysqld-nt.exe Do I have to search for all these files(and others that I dont know yet :) ) to be sure that its not runing?
Mysql Import Trouble
I'm using the following code to import a .sql file. mysqlimport --local -u root -pCENSORED teraspot_db /home/default/teraspot_db.sql and I get this error mysqlimport: Error: Table 'teraspot.teraspot_db' doesn't exist, when using table: teraspot_db I got the .sql file from exporting the database in phpmyadmin on the old server. What am I doing wrong?
Trouble Installing MySQL On Mac OS 10.4
I'm working on a Mac under OS 10.4 In the hopes of making my website interactive I've been trying to use Kevin Yank's book "Build Your Own Database Driven Website Using PHP and MySQL" to learn some MySQL and some PHP. (At the moment I know only a tiny bit about PHP and nothing about MySQL.) Despite my determination to go about this in a calm and orderly way, I've run into a frustrating obstacle right at the beginning. To make matters worse, I'm not even sure what the problem is, which makes it difficult to ask for help. I don't know whether MySQL is actually installed and I just don't know how to use it or whether, despite my efforts, it's not really installed at all. I tried to install it according to Kevin's instructions and thought it had been installed properly (I mounted the dmg and a "startup package appeared in my Library, but when I tried to proceed farther by typing commands into a Terminal window according to Kevin's instructions, I just got a "command not found" response.) I read what Apple has to say about installing MySQL under OS 10.4 and tried again, but when, following their instructions to make sure no MySQL processes were already running before installing I entered "mysqlshutdown admin" once again I got a "command not found". One other thing: I think the problem (or part of the problem) might be that I'm not in the right directory when I type in these commands. I get the impression MySQL stuff is supposed to be happening in the "root" directory, but when I type in "cd root" in the Terminal window I just get another "command not found." (Before I started to work on this yesterday I'd never used a Unix terminal window!) I'm a bit embarrassed and hesitant about this post — my first on this forum— because I'm afraid it's going to sound very ignorant and confused. But you do say beginners are welcome so....
Having Trouble With Subqueries With Mysql 4.0.21
i'm trying to make this command run: select MAID from spez_MA where MAID = any(select MAID from spez_P_MA where P_ID = 1) on a mysql server 4.0.21. and i get an error #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 '( select MAID from spez_P_MA where P_ID = 1 ) LIMIT 0, 30' at the command works using the same database in another mashine running mysql 4.1.22. where can i find the documentation of the correct syntax for 4.0.21? my sintax is according with http://dev.mysql.com/doc/refman/4.1/en/any-in-some-subqueries.html, but this is for 4.1, not for 4.0. this manual should be for versions 3.23 and 4.0 too.
MySQL 4.1.7 On OS X 10.3.6 Install Trouble
I am trying to get MySQL, PHP 5, and OS Commerce installed on OS 10.3.6 but am running into a little trouble with MySQL. Here is the output that I get when trying to start MySQL after installing from the OS X PKG file. Last login: Sun Dec 5 21:47:38 on console Welcome to Darwin! Rhapsody:~ jeffery$ cd /usr/local/mysql Rhapsody:/usr/local/mysql jeffery$ sudo ./bin/mysqld_safe Password: Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/Rhapsody.local.pid 041206 09:48:13 mysqld ended I have searched the internet and all around the forums for some help, but have not found anything yet, could someone let me know whats up?. Or possibly point me in the right direction?
Trouble Installing The MySQL GUI Tools With Red Hat 8.0
I just installed MySQL Community Server 5.0 onto my computer, which is running Red Hat 8.0 and it works fine, but I was trying to install the MySQL GUI Tools (Query Browser, MySQL Administration and the Migration Toolkit) and I'm having trouble with it, I have decompressed the installer , I go to the installation directory (/usr/local/mysql/mysql-gui- tools-5.0) and type in ./mysql-query-browser to run the query browser, but it gives me this error message: ../mysql-query-browser-bin: error while loading shared libraries: libgtkmm-2.4.so.1: cannot open shared object file: No such file or directory.
Trouble Logging Into MySQL Administrator
I've installed MySQL and it appears to running properly because I can enter data in the command line format but I'd like to use the graphical user interface of MySQL Administrator. When I try to log in, I can not get through. Is there someplace on the MySQL website that I can go to send me a reminder of the information I used to set-up the server and how to properly fill-out this form? When I hit contol and skip, it shows that my server is running. I did save the original information I gave on the website during the server configuration and download procedures but when I try different combinations of this information, I'm still not able to access the Administrator functions.
Trouble Installing MySQL On Mac OS X Tiger (10.4)
I have searched all over the internet, and tried to learn how to do this. It's not really up my alley, so please someone tell me what to do! Here are some of the things I type and the messages I get with them. CODEkirk:/usr/local/mysql kirkstrobeck$ mysql -u root ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Trouble Updating Mysql Database
I am trying to update my Mysql database with a dataset. The dataset is created and filled on a handheld device running the SqlCE server. I then call the dataset from the handheld via a web service. Running the mysql data adapter and executing the Update method does not seem to work, (I think its because the dataset does not recognise any changes made to it). Can anybody please help me in this regard, or just send me some links with GOOD examples of where somebody is getting it to work.
Linux (Fedora) MySQL Trouble
I'm currently trying to complete a MySQL book I purchased. I have installed the server and client applications. When I go into the terminal to run MySQL, I get the following message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Not sure what exactly this means. I did look in the mysql directory and the sock appeared to be there.Still fairly new to Linux, but it's all I have to work with.
Trouble With Export Of Access Table Into Mysql
I exported some tables out of access into mysql and I cant edit and records under mysql root account through mysql's query browser. I can edit from mysql command line using same credentials while working localy on the mysql server. Wondering why Query broswers Edit button is greyed out.
Help! Trouble Loading .txt Files Into MySQL Front
spent all night entering data into my 1st DB via "mySQL front" and this morning had to reinstall everything, so i lost the whole DB but i did export it as a .txt & html table file last night.. but now i can't seem to get it back :mad: here is what the exported .txt file looks like: id,artist,title,label,price,sound 1,Niko Bellotto ,Slam mode,La colecion,21.50,slam_mode.mp3 2,Oliver Ho,Listening to the voice inside,Meta,40.50,oliver.mp3 3,Numero Deux,The dinning rooms,Conesa,32.50,numero.mp3 4,Photek,Solaris,Omni,32.50,photek.mp3 5,Gianni Ferrio,Spring themes,Garden,32.50,spring.mp3 ..... more of the same.. (its for an online cd store (fake one) i created a table with the same fields and tried to "import .txt file" but all i get is the id field filled up? the other fields stay blank?
Trouble Chanigng Mysql 5 Socket Location
How do I change the place where the mysql socket file gets created? I thought it was in the my.cnf file by changing the "socket" property. However, using MySQL 5.0 on my Fedora Core 5 Linux system, when I do this and restart, attempting to connect to MySQL through PHP gives me this error Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/apache2/htdocs/refillingstation/db.php on line 19 Can't connect to MySQL: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Here is my "my.cnf" file: [mysqld] datadir=/var/lib/mysql socket=/tmp/mysql5.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid .
Trouble Connecting To MySQL On Windows Server 2003
Fatal error: Call to undefined function mysql_pconnect() <?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_connMySQL = "localhost"; $database_connMySQL = "database"; $username_connMySQL = "root"; $password_connMySQL = "mypassword"; $connMySQL = mysql_pconnect($hostname_connMySQL, $username_connMySQL, $password_connMySQL) or trigger_error(mysql_error(),E_USER_ERROR); ?> I installed the ODBC drivers as an optional solution, and that appears to be working when I test it within the program, but I don't know how to get my .php website to connect to it. .php files are working correctly on the server, but it's just not connecting to the database.
Versions
I have MySQL 5.0.24 installed on a XP Pro SP2 PC. The latest version is 5.0.41. I looked at the change logs and they say they are bug fixes only. Have there been any security issues with 5.0.24 that I should be aware of? Do I need to move to 5.0.41 to be safe?
Run 2 Versions
Is it possible to run both MySQL 3.23 and MySQL 5, at the same time on the same machine with php4.3.0 and apache 1.3.27? What should I consider ?
Two Versions
I wanna run MySQL 3.23.54 and MySQL 5.0 in the same Redhat Linux 9 box at the same time. Is it possible?
Differences Between Versions
We have two versions of mySQL running; version 4.1.15 on a couple of local machines under Windows XP Professional and our public database running 3.23.58 under Apache. I was populating a new field in our members table based upon a match to a table called region using the following query UPDATE members,region set members.FPosition_Id = 19 where region.Region_Commodore_Id > 0 and region.Region_Commodore_Id = members.member_Id The query ran fine locally (ver 4) but gave a syntax error on version 3. Is there a list of differences/updates between these two versions? Does version 3 not support update queries using multiple tables? I tried parenthasizing the where statement but that made no change.
Versions Of AMP On Windows?
I am somewhat concerned that i have the right versions of AMP on my Win XP system so it will all work together... Is there some link that (in simple terms!) tells which versions are safe together? I currently have MySQL version 4.0.20d, with Apache 2.0.52 and php 4.3.10. Is this the best combination?
Two Versions On Same Machine
I had MySQL 4.2 - working fine. I saw version 5 is now stable so I downloaded and installed but did not run it (I think!). Carried on with 4.2. Then one day MySQLAdmin and Query would not log me on. I checked via the cmd line utility and when I typed in the password the window dissappeared! I opened MySQLAdmin again and reconfigured the log-on o 3307 (I remember this was default when I installed 5.0). OK, the server must be running. So keep with 5.0 as I managed to restore one of my schemas. I wanted a later version which is only in the 4.1 directories and copied it across BUT 5.0 does not see it. But when I go to stop and restart the 5.0 server in Admin as soon as I go to the server tab to do this it stops automatically! AND will not restart.
Comparing Versions Of Sql
I'm taking up a new position and have never used sql before although use and code in lots of other languages. When doing a bit of survey I find many many versions of commercial and public versions of sql. Can anyone tell me if the syntax is generally similar or are they completely different. If I invest time learning mysql on XP or Linux will that be useful if I end up using something like Oracle later on? The only one I would avoid is MS.... like things that work occasionally.
Removing Old Versions
I loaded a new version of Mandrake Linux 10.0 CE and have also installed and dowloaded a new version of MySQL 4. I'm not sure but think I have several versions installed and running ... How can I check to see what is installed, what is currently running, and then perhaps remove them all and start by installing single new copy?
Compatibility Between Versions Of SQL
Hi! Would like to enquire if different versions of SQL are compatible to one another. I've done some code in PHP and which requires access to MySQL on my server. I have tested it on localhost and everything worked fine. Hence, i decided to upload both my code and the database i created to the server. That's when the prob started. I received this msg while trying to view my page: Could not connect to database: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) what this is about? For info, my MySQL version on my personal computer is 5.0 while that of the server is 3.23. Are the database compatible?
Comparing Versions Of Sql
I'm taking up a new position and have never used sql before although use and code in lots of other languages. When doing a bit of survey I find many many versions of commercial and public versions of sql. Can anyone tell me if the syntax is generally similar or are they completely different. If I invest time learning mysql on XP or Linux will that be useful if I end up using something like Oracle later on? The only one I would avoid is MS.like things that work occasionally.
How To Keep Trace Of The Versions From A Table
From the Code that is been written below i need to keep trace of the versions that are been read from the file(test1.lst) each time it is been changed.Does anyone know as to how i can store it in diff tables(version_0701151004 version0701151100,version_0701161000 ....versionYYMMDDHHMM) each time when this query is been called? n how to keep trace of the date and time ? or maybe is there any other method where i can store diff versions in diff files ? would be gratefull for any advice --DROP TABLE stocklist_values; CREATE TABLE stocklist_values( SAG_FREIGABE INT(1) NOT NULL, SAG_SNR VARCHAR(50) NOT NULL, SAG_NAME VARCHAR(40), GSM_RELEASE_VON VARCHAR(20)); LOAD DATA INFILE '/home/user945/database/test1.txt' INTO TABLE stocklist_values FIELDS TERMINATED BY '&'
XAMPP And MAMP Versions
I'm running an XAMPP version of mysql on a PC and the MAMP version on a Macintosh. I just realized that I needed to change a couple of tables. Can I change them on the MAMP version and then copy the appropriate files to the XAMPP version, and expect them to work? Which files should I copy over ... .MYI, .MYD or both? The MAC version is 5.0.19 The PC version is 5.0.27 I use Navicat to modify my tables on the mac and do not have this product for the pc.
|
TRACKER
