MySQL Database Forum

Hi Experts, I encountered the following problem when I'm trying to open SOME tables in MySQL database: "Incorrect information in file .//.frm" Other tables within the same database can be opened without any issues, only some tables have this problem. And this is not just happening in one database, but the other database on the same server...

Please help me to fetch data from table B to table A: Its my input form coding(insertdata.php): <?php include ( 'header.html'); include ('selectdriver.php'); include ('selectdestination.php'); include ('selectloading.php'); ?>

I'm trying to get a web page working so that visitors to the website can leave reviews of the business, or read reviews others have left. But I'm having trouble getting it working on the production server, even though it worked in development. Here's the code I'm using to inert the reviews into the database; <?php $dbc =...

How can a read only MYISAM table become corrupt? I have to do a myisamchk -r approx. once a week as the table gets marked as crashed. I can't see how this is happening though as no changes are being made to it, it's read only. It's running on mysqld-nt version 5.0.51b, the same table running on a mac and a linux box have not done this, so...

I have a StudentsTable which has 3 fields to describe which class a student belongs to. The first is session, in the db it is stored as 1 or 2. afternoon,morning (values 1, 2) Language, also stored as 1, 2. English, Chinese (values 1, 2) Class number which has values K1,K2,3,4,G...etc. This list is long and changes from time to time.

Hello Bytes Community, I am not programmer at all. I run a free forum as a hobby for organised racing and I'm just managing with HTML and CSS right now. I've been doing this since January, never touched a line of HTML really until then but I'm enjoying learning as I go. So... this post is just a different method I'm trying, to see if I can...

I get these error each time I write the syntax in quotes. Please can someone help me? ERROR 1064 (42000): 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 'book( saleID int not null,isbn varchar(20) not null,quantity int not null,salePri' at line 1

Dear All, I have a strange problem. I have a Synology NAS server with SQL databases. When connecting from my client workstation with mysql workbench 6.2 CE it all works perfect and could access the database. Sometimes I have to execute flush-hosts but then again access granted. User previleges on database set '%'. Also telnet 3306 works fine...

I have functions saved under proc. I am using MySQL Workbench. I just tried to alter a function which resulted in an error (something about it being unsafe and binary logging); however, when I clicked "Apply", it dropped my function... and then as I was searching for the relevant option setting, Workbench crashed! What's the easiest way to...

Hi Guys, I am using Java in Eclipse to create tables in a MySQL Database. Everything has been working fine until it inexplicably stopped working the other day. My code runs but nothing happens to the database due to an error when I try to initialise the connection. The code actually runs to the end, the error is only viewable when I step...

I want to count size of all rows in mysql table? is it possible? how?

How to do paging in mysql store procedure?? input paramter will be (in pageno INT, IN no_records) result will be for example i pass value 1 and 10 : first 10 records it will show. or 2 and 10 then it will show 11 to 20 records.. please help..

what is the procedure to connecting a database and application using byethost server

Trying to write a sql statement to return a result set comparing two dates where the 1st date is 31 days or greater than the 2nd date

My colleagues say it is wrong but not one of them can tell why and I don't know myself. I attached the design and ERD for your correction ,please.

I have bunch of data in the table in my database, the field is in a varchar type, the field has deimal numbers, has integers, has letters etc. i only want to check if the data in that field is a decimal, how can i check that using only mysql syntax? no php. Any comment are so apprecitaed, thank you. :)

HELP PLEASE!!!!!!!!!!!!! Error MySQL said: Documentation #2003 - Can't connect to MySQL server on '127.0.0.1' (10061) Connection for controluser as defined in your configuration failed.

i am trying to feed a number to database in this case my reference number which is of a (AAA/BBB/28AUG2015 - 4082) format, which should be selected by user,and the date should be the system date while the last number should be auto-generated in that sequence. the 1st and 2nd values are fixed.kindly i am unable to do that on phpmyadmin DB...

Is it possible to install MySQL standard edition to a remote server using filezilla to upload files and putty to run and execute the setup MySQL? if yes, how to run the installation

My goal is to connect my SSIS package to a MySQL server running on a different machine (windows). I am new to MySQL and my client's system admin doesn't know much about MySQL either. I've been trying to connect to using ODBC MySQL driver 5.3 but i keep getting this error: ERROR: Can't connect to MySQL server on '' (10061) Do i need to have a...

I tried editing .ini file, it prompts access in denied. And if i try to chnage using command prompt that also it does no allow me to do so.I cannot even use "Show Max_allowed_packets". It says show is not recognized as internal and external command. # For advice on how to change settings please see #...

I was trying to create a website that enables the users to Input something in it, like user info. but it always gives an error whenever I try to test submit the inputted data's into the database. 'Could not Connect: Access denied for user 'smdg'@'localhost' (using password: YES)' connection: define('DB_NAME', 'testdb'); define('DB_USER',...

I have created a search box now want to add search function to it that searches for text entered only in my site. I want to know how things are put together for search to work. I know we need to call data from tables we want to search, but do i need to create a table for this search function just read it somewhere, if it is so what is the purpose...

I am using the code below for search function but it is not protected from injections and I am not programming expert so can anyone help me on this my code is <?php include ( "./inc/header.inc.php" ); ?> <?php if(!isset($_POST)) { header("Location: main.php"); } $search_sql="SELECT * FROM blogs WHERE title LIKE '%".$_POST."%' OR body...

how do i change this to mysqli? <?php require 'connect.php'; session_start(); $username = ""; $password = "";