Mysql syntax
Hi Have a table: budget When I try this: MySql: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a courseno from table course 2 also represents: a courseno from table course It doesnt work :|… Any suggestions.... ? ...
Hi Have a table: budget When I try this: MySql: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a courseno from table course 2 also represents: a courseno from table course It doesnt work :|… Any suggestions.... ? ...
30 pts.
Constraints (MySql,tables,null,PK,FK etc)
Hi all(waves) noob here ( :) ) ( yes you might look down upon me) ( :( ) never the less....:) Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg "Table budgets"...with values of two budgets (£100 and £200) for...
Hi all(waves) noob here ( :) ) ( yes you might look down upon me) ( :( ) never the less....:) Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg "Table budgets"...with values of two budgets (£100 and £200) for...
MySQL database size
Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance? Software/Hardware used: linux server
Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance? Software/Hardware used: linux server
multi-use of the database
Hello . I've developed a local website using xampp , and I want to access the mysql database in it to develop a J2SE application. Is it possible ? if so could you give me the right keywords to search since I kept trying every single word that could pop into my mind . Thank you very much . ...
Hello . I've developed a local website using xampp , and I want to access the mysql database in it to develop a J2SE application. Is it possible ? if so could you give me the right keywords to search since I kept trying every single word that could pop into my mind . Thank you very much . ...
Foreign key constraints support in MyISAM
Are foreign key constraints supported in MyISAM of MySQL? I have created a table using InnoDB, declaring the foreign key, and now I want to convert that table to MyISAM. Is it possible, and if so, how can I do it? Software/Hardware used: MySQL
Are foreign key constraints supported in MyISAM of MySQL? I have created a table using InnoDB, declaring the foreign key, and now I want to convert that table to MyISAM. Is it possible, and if so, how can I do it? Software/Hardware used: MySQL
SQL related tables
I have 2 tables one with all my products and their accociated details and another with comments on the products. Product table 1 prodID, title, description, price Comments table 2 commID, prodID, comment I would like to export this to a single XML file, thus an XML element for each product from...
I have 2 tables one with all my products and their accociated details and another with comments on the products. Product table 1 prodID, title, description, price Comments table 2 commID, prodID, comment I would like to export this to a single XML file, thus an XML element for each product from...
Plans and Guidelines for a Web Application Project
Hello there fellow users, I have been entrusted with the task of designing and implementing a financial system for a charity foundation where I live. The charity foundation requires its work (addition and retrieval of records, for example) to be done online, using a web app. The app connects to a...
Hello there fellow users, I have been entrusted with the task of designing and implementing a financial system for a charity foundation where I live. The charity foundation requires its work (addition and retrieval of records, for example) to be done online, using a web app. The app connects to a...
abt the server
is it possible to make my personal computer to act both as client and server for the purpous of doing project like php-mysql-apache and for deployinf j2ee also
is it possible to make my personal computer to act both as client and server for the purpous of doing project like php-mysql-apache and for deployinf j2ee also
Advantages and disadvantages of MySQL 5.0
Can someone explain me what are the advantages and disadvantages of MySQL 5.0??
Can someone explain me what are the advantages and disadvantages of MySQL 5.0??
mysqldatetime exception
mysqldatetime exception i am using MySql with c# in my window application , In code i think everything is fine , when i made a latest patch for the given installer it throwing an exceptuon at client side " Cannot perform '<=' operation on MySql.Data.Types.MySqlDateTime and System.String." ...
mysqldatetime exception i am using MySql with c# in my window application , In code i think everything is fine , when i made a latest patch for the given installer it throwing an exceptuon at client side " Cannot perform '<=' operation on MySql.Data.Types.MySqlDateTime and System.String." ...
MySQL Database - Multiple Images
Hi, I am going to build a database soon for a website that can grow tremendously in the long run when it comes to the amount of records being added. This will be a MySql Database integrating with a Flash website. My main question is how should I handle multiple images being uploaded. A user will...
Hi, I am going to build a database soon for a website that can grow tremendously in the long run when it comes to the amount of records being added. This will be a MySql Database integrating with a Flash website. My main question is how should I handle multiple images being uploaded. A user will...
Using MySQL message API on Windows
I am new to MySQL message API. I want to use MySQL message API on Windows platform. But MySQL message API is tested and developed on open source platform (Linux, Unix, etc). I think MySQL message API is nothing but a udf, which uses spread toolkit (spread daemon). So I tried to build a dll for...
I am new to MySQL message API. I want to use MySQL message API on Windows platform. But MySQL message API is tested and developed on open source platform (Linux, Unix, etc). I think MySQL message API is nothing but a udf, which uses spread toolkit (spread daemon). So I tried to build a dll for...
How can I synchronize three instances of MySql
I have three instances of MySQL located in Chicago, London and Hong Kong and I want to keep them sychronized. Is there a standard way to do this.
I have three instances of MySQL located in Chicago, London and Hong Kong and I want to keep them sychronized. Is there a standard way to do this.
Photo upload in a profile with PHP and MySQL?
Please help me by giving script for uploading and updating member photo in his profile using php and mysql
Please help me by giving script for uploading and updating member photo in his profile using php and mysql
Send email to admin on table update in MySQL
hi, I have to send an email every time table in DB is updated. i have to do this because my anti virus is blocking 25 port. so how it is possible to send an email without unblocking of 25 port
hi, I have to send an email every time table in DB is updated. i have to do this because my anti virus is blocking 25 port. so how it is possible to send an email without unblocking of 25 port
