[mysql] Forum Topics

when i install mysql, my computer keeps restarting I can't even uninstall it! i fixed it by logging into Safe Mode and do a System Restore. MSQL is now uninstalled, so it's fine now. I want to have MSQL working. - using XP SP2.

Hello everyone. I'm now working on a banner software which allows admins to see full statistics of banner displays, clicks and other information in selected time interval by minutes, hours, days etc. I want to consult any experts who have experience using large tables with JOIN queries and optiomize my …

the most important thing is that people cant access the members only page without loggin in first. the second most important thing is actually loggin the person in and being able to like store a session i guess thats what it is that makes it so they can visit thir …

hi guys, I have one table: exams(e_no integer primary key,e_name text); now i want to create another table called questions which should have primary key that is combination of exam.e_no (foreign key) and question.q_no questions(q_no,e_no,questions text); so i would like to make q_no and e_no both act as primary key …

Hi Story goes - I have an online store... there is a sales table which records every product sold. Each product is within a style. So a Style might be 'Red Jacket'. I want to pull out (from the sales table), in order of how many sales have been made, …

I have two issues. I have simplified the tables involved. Issue1. advertisers is a table with two columns unique id and name views is a table with two columns id and advtid msgs is a table with two columns id and advtid How do I fetch only those advertisers who …

hi all Database Masters Here i have suffer one critical issue,i have two column a and b, Table name : Student "A" "B" "1" "SAntOsh" "2" "SAuraV" "3" "SAriya" "4" "SAnju" "5" "SAthiYa" These are the sample records from my Table field. The "B" column always start with 'SA', the …

Hi, I have installed the **mysql connector ODBC 3.51** on the remote machine as well as on the local machine. Mysql Connection with VB.Mysql Connection on the local machine its working fine. cn1.ConnectionString = "driver={MySQL ODBC 3.51 Driver};server=localhost;database=dummy;data source=dum;Option=3" When i trying to connect the mysql from the remote machine …

Hey, I've just started using mysql and I have som problem with JOIN. I have table1 and table2 and I would like to join these two on table1.col1 and table2.col1 to eliminate all identical rows. In addition I need to have a WHERE statement on table1. This is my attempt: …

Hi, I have been trying to find a way to get my databases on two external hard drives plus one internal hard drive but I just can't find a way to place each database on a separate drive. The only thing I have come across is windows junctions but can't …

Hi guys, I know what I need, but not sure how to do it.. a) Store values in a database field like: 12|3|43 b) How to retrieve these values as seperate variables. Appreciate any help! :'( Thanks

hi how i can restore database from binarylogs what is the procedure. i had taken a backup and inserted data into the database. now i want to take a incremental backup. i had a binlog as mysql-bin.000013 i am using mac os10.5

[B]I am trying to insert a new record into a mysql database and get the following error:[/B] 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 '30, 60, 90, DayCreated) VALUES ( 'Rush Shirt', …

Hi, I want to take a range value from mysql and store that in php. ugid sfidfrom sfidto 7 03010101 03010105 I want to take inbetween values from the column sfidfrom and sfidto and want to store that in php as a array,please help me out Regards, Vidhya

I am using mysql as backend in my windows project, some times one of table gets stucked and application also gets stocked after restartin mysql server it will be alright , any alternative solution for this problem... Thanks in advance

Hi everyone, I have PHPAuction XL V3.1, please may someone help me. I have managed to create the auctions but i cannot bid on them, the following error comes up: update PHPAUCTIONXL_auctions set current_bid=20, starts=2009-05-01 18:21:29,ends=2009-05-02 18:21:29 where id="1336eca400908b7a04133d27be69e27e" You have an error in your SQL syntax; check the manual …

Hi i am a beginner in php and mysql.... I have a made a database for registration of a customer in shrare market.... Now what i want to show at the front end is the the person who is entering information has a choice to select from a company through …

Hi , I want help in designing a Bonus System Database. I am planning to organize contests on my site where in users will have to answer some 10 questions , and at the end of each day users points will be calculated, based on there answers. Prizes can be …

Azul(Hi) i created program on php where i can output data set of any table by submitting query. i need help to input i mean to load data into the table from the HTML file can any one give help please thank you. this is the program i created, so …

Hi, How to export the data from the sql server 2000 to mysql ....Please help me.I had no idea Regards, santhanalakshmi

I have eight tables with the same schema but containing different data: `node_a_data` ( `node_a_data_id` int(5) NOT NULL auto_increment, `timestamp` int(10) NOT NULL default '', `user_count` int(5) NOT NULL default '0', PRIMARY KEY (`node_a_data_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=795 ; The timestamp field just contains a Unix 10 digit timestamp …

cannot connect to mysql server error 10060 on sqlyog on my other domain but ok on the other one. Just awhile ago I can connect to both domains but after restarting my pc I can't connect to the other one. Some said to turn off firewall which I did, it …

Hi, I am retrieving the below values from the table and use the values in drop down box in php,i don't want to retrieve [B]"All"[/B] value from the table,i tried with except keyword queries, but i din't got the value,please help me out 01 Dean 02 HOD 03 Students 04 …

I am developing a portal using php and mysql. I am facing a problem in the database design because my database is going to take million of records. I am not very much experienced in database design. So I request some experienced people to come forward for my help. I …

Hey All, I wanted to find if it this is possible. I have a db in sql server with some large tables and I would like to transfer the entire db from one server to another server without having to create the tables and so on. Is this possible? Thanks

In a application for online test, the rank list is computed as follows- [CODE] select * from test order by marks DESC[/CODE] How can we make sure that the first record gets rank1, second rank2 and so on... I want to add the field to the table. Can this be …

Hey Everybody - I'm looking into creating a calculating form for a website. I know that i can be done in JavaScript but my boss is requiring it be done in SQL as well as probably CF. I usually use SQL/CF for only simple databases or form submissions, so this …

hello hi i am using mac osx 10.5 i want to start mysql in it with --log-bin option so as to take incremental backup.so how can i start mysql with that option. i start mysql as mysql -u root -p. plz help me. where can i find my binlogs

hi all i had taken backup of my database and added some tables so as to take inc.backup i had a binary log as mysql-bin.000001 now i want to make a incremental backup from it. plz help me how can i use this log for inc.backup in mysql

Currently connected to remote server but remote configuration is not yet possible this is msg shown when trying to connect remotely to a database what does it means