how do i load database in m file?

15 次查看（过去 30 天）
Rya
Rya 2017-5-25
评论： Rya 2017-5-31
how do i load database in m file? so that i could match value of variable with values stored in database field? A quick reply will be really appreciated. thank you

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2017-5-25
In https://www.mathworks.com/matlabcentral/answers/340650-how-can-i-match-a-value-in-variable-with-data-stored-in-database#comment_455338 you indicate that your database is stored in an SQL server.
You cannot meaningfully load an SQL database into a MATLAB session. What you can do is make queries against a database to retrieve the information stored there. For information about that, see https://www.mathworks.com/help/database/import-data.html
... However, it is questionable as to why you bothered to store your license plate related information in an SQL server, unless you have a lot of license plate information. containers.Map() would probably be sufficient for your purposes.
  6 个评论
显示 4更早的评论
Walter Roberson
Walter Roberson 2017-5-30
In that case you should be able to use something like
[~, ~, raw] = csvread('YourFile.csv');
Then
[tf, idx] = ismember(lower(DetectedLicensePlate), lower(raw(:,1)) );
if ~tf
fprintf('Plate not registered, or OCR did not work well enough\n')
else
fprintf('Plate found at row #%d of database\n', idx);
end
Rya
Rya 2017-5-31
i dont have any file with csv extension, and what is tf, and idx?

请先登录，再进行评论。

更多回答（1 个）

MathReallyWorks
MathReallyWorks 2017-5-25
Hello Rya,
Use this to load the database in your workspace:
1. Go to home
2. Click on Import Data
3. Select your file. (I'll suggest to keep data in excel sheet)
4. A window will appear
5. click on import selection and remember the names of variable(Use that variable name in code given below)
Now, use this code to check whether the particular number is present in database or not.
clc;
clear all
X = [1 323 2 44 3 66 77 88 2 1 2 3 34 56 78 5 7 4 44 28]; %Sample DataBase
%Remove above line and replace X by variable name of your database
b = input('enter the number you want to check:');
n = find(X==b);
A = isempty(X(n));
if A==1
disp('The number is not present in database');
else
disp('The number is present in database');
end

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by