MySQL Database Forum

hi.... How to remove the new line character in the left and right side of the sting value in mysql? Can you any one give me the sample query for this? Regards, S.Ashokkumar

hi guys i have an sql query that alters a view by changing the data type of a column from varchar to int but keeps giving me this error "Conversion failed when converting the varchar value 'File N' to data type int." here is the sql query ALTER VIEW V_IMPORT_RECORDS AS SELECT case when cast(left(right(IMPORT_RECORDS.whichfile,44),6)as...

Hai all, I have three tables in MySql.Each table is related with 'id' column. First table contains all the id's. Second contains some of id's of first table and third table contains remaining id's of the first table. As shown in the below 3 figures. Based on that i want the output as shown in the figure 4(OutPut). How i get my required...

HI. Im new to database. I didnt know how to use bridge table. In my bridge table i have SubjectID and studentID, PK from student table and subject table. In my subject table have SubjectID, SubjectName and SubjectLecturer while in my student table have studentID,,studentName,IC,studentFac,studentPhone,studentEmail,pswd,studentAddress. I didnt know...

Hello, I have only one table with the following fields: table name : visitcount ip time lastvisit visitcount

Can someone tell me a good method for automatically placing a unique random number in a mysql database table when a new record is created.

Hi there, Can anyone tell me why the escape_string routines work on my PC but not on the server? I am using object version of mysqli PC PHP version = 5.2.9-2 Server PHP version = 5.3.2-1

I would like to start off apologizing for any mistakes i may make when trying to explain my situation, I am very new to this. Just started a new job and I am currently learning how to watch logs via MySql. I had noticed that there was a way to select a specific line of text and change the color of it each time it pops up in the logs making...

To select even or odd IDs from a MySQL table, you would use the 'MOD', this easy way to select the Odd and Even numbers/. Odd number select... select column_name from table_name where mod(column_name,2)=1; Even number select.. select column_name from table_name where mod(column_name,2)=0; if u need odd or even number put 1 or 0.

Hello friends, I am developing my own website with php and sql. I've a mistake in my codings when try to fetch all rows of a column in a table, It shows the result of only last row of the particular column There are my codings <?php include_once("com_check_login.php"); include("test_connect_to_mysql.php"); $client_idd...

hello friends! Can anyone help me to matching one column databases from another colunm databases. For example: The below table name is domains ---------------------------------------------------------- id | name | domains

Before to my question I want to say thanks to the admin of this website for very good support to improve my knowledge... :) Hello friends, How to fetch a data from a particular row in a column in the table without choosing its id or other headers of the columns For example: ...

Background: I am using ColdFusion to access an MS-Access database table via SQL. I have a membership list database table with four email address fields (email1, email 2, email3, email4) - all in the same table. (Some folks have multiple email addresses, often from different Email Service Providers - ESPs.) I need to develop an SQL query to...

Hi, How can i add(append) extra columns to a table using phpmyadmin? or through coding? Thanks.

If I write: SELECT * FROM table_name WHERE date BETWEEN "2014/07/01" AND "2014/07/04" I get 4 records returned which is what I want. But I also want the total number of records which in this case is 4, but if I write: SELECT *, count(*) AS total FROM table_name WHERE date BETWEEN "2014/07/01" AND "2014/07/04" It displays total 4, but...

in oracle so how can i do this in mysql?

I got an error... when i wants to create database "usersinfo" Username is 'blacksmoke'... Commandline argumments are: mysql> select user(); : e.g., blacksmoke@localhost -------

Hi, I'm just a user and I had this query programmed by a friend and seems to have stop working. The error message I get says that the error is near the CASE WHEN statement at line 8. Any comments are welcomed and if possible suggestions to correct the error. Select vendor,F.airline_code,F.invoice_nmr invoice_vendor,F.booking_nmr, sum(amount)...

I have a database with some products in it. I can update one of the products with a SQL query by the command UPDATE `mytablename` SET `price` = '7.99' WHERE `id` =26 LIMIT 1 ; In order for me to update about 100 products to a price '3.99' I have to go in excel and do some concatenations(linking) and then copy and paste a hundred...

I have recently started to write server scripts. Although the question may seem to be very basic but i am not able to get a solution. I have two tables one is PRODUCTS and the other is DEALS. PRODUCTS TABLE: Id product_name product_desc category brand 1 product1 desc1 cat1 brand1 ...

I want to add current date and time in one field in sql. Can anyone please help on this?

hi, i had installed wamp server in my system. i wanted to access it from another system.

Display the name of employee who does not work under any manager.

Hi.. I am really bashing my head on this one. I have an image I have manipulated, now I want to push it back to the database. So, to accomplish this, I have the following: --- $image_file = fopen ('/var/tmp/tmp.jpg','rb'); $image_data...

I am getting 2 messages:- 1. mysql error at start cannot access database 2. syntax error 1064 - line 1 - near yoya THE QUESTION If I purchase a commercial software - such as ErrorFix - is it likely to repair this error?